XFMemberProperty in Cube View

Filip
New Contributor

How do I combine XFMemberProperty with Dynamic expansion in a cube view? 

E.g. I want to expand Entity and account on Rows.

Row1: E1 =E#Total.Base, E2=A#FinancialAssets.Base

in columns I have transaction and ledger amounts (UD5) and then I want to add one column with entity currency and one with Text8 which we are using for region. Based on the entity on each row. So the XFGetMembers should reference to Row1 Expanion 1.

Col1E1: U5#DS_Trans_CCY

Col2E1: U5#DS_Ledger_CCY

Col3E1: XFMemberProperty: Currency

Col4E1: XFMemberProperty: Text8

 

Entity.Base Account.Base Trans CCY (UD5) Ledger CCY (UD5) Currency Text8
Entity A Account 1 10 100 EUR Germany
  Account 2 15 150 EUR Germany
Entity B Account 1 23 56 DKK

Sweden

Entity C Account 1 78 78 SEK

Sweden

 

1 ACCEPTED SOLUTION

miked
Contributor

Hi Filip,

The easiest way is probably to just create 2 dynamically calculated members in one of your dimensions (typically UD8) which just references and displays the entity's attributes that you desire.  You will need to set the columns for Currency and Text8 to the view member: Annotation to show text values.

 

Thx,

Mike

View solution in original post

1 REPLY 1

miked
Contributor

Hi Filip,

The easiest way is probably to just create 2 dynamically calculated members in one of your dimensions (typically UD8) which just references and displays the entity's attributes that you desire.  You will need to set the columns for Currency and Text8 to the view member: Annotation to show text values.

 

Thx,

Mike