Skip to Content
avatar image
Former Member

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

snapshot.png (44.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 31, 2015 at 04:06 PM

    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

    Add comment
    10|10000 characters needed characters exceeded