Question

IFS Account Node Dimension Join

  • 21 February 2020
  • 1 reply
  • 57 views
chrisbrigg
Rank
Userlevel 2
Badge +4

Hello,

I am trying to determine how Account Node Dimension data is joined to database view FACT_CONSOL_BALANCE_OL in an APP10 UPD 5 environment.

In IFS Business Reporter, the dimension is identified as ‘DIM_ACCOUNT.NODE_DESCRIPTION’.

Any help or guidance would be appreciated. Thank you.

1 reply

chrisbrigg
Rank
Userlevel 2
Badge +4

Also, I found the ‘NODE_ID_DESCRIPTION’ column in database view ‘DIM_ACC_STRUCT_NODE_ACCOUNT_OL’ contains the data I am looking to join to database view ‘FACT_CONSOL_BALANCE_OL’.

Reply


Terms & ConditionsCookie settings