SEMANTIC PARTITIONING IN BW - can SPO cube be used to feed BPC model
We do have a requirement to implement the semantic partitioning on top of a standard DSO.
So my approach would be an info source with semantic partitioning of cubes on top of DSO. With this semantic partitioning of cubes, we plan to achieve the data segregation based on the 0FISCYEAR PERIOD.Then finally can we use the SPO-Cube as a feeder to BPC cube?
Comments / suggestions please!!!
Let me add one more line to my above post. I would like to add a BPC staging cube(standard info cube) on top of the semantic CUBE so that the BPC staging data will be feeded to BPC model and semantic cube can be used for BW reporting. Looking for a most efficient approach? Any comments / suggestions please!!!
Thanks in Advance
Ashok Babu Kumili replied
Great your approach is good at it is doable and problem proof. . .
Option-1 (Your base idea)
DSO -----> Info Src -----> Semantic IC (BW Data) -----> IC STD (BPC Staging)
Pros 1) Easy to develop 2) Ability to have a solid design 3) Moderate reporting flexibility
Option-2 (My suggestion)
DSO -----> Info Src -----> Semantic IC (BW Data) -----> IC STD (BPC Staging) -----> Multiprovider (For better flexibility of reporting)
Pros 1) Easy to develop 2) Ability to have a solid design 3) Advanced reporting flexibility bcoz we may not know the users need, many times they come and ask data at every level.
Let me know if any hit back during development.
Hope this is helpful Best wishes. -Ashok