Summing Values across dimensions

Hello -

I have modules dimensionalized by an L3 hierarchy (Co/Dep/Sub) with the line items equaling Accounts that are "collected" through a LIS.

Now I want to sum my values into an L4; which is just "L3" and "Account "strung together; but my formula of Sum - Lookup: the "L3" and "Account" attributes (Mapped to the L4) does not work.

Is there something I am missing here?

Accepted answers

All comments

M.Kierepka

Hi @Mataylor,

Can you share some screenshot of blueprints/lists/structures?

If I understand correctly, you created join list "L4", which is L3xAccount (probably only for valid intersections), with parent as L3. Your source module has dimensions L3 and Account, and target module is just L4. So then you have two options for bringing data from source to target:

LOOKUPs: in the SYS module for your L4 list you need to have 2 line items with format set as L3 and Account, that are either populated from code or during intersection creation. Then in your target module you just have a formula like: Source.Value[LOOKUP: 'SYS L4'.'L3, LOOKUP: 'SYS L4'.Account]
SUM: in the mapping module dimensioned by L3 and Account (which you probably use for intersection creation) you should have line item formatted by L4. Then, in your target module, the formula would look like: Source.Value[SUM: 'SYS Creation L4'.'L4']

jagadishdash

@Mataylor

You have the data in L3 hierarchy, And you want to bring to L4. So for that, if L3 module have account as well as L3. In L4 you need to have account as dimension. and bring Account and L3 in the line item for mapping.

then Lookup with the Both Account and L3.

If you want for the same then do that line items in source module for mapping that's it.

For a Glimpse, Refer to Level2: TRA01 module which has P2 Products and shipping method as dimension

In target INV01 module have the dimensions as P3 SKU, So the Lookup is used with P2 as well as Shipping method.

(For sum,You need to map in source module.)

Hope you got it. If it is helpful for you, Please accept my answer as solution.

Thanks,

Jagadish Dash

Quick Links

Can you help?

Unanswered questions

Introducing Anaplan Python API 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…