This page will briefly discuss the Dimension Property MBR_SEQ that has been added to _SAP BusinessObjects Planning and Consolidation 7.5, version for SAP NetWeaver.
The MBR__SEQ property has been added on version 7.5 of BPC NW to allow the system to better handle the sequence of the dimension members. This property is manually added and not having it cause several problems.
This property was added on version 7.5 of BPC NW to better handle the member sequence. On previous versions it was handled exclusively by the order the members were stored on the database.
Up to Support Package 5, both MBR_SEQ and older structures were available. Two code logics were maintained on the methods to handle both structures types and the MBR_SEQ structure was not mandatory. On Support Package 6 the older structure is not maintained anymore and the MBR_SEQ became mandatory.
On version 10 of BPC NW the member sequence has been re-structured and the MBR__SEQ property is not necessary anymore.
Dimensions missing MBR__SEQ property
This Dimension Property is a system property and is not visible at BPC NW client side. To verify this property you need to use transaction RSA1 on ABAP server and maintain the desired dimension (Check Note 1569103 for more details).
After Support Package 6 not having the MBR__SEQ property can cause many problems, mostly related to Dimension processing and editing. Some common ones are described on the notes below:
- SAP Note 1610665 - MBR_SEQ invalid when restore master data
- SAP Note 1468435 - Fix some member sequence issues
- SAP Note 1615632 - Master data of standard ApShell cannot be loaded in ApShell-BPC NW7.5
- SAP Note 1569103 - When running UJA_DATA_CHECKER, an error appears: GETWA_NOT_ASSIGNED
- SAP Note 1615304 - Wrong member sequence after adjusting member sequence
Other behaviours are related to missing MBR_SEQ property after SP6. Make sure that, once you are at this SP Level or above, all your dimensions contain the MBR_SEQ property.
To add the MBR__SEQ property you need to run ABAP program UJA_MIGRATE_MBR_SEQ on transaction SE38 (Check note 1569986 for more details).
SAP Note 1610665: MBR_SEQ invalid when restore master data
SAP Note 1468435: Fix some member sequence issues
SAP Note 1615632: Master data of standard ApShell cannot be loaded in ApShell-BPC NW7.5
SAP Note 1569103: When running UJA_DATA_CHECKER, an error appears: GETWA_NOT_ASSIGNED
SAP Note 1615304: Wrong member sequence after adjusting member sequence
SAP Note 1569986: How to add the MBR_SEQ attribute to a dimension - BPC