Topics started by Robby C

1 Topic

R
Do Gooder (Customer)
Robby CDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)

BR - Adding Dimension to FACT table

Hello, Some advice or how to guide on adding a dimension(s) to an existing FACT table.We would like to use FACT_IL_ACCOUNT_BALANCE table for Business Reporter, we have also recently started using Accounting Structures from which the dimensions from accounting structures do not exit on the main FACT table or the underlying database view (as a persistent field)I believe we have to add the dimension to the FACT as below. From the existing set of dimensions here  Any ideas or help as to what I need to do to join/link the DIM_ACC_STRUCT_ACCOUNT to the existing FACT_IL_ACCOUNT_BALANCE table?Any guidance appreciated Thanks,Rob

4
D
Do Gooder (Customer)
1 year ago

Badges

Show all badges
Terms & ConditionsCookie settings