Forum Discussion

Filip's avatar
Filip
New Contributor II
2 years ago

XFMemberProperty in Cube View

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

 

Cube View
  • miked's avatar
    miked
    2 years ago

    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

  • miked's avatar
    miked
    Contributor
    2 years ago

    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