SPO partition ID - Semantically Partitioned Objects

[leandrovani]

Hi all!

I am creating a DSO Semantically Partitioned using BW 7.3 new feature called SPO from BAdI implementation following the Juergen Haupt WebLog step-by-step.

Everything is fine, except that I am not being able to rename the partition ID. My SPO is called RCC0P3 and the 4 partitions are sequentially numbered: RCC0P301, RCC0P302 and so on. I checked that standard table RSLPOPARTRANGE is filled and the field IDPART (Partition ID) is already numbered with 01, 02, 03 and 04.

Does anybody know what I need to do in order to change this partitions ID? I need to use letters and the only way is using BAdI implementation. The is that even using the BAdI implementation tutorial, I didn't find where determine the partitions ID in order to have the partitions technical name customized.

Thanks for your attention.

Leandro

[sander_vanwilligen]

Hi Leandro,

Further to the reply of Ethan I can confirm that method IF_RSLPO_BADI_PARTITIONING~GET_T_PART is the right place to define your Partition IDs. The return table R_T_PART has to be filled with the partitions. Structure RSLPO_BADI_S_PART has two fields:

• IDPART -> here you supply the Partition ID in a CHAR 2 format;
• POSIT -> here you supply a sequential no.; first one is always 1.

Since BW 7.3 SP4 you can indeed use uppercase letters as well. Please refer to my blog for more information.

Last but least I advise you to read the technical documentation of interface IF_RSLPO_BADI_PARTITIONING carefully. In my opinion it's not an easy BAdI to implement. Pay attention to the consistency between the various interface methods and follow exactly the guidelines provided in the technical interface documentation.

Best regards,

Sander

[esjewett]

When you implement the BADI method IF_RSLPO_BADI_PARTITIONING~GET_T_PART, in the return structure R_T_PART, can you not specify the IDPART field? I thought this should determine the last two characters of the SPO part provider technical name. Haven't actually tried it though...

BTW, Juergen's post is here, for those who are curious: http://scn.sap.com/people/juergen.haupt/blog/2010/12/07/sap-netweaver-bw-730-semantically-partitione...

And there is a good set of posts on the topic by that starts here: http://scn.sap.com/community/data-warehousing/netweaver-bw/blog/2012/01/06/pattern-based-partitionin...

Regards,

Ethan