Hi Grace,
yes, with BW 7.30 and BWA 720 it is possible to index DSO/ODS data.
Have a look at this document on page 5.
Regards,
Jens
Hello Jen,
Thank you so much for replying.Have you tried Accelerating DSO ? If you have can a get a step by step guide on how to Accelerate a DSO? with the infocube i can right click and get option maintain BW accelerator index but with DSO it doesn't have that option.can u tell me how to Accelerate with DSO if u have applied it before.
Thank you!
Hi
Using BW 7.3 and BWA 7.2, it is now possible to have an accelerated DSO. But unlike in cubes where there is a straight forward "Right Click" create BWA indexes option, the DSO indexing is not soo simple.
BW 7.3 allows you to create a Hybrid Provider based on a DSO. When you create a Hybrid Provider, you essentially follow almost all steps of creating a cube like deciding which characteristics to bring from DSO, which dimensions e.t.c. The ETL process is done by BW itself and loading is taken care of by BW. So when a new request is activated in a DSO, it automatically gets loaded into the Hybrid Provider via BW generated transformations and DTP's.
you can then have a BWA on the Hybrid Provider.
Why would you do all this work?
In cases where you have all characteristics in the DSO and no lookup and transformation logic is needed, this is a easier development method.
Practically I have not see if being used anywhere.
Hope this helps.
The best way to index DSOs is to not use a HybridProvider but use a BWA only InfoCube. Please see my write up on this which contains screenshots walking you through the entire process.
http://www.sapbwtraininghq.com/business-warehouse-accelerator/
Hi Robert,
Thanks for the update. I hads some questions around the way this works from a technical point of view. This process still does not directly put an index on a DSO but creates a Cube with associated structures of Transformation and DTP being created by the system itself. So Now we have a seperate Technical object with in not a DSO but a cube
I am not sure on how this cube is used after the initial load and indexing.
1. What do we do if regular loads are being added to the DSO?
2. Do we need to run DTP from the DSO to cube after every new request into DSO?
Thanks
Chandra Malavalli
Chandra,
1. What do we do if regular loads are being added to the DSO?
You will need to set up a process chain that kicks off a DTP after you load the DSO. You need to keep the BWA only cube as recent as possible. Make sure to try and transfer the DSO delta data to the BWA only cube as frequently as possible.
2. Do we need to run DTP from the DSO to cube after every new request into DSO?
Yes, the BWA only cube will only write the data to memory when the DSO to BWA only cube load is kicked off. Otherwise the BWA only cube has no idea that the DSO has new data. The DTP runs very quickly as it's loading to memory so run it often.
Thanks
SAP BW Training
