Have a line item that does not apply to a dimension, not repeat itself

Hi guys,

I am wondering if there is a way to have line items that do not apply to a specific dimension, not repeat itself within a dimension. I have a list that has another module storing details about the list and then another module which has the time dimension look at revenue for specific accounts. I have pulled through the revenue data from another module but would like a few additional line items before the time dimension.

I have attached an image that should hopefully show what I am trying to achieve. as you can see the agency inf is repeated each month. I would like it to show before Jul and then have the monthly data appear afterwards

Thanks.

Accepted answers

All comments

luke_e

From my experience, this isn't an easy one to deal with. I would have suggested using a line item subset and having a filter in some way, but they only work with number type fields.

The only solutions I'm aware of that don't require manually hiding the columns are,

- using the NUX and the scroll-lock function with a non-time based grid on the left and the time-based grid on the right, or

- using a non-time based grid and using line items to pickup the periods you want via LOOKUP (rather than native time), but this isn't particularly good in most cases.

Alternatively, is the text string something you can include within the display name of the list item so that you don't need it in the grid as a line?

MarkWarren

Agree with @luke_e here, looks like those should be a list dimension, which hopefully they are instead of using text

MatthewWilcox

Hi Mark,

Yes the Agency is a list dimension. But if I add it as a dimension to the module wouldn't that increase the number of cells by a factor of the number of Agencies in the list?

DaanishSoomar

1 approach is to simply remake that line item in a separate module with the desired dimensions. This will eliminate the subsidiary view and maintain better user experience. Regarding your question about list dimension - if you add it as a dimension to the module it would add that many number of cells. If you don't need it, consider storing the line item in a separate module. Here is a Planual principle related to this: https://community.anaplan.com/t5/Chapter-2/2-01-06-Avoid-Using-Subsidiary-Views/ta-p/76835

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…