Archived discussions are read-only. Learn more about SAP Q&A

BW on HANA

Hi Experts,


I have the below questions pertaining to BW on HANA only, can some one please clarify: would really appreciate your help!

1. when we migrate the exiting cubes to "In Memory" cube, then we wont be having any more DIM tables. ?


2. now, If I want to do a "Real time" data load into this Cube. then can I use SLT?


3. when I use SLT, does that mean, the extractor should be real time enabled? and if it is, them when I do a data load, Am I actually doing a data load into BW Into In-Memory Cube? and if so, where can I see the data. do I need to login to HANA DB? or can I directly see it from Manage of Cube?


4.in which cases we need to create "attribute/analytical" views"?. I mean, now that I have the In memory cube (which has the Master data available in BW), do I still need to login to HDB and create "attribute/analytical" views"

5. what and when do we use Transient Info Providers?

Thanks

Kalyan



replied

Hi Kalyan,

Some of the points in order of architecture:

1. when we migrate the exiting cubes to "In Memory" cube, then we wont be having any more DIM tables. ?


--- In memory InfoCubes in BW on HANA do not have DIM tables. The SID tables are linked to the fact table directly. Please refer to the architecture at following location:

http://help.sap.com/saphelp_nw73/helpdata/en/e1/5282890fb846899182bc1136918459/frameset.htm

4.in which cases we need to create "attribute/analytical" views"?. I mean, now that I have the In memory cube (which has the Master data available in BW), do I still need to login to HDB and create "attribute/analytical" views"

--- If you are using BW on HANA, then there is no need for "Attribute / Analytical" views. These are implemented on "Standalone" HANA. If you have DSOs / InfoCubes migrated to "BW on HANA", you can use the same for reporting.

You might want to create these views, in case you have some data flows implemented in Standalone HANA and you wish to integrate it with BW data model. But that depends on the business case.

5. what and when do we use Transient Info Providers?

In case of BW on HANA architecture, Transient Providers are used to combine the Standalone HANA models with BW on HANA models. Please refer to the blog below which can help you understand the Transient providers and the use in BW on HANA context.

http://scn.sap.com/people/thomas.zurek/blog/2011/11/01/how-bw-on-hana-combines-with-native-hana

2. now, If I want to do a "Real time" data load into this Cube. then can I use SLT?

--- Regarding the data loads to Cubes in BW on HANA architecture, the ETL process remains same as it is on any regular BW architecture.


3. when I use SLT, does that mean, the extractor should be real time enabled? and if it is, them when I do a data load, Am I actually doing a data load into BW Into In-Memory Cube? and if so, where can I see the data. do I need to login to HANA DB? or can I directly see it from Manage of Cube?


--- Regarding data loading to Cube and managing the data and InfoCube, it remains exactly same as it is now. Nothing on BW would change if you move to BW on HANA.

Hope this helps.

Regards,

Ravi

2 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question