SAP BW Create SPO via BAdI - Part 3

After we created in Part 1 the transparent tables and in Part 2 all BAdI implementation, we can now maintain and create our SPO. First we have to fill our table ZSPOPATTERN with a PATTERNID and a corresponding INFOOBJECT. Go to the se16 and create a new table entry. As PATTERNID enter a unique id for example CALYEAR and as INFOOBJECT 0CALYEAR. For TXTLG and TXTSM enter a useful text. Depending on how many InfoObject are used for a partition, create the other pattern.

Table ZSPOPATTERN
Table ZSPOPATTERN

After we filled ZSPOPATTERN, we can now fill ZSPOINFOPROV. As SPONAME enter the technical Name of the SPO. As PATTERNID1 to PATTERNID4 enter your previous created pattern. For example Y_TM as SPONAME and CALYEAR as PATTERNID1.

Table ZSPOINFOPROV
Table ZSPOINFOPROV

The next table is ZSPOCRITERIA. Enter the previous created PATTERNID, a PARTGROUP, a LOWVALUE and if necessary a HIGHVALUE. For example:

  • PATTERNID - CALYEAR
  • PARTGROUP - 1
  • LOWVALUE - 2016

For 2017 use PARTGROUP 2, for more explanation see the screenshot below.

Table ZSPOCRITERIA
Table ZSPOCRITERIA

The last table is ZSPODTP. Enter a SPONAME, OBJTYPE, LOGSYS, DTPTEMPLATE and DTPTEMPLATEID. The DTPTEMPLATEID can be found in table RSLPO_DFG_DTPTPL. For example:

  • SPONAME - Y_TM
  • OBJTYPE - ODSO
  • OBJNAME - YTM01
  • LOGSYS - T04CLNT100
  • DTPTEMPLATE - DSO FULL
  • DTPTEMPLATEID - 00O2TGUDQNX7RY71D737H5IZ2
Table ZSPODTP
Table ZSPODTP

After the initial maintenance is done, we can go to the transaction RSA1. We can either maintain our SPO directly or under Administration you find the Mass Activation of BAdI SPOs. The first new partion will be created directly and the second and third under Mass Activation of BAdI SPOs. When you start from scretch you click on Change Partitions to create your new partitions. Now you can choose your criteria.

SPO: Select Partitioning Criteria
SPO: Select Partitioning Criteria

As you can see on the screenshot below, when you select Read Charactcs. from BAdI, the InfoObject 0CALYEAR is automatically add as criteria.

SPO: Select Partitioning Criteria via BAdI
SPO: Select Partitioning Criteria via BAdI

In the screenshot below you see the partition 1 is automatically added with the year 2016.

SPO: Partition created by BAdI
SPO: Partition created by BAdI

Now we can activate our SPO and see, that the partition 1 is created. You can now add your new partitions either by clicking on Build Version From or via Mass Activation of BAdI SPOs. I choose the second way to show you how can activate multiple SPOs at once. Goto Administration >> Mass Activation of BAdI SPOs.

SPO: Mass Activation of BAdI SPOs
SPO: Mass Activation of BAdI SPOs

As you can see in the screeshot above, our SPO find new partitions. With the function Version Comparison you can compare the actual version with the new.

SPO: Version Comparison
SPO: Version Comparison

As you see, the two new partitions for 2017 and 2018 will be created. By click on Activate, the partitions are created.

SPO: New partitions are created via Mass Activation
SPO: New partitions are created via Mass Activation

Now our SPO is up to date and all partitions are created. If you need for example 2019, you have to maintain the table ZSPOCRITERIA and go back to the Mass Activation of BAdI SPOs. The last part is now to create the DTPs. Go to the SPO and open it in change mode. Click on Create Data Transfer Processes. You will see the following screen.

SPO: Create DTP for SPO
SPO: Create DTP for SPO

Select your partitions and click on the button BAdI Version.

SPO: Create DTP for SPO via BAdI
SPO: Create DTP for SPO via BAdI

The DTPs automatically appear and you only have to generate them.

SPO: DTP created via BAdI
SPO: DTP created via BAdI

That's it. Your SPO and associated DTPS can be created via BAdI. I tested it with a Business Warehouse 7.31 SP18, maybe it is a little bit different in a higher release.

Analysis Office - The Comprehensive Guide
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.3 and contains 227 Pages.
29,99 €
Analysis Office - The Comprehensive Guide 2nd edit
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.4 and contains 243 pages.
39,99 €

Write a comment

Comments: 0