Problem with dimensions

CAPUAM01
CAPUAM01
in Modeling

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

I have these two SYS module,

image.png image.png

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

image.png image.png

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

image.png image.png

And the third calc module, organized with formula.

image.png

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

Answers

  • andrewtye
    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
    CAPUAM01

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

    Have these two dimensionalities

    image.png image.png

    Second calc mode with Product and Customers

    image.png

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

    image.png image.png image.png

    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
    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
    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

    image.png image.png image.png
  • wedd26
    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
    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.

Categories