Skip to main content
Question

IFS Account Node Dimension Join

  • February 21, 2020
  • 1 reply
  • 69 views
chrisbrigg
Sidekick (Customer)
Forum|alt.badge.img+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.

chrisbrigg
Sidekick (Customer)
Forum|alt.badge.img+4
  • chrisbrigg
  • Sidekick (Customer)
  • February 21, 2020

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

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings