Problem with dimensions

CAPUAM01 · 2024-09-04T12:08:18+00:00

There was an error rendering this rich post.

CAPUAM01

Hello I have a question that I am struggling to solve:

I have these two SYS module,

Store City here is a property of a numbered list with store code

I have second calc module, historical volumes loaded with this set of data

And the third calc module, organized with formula.

So far so good, the issue is that I cant come up with an idea lo explode the data for geographic data as well, having the store code on paper I also know the location.

Not sure this is the right location to ask, anybody has any idea?

Thanks a lot

Accepted answers

All comments

andrewtye

Hi - sounds like a use of SUM calculation. Be mindful of the dimensionality and space usage.

Just need to be sure of the dimensions and then do a new module to report the numbers usng the property module that you've setup

CAPUAM01

Yeah I was thinking about but I am a bit lost.

Have these two dimensionalities

Second calc mode with Product and Customers

I created additional module adding Cities and SUM formula but the city dont sum up properly.

I know I am messing with dimensionality but cant find a solution, on my final report I want to add city as possibile filter, but it works only for product and customer.

How can I solve?

nvilkko

Hi @CAPUAM01,

I think you have an extra dimension there. If you want to see the volumes summed by only city, you should remove 'S2 Customer#' from your CAL02.05 module. Then the same formula should work.

Thanks,

Niko

CAPUAM01

Hi @nvilkko

thanks for the reply, I think I'm still missing something because it doesn't work yet, it doesn't sum up well. "Store City" is a property list of the list 'S2 Customer#' even though I have also list of cities in 'G2 Geo'.

I would like to be able to explode data well for all possible dimensions, Product, Customer, City and so far only the first 2 dimensions works.

Thanks in advance for any additional help

wedd26

step 1. create list for each Level 1 Region, Level 2 Country, Level 3 City, then add to your system modules, then u can sum and get your views u need, repeat the same for Products, and customers, these are 3 independent dimensions. and you are mixing them all into one join

CAPUAM01

Yeah this is what I am trying to do but its not working, I am missing something maybe.

Thanks in advance for any other idea.

Quick Links

Can you help?

Unanswered questions

Curious Comparison: Forecast Modeling for Unusual Products
I've been experimenting with some forecast modeling techniques in Anaplan recently and decided to test them on a few quirky, offbeat product categories just for fun. One of the categories I played around with was love dolls—yes, you read that right. It actually turned out to be more interesting than expected. Unlike…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…