Skip to Content
Author's profile photo Nitesh Kumar

Semantically Partitioned Objects (SPO) in SAP BW

Business Scenario:

An organization is operating its business in many continents/regions. When it comes to data analysis and decision making based on the BW data, the organization might face various problems because of the larger geographical area and different standard time zones. There might be following problems:

  1. The data would be very huge. It will take significantly more time to get even a small data records.
  2. Data loading is usually done in non-business hours. Because of the different time zones, some down time would be required. Reason is that when data load is done as per the non-business hours of 1 region, it could be business hours in other regions.
  3. If an error occurs in the data of a particular region, it will have impact on the global business. Request will be red and concerned persons from other regions also would not be able to do the analysis.

Solution:

To overcome such hurdles, SAP has provided an InfoProvider, Semantically Partitioned Object. It is an Infoprovider that contains many InfoCubes or DataStore Objects with same structure. At the time of defining the InfoProvider, we decide to make it as Semantically Partitioned Object.

Note: This feature is available for BI 7.3 or higher version.

Creation of Semantically Partition Object:

1. Right Click InfoArea – > Select Create InfoCube

1.PNG

2. Following screen is displayed. Enter the name of the infoCube. Tick the check box ‘Semantically Partitioned’ and click Create button.

2.PNG

3. Enter the characteristics InfoObjects for this InfoProvider.

3.PNG

4. Enter the KeyFigures.

4.PNG

5. Click Maintain Partition as shown below:

5.PNG

6. We get the following screen:

6.PNG

7. Select the characteristics based on which partition has to be created.

7.PNG

Here we are creating partition based on geography.

8.  Click Partition to create required number of partitions. Enter the geography name as required.

8.PNG

9. Here we have created 4 partitions as shown:

9.PNG

10. Now activate the InfoProvider as shown below:

10.PNG

11. InfoProvider gets activated. Now create the transformation as shown below:

11.PNG

12. Enter the details for source.

12.PNG

13. Transformation is created. Activate the transformation.Now create the DTP as shown below:

13.PNG

14. Click Folder to create a new template folder as shown below:

14.PNG

15. Enter the name of Template folder:

15.PNG

16. Right click the created template (ZGEO_SL)  à  Click Create New DTP Template:

16.PNG

17. Enter DTP Template name.

17.PNG

18. DTP setting screen is displayed:

18.PNG

19. Click Save. Following screen is displayed.

      Select DTP Template and the DataSource connected to first partition. Click Assign.

19.PNG

20. Following screen is displayed. Select the ‘Not Yet Generated’ DTP and click Generate.

20.PNG

21. Follow steps 19 and 20 to create the DTP for all the partitions. All the DTPs are created as shown below:

21.PNG

22. Click Create Process Chains to create the process chains  for all the partitions:

22.PNG

23. Select  first DTP and click Add as shown below:

23.PNG

24.  Follow the same procedure to add all the remaining DTPs in process chain.

25. Once all the DTPs are added , click Generate as shown below:

24.PNG

26.  After successful generation of process chain, we see the following screen:

25.PNG

27.  Click Process Chain Maintenance to display the generated process chain:

26.PNG

28.  We get the following process chain created:

27.PNG

Now run this process chain and check the data in each InfoCube:

Data in partition 1:

28.PNG

Data in partition 2:

29.PNG

Data in partition  3:

30.PNG

Data in partition 4:

31.PNG

Check the number of records in PSA.

32.PNG

We find that there are 10 records in PSA but depending on the geographical partition, only the relevant data is being loaded in each InfoCube.

Benefits:

1.      Report execution time will be tremendously decreased

2.      If error occurs in one partition, other partitions will be not affected and those will be available for reporting.

3.      No downtime is required for data load; data in each partitions can be loaded as required.

     SPO can be used in case of the creation of multiple InfoCubes based on ‘CALYEAR‘ also. Many projects need this scenario where year wise data is required to be analyzed.

Assigned tags

      29 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Phani KV
      Phani KV

      Hi ,

      Thanks for sharing.

      Phani.

      Author's profile photo Nitesh Kumar
      Nitesh Kumar
      Blog Post Author

      Hi Phani,

      Thank you for reading the document.

      Regards,

      Nitesh

      Author's profile photo Former Member
      Former Member

      Nice document

      Author's profile photo Nitesh Kumar
      Nitesh Kumar
      Blog Post Author

      Thank you Gaurav 🙂 .

      Author's profile photo Former Member
      Former Member

      Well explained. Thank you for sharing...

      Best Regards

      Venkat...

      Author's profile photo Nitesh Kumar
      Nitesh Kumar
      Blog Post Author

      Hi Venkat,

      Thank you so much.

      Happy that you liked the explanations 🙂 .

      Regards,

      Nitesh

      Author's profile photo Ganesh Bothe
      Ganesh Bothe

      Nice documents with lot of screen shots..it will helpful. 🙂 .

      Author's profile photo Nitesh Kumar
      Nitesh Kumar
      Blog Post Author

      Hi Ganesh.

      Thank you so much.

      Yes, it contains lots of screen shots. It consists so much tasks (From InfoProvider creation to Process chain creation) that I could not control this 😉 .

      Thanks a lot 🙂 .

      Regards,

      Nitesh

      Author's profile photo Former Member
      Former Member

      Hi Nitesh,

      Nice & also very helpful document to those who are new to BW 7.3. 🙂

      Thanks,

      Karan.

      Author's profile photo Nitesh Kumar
      Nitesh Kumar
      Blog Post Author

      Hi Karan,

      Really delighted by your comments 🙂 .

      Thank you so much.

      Regards,

      Nitesh

      Author's profile photo Phani KV
      Phani KV

      Nice document and very helpful

      Thanks,

      Phani.

      Author's profile photo Nitesh Kumar
      Nitesh Kumar
      Blog Post Author

      Thank you so much 🙂 .

      Regards,

      Nitesh

      Author's profile photo Elwanda Bennett
      Elwanda Bennett

      This article offered very clear, step-by-step instructions.  Very good work on this matter! 🙂

      Author's profile photo Nitesh Kumar
      Nitesh Kumar
      Blog Post Author

      Hi Elwanda,

      Really happy to see that you liked the document and its illustrations.

      Thank you so much for rating this document 🙂 .

      Regards,

      Nitesh

      Author's profile photo Yogesh Narwani
      Yogesh Narwani

      Hi Nitesh,

      Very nicely documented the whole process .

      Just one question, as you mentioned in last line before benefits

      "We find that there are 10 records in PSA but depending on the geographical partition, only the relevant data is being loaded in each InfoCube."

      From In each InfoCube, are we using multiple cube ?I believe there is a single cube in which there are different partitions. Please correct me If I am wrong !

      Again wonderful document !

      Regards

      YN

      Author's profile photo Nitesh Kumar
      Nitesh Kumar
      Blog Post Author

      Hi Yogesh,

      First of all, thank you so much for reading this document so carefully.

      Yes, we have created a single SPO InfoCube. When we create SPO, it is a single object. In this example, ZGE_SL is the SPO InfoCube.

      When we create the partition, system automatically creates the partitioned InfoCubes depending on the number of partitions.

      Since we have created 4 partitions, we can see the 4 InfoCubes ZGE_SL01, ZGE_SL02, ZGE_SL03 and ZGE_SL04 which have been automatically created by the system.

      Please find below the screen shot:

      Explanation.PNG

      We can find above the design showing all the partitioned InfoCubes and related DTPs which have been created automatically at the time of partition and creation of process chain.

      Hope it clarifies your queries.

      Thanks a lot again 🙂 .

      Regards,

      Nitesh

      Author's profile photo Umashankar Poojar
      Umashankar Poojar

      Hi Nitesh,

             Very  informative and good presentation. I'll definitely keep it handy and implement this when I get next chance.

      Thanks for sharing and appreciate your time and knowledge!

      Cheers!

      Umashankar

      Author's profile photo Nitesh Kumar
      Nitesh Kumar
      Blog Post Author

      Dear Umashankar,

      Thank you so much for your kind and motivating words.

      A very big thanks for rating this document 🙂 .

      Regards,

      Nitesh

      Author's profile photo Former Member
      Former Member

      Hi Nitesh,

      It's really a worth document that you have prepared. It's really usefull. Thanks for sharing 🙂

      Author's profile photo Nitesh Kumar
      Nitesh Kumar
      Blog Post Author

      Hi Gokul,

      Thank you so much for your comments. Happy that you found it useful.

      Regards,

      Nitesh

      Author's profile photo Former Member
      Former Member

      Hi Nitesh,

      Quite useful document.

      Best Regards,

      Arpit

      Author's profile photo Nitesh Kumar
      Nitesh Kumar
      Blog Post Author

      Hi Arpit,

      Thanks for your comments.

      Regards,

      Nitesh

      Author's profile photo Former Member
      Former Member

      Good work done. Very happy. 🙂 .

      Author's profile photo Nitesh Kumar
      Nitesh Kumar
      Blog Post Author

      Thank you so much for your kind appreciation 🙂 . Thanks a lot 🙂 .

      Author's profile photo Erdem Uren
      Erdem Uren

      Hi.very nice document.thank you.

      wh    What is different this approach from creation of multiple InfoCubes based on 'CALYEAR.which is good?

      Author's profile photo Former Member
      Former Member

      Hi Erdem,

      This is a new feature available from BI 7.3 version & above, whereas Info cubes based on CALYEAR can be done in any version.

      Thanks,

      Karan.

      Author's profile photo Former Member
      Former Member

      Hi nitesh

      i am very happy to learn this spo

      i have a doubt...that is how can we create a SPO(CUBE) on top of the  SAP(DSO)

      ?  If it is possible then share the document. please give the reply for this

      Thanks..........

      Kiran

      Author's profile photo N P Siddhu Bollimpalli
      N P Siddhu Bollimpalli

      Hello Nitesh

      Thank you for the wonderful document with detailed approach.

      One question to you on this. 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. Then finally can we use the SP-Cube as a feeder to BPC cube.

      Comments / suggestions please!!!

      /wp-content/uploads/2015/10/snapshot_815339.png

      Thanks

      Siddhu

      Author's profile photo N P Siddhu Bollimpalli
      N P Siddhu Bollimpalli

      Hello Experts,

      Let me add one more line to my above post.I would like to add a BPC staging cube on top of the semantic CUBE so that the BPC staging data will be feeded to BPC model.

      Thank you

      Siddhu