Skip to Content

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

SEMANTIC PARTITIONING IN BW - can SPO cube be used to feed BPC model

Hello Experts

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

Sidd..

Former Member
replied

Hi Siddhu,

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question