Skip to Content

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 InfoProvider.

/wp-content/uploads/2015/11/1_836407.jpg

/wp-content/uploads/2015/11/2_836426.jpg

  • This launches the index maintenance screen where you select the table and click on Activate and Fill Index. After activating and filling the index is completed, Index Status will appear as green.

/wp-content/uploads/2015/11/3_836427.jpg

  • Log on to SAP HANA Studio to import the query as a snapshot that we created in the earlier step.

/wp-content/uploads/2015/11/5_836432.jpg

  • Import the SAP NetWeaver BW model by clicking File > Import. On the Import screen, click the SAP HANA Content folder, and choose the Import SAP NetWeaver BW Models option.

/wp-content/uploads/2015/11/6_836438.jpg

/wp-content/uploads/2015/11/7_836433.jpg

  • Select the connection and provide a Username and Password to login to the SAP NetWeaver BW system to import an SAP NetWeaver BW model> Click Next.

/wp-content/uploads/2015/11/8_836439.jpg

  • Select the Target folder where you want to import SAP NetWeaver BW models by entering the Target Package on the screen.

/wp-content/uploads/2015/11/9_836440.jpg

  • Import BW Query “DEMO_QUERY_03” snapshot and click “Next”. Note that imported models will be created as an SAP HANA model (analytic or calculation view) under the Target package sap.bw.

/wp-content/uploads/2015/11/10_836441.jpg

  • Once you have imported SAP BW Query as Hana View, you can check newly created SAP Hana View under Content > sap.bw

/wp-content/uploads/2015/11/11_836442.jpg

  • Make sure to apply “Analytic” privileges to assign BW analytics roles.

/wp-content/uploads/2015/11/12_836443.jpg

After the import of the query as a snapshot as SAP HANA views, these views can be exposed to SAP BusinessObjects Explorer or SAP Lumira for business users to search and explore on the SAP NetWeaver data.

Caveats

  • Since you are creating snapshot of your SAP BW Queries in SAP HANA database, this means you are using additional Hana memory to save these datasets.
  • Furthermore creation of indexing on SAP BW Queries to be scheduled on daily basis to have recent data.
To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

  1. German Mumma

    HI,

    Thanks for your post.

    I have a question regarding update of the BW data. If the data in BW updates (say, values changed, added, collumns added etc) will the HANA view be also updated or will I need to import the snapshot again? OR will I first need to create another snapshot and then import that new snapshot into HANA?

    (0) 
    1. Nadeem Malik Post author

      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

      (0) 
  2. Aby Aby

    Hi,

    Thanks for the valuable information. We have a doubt regarding the step # 3.Until step #3 we are going good. After step#3 , we cannot see any window for “Activate and Fill Index” like you have shown to perform step#4 and Step#5. Is it another t-code or it comes automatically once you complete step#3?

    We are on BW on HANA 7.4 SP16.

    We are trying to generate HANA view for query.(Is it possible to create HANA view for Non-Cumulative cube?)

    Any inputs/suggestions will be very helpful.

    thnks & rgds,

    aby

    (0) 
    1. Nadeem Malik Post author

      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 is based on SP13.

      Nadeem

      (0) 
      1. Vishal Sharma

        Hi ..do you know how new changes worked on this solution.

        if we add or delete columns or rows from existing bex query so how new changes reflect in HANA ..do we need to delete every thing in HANA side and need to recreate new index in RSDDB with existing bex query

         

        Also for me if i make any changes in existing query then i have to delete old index and need to create new one but is is not getting active (Green, always red). but earlier with first time development it worked but now after changes in rows/columns.

         

        (0) 
  3. anjali anjali

    Hi German,

     

    Thanks for the post, really helpful.

    I have doubt if we import BW models/query in HANA how the transportation to be done for this BW models?

     

    Thanks,

    Anjali

     

    (0) 

Leave a Reply