Skip to main content
Solved

BR - Adding Dimension to FACT table

  • Jan 14, 2022 11:26 AM UTC
  • 4 replies
  • 403 views
Do Gooder (Customer)
Forum|alt.badge.img+2

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

Best answer by Thiwanka Sandaruwan

Hi @Robby C ,

 

Please refer the below documentation to get an idea about how to add a dimension to an information source(fact).

 

https://docs.ifs.com/techdocs/foundation1/040_administration/255_br_and_a/010_Information_Sources/055_custom_objects/020_Custom_Dim_Connections/010_cust_dim_conn_ovw.htm

 

As well as you can refer to some examples from the below documentation.

 

https://docs.ifs.com/techdocs/foundation1/040_administration/255_br_and_a/010_Information_Sources/055_custom_objects/020_Custom_Dim_Connections/020_cust_dim_conn_ex.htm

 

Best Regards,

Thiwanka

 

 

View original
      This topic has been closed for replies.

      4 replies

      Thiwanka Sandaruwan
      Hero (Employee)
      Forum|alt.badge.img+9

      Hi @Robby C ,

       

      Please refer the below documentation to get an idea about how to add a dimension to an information source(fact).

       

      https://docs.ifs.com/techdocs/foundation1/040_administration/255_br_and_a/010_Information_Sources/055_custom_objects/020_Custom_Dim_Connections/010_cust_dim_conn_ovw.htm

       

      As well as you can refer to some examples from the below documentation.

       

      https://docs.ifs.com/techdocs/foundation1/040_administration/255_br_and_a/010_Information_Sources/055_custom_objects/020_Custom_Dim_Connections/020_cust_dim_conn_ex.htm

       

      Best Regards,

      Thiwanka

       

       

      Do Gooder (Customer)
      Forum|alt.badge.img+2
      • Robby C
      • Author
      • Do Gooder (Customer)
      • Jan 14, 2022 12:00 PM UTC

      Excellent, thanks for the quick reply Thiwanka!

       

      Do we have to use Custom Dimension Connections even for the out of the box dimensions already listed within the application Information Sources (second screenshot in my original email)?

       

      Thanks again, 

      Rob

        Thiwanka Sandaruwan
        Hero (Employee)
        Forum|alt.badge.img+9

        Hi @Robby C ,

         

        Yes, the recommended way is to add a new dimension(standard dimension/quick dimension) to an information source via Custom Dimension Connections.

         

        Best Regards,

        Thiwanka

        Do Gooder (Customer)
        Forum|alt.badge.img+2
        • Dexpne
        • Do Gooder (Customer)
        • Dec 25, 2022 3:13 PM UTC

        Folks can you please guide me on where to find the Custom Dimension Connections? is it under Information Sources in the explorer? 

        Do I need a specific permission to see it? what is that permission?

        Thanks 

        Terms & ConditionsAccessibility statement