Allowing end-users to have visibility into source transactional data is very important for many Anaplan customers. There is always the ability to Drill-Down into source data, but at times, this may not be intuitive or may take several drill-downs to get back to the raw data.
There is another option that can be easily accomplished and can give users all the information they need on one centralized dashboard. This is accomplished using a series of filters and with synchronization on a dashboard. This allows users to select any dimension of a module on a dashboard and synchronize a separate element on that dashboard to show the related transactions that make up a value.
We can accomplish this by using the following steps.
1. We will want to store data in a flat fashion. We will have a module that has a primary key (unique identifier) for each row of transactional data, along with line items for each category of the transaction
2. We will then have a separate module that is essentially a carbon copy of the first raw data module and will formulaically link to the raw data module. One consideration here, is that this second module will consume space. However, since this is a flat module, this will typically not consume a significant amount of extra space in the model. Also, a reason that we want this second module is to differentiate the module we are loading raw data to, from the module that will be present on a dashboard to end-users
3. There are a few intricacies to note on the module above.
The end result is a dashboard where a user can view a module, such as the P&L shown below.
When the user selects any node in the dimension of the P&L, the related Transaction details filter to show exactly the transactions that make up what the user is selecting. This allows users to have more visibility into source data in an easier fashion.
Our example above shows data for just one time period. In theory, this concept could be used to allow a user to select a column of any time period and also sync transaction data for that time period. Or, any other dimension! Hope this helps!
Could Dynamic Cell Access be used to make the import module "read only" for end users? This would eliminate the need for duplicating the entire dataset in a formula-based module.