Skip to main content
F
Filip
Newcomer
March 26, 2023
Solved

XFMemberProperty in Cube View

  • March 26, 2023
  • 1 reply
  • 0 views

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

 

Best answer by miked

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

1 reply

M
mikedAnswer
Contributor
March 27, 2023

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

    Terms & ConditionsAccessibility statement