Line Item Formatting

Hi All,

I need to be able to show actuals across a selection of line items which are populated by data sources and forecast inputs across the same selection of line items. My current solution is to use two modules containing identical line items with identical formatting using the same styles. This ensures they align when presented on a dashboard. However, as the model grows the user must update both modules when wanting to make changes to the line items which is more admin than I would like!!

Is it possible to use a line item subset where the the style formatting is retained? I suspect this is not available, if so are there any suitable alternatives to avoiding the need to update multiple identical modules when making changes? This requirement just reeks of redundancy which I would like to minimise as much as possible.

All suggestions welcome.

Thanks, Chris

Accepted answers

All comments

Misbah

@ChrisAHeathcote

Not sure if it is only me.I am confused about what is it that you want to do? Why not having versions in your module?

On LIS, yes you are right there is no way to change the style formatting.

Akhtar.shahbaz

Hi @ChrisAHeathcote

I am not sure if i understand your question correctly, yes styles on the line items are not transferred over to the line item subset but we can achieve almost the same with the source module from which you want to create Line item subset. Only you need to take care of "Is Summary" of the line item.

source module:

* Is summary will not be checked for Ratio line items , to get the "Is summary" you need to create extra line items and write your main formula here and then refer back this line item in your original line item.

LIS module

Now here you can see your summary style or P&L hierarchy.

Note:

Limitation -> you need extra line item.

Hope this helps!

Thanks

Akhtar

Amaya

Hi, @ChrisAHeathcote

Is this truly a topic with Line Item Formatting issue?

I understand your situation this way.
You have two modules, and their line items are all the same, includes formatting. One is for actual data, and one is for inputs of the forecast. You and your customer want to synchronize these two modules when the model grows and needs more Line Items.
It concerns maintainability = sustainability.

If so, please let me know why you need two modules instead of one.
Is there some technical difficulty in combining two modules? For example, the formula scope functionality doesn't meet your requirements?

I would like to specify your wants more and think about the best way to solve this.

Best regards,
Taichi

ChrisAHeathcote

You are correct. I was not aware of formula scope and its range of functionality.

I have managed to resolve the issue using formula scope to display actual and capture forecast in the same module.

Quick Links

Can you help?

Unanswered questions

Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
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.
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…