Show TOC

Syntax documentation*XDIM_MEMBERSET Locate this document in the navigation structure

*XDIM_MEMBERSET defines the scope of the data in which subsequent business logic will be applied.

Syntax

*XDIM_MEMBERSET {Dimension name} = {Members Set}

* XDIM_MEMBERSET {Dimension}<>{MemberSet}

Example Example

*XDIM_MEMBERSET TIME = 2006.DEC

*XDIM_MEMBERSET P_ACCT = bas(CE0004000)

[TIME].[#2009.DEC] = [TIME].[2006.DEC] * 1.1

*COMMIT

This example first reads all children of CE0004000 in the 2006.DEC period, and then increases them by 10% and copies them to the 2009.DEC period.

Other valid use cases

*XDIM_MEMBERSET P_ACCT = CE0004010, CE0004020, CE0004030

*XDIM_MEMBERSET P_ACCT = CE0004000 //All children values are summarized to one parent record.

*XDIM_MEMBERSET P_ACCT <> CE0004010

You can’t combine bas() with any other member set.

*XDIM_MEMBERSET P_ACCT = bas(CE0004000), CE0004210 //This is not a valid use case.

Use *XDIM_ADDMEMBERSET to add more members to the scope of the member set defined by bas() already.

End of the example.
Forcing a dimension to read all members

Using the <ALL> keyword, you can force a dimension to read all members, including parents.

Example

*XDIM_MEMBERSET P_ACCT = <ALL>

*XDIM_MEMBERSET TIME = 2006.DEC

[P_ACCT].[#CE0661000] = [P_ACCT].[CE0004000] / [P_ACCT].[CE0652000]

Any software coding and/or code lines / strings ("Code") included in this documentation are only examples and are not intended to be used in a productive system environment. The Code is only intended to better explain and visualize the syntax and phrasing rules of certain coding. SAP does not warrant the correctness and completeness of the Code given herein, and SAP shall not be liable for errors or damages caused by the usage of the Code, except if such damages were caused by SAP intentionally or by its gross negligence.