LE Operational Plan Variance Capex Lifecycle (OP-LE)/LE Expex Lifecycle (OP-LE)/LE Feasex Lifecycle (OP-LE)/LE Opex Lifecycle (OP-LE)/LE TotalExp Lifecycle (OP-LE)/LE How to bring data from different module for all the line items, Please hel

@Aditya1993 Check this out and see if it helps. You have to have the version dimension in all of your 4 modules This is the blueprint for your reference Please note the following: * All 3 source modules have the SKU and Version dimensions * The combined module has the same 2 dimensions in addition to the Line Item Subset LiSs

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

variance for different line items

Aditya1993

	LE	Operational Plan	Variance
Capex Lifecycle			(OP-LE)/LE
Expex Lifecycle			(OP-LE)/LE
Feasex Lifecycle			(OP-LE)/LE
Opex Lifecycle			(OP-LE)/LE
TotalExp Lifecycle			(OP-LE)/LE

How to bring data from different module for all the line items, Please hel

Accepted answers

einas.ibrahim

@Aditya1993

Check this out and see if it helps.

You have to have the version dimension in all of your 4 modules

This is the blueprint for your reference

Please note the following:

All 3 source modules have the SKU and Version dimensions
The combined module has the same 2 dimensions in addition to the Line Item Subset LiSs

All comments

anirudh

Hi Aditya,

Can you share what the LE and operational plan modules look like and I can give you the correct formula

Regards,
Anirudh

einas.ibrahim

Hello @Aditya1993

If I understand you correctly, you have the individual items in “column 1” such as Capex lifecycle, Opex lifecycle,...

calculated in different separate module and you want to display these particular line items in one module as report, for example.

if that’s the case, then the answer is Line Item subsets

you have to create a line item subset (list) that contains all the line items you want to group from the different modules, then use this newly created list as the dimension for your output/reporting module.

it wasn’t clear to from your question, What is it you need regarding the variance.

if this is not what you need or you need help with Line Items Subsets, please let me know.

Aditya1993

Hi Anirudh,

Thank you for responding.

LE and Operational Plan are the 2 version I have in my module. See below

I Need this data in my Variance analysis model where I have created the line item subset for capex, opex, Expex and Feasex and the problem is collect() formula is not working.

Aditya1993

Thank you Einas for responding,

I have created the Line item subset but what formula I should use to bring the values from the original module as collect() is not working.

and for your information LE and Operational plan are the 2 version I have

einas.ibrahim

@Aditya1993

I assume the source modules where these line items are calculated, is also dimensioned by version, correct?

Aditya1993

@einas.ibrahim

Yes, source module have version as one dimension.

einas.ibrahim

If that's the case, then COLLECT() should work. There isn't any other functions to use with LiSs.
Can you share your blueprint or any data that would allow me to look into the issue?

Aditya1993

@einas.ibrahim

I have 2 issue if I have versions in the target modules the for both the line item i'm getting the same data for both the line item as it depend on the version dimension and if I don't apply the version dimension then the value is 0

einas.ibrahim

@Aditya1993

Check this out and see if it helps.

You have to have the version dimension in all of your 4 modules

This is the blueprint for your reference

Please note the following:

All 3 source modules have the SKU and Version dimensions
The combined module has the same 2 dimensions in addition to the Line Item Subset LiSs

Quick Links

Can you help?

Unanswered questions

Uploaded Date data in other formats
I am trying upload data from a CSV with date. For size reasons, I don't want to dimension the module by date but bring it in as a line item formatted as date. The problem is that person that will be doing the upload is in Italy, and their date format is different. When she does the upload, the date gets messed up…
Anaplan Level 3 Assign accounts to territory
Hi, when I am assigning the account to the territory I am always facing error as below and account never get assigned to the territory , what could be the reason ? When I use same method for unassign it works .
An Update on Anaplan Audit Log Reporting: A No-Code Approach
A while back, I shared a pattern for extracting and reporting on Anaplan audit data using a Python project hosted on GitHub. I wrote that during my time on the Operational Excellence Group (OEG) at Anaplan. The Python solution still works, and plenty of teams are running it today. The problem it solves hasn't changed:…