Consolidate Numbered List table

akprasa1

Hi All,

I needed some help in designing a consolidation table for the input table as attached as image.

i am trying to consolidate the Org Var based on CF Lines,Driver,Driver Groups for the fixed dimensions (in black).

If i use these dimensions (CF Lines,Driver,Driver Groups) ,the model size increases to a huge extent.

The users would like to see the headings as wells of these dimension along with a drop down for Local and USD currency.

Please suggest some ways to get accurate consolidated results .

Input_table_84207.JPG

Accepted answers

All comments

SandeepB

@akprasa1,

I would be making some assumptions here based on the input table and here are my suggestions,

1) Assuming "driver" and "driver group" might hold one-many relationships. In that case, you might not need to include both of these in your dimensions.

2) Also, each "CF lines" might have only one driver or driver group (one to one ) and need not to be dimensioned.

You can create a consolidated report based on "CF Lines" and can have custom filters as page selectors to filter by driver or driver group.

Hope this might help.

Thanks,

Sandeep

akprasa1

Thanks Sandeep.

On Second thought i could solve the issue by creating a combination List through an import along with few properties.

Then populated the required columns as line items by direct referencing the list properties.For Values i used Sum based on Combination List.

SandeepB

@akprasa1,

Exactly..! You can always have a combination list as you stated. In some cases, it depends on the use case and ease of use. In general, setting up the combination list requires some attention and you may need to update the combination list more often.

Regards,

Sandeep

Quick Links

Can you help?

Unanswered questions

別ディメンションで、セレクターをモジュールに返し、計算したい
下記のようなことがしたいですコンテキストセレクターの値を別モジュールに反映し、それを使って計算したいです。 selecter A-1 Dim code amount Select→ A-1 1 100 A-2 2 100 A-3 3 100 A-4 4 100 module Dim code amount key Flg A-1 1 1 25 A-1 TRUE 1 1 25 A-1 TRUE 1 1 25 A-1 TRUE 1 1 25 A-1 TRUE 2 2 50 A-2 FALSE 2 2 50 A-2 FALSE
Importing Ragged Hierarchies
Hello - I have a 2 level ragged hierarchy (yes, it's a chart of accounts), that for reporting purposes is used in 4 different models (yes, it's a P&L). What is the best way set this to allow one to be the "source of truth" and then import between the four models without creating actions that include ignores? It seems like…
Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…