orkungedik/SAP-basis-dataset huggingface dataset:
How do I configure HANA replication? How to configure async HANA replication? How to configure HANA replication? How to configure HANA system replication? HANA System Replication [acronym HSR in this blog] is one of the very important topic in SAP HANA. Being used in the context of high availability and disaster recovery scenario and  it is must to be aware about it for any SAP HANA Technology Consultant. During work and  we always come across the situation where we need to enable & disable the HSR. In this blog and  I will be explaining the technical steps to perform the same. For this blog. I'm considering 3 system multi-tier HSR scenario. Disable the System Replication in multi-tier setup- This is 2 step process if you've 3 systems in multi-tier system replication. Step 1- 1. Stop the secondary system [This is tertiary / DR site in actual setup]. Execute 'HDB stop' with <sid>adm user. 2. Un-register the secondary system. hdbnsutil -sr_unregister -id=3 -name=<site name> 3. Disable system replication on primary system [This is secondary / HA site in actual setup]. hdbnsutil -sr_disable Step 2- 1. Stop the secondary system . Execute 'HDB stop' with <sid>adm user. 2. Un-register the secondary system [This is secondary / HA site in actual setup]. hdbnsutil -sr_unregister -id=3 -name=<site name> *n3. Disable system replication on primary system [This is primary site in actual setup]. hdbnsutil -sr_disable Enable the System Replication in multi-tier setup- This is 2 step process if you've 3 systems in multi-tier system replication. Step 1- 1.Enable system replication on primary system [This is primary site in actual setup]. hdbnsutil -sr_enable -name=<site name> 2.Register the secondary system to primary system [This is secondary / HA site in actual setup]. hdbnsutil -sr_register -name=<site name> -remoteHost=<primary host> -remoteInstance=<xx> -replicationMode=<sync | async | syncmem | fullsync> -operationMode=<logreplay | deltadatashipping> -force_full_replica 3. Start the secondary system Execute 'HDB start' with <sid>adm user. Step 2- 1.Enable system replication on primary system [This is secondary / HA site in actual setup]. hdbnsutil -sr_enable -name=<site name> 2.Register the secondary system to primary system [This is tertiary / DR site in actual setup]. hdbnsutil -sr_register -name=<site name> -remoteHost=<primary host> -remoteInstance=<xx> -replicationMode=<sync | async | syncmem | fullsync> -operationMode=<logreplay | deltadatashipping> -force_full_replica 3. Start the secondary system Execute 'HDB start' with <sid>adm user. I have designed diagram to make this process easy to understand as well as remember. This will help out reader. Description is shorten here as details are present in blog.,HANA replication configuration Load/unload process may lead performance problem on HANA. It may cause high CPU load during the process since loading data from disk to memory. You can use HANA_Tables_ColumnStore_UnloadsAndLoads query in HANA SQL collection to identify the problem,HANA performance analysis
#How to use hdbcons? #How to run hdbcons in hana? How to run hdbcons? #How do I analyze with hdbcons? #How do I get a dump with hdbcons? #How to get dump on HANA? #How to get kernel dump on HANA? To get kernel dump on HANA by hdbcons at operating system; connect to your SAP HANA database server as user <sid>adm via ssh and execute the following steps to get kernel dump on HANA: 1. hdbcons -p <index server proces id> "profiler clear" 2. hdbcons -p <index server proces id> "profiler start" 4. Wait for 2-3 minutes 5. hdbcons -p <index server proces id> "profiler stop" 6. hdbcons -p <index server proces id> "profiler print -o /usr/sap/<SID>/HDB<SYSNR>/<hostname>/trace/<DB_SID>/cpu.dot /usr/sap/<SID>/HDB<SYSNR>/<hostname>/trace/<DB_SID>/wait.dot". 7. Use https://dreampuf.github.io/GraphvizOnline/ to analyze output files. For run time dump 1. Log into the linux HANA host presenting the issue as sidadm user; 2. Run command hdbcons; 3. On the hdbcons console run command below: > runtimedump dump,HANA kernel dump HANA start and stop commands; To start HANA services login with <sid>adm. HANA start command: HDB start stop command: HDB stop, HANA services
#Parts of dialog response time #Parts of SAP response time and Processing time?- Wait time: the dispatcher is waiting for a free work process (= dispatcher queue).- Load/generating time: for loading/generating screens and ABAP programs and CUA elements (not in presentation).- DB time for accessing and waiting for the database interface and therefore for the underlying database.- Roll-in time: for the roll-in of the roll area context of a dialog step and possibly for a dialog step that is waiting for RFCs (as of Rel. 4.0A and also called 'roll wait time' – see below for more information).- Enqueue time: for setting a logical SAP enqueue.- DB procedure time: time for processing DB procedures in the database (as of Rel. 4.6C; for example, in liveCache). SAP performance
HANA slow system performance: Slow system-wide performance issues are problems that could be caused by excessive use of CPU misuse of SAP HANA database resource such as locks or configuration of OS parameters. Generally when you encounter a performance issue you may see continuing high usage of CPU according to OS commands or load graph or many pending or waiting threads in the thread view (both are visible from SAP HANA studio  Administration  Performance) If the entire system looks hung or works extremely slower than before check the following. Since the performance issue could persist as time goes by or could happen sporadically to analyze root cause please gather runtime dump more than twice with 3 minute intervals for further investigation by SAP as per SAP Note 1813020 - How to generate a runtime dump on SAP HANA. The runtime dumps should be collected while the system is experiencing the issue for later analysis in case the situation is already resolved Additionally there is case where we need to check sar files or /var/log/messages because the cause could be at the OS level.,HANA performance
#How to make an upgrade in the HANA? #HANA upgrade #HANA update 1. If you have SLT Based setup or any kind of replication to HANA and stop it. 2. Take the backup of HANA. 3. Check if there is any plugins installed or not. To check it. Login to HANA using studio. In administration you can check if there is any plugins or not. 4. If there is plugin and you are not using it. You can uninstall these plugin. Note:2223318 and 1920457 5. To uninstall and login to Hana server using root. Go to folder SHARED/<SID>/HDBLCM-> open in terminal. Execute below command. 6. ./hdblcm --action=uninstall --component=lcapps 7. ./hdblcm --action=uninstall --component=afl 8. Because these plugin will throw error while update. 9. Now go to new download folder which you have to update. 10. Open in terminal -> provide the permission to that folder. 11. chmod –R 777 <path of folder including folder name> 12. ./hdbupd 13. It will ask system ID to update and <SIDADM> password SYSTEM password 14. Continue till update. 15. After update and start replication or SLT or any kind of services which was stopped earlier. 16. Try to update Hana studio and sap hostagent and Hana client etc. with the same patch level.,HANA upgrade
#Long running commit #commit takes long time #HANA commit problem# HANA commit performance problem: It usually occurs due to DR line saturation. You can provide a temporary solution by increasing the HANA logshipping_async_buffer_size parameter at production. However solving the DR system performance problem or increasing the line capacity provides a permanent solution HANA performance, HANA performance
#is a customer of the HANA #HaaS customers #HANA customers #HANA as a service customers : - Linea Dekor - Gencallar Giyim - Starwood - Polifarma - Ditaş (ÇVM) - Mudo - MQX - Lota Ayakkabı - Umur Basım - Eureko - Gateway Lojistik - KLV İnşaat - Akedaş - TKG Otomotiv - Fuchs - Aygaz - FKT - ÇOY - Arçelik LG - Tüpraş - Ford Otosan - Ersa Mobilya - Euro Gıda - Aktül - Vakko - Hisar Çelik - Inventram - Demirexport - Bakioğlu - Orka - Astaş - Karadeniz Holding - Engine Holding - Mess - Generica - KoçSistem - Farplas - Koç Hayat Emeklilik - OPET - Soma Çimento - GGG - Polat - Sarkuysan - Koç Yaşa Çok Yaşa - Ram - Arçelik - İzeltaş - Şenpiliç - Otokoç - Ingage - Koçtaş - Halla - VEM - Kopaş - Sampa - Zer - izocam - TOFAŞ - Tat - Entek - Token - Diler Holding - Fragola - Bilkom - Otokar #is HaaS customer #at HaaS, HaaS customers
#how to import SCA into J2EE server? #how do I import an SCA package into J2EE server? #J2EE single package deployment #J2EE single package #J2EE single package deployment #Java single package deployment #Java single package #sap j2ee sca deployment #java server sca deployment Procedure: - Copy the SCA file to a local directory. - Open a command prompt and run the following command: 'telnet localhost 5<AS_Java_instance_number>08' where <AS_Java_instance_number> is the system number of the AS Java instance (next to the thin server icon in SAP MMC). The telnet port is the HTTP port for your instance + 8. - Log in with NetWeaver Administrator credentials. - Once logged in, execute the following commands: - add deploy - deploy <sca_file_location>, J2EE SCA deployment
#who are TİM contacts? #TİM contacts #Display TİM contacts -Süleyman Şanlı suleymansanli@tim.org.tr 0(530)1495470 -Emin Bağcı MHY emin.bagci@kocsistem.com.tr 0(549)3896540 -Ahmet Yıldırım Planlamacı ahmet.yildirim@ext.kocsistem.com.tr 0(530)1571788 -Onur Kılıç Danışman onur.kilic@ext.kocsistem.com.tr 0(542)3518793,Contacts
#who are Arçelik contacts? #Arçelik contacts #Display Arçelik contacts -İsa Sarı isa.sarı@arcelik.com 0(532)7640034 Kriz Esnasında aranacak 4. Kişi -Okan Sancaklı okan.sancakli@arcelik.com 0(536)4031092 Kriz Esnasında aranacak 1. Kişi -Tuğba Yıldırım tugba_yildirim@arcelik.com 0(538)2703670 Kriz Esnasında aranacak 2. Kişi -Serkan Karadeniz serkan.karadeniz@arcelik.com 0(506)9482460 Kriz Esnasında aranacak 3. Kişi -Tuğrul Tolga Salış tugrultolga.salis@kocsistem.com.tr 0(533)5040039 -Yasin Öz Planlamacı yasin.oz02@kocsistem.com.tr 0(549)5623879,Arçelik Contacts
#who are HSBC contacts? #HSBC contacts #Display HSBC contacts - Gülru Seber gulruseber@hsbc.com.tr 0(532)6365854 - Gonca Yılmaz goncayilmaz@hsbc.com.tr 0(544)2345197 -Buğra Ergül Danışman bugra.ergul@ext.kocsistem.com.tr 0(538)5462280 -Işık Dündar Mhy isik.dundar@kocsistem.com.tr 0(549)7259359 -Ahmet Yıldırım Planlamacı ahmet.yildirim@ext.kocsistem.com.tr 0(530)1571788,Contacts
#who are Koçtaş contacts? #Koçtaş contacts #Display Koçtaş contacts Eray Kaya eray.kaya@koctas.com.tr 0(507)6063939 -Emre Kibar emre.kibar@koctas.com.tr 0(507)6063939 -Özlem Duran Mhy ozlem.duran@kocsistem.com.tr 0(549)5621606 -Semih Arslan Planlamacı semih.arslan@kocsistem.com.tr 0(549)5784037 - Yasin Öz Planlamacı Yasin.Oz02@kocsistem.com.tr 0(549)5623879 -Tuna Köse Proje tuna.kose@kocsistem.com.tr 0(549)5783896 -Ertan İdare Danışman ertan.idare@kocsistem.com.tr 0(549)5613203,Contacts
#who are TEKB contacts? #TEKB contacts #Display TEKB contacts - Ali İhsan Barışman abarisman@tekb.org.tr 0(532)3855839 -Tolga AkçavlanMHYtolga.akcavlan@kocsistem.com.tr(533)5039904 - Ahmet Yıldırım Planlamacı ahmet.yildirim@ext.kocsistem.com.tr 0(533)5039904 - Zekeriya Gül Planlamacı zekeriya.gul@kocsistem.com.tr 0(549)3896529- Ertan İdare Danışman ertan.idare@kocsistem.com.tr 0(549)5613203,Contacts
#who are Türk Traktör contacts? #Türk Traktör contacts #Display Türk Traktör contacts - Hafize Selimoğlu hafize.selimoglu@turktraktor.com.tr 0(549)7957787 -Tolga Başer tolga.baser@turktraktor.com.tr 0(553)5852561 -İlay Telmen ilay.telmen@turktraktor.com.tr 0(538)5676683 -TT Sap Grubu _SAPGrubu@turktraktor.com.tr -Emre Gedik Danışman emre.gedik@kocsistem.com.tr 0(542)7760231 -Esra Başoğul Mhy esra.basogul@kocsistem.com.tr 0(549)7724876 -Ahmet Yıldırım Planlamacı ahmet.yildirim@ext.kocsistem.com.tr 0(530)1571788,Contacts
#who are Tüpraş contacts? #Tüpraş contacts #Display Tüpraş contacts  - Fatih Sultan Akdeniz fatihsultan.akdeniz@tupras.com.tr 0(553)3523563 - Hakan Şahin hakan.sahin@tupras.com.tr 0(533)3660395 - Tüpraş Sap Grubu _tupras-gm-kbc@tupras.com.tr - Enis Kütük Danışman enis.kutuk@kocsistem.com.tr 0(549)3897103 -Ümit Karaca Mhy umit.karaca@kocsistem.com.tr 0(549)7447021 -Çağrı Kasapoğlu Planlamacı cagri.kasapoglu@ext.kocsistem.com.tr 0(531)8680031,Contacts
#who are Bakioğlu contacts? #Bakioğlu contacts #Display Bakioğlu contacts  - Gözde Özçelik gozde.ozcelik@bakioglu.com.tr 0(549)7833375 -Seçil Ünal secil.unal@bakioglu.com.tr 0(549)8256365 - Baybora Uzunoğlu baybora.uzunoglu@bakioglu.com.tr 0(505)3847505 -Dilan Arslan Mhy dilan.arslan@kocsistem.com.tr 0(549)3891543 -Zekeriya Gül Planlamacı zekeriya.gul@kocsistem.com.tr 0(549)3896529,Contacts
#who are Euro Gıda contacts? #Euro Gıda contacts #Display Euro Gıda contacts  - Kerim Deniz Kaçmaz denizkacmaz@eurogida.com.tr 0(538)6537100 -Ahmet Uzunkuşlar ahmetuzunkuslar@eurogida.com.tr 0(554)7734624 -Merve Yücel merveyucel@eurogida.com.tr 0(506)5198774 - Işık Dündar Mhy isik.dundar@kocsistem.com.tr 0(549)7259359 -Zekeriya Gül Planlamacı zekeriya.gul@kocsistem.com.tr 0(549)3896529,Contacts
#who are İzeltaş contacts? #İzeltaş contacts #Display İzeltaş contacts  - Barış Eroğlu baris.eroglu@izeltas.com.tr 0(535)7423249 -Emin Bağcı MHY emin.bagci@kocsistem.com.tr 0(549)3896540 -Ahmet Yıldırım Planlama ahmet.yildirim@ext.kocsistem.com.tr -Deniz Aytur Danışman deniz.aytur@ext.kocsistem.com.tr 0(542)6265708,Contacts
#who are Soma Çimento contacts? #Soma Çimento contacts #Display Soma Çimento contacts - Mahmut İfşat mifsat@somacimento.com 0(542)2991777 - Emin Bağcı Mhy emin.bagci@kocsistem.com.tr 0(549)3896540 -Çağrı Kasapoğlu Planlamacı cagri.kasapoglu@ext.kocsistem.com.tr 0(535)4592104,Contacts
#who are Otokar contacts? #Otokar contacts #Display Otokar contacts -Adnan Güçlü aguclu@otokar.com.tr 0(549)8130321 -İbrahim Afak iafak@otokar.com.tr 0(535)6193585 -Emre Gedik Danışman emre.gedik@kocsistem.com.tr 0(542)7760231 -Emin Bağcı Mhy emin.bagci@kocsistem.com.tr 0(549)3896540 -Ali Can Akyüz Planlamacı alican.akyuz@ext.kocsistem.com.tr,Contacts
#who are Bilkom contacts? #Bilkom contacts #Display Bilkom contacts  Seda Özeren Yıldız seda.ozeren@bilkom.com.tr 0(542)3001126 -Sena Şahin sena.sahin@bilkom.com.tr 0(549)6507842 -Emre Gedik Danışman emre.gedik@kocsistem.com.tr 0(542)7760231 -Bülent Dışkaya Mhy bulent.diskaya@kocsistem.com.tr 0(530)5245293 -Zekeriya Gül Planlamacı zekeriya.gul@kocsistem.com.tr 0(549)3896529,,Contacts
#who are DemirExport contacts? #DemirExport contacts #Display DemirExport contacts - BT Müdürü Kürşad Uğur kursadu@demirexport.com  0(555)5945573 -ERP Sorumlusu Binnaz Kılıçlı binnaz.kilicli@demirexport.com  0(530)2915778 -MHY özlem Duran ozlem.duran@kocsistem.com.tr -Planlamacı ahmet.yildirim@ext.kocsistem.com.tr,Contacts
#who are Migros contacts? #Migros contacts #Display Migros contacts  - Emre Kocabıyık  emrekoc@migros.com.tr 0(530)6778150 -Burcu Polat burcumu@migros.com.tr 0(538)7029681 -MHY Nedim Dal  nedim.dal@kocsistem.com.tr -Planlamacı Semih Arslan semih.arslan@kocsistem.com.tr,Contacts
#who are Thy Opet contacts? #Thy Opet contacts #Display Thy Opet contacts  -Ceren Bulut ERP Yöneticisi ceren.bulut@thyopet.com 0(549)4624582 -Muharrrem Yalçın Kurumsal Bilişim Çözümleri Yöneticisi muharrem.yalcin@thyopet.com 0(212)4682937 -Dilan Arslan MHY dilan.arslan@kocsistem.com.tr 0(549)3891543 -Aydın Arıkan Planlamacı aydin.arikan@ext.kocsistem.com.tr 0(554)9761225,Contacts
#who are Ark contacts? #Ark contacts #Display Ark contacts - Semih Dağ semihd@arkinsaat.com.tr 0(545) 8978900 –Hacer GB  Danışman hacer.goren@ext.kocsistem.com.tr 0(530) 5966990 –Merve Çayıraltı Mhy merve.cayiralti@kocsistem.com.tr 0(549) 3896675 –Çağrı Kasapoğlu Planlamacı cagri.kasapoglu@ext.kocsistem.com.tr 0(531)8680031,Contacts
#who are Koç Yaşa contacts? #Koç Yaşa contacts #Display Koç Yaşa contacts contacts: - Umut Düvenci umut.duvenci@kocyasa.com 0(535) 2304120 –Hacer GB  Danışman hacer.goren@ext.kocsistem.com.tr 0(530)5966990 –Dilan Arslan MHY dilan.arslan@kocsistem.com.tr 0(549)3891543 –Zekeriya Gül Planlamacı zekeriya.gul@kocsistem.com.tr 0(549)3896529,Contacts
#who are MQX contacts? #MQX contacts #Display MQX contacts - Can Kenanoğlu can.kenanoglu@mediaqx.com -Serra Atabek serra.atabek@mediaqx.com -Hacer GB  Danışman hacer.goren@ext.kocsistem.com.tr 0(530)5966990 –Işık Dündar MHY isik.dundar@kocsistem.com.tr 0(549) 7259359 –Begüm Ergin Planlamacı begum.ergin@kocsistem.com.tr 0(549)5620480,Contacts
#who are Sendeo contacts? #Sendeo contacts #Display Sendo contacts - Murat Genç Murat.Genc@sendeo.com.tr 0(545)5030452 –Hacer GB  Danışman hacer.goren@ext.kocsistem.com.tr 0(530)5966990 –Ümit Karaca MHY umit.karaca@kocsistem.com.tr 0(549)7447021 –Çağrı Kasapoğlu Planlamacı cagri.kasapoglu@ext.kocsistem.com.tr 0(531)8680031,Contacts
#who are Mudo contacts? #Mudo contacts #Display Mudo contacts - Uğur Güler ugur.guler@mudo.com.tr 0(532)0640004 -Özlem Duran Mhy ozlem.duran@kocsistem.com.tr 0(549)5621606 - Ahmet Yıldırım Planlamacı  ahmet.yildirim@ext.kocsistem.com.tr 0(530)1571788  -Doruk Tekintaş Danışman doruk.tekintas@ext.kocsistem.com.tr 0(506)6780961,Contacts
#who are Chippin contacts? #Chippin contacts #Display Chippin contacts - Aykut Pehlivan aykut.pehlivan@chippin.com.tr 0(536)2882726 -Tufan Karahançer Mhy tufan.karahancer@kocsistem.com.tr 0(530)5111772 - Zekeriya Gül Planlamacı  zekeriya.gul@kocsistem.com.tr 0(549)3896529  -Doruk Tekintaş Danışman doruk.tekintas@ext.kocsistem.com.tr 0(506)6780961,Contacts
#who are İsken contacts? #İsken contacts #Display İsken contacts - Ergun Fırat ergun.firat@isken.com.tr 0(533)3007609 - Türker Kılıç turker.kilic@isken.com.tr 0(554)7335244 -Tufan Karahançer Mhy tufan.karahancer@kocsistem.com.tr 0(530)5111772 - Zekeriya Gül Planlamacı  zekeriya.gul@kocsistem.com.tr 0(549)3896529  -Doruk Tekintaş Danışman doruk.tekintas@ext.kocsistem.com.tr 0(506)6780961,Contacts
#who are Ingage contacts? #Ingage contacts #Display Ingage contacts - Umutcan Ağan umutcana@ingage.media 0(554)8997071 - Mihriban Dalkıran mihriband@ingage.media 0(549)5620219 -Dilan Arslan Mhy dilan.arslan@kocsistem.com.tr 0(549)3891543 - Çağrı Kasapoğlu Planlamacı  cagri.kasapoglu@ext.kocsistem.com.tr 0(535)4592104  -Doruk Tekintaş Danışman doruk.tekintas@ext.kocsistem.com.tr 0(506)6780961,Contacts
#who are RAM contacts? #RAM contacts #Display RAM contacts - Cenk Yaşar cenky@ram.com.tr 0(549)6400986 - Aleyna Kayabaşı aleynak@ram.com.tr 0(532)6687115 -Emin Bağcı Mhy emin.bagci@kocsistem.com.tr 0(549)3896540 - Emre Adıgüzel Planlamacı  emre.adiguzel@ext.kocsistem.com.tr 0(532)6718289  -Doruk Tekintaş Danışman doruk.tekintas@ext.kocsistem.com.tr 0(506)6780961,Contacts
#who are Zer contacts? #Zer contacts #Display Zer contacts - Yusuf Seven yusufs@koczer.com 0(549)5629798 - Tuğba Şişik TUGBAS@koczer.com 0(543)8359911 -Ümit Karaca Mhy umit.karaca@kocsistem.com.tr 0(549)7447021 - Yasin Öz Planlamacı  yasin.oz02@kocsistem.com.tr 0(549)5623879 -Doruk Tekintaş Danışman doruk.tekintas@ext.kocsistem.com.tr 0(506)6780961,Contacts
#who are ENTEK contacts? #ENTEK contacts #Display ENTEK contacts - Oğuz Ahmet Arslan ahmet.arslan@entekelektrik.com.tr 0(507)4729938 -Hilmi Cihan MERAL Danışman hilmicihan.meral@ext.kocsistem.com.tr 0(539)8894845 -Begüm Ergin Planlamacı begum.ergin@kocsistem.com.tr 0(549)5620480 -Dilan Arslan MHY dilan.arslan@kocsistem.com.tr 0(549)3891543,Contacts
#who are Elginkan contacts? #Elginkan contacts #Display Elginkan contacts - Mustafa Yurttaş mustafa.yurttas@elginkan.com.tr0(535)6936168 -Hilmi Cihan MERAL Danışman hilmicihan.meral@ext.kocsistem.com.tr 0(539)8894845 -Gökhan Günal Planlamacı gokhan.gunal@kocsistem.com.tr 0(549)6783123 -Özlem Duran MHY ozlem.duran@kocsistem.com.tr 0(549)5621606,Contacts
#who are Aygaz contacts? #Aygaz contacts #Display Aygaz contacts - Emre Karakurum emre.karakurum@aygaz.com.tr 0(549)5621038 -Korhan Özduygu korhan.ozduygu@aygaz.com.tr 0(549)7498437 - Emre Tamer emre.tamer@aygaz.com.tr 0(549)7498438 - Ümit Karaca Mhy ümit.karaca@kocsistem.com.tr 0(549)7447021 -Gökhan Günal Planlamacı gokhan.gunal@kocsistem.com.tr 0(549)6783123 - Yasin Kurtuluş Danışman yasin.kurtulus@kocsistem.com.tr 0(549)6354117,Contacts
#who are Karadeniz Holding contacts? #Karadeniz Holding contacts #Display Karadeniz Holding contacts - Nazan Ünal nazan.unal@karpowership.com 0(539)2873717 - Gülistan Karapeçe gulistan.karapece@karpowership.com 05443494039 - Emrah Yavuz gulistan.yilmaz@karpowership.com 0(535)3659435 - Tufan Karahançer MHY tufan.karahancer@kocsistem.com.tr 0(530)5111772 - Aydın Arıkan Planlamacı aydin.arikan@kocsistem.com.tr <Telefon no bilinmiyor> - Yasin Kurtuluş Danışman yasin.kurtulus@kocsistem.com.tr 0(549)6354117,Contacts
#who are OPET contacts? #OPET contacts #Display OPET contacts - Cenk Urağ cenk.urag@opet.com.tr 0(549)5626002 - Ahmet Akgül ahmet.akgul@opet.com.tr 0(549)5626035 -Ebru Palak ebru.palak@opet.com.tr 0(549)5626003 -Emin Bağcı MHY emin.bagci@kocsistem.com.tr -Ahmet Yıldırım Planlamacı ahmet.yildirim@ext.kocsistem.com.tr -Yasin Kurtuluş Danışman yasin.kurtulus@kocsistem.com.tr 0(549)6354117,Contacts
#who are Aytemiz contacts? #Aytemiz contacts #Display Aytemiz contacts - Ebru Safer ebru.safer@aytemiz.com.tr 0(532)7204738 -Işık Dündar MHY isik.dundar@kocsistem.com.tr 0(549)7259359 -Hakan Tülay Planlamacı hakan.tulay@ext.kocsistem.com.tr0(536)2882647 - Yavuz Aydın Danışman yavuz.aydin@ext.kocsistem.com.tr,Contacts
#who are Çelebi contacts? #Çelebi contacts #Display Çelebi contacts - Özlem Duran MHY ozlem.duran@kocsistem.com.tr 0(549)5621606 -yasin.oz02@kocsistem.com.tr 0(549)5623879,Contacts
#who are Tofaş contacts? #Tofaş contacts #Display Tofaş contacts: - İsmail Müftüoğlu ismai.muftuoglu@tofas.com.tr 0(549)7944064 SAP Architect -Emir Yılmaz emir.yilmaz@tofas.com.tr 0(549)6948234 Bulut Bilişim Mühendisi -Elif Çekinmez elif.cekinmez@tofas.com.tr HR Danışmanı -Serkan Demir serkan.demir@tofas.com.tr Fiori Danışmanı -Talha Özen talha.ozen@tofas.com.tr 0(549)6948433 Dizayn Mühendisi -Okan Çelik okan.celik@kocsistem.com.tr 0(549)6578215 -Aydın Arıkan Planlamacı aydin.arikan@ext.kocsistem.com.tr 0(554)9761225,Contacts
#who are Arçelik LG contacts? #Arçelik LG contacts #Display Arçelik LG contacts - Merve Kayan merve.kayan@arcelik-lg.com 0(506)1599455 - Yasin Çalkaya yasin.calkaya@arcelik-lg.com 0(532)7871518-Tuğrul Tolga SalışMHYtugrultolga.salis@kocsistem.com.tr0(533)5040039 - Yasin Öz Planlamacı yasin.oz02@kocsistem.com.tr 0(549)5623879 - Onur Kılıç Danışman onur.kilic@ext.kocsistem.com.tr 0(542)3518793,Contacts
#who are Kablotek contacts? #Kablotek contacts #Display Kablotek contacts - Halil Özdemir halil.ozdemir@kabtek.com 0(530)1495470 -Tuncay öznalMHYtuncay.oznal@kocsistem.com.tr0(549)0000000 - Begüm Ergin Planlamacı begum.ergin@kocsistem.com.tr 0(549)5620480 - Onur Kılıç Danışman onur.kilic@ext.kocsistem.com.tr 0(542)3518793,Contacts
#who are Divan contacts? #Divan contacts #Display Divan contacts - İnci Güvenli inci.guvenli@divan.com.tr 0(530)000000 - Erkan Engin erkan.engin@divan.com.tr 0(530)000000Özlem DuranMHYozlem.duran@kocsistem.com.tr0(549)5621606 - Ahmet Yıldırım Planlamacı ahmet.yildirim@ext.kocsistem.com.tr 0(530)1571788 - Onur Kılıç Danışman onur.kilic@ext.kocsistem.com.tr 0(542)3518793,Contacts
#who are Getir contacts? #Getir contacts #Display Getir contacts - Caner Tiryaki caner.t@getir.com 0(530)000000 -Emin BağcıMHYemin.bagci@kocsistem.com.tr0(549)3896540 - Ahmet Yıldırım Planlamacı ahmet.yildirim@ext.kocsistem.com.tr 0(530)1571788 - Onur Kılıç Danışman onur.kilic@ext.kocsistem.com.tr 0(542)3518793,Contacts
#who are TOKEN contacts? #TOKEN contacts #Display TOKEN contacts - Türkan Konuk turkan.konuk@tokeninc.com 0(530)5229080 - İlker Erdoğan ilker.erdogan@tokeninc.com 0(549)7750790 - Işık Dündar MHYisik.dundar@kocsistem.com.tr0(549)7259359 - Aydın Arıkan  Planlamacı aydin.arikan@ext.kocsistem.com.tr 0(554)9761225 - Onur Kılıç Danışman onur.kilic@ext.kocsistem.com.tr 0(542)3518793,Contacts
#who are Sarkuysan contacts? #Sarkuysan contacts #Display Sarkuysan contacts - İsmail AK i.ak@sks.com.tr 0(538)9747015 -Sabri Savaş s.savas@sks.com.tr 0(539)4984753 - Okan Çelik MHYokan.celik@kocsistem.com.tr0(549) 657 82 15 - Hakan Tülay  Planlamacı hakan.tulay@ext.kocsistem.com.tr 0(536)2882647 -Sena Akbel Danışman sena.akbel@ext.kocsistem.com.tr 0(551)3881689,Contacts
#who are Genveon contacts? #Genveon contacts #Display Genveon contacts - Kerem KÖY kerem.koy@genveon.com 0(554)8208008 -   Ümit Karaca MHY umit.karaca@kocsistem.com.tr0(549)7447021 -Ahmet Yıldırım  Planlamacı ahmet.yildirim@ext.kocsistem.com.tr 0(535)4592104 -Sena Akbel Danışman sena.akbel@ext.kocsistem.com.tr 0(551)3881689,Contacts
#who are Koç Üniversitesi contacts? #Koç Üniversitesi contacts #Display Koç Üniversitesi contacts contacts: - Tayfun YÜZÜK tyuzuk@ku.edu.tr 0(549)5627016 -Batıkan Halis Yayla byayla@ku.edu.tr 0(549)5627077 -Özlem Duran Mhy ozlem.duran@kocsistem.com.tr 0(549)5621606 -Zekeriya Gül  Planlamacı zekeriya.gul@kocsistem.com.tr 0(549)3896529 -Sena Akbel Danışman sena.akbel@ext.kocsistem.com.tr 0(551)3881689,Contacts
#who are Ford contacts? #Ford contacts #Display Ford contacts - Özgür Şahin osahin27@ford.com.tr 0(549)6100108 -Özgür Yenipınar HR oyenipin@ford.com.tr0(554)6326324 -Gülben Arslan HR garslan6@ford.com.tr 0(506)5938947-Tuğrul Tolga Salış MHY tugrultolga.salis@kocsistem.com.tr 0(533)5040039 -Ahmet Yıldırım Planlamacı ahmet.yildirim@ext.kocsistem.com.tr 0(554)7708978,Contacts
#who are Vakko contacts? #Vakko contacts #Display Vakko contacts - Güray Koç SAP ERP Müdürü guray.koc@vakko.com.tr - Alper Kıran SAP ERP Sorumlusualper.kiran@vakko.com.tr - Tansel Çak Altyapı Sorumlusu tanselc@vakko.com.tr - Tuncay Öznal MHY tuncay.oznal@kocsistem.com.tr 0(549)5620375 -Ali Can Akyüz Planlamacı alican.akyuz@ext.kocsistem.com.tr 0(549)3896540 -Serdar Oktay TUNÇ Danışman serdar.tunc@ext.kocsistem.com.tr 0(546)8611420,Contacts
#who are Ferro Döküm contacts? #Ferro Döküm contacts #Display Ferro Döküm contacts - Murat Yurtal murat.yurtal@efesan.com.tr0(542)4848404 -SAP BT sap_bt@efesan.com.tr -Özgür Kılıç ozgur.kilic@efesan.com.tr 0(530)1406131-Özlem İnce MHY ozlem.ince@kocsistem.com.tr 0(533)2406926 -Aydın Arıkan Planlamacı aydin.arikan@ext.kocsistem.com.tr 0(554)9761225-Yüksel Ali Akgün Danışman yukselali.akgun@ext.kocsistem.com.tr 0(538)7815948,Contacts
#who are Marzinc contacts? #Marzinc contacts #Display Marzinc contacts - Kemal Erdin erdin@erdinltd.com.tr 0(532)3102869 -Dilan Arslan MHY dilan.arslan@kocsistem.com.tr 0(549)3891543 -Çağrı Kasapoğlu Planlama cagri.kasapoglu@ext.kocsistem.com.tr -Yüksel Ali Akgün Danışman yukselali.akgun@ext.kocsistem.com.tr 0(538)7815948,Contacts
#who are Setur Marina contacts? #Setur Marina contacts #Display Setur Marina contacts - Kenan Kaan Çalıştırıcı kenancalistirici@seturmarinas.com 0(549)5690000-Kudret Topuz Mali İşler kudrettopuz@seturmarinas.com -Özden Yıldırım MHY ozden.yildirim@kocsistem.com.tr 0(549)3891226 -Suna Yılmaz Sipariş İşlemleri suna.karahal@kocsistem.com.tr0(549)6237105 -Yüksel Ali Akgün Danışman yukselali.akgun@ext.kocsistem.com.tr 0(538)7815948,Contacts
#who are Kopaş contacts? #Kopaş contacts #Display Kopaş contacts - Birkan UÇAR Birkan.UCAR@kopas.com 0(533)9228596 - Tuğrul Tolga Salış MHYtugrultolga.salis@kocsistem.com.tr0(533)5040039 - Aydın Arıkan  Planlamacı aydin.arikan@ext.kocsistem.com.tr 0(536)2882647  - Esin Okta Danışman esin.okta@ext.kocsistem.com.tr 0(545)7643282,Contacts
#who are İnventram contacts? #İnventram contacts #Display İnventram contacts - Hüseyin Uğur huseyinu@koc.com.tr 0(532)7493128 - Emin Bağcı MHYemin.bagci@kocsistem.com.tr0(549)3896540 - Zekeriya Gül  Planlamacı zekeriya.gul@kocsistem.com.tr  0(549)3896529  - Esin Okta Danışman esin.okta@ext.kocsistem.com.tr 0(545)7643282,Contacts
#who are Sarıbekir contacts? #Sarıbekir contacts #Display Sarıbekir contacts - Fatma Çavuş fatmacavus@saribekir.com.tr 0(532)3530837 - Okan Çelik MHYokan.celik@kocsistem.com.tr0(549)6578215 - Çağrı Kasapoğlu  Planlamacı cagri.kasapoglu@ext.kocsistem.com.tr 0(531)8680031  - Esin Okta Danışman esin.okta@ext.kocsistem.com.tr 0(545)7643282,Contacts
#who are RMK contacts contacts?#RMK contacts: - Hüseyin Akbaba huseyina@rmkmarine.com.tr  Veli Keskin velik@rmkmarine.com.tr - Nedim Dal MHYnedim.dal@kocsistem.com.tr 0(549)5620353 - Begüm Ergin  Planlamacı begum.ergin@kocsistem.com.tr 0(549)5620480  - Esin Okta Danışman esin.okta@ext.kocsistem.com.tr 0(545)7643282,Contacts
#who are Koç Holding contacts?#Koç Holding contacts: - İlter Sezan ilters@koc.com.tr@koc.com.tr 0(505)8916280  Sezin Demirci sezin.demirci@kocsistem.com.tr 0(549)8027286 - Emin Bağcı MHYemin.bagci@kocsistem.com.tr 0(549)3896529  - Esin Okta Danışman esin.okta@ext.kocsistem.com.tr 0(545)7643282,Contacts
#who are Diler contacts?#Diler Holding contacts: - Mehmet Ali Büyükimdat mehmetbuyukimdat@dilerhld.com -Işık Senyen MHY isik.senyen@kocsistem.com.tr 0(549)7482937 -Ahmet Yıldırım Planlamacı ahmet.yildirim@ext.kocsistem.com.tr -Serdar Tunç Danışman serdar.tunc@ext.kocsistem.com.tr 0(546)8611420,Contacts
#who are Ditaş contacts?#Ditaş contacts: - Mustafa Öncül moncul@ditasdeniz.com.tr 0(549)5623897 -Yılmaz Ertek yertek@ditasdeniz.com.tr 05324684555-Tuğrul Tolga Salış MHY tugrultolga.salis@kocsistem.com.tr 0(533)5040039 -Çağrı Kasapoğlu Planlamacı cagri.kasapoglu@ext.kocsistem.com.tr0(535)4592104 -İlayda Öner Danışman ilayda.oner@ext.kocsistem.com.tr 0(543)8098023,Contacts
#who are Fenerbahçe contacts?#Fenerbahçe contacts: - Emre Demirci emre.demirci@fenerbahce.orgÖzlem Duran MHY ozlem.duran@kocsistem.com.tr 0(549)5621606 -Çağrı Kasapoğlu Planlamacı cagri.kasapoglu@ext.kocsistem.com.tr0(535)4592104 -Mustafa Güler Danışman mustafa.guler@ext.kocsistem.com.tr 0(532)3806434,Contacts
#who are Opet Fuchs contacts?#Opet Fuchs contacts: - Tuğrul Tolga Salış MHYtugrultolga.salis@kocsistem.com.tr0(533)5040039 -Hakan Tülay Planlamacı hakan.tulay@ext.kocsistem.com.tr0(536)2882647 -Mustafa Güler Danışman mustafa.guler@ext.kocsistem.com.tr 0(532)3806434,Contacts
#who are Adeka contacts?#Adeka Contacts: - Sercan Gençtürk sercan.gencturk@adeka.com.tr -Esra Başoğul MHY esra.basoglu@kocsistem.com.tr0(549)7724876 -Hakan Tülay Planlamacı hakan.tulay@ext.kocsistem.com.tr0(536)2882647 -Mustafa Güler Danışman mustafa.guler@ext.kocsistem.com.tr 0(532)3806434,Contacts
#who are KoçSistem contacts?#KoçSistem contacts: - Serhat Tez serhat.tez@kocsistem.com.tr 0(549)7430928 -Gizem Çelik gizem.celik@kocsistem.com.tr -Zekeriya Gül Planlamacı zekeriya.gul@kocsistem.com.tr 0(549)3896529 -Mustafa Güler Danışman mustafa.guler@ext.kocsistem.com.tr 0(532)3806434,Contacts
#who are Koç Emeklilik contacts?#Koç Emeklilik contacts: - Erdoğan Aksoy erdogana@khev.org.tr -Işık Senyen MHY isik.senyen@kocsistem.com.tr 0(549)7482937 -Aydın Arıkan  Planlamacı aydin.arikan@ext.kocsistem.com.tr 0(536)2882647 -İlayda Öner Danışman ilayda.oner@ext.kocsistem.com.tr 0(543)8098023,Contacts
#who are callus contacts?#callus contacts: - Ali Günal Sap Sorumlusu ali.gunal@konecta-group.com 0(549)8134890 -Mesut Hançer Network mesut.hancer@konecta-group.com-Umut Onak Database umut.omak@konecta-group.com -Bengü Kabataş Yılmaz BW bengu.kabatas@konecta-group.com-Işık Dündar Mhy isik.dundar@kocsistem.com.tr 0(549)7259359 -Aydın Arıkan  Planlamacı aydin.arikan@ext.kocsistem.com.tr 0(536)2882647 -İlayda Öner Danışman ilayda.oner@ext.kocsistem.com.tr 0(543)8098023,Contacts
#who are Setur contacts?#Setur contacts: - Kenan Tuncay kenan.tuncay@setur.com.tr -Bülent Dişkaya MHY bulent.diskaya@kocsistem.com.tr 0(530)5245293 -Aydın Arıkan  Planlamacı aydin.arikan@ext.kocsistem.com.tr 0(536)2882647 -İlayda Öner Danışman ilayda.oner@ext.kocsistem.com.tr 0(543)8098023,Contacts
#who are Yapı Kredi contacts?#Yapı Kredi contacts: - Alper Çam Alper.Cam@ykteknoloji.com.tr -Murat Serdar Apohan MHY murat.apohan@kocsistem.com.tr 0(549)5620358 -Hakan Tülay Planlamacı hakan.tulay@ext.kocsistem.com.tr0(536)2882647 -Yüksel Ali Akgün Danışman yukselali.akgun@ext.kocsistem.com.tr 0(538)7815948,Contacts
#invalid packet size: packetSize #HANA #DisasterRecoveryProtocol #40002 #sendRequest dr_getservers #Cannot start HANA replication Configure ssl_enable=off on global.ini files. To disable ssl_enable parameter without shutdown follow steps: - Stop secondary hana database: sapcontrol -nr <instance_number> -function StopSystem - Unregister from secondary site: hdbnsutil -sr_unregister - Disable replication source on the primary: hdbnsutil -sr_disable --force - Set 'enable_ssl=off' in the global.ini file, under the property [system_replication_communication] in the primary - Enable replication source on the primary: hdbnsutil -sr_enable --name=<Site_name> - Set 'enable_ssl=off' in the global.ini file, under the property [system_replication_communication] in the secondary - Reregister the secondary: hdbnsutil -sr_register --name=<Site_name> --remoteHost=<remote_hostname> --remoteInstance=<Instance> --replicationMode=<mode> --operationMode=<op_mode> - Start the secondary hana: sapcontrol -nr <instance number> -function StartSystem
#How do I configure a HANA failover cluster, To configure a HANA failover cluster, you must integrate SAP HANA System Replication (HSR) with a cluster manager such as Pacemaker/Corosync. Steps:

1. Preparation:
- Two nodes with identical SAP HANA and OS versions, same kernel, patch level.
- Low-latency network (separate client and replication networks recommended).
- SSH trust for sidadm user and root access.

2. Install & Configure HANA:
- Install HANA identically on both nodes (same SID, instance number).
- Verify standalone operation.

3. Enable System Replication:
- On Primary:
  hdbnsutil -sr_enable --name=SITE_A
- On Secondary:
  hdbnsutil -sr_register --name=SITE_B --remoteHost=<PrimaryHost> --remoteInstance=00 --replicationMode=sync --operationMode=logreplay
- Verify with:
  hdbnsutil -sr_state

4. Install Cluster Software:
- On SUSE Linux: zypper in SAPHanaSR SAPHanaSR-doc pacemaker
- On RHEL: yum install pcs pacemaker
- Enable cluster services: systemctl enable pacemaker && systemctl start pacemaker

5. Example Pacemaker configuration:
crm configure primitive rsc_SAPHanaTopology_HDB00 ocf:suse:SAPHanaTopology \
 params SID=HDB InstanceNumber=00 \
 op monitor interval=10 timeout=600 \
 op start timeout=600 interval=0 \
 op stop timeout=300 interval=0 \
 meta resource-stickiness=0

crm configure primitive rsc_SAPHana_HDB00 ocf:suse:SAPHana \
 params SID=HDB InstanceNumber=00 \
 op start timeout=3600 interval=0 \
 op stop timeout=3600 interval=0 \
 op monitor interval=60 role=Master timeout=700 \
 op monitor interval=61 role=Slave timeout=700

crm configure ms msl_SAPHana_HDB00 rsc_SAPHana_HDB00 \
 meta clone-max=2 clone-node-max=1 notify=true

crm configure primitive rsc_ip_HDB00 IPaddr2 \
 params ip=10.0.0.100 cidr_netmask=24 \
 op monitor interval=10 timeout=20
crm configure colocation col_saphana_ip 2000: rsc_ip_HDB00:Started msl_SAPHana_HDB00:Master
crm configure order ord_saphana 2000: msl_SAPHana_HDB00:promote rsc_ip_HDB00:start

Monitoring:
- Use crm_mon -1 or pcs status for cluster health.
- Use HANA Studio/Cockpit for replication health.
- Regularly test failover and validate backups.
## 1 Getting Started
## 1.1 What is SAP Analysis for Microsoft Office, edition for SAP Analytics Cloud
SAP Analysis for Microsoft Office, edition for SAP Analytics Cloud, is a Microsoft Office Add-In that allows multidimensional analysis of data sources in Microsoft Excel and MS Excel workbook application design.
It is available for the following Microsoft Office versions:
- Office 365 (Excel)
- Microsoft Office 2019 (Excel)
- Microsoft Office 2016 (Excel)
In Microsoft Excel, Analysis is available in two separate tabs in the ribbon: Analysis and Analysis Design .
With Analysis, you can use SAP Analytics Cloud models, SAP BW data sources from the BI platform or from a BW system, and SAP HANA data sources. The data is displayed in the workbook in crosstabs. You can insert multiple crosstabs in a workbook with data from different sources and systems. If the workbook will be used by different users, it is also helpful to add info fields with information on the data source and filter status.
Using the design panel, you can analyze the data and change the view on the displayed data. You can add and remove dimensions and measures to be displayed easily with drag and drop. To avoid single refreshes after each step, you can pause the refresh to build a crosstab. After ending the pause, all changes are applied at once.
You can refine your analysis using conditional formatting, filter, prompting, calculations and display hierarchies.
You can also add charts to your analysis. If you want to keep a status of your navigation, you can save it as an analysis view. Other users can then reuse your analysis.
For more sophisticated workbook design, the Analysis contains a dedicated set of functions in Microsoft Excel to access data and meta data of connected systems. There are also a number of API functions available that you can use with the Visual Basic Editor, to filter data and set values for variables.
You can also plan business data based on the current data in your data source. You can enter the planning data manually and you can enter planning data automatically using planning functions and planning sequences of SAP BW Integrated Planning.
Analysis must be installed on your local machine. You can connect directly to a system or you can connect via a platform to include data sources. You can use the following platforms to store and share workbooks: SAP BusinessObjects business intelligence platform and SAP BW / SAP BW/4HANA.
##  Note
Microsoft Office documents contain free text fields. These text fields are not intended to store personal data without additional technical or organizational measures to safeguard data protection and privacy.
In order to ensure that analytical data which is personal data and which is retrieved from the servers with Analysis functionality, does not get stored in documents, the Analysis workbook property Remove Data Before Saving can be active in those workbooks.
## 1.2 Working with Analysis in Microsoft Excel
In Microsoft Excel, Analysis is available in two separate tabs in the ribbon: Analysis and Analysis Design .
The ribbon is part of the Microsoft Office user interface above the main work area that presents commands and options. Some Analysis options are available in the ribbon tab under File Analysis in Microsoft Excel.
This guide describes procedures using the ribbon. Most of the options are also available via the context menu.
## Related Information
Analysis in the File tab [page 8] Analysis tab [page 10] Analysis Design tab [page 13]
## 1.3 Customizing the User Interface
You can customize certain user interface areas of Analysis to meet your business needs.
##  Note
In Analysis versions less than 2.4, the display of the following commands was specified with file system settings: Convert to Formula, Create Web Application, Launch Query Designer and Planning group.
When switching to Analysis 2.5 from a version less than 4, for example 2.3, Analysis takes the definition from the setting in the file system. If the command was displayed in the 2.3 installation, it will also be displayed in the 2.5 installation.
To see how you can customize user interface areas using profiles, check out this how-to video: https:/ / youtu.be/X1jXGF8NiFs
## Related Information
Introduction to Customizing the User Interface [page 227]
## 1.4 About this guide
## 1.4.1  Who should read this guide?
This guide is intended for users interested in building and analyzing workbooks using SAP Analysis for Microsoft Office.
## 1.4.2  User profiles
There are three user profiles for SAP Analysis for Microsoft Office:
- Workbook Creator
- Users who create and maintain workbooks based on different data sources.
- Data Analyst Users who navigate through existing workbooks and analyze the data they contain.
- Administrator
IT specialists who install, configure and administer SAP Analysis for Microsoft Office. They also assign security rights and authorizations to workbook creators and analyzers.
If your existing profile needs to be modified, contact your IT administrator.
## 1.4.3  About the documentation set
The documentation set for SAP Analysis for Microsoft Office, edition for SAP Analytics Cloud, comprises the following guides and online help products:
##  Tip
The guides are regulary updated and enhanced. Make sure that you have the latest version by checking the SAP Help Portal on a regular basis.
## Administrator Guide
The Administrator Guide contains detailed information that a user needs to install, configure and administer Analysis for Microsoft Office, edition for SAP Analytics Cloud. The guide is available on the SAP Help Portal.
## User Guide
The User Guide contains the conceptual information, procedures and reference material that a user needs to create and analyze Microsoft Excel workbooks with Analysis for Microsoft Office, edition for SAP Analytics Cloud. The guide is available on the SAP Help Portal.
## Online Help
The online help contains the same information as the User Guides. It links directly to the documents on the SAP Help Portal.
## What's New Guide
The What's New guide for SAP Analysis for Microsoft Office,edition for SAP Analytics Cloud, provides a complete list of the new and modified features for SAP Analysis since the previous release. The guide is available on the SAP Help Portal.
## 2 Creating and Administrating Workbooks
In Analysis, you can work with SAP BW data sources from the BI platform or from a BW system, SAP Analytics Cloud models (analytic and planning) and SAP HANA data sources.
You can insert a data source into a standard workbook or default workbook. If you use a default workbook, styles, formatting and the workbook settings that you defined in the default workbook are used when you open a data source.
You can also insert data sources with local data into a workbook. To be analyzed, the local data is uploaded to a BW workspace.
New workbooks can be saved either on the SAP BusinessObjects business intelligence platform, a SAP BW platform or in a SAP BW/HANA system. Stored workbooks can be opened from the corresponding platforms. They can also be renamed or deleted on the platforms.
You can also convert workbooks created with the SAP BEx Analyzer 3.5 and SAP BEx Analyzer 7.0 to an Analysis workbook.
## Related Information
Inserting data sources in a workbook [page 20]
To insert a data source into a default workbook [page 31]
To open a workbook [page 33]
To save a workbook [page 35]
To rename a workbook [page 36]
To delete a workbook [page 37]
To protect a workbook or worksheet [page 38]
To convert a BEx workbook [page 40]
Inserting data sources using BW Workspaces [page 63]
## 2.1 Inserting data sources in a workbook
Using Analysis, edition for SAP Analytics Cloud, the first step for inserting a data source is establishing a connection to SAP Analytics Cloud:
1. Select Insert Data Source Select Data Source for Analysis . When you don't have a defined SAP Analytics Cloud connection yet, you get the following Connect to SAC dialog:

2. Select Create Connection to define your first connection to SAP Analytics Cloud. After defining the first connection, you get the following Connect to SAC dialog to connect to SAP Analytics Cloud.

If you have more than one SAP Analytics Cloud connection defined, you can use the drop-down to select the connection you want to establish. The preselected connection is the last one you used. You can also edit or delete the selected connection, or you can create a new one.
3. Select OK and enter your credentials to connect to SAP Analytics Cloud.
2. You need to enter your credentials only once. The next time you select OK , the connection is established automatically. If you select the option Remember my decision and use this connection from now on , you'll be automatically
connected to this SAP Analytics Cloud tenant the next time you start to insert a data source without seeing the Connect to SAC dialog. Y ou can set the setting AutoConnectToLastSelectedSacSystem to False to get the dialog again.
When the connection to SAP Analytics Cloud is established, you can continue to select a data source from the BI platform, a BW system, a SAP Analytics Cloud tenant or SAP HANA.
The BW data sources you can use are Queries, query views, and InfoProviders. You can also insert and analyze SAP Analytics Cloud models (analytic and planning) and SAP HANA data sources in an Analysis workbook.
You can add multiple crosstabs to a worksheet or workbook. The crosstabs can contain data from the same data source or from different sources. You can also use data sources that are stored in different systems in one workbook.
Please note that we do not recommend changing the definition of a query in the backend system after it has been inserted in an Analysis workbook. That's because the navigational state of the embedded queries is saved within the workbook in Analysis. When you reopen the workbook, this state is read and applied to the
queries. If the definition of one of the queries was changed, it might come to inconsistencies while refreshing the workbook, and changes to the query may not be reflected.
To add a crosstab with data to a workbook, you select a data source in the corresponding system. You need the appropriate authorizations for the platform you want to use and the relevant systems to insert a data source into a workbook. For more information, contact your IT administrator.
## Related Information
To insert a data source from the BI platform [page 22]
To insert a data source from a BW system [page 23]
To insert a SAP Analytics Cloud data source [page 25]
To insert a SAP HANA data source [page 29]
## 2.1.2  To insert a data source from a BW system
You can insert SAP BEx Queries, query views and BW InfoProviders as data sources into a workbook. These data sources are stored in a SAP BW system.
1. Select the cell in the worksheet where the crosstab with the data from the selected data source should be inserted.
2. Select Insert Data Source Select Data Source for Analysis .
As a first step, you need to connect to SAP Analytics Cloud. For more information, please see Inserting data sources in a workbook [page 20].
After establishing the SAP Analytics Cloud connection, the Log on to SAP BusinessObjects BI platform dialog box appears.
3. Select Skip to log on directly to a SAP BW system. Please note: When you're trying to connect to an insecure connection, you'll get a warning before you can proceed. Please contact you system administrator if you need further information.
4. Select a BW system in the list and press Next .
##  Note
If you log on with an initial password to a BW system, or your password is expired and needs to be reset, the dialog for changing the password opens automatically.
The Logon to System dialog box appears.
When logging on directly to a BW system, Local System is preselected for Show Connections , and all BW systems of your local SAP Logon are displayed.
You can refresh the displayed system list by choosing Refresh in the context menu or pressing F5 , for example after adding a new system to the SAP Logon.
5. Enter Client , User and Password in the fields and press OK . If you want to specify the system language, select Options and enter the language in the Language field.
6. Select a data source in the Select Data Source box and press OK .
For BW systems, the Select Data Source dialog consists of the following tabs:
- Search
You can select if you want to search for the Description , Technical Name or All . To retrieve data sources that begin with a specific string, you can type * after a partial string.
- Area
- Role
- Workspaces
- Environments
On the Search and Role tabs, you can specify the objects to be displayed: All , InfoProvider , Query or Query View .
Note that query views have only a technical name.
A new crosstab with the data of the selected data source is inserted into the worksheet. The SAP style set SAP Black&amp;White is used as default. Y ou can now analyze the data and change the displayed data set according to your needs. You can also add other components to your analysis.
##  Note
You can also activate Pause Refresh before inserting a data source. You can then insert a data source and define your analysis on the Analysis tab in the design panel (columns, rows and filter). The crosstab with the data source and the defined analysis will only be inserted after Pause Refresh is deactivated again.
## Related Information
Pausing Refresh [page 156]