Semantically Partitioned Objects (SPOs)

Posted by on



When we need to store partitioned data based on certain charateristic values..

for example:- data stored in multiple identical infocubes based on year or month..

prior to BW 7.3 , we could do this by creating infocubes for each year..



and creating a multiprovider on top of it...


but in BW 7.3.. we have a infoprovider specifically for scenarios like this.. Semantically Partitioned Object(SPO).





Creating SPOs




we are going to build Semantically partitioned Infocube on top of this DSO.









we are using template of 0SD_C03 infocube... check mark ON for Semantically partitioned .. and create ...




all the dimensions, keyfigures and navigational attributes of 0SD_C03 are created, As we have given the template of 0SD_C03 while creating Infocube.

Now click on Maintain Partitions..










1 default partition is created.. give values for that partition..





I have created 3 partitions.. for 06.2013, 07.2013, 08.2013

Now click on Start Activation.







click on activation.






select standard DTP template on right panel and click on copy button.






select the DTP template we created and clickon edit button.







Select the DSO under all partitions and click on ASSIGN...



Now DTP will be created for all partitions... select all DTPs and click on GENERATE button.





we have activated all DTPs Needed... now to execute this DTP s.. select all DTP and  click on execute button.













partition1 contains data of 06.2013
partition2 contains data of 07.2013
partition3 contains data of 08.2013




Want to learn SAP from Experts? - Archon Solutions

Comments

  1. UnknownMarch 17, 2014 at 6:34 AM

    first of all thank you for such valuable information... second..It will be helpful if u provide some details about hybrid providers and aggregation level... thanks in advance

    ReplyDelete
  2. UnknownMarch 18, 2014 at 8:47 AM

    wow very nice document thanks for this

    ReplyDelete
  3. dperikaMarch 24, 2014 at 5:14 PM

    Blog is mind blowing Very much helpful.Brother please upload some real time interview questions and answer

    ReplyDelete
  4. AnonymousApril 3, 2014 at 2:32 AM

    How to use the Semantically Partitioned Objects (SPOs) in my reporting?

    ReplyDelete
  5. VenkiApril 18, 2014 at 10:52 AM

    HI Aslam thanks to you for running such a great blog. i am requesting if you can post virtual info provider data loading with scree shots that will be great .thanks

    ReplyDelete
  6. UnknownMay 7, 2014 at 10:04 AM

    HI aslam , could you please send me the real time interview questions..

    ReplyDelete
  7. VinayaMay 29, 2014 at 8:26 PM

    Hi MA ,
    Good material for SPO
    Quick thing , how did you get the template , and whenever we create SPO should it be choosen as >> Rt click INFOAREA >>> CUBE(example) >> under object type should i choose cube or SPO ?

    ReplyDelete
  8. AnonymousJuly 30, 2014 at 8:28 PM

    One thing I would like to here is how to find template cube name, after creating SPO...Anybody have a clue???

    ReplyDelete
  9. AnonymousOctober 9, 2014 at 1:53 AM

    what about when new month comes ? manually insert dtp?

    ReplyDelete
  10. UnknownMarch 31, 2015 at 1:21 PM

    thanks to publish a valuable information.

    please explain how the data request are updated in dso & info cube ould be useful.

    ReplyDelete
  11. AnonymousMay 30, 2016 at 2:37 PM

    Hi, Thank you for the great tutorial. I just have a question. If i do partitions in Cube but I still want to report on the whole data of the cube. Do the OLAP takes first the data from the partitions to increase the performance and report on that part of the data when the query is selected for it or reporting has to be done in each of these small partitions?

    Thank you

    ReplyDelete
  12. UnknownJanuary 12, 2017 at 6:11 AM

    nice info (Y) Well Done

    ReplyDelete

Post a Comment