You perform multiple expansions in a sequence on the same rows or columns by defining a RowKeyRange or ColKeyRange that is partly static, and partly dynamic.
Example
The following example shows that the RowKeyRange includes two columns: one for the Account and one for the RptCurrency dimension. The system suppresses the expansion for Account dimension, since the MemberSet value is set to NoExpand. The Account is hard-coded in the RowKeyRange.
PARAMETER |
EXPANSION 1 |
EXPANSION 2 |
---|---|---|
ExpandIn |
ROW |
ROW |
Dimension |
ACCOUNT |
RPTCURRENCY |
MemberSet |
NOEXPAND |
MEMBERS |
Cash |
Cash |
USD |
Cash |
EUR |
Cash |
LC |
Cash |
UDS |
Cash |
EUR |
Cash |
LC |
Accrec |
USD |
Accrec |
EUR |
Accrec |
LC |
Accpay |
USD |
Accpay |
EUR |
Accpay |
LC |