Display Dimension Properties along with Dimension

I am intending to display the properties of the dimension in a grid along with the dimension. If I add properties as line item then each line item is repeated across all the dimension elements, as the properties are tied to dimension members and they should not be repeating across dimensions. Below is the screen shot.. In this example my line item should be only amount and somehow I should be in position to display the dimension properties along with dimension. Happy to be on call as well. Need assistance.

Dimension (X)	Dimension(X) Property 1	Dimension (X) Proprtery 2		Jan	Feb	Mar
10050111001	CC_10050	Amount_USD	Amount	100,000	100,000	100,000
10100111002	CC_10100	Amount_USD	Amount	0	0	0
10050112006	CC_10050	Amount_USD	Amount	500	500	500
10050211001	CC_10050	Amount_USD	Amount	200,000	200,000	200,000

Question_1_104352.xlsx

Accepted answers

rob_marshall

@AvnishGoel

Please don't use properties as I don't believe they work the way you think it should work meaning they will automatically be rendered in a module because they are a property. It is best to store them in a SYS module so you aren't double counting them from a cell perspective (properties add to cell count as well).

In your example, you should have a list which is Dimension X then create two modules:

the first one will be transactional module which is dimensionalized by Dimension X and Time with the only line item being Amount. This is where you will load your transactional data
the second module will be a SYS module which is only dimensionalized by Dimension X, no time. In here, you can have two line items, list formatted. The first being CC and the other Currency.

From a reporting perspective, create a 3rd module which is dimensionalized by CC, Currency, and Time with a line item named Amount. The formula for Amount will be: Name of Trans module.Amount[SUM:SYS Module.Cost Center Line item, SUM: SYS Module.Currency line item]. Then you can pivot the module the way you would like.

Hope this helps,

Rob

All comments

rob_marshall

@AvnishGoel

In your example, you should have a list which is Dimension X then create two modules:

the first one will be transactional module which is dimensionalized by Dimension X and Time with the only line item being Amount. This is where you will load your transactional data
the second module will be a SYS module which is only dimensionalized by Dimension X, no time. In here, you can have two line items, list formatted. The first being CC and the other Currency.

Hope this helps,

Rob

AvnishGoel

@rob_marshall
Appreciate your quick reply. Your solution works. I really wish there is some way to use properties. We are un-necessary creating additional dimensions where there is no need.

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…