Hi, This blog describes how to create a query snapshot in SAP BW, which creates a SAP HANA index on that query snapshot.How to do this?Run Transaction RSDDB in the SAP BW system and enter your SAP BW query name and click on Release Query as InfoProvi...
SAP had released a two versions for BPC 10.1; they are BPC 10.1 Classic and BPC 10.1 Embedded.The Classic version can be considered an extension of previous versions in the BPC family, and can be used to implement both planning and consolidations sol...
Usually test data does not exist in source systems to load in SAP BW. Even if some test data is available to load, then we need to create complete data flow which time consuming effort.By using this method, you can create sample transaction data usin...
The “Use Selection of Structure Elements” gives performance boost to BW query. By using this function the system only passes to the database the selections and key figures (KFs) of the columns (or structure elements) currently used to filter the quer...
When the SAP NetWeaver BW system is migrated to an SAP HANA database, all the InfoCubes are not automatically converted to SAP HANA optimized InfoCubes.The conversion of standard InfoCubes to SAP HANA optimized InfoCubes ensures that the cubes are se...
Hi Carsten,
Thank you for sharing your thoughts and concerns on the challenges of finding a workable solution for the user lifecycle in the current environment. It sounds like you're dealing with a complex situation that requires a lot of careful c...
Hi Aby,
Can you use check program RSR_QPROV_CHECK to find out if your query has restrictions for generating SAP HANA views in transaction RSDDB (SAP HANA Index Maintenance)?
I am not sure what has been changed on SAP BW 7.4 SP16. My example above i...
Hello German,
Hana view will not be automatically updated if there is new delta came to BW data.
At step 5 above, you need to schedule it on daily basis (after your BW loads are completed) so that snapshot remains up to date.
Nadeem
Hi Ingo,Since Design Studio 1.6 is out with nice features like scorecards and spreadsheet (not sure if formulas are supported), what is your advice if I should wait unless support pack arrive for 1.6 or can start with 1.5 SP2?Your input is highly app...