Skip to end of metadata
Go to start of metadata

Purpose

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.

 

Overview

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.

 

MBR__SEQ History

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).

Related Content

Related Documents

Related Notes

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