Hello, I am attempting to calculate the % of a parent forecast each child makes up in a given time period. For example, a month has a 100 unit forecast in America. Texas makes up 60 units and California makes up 40 units (both children of America in a list). I am trying to show this: Texas 60% California 40% America 100% I am having trouble avoiding the level mismatch error. Any suggestions on formulas?
... View more
I am looking for suggestions for basic, high level and non-time consuming training lessons for a fellow employee who recently started at my company. They will not be doing any model building. Thank you!
... View more
I have an established hierarchy and need to add a new level within the middle of it. Currently, the hierarchy looks like M1>M2>M3. I will be adding a new level between M1 and M2. The current M2 and M3 will be children of the new M2. My concern is around the formulas already associated with the levels in their current positions. I have multiple modules/dashboards already built using my current hierarchy. Are there any concerns or issues I should expect? Has anyone done this before and can offer some guidance?
... View more
@jasonblinn Okay that makes sense. Either way the size of the copied model will remain the same as the original with/without the data in cells or is there a size benefit to not copying over the data? For my needs, I'll just need the structure so if there is a savings on space that would be ideal.
... View more
@jasonblinn Just to be clear, your recommendation is to copy the model from a revision tag or use the import model function in manage models?
... View more
@Misbah Also, the compare and sync relationship between the original (target) model and the imported (source) model in the Dev workspace will still exist if I follow the import path, correct?
... View more
@Misbah I have already set up my production lists and production imports. If I'm understanding you correctly, you suggest copying the model and importing the copy into the Dev workspace? Then I would just change the original model to be in production?
... View more
I have a model that I would like to create a production model from. Currently, the model is in the target workspace, not in our development workspace. In order to not break sync, would it be better to move the current model into the development workspace then create a production copy?
... View more
@abhi1017我已经数求和ry and Product Family in the check module. With those as the only dimensions other than time, which is constant between the two modules, I can't think of anything else. Is there something else I need to add?
... View more
I am able to have the correctly summed PY Country and Product Family sales roll into the PY Account revenue but my % don't add up to 100% in the check module. They are about 3-5X higher. I have validated all input data but can't seem to get them to only add to 100%. Any help would be appreciated.
... View more