level 1 activity 9.2.5 dimension error

ValentineLS
Occasional Contributor

level 1 activity 9.2.5 dimension error

Hello again

I am trying to import a formula in Unit Price % in the REV05 Price Growth Rates Staging module.

However, I get this error message : Level mismatch on common dimension

I checked multiple times the dimension of all the modules and everything seems fine to me. And my line items are all set to list format. Could anyone help me ? Thank you!

ValentineLS_0-1625760887728.pngValentineLS_1-1625760906419.pngValentineLS_2-1625760921986.pngValentineLS_3-1625760933860.png

 

 
1 ACCEPTED SOLUTION

Accepted Solutions
anand.shekhawat
Super Contributor

Re: level 1 activity 9.2.5 dimension error

@ValentineLS 

The output is correct . In the REV04 module you have entered the value 5% for all the chocolates in the the Country US. But in the REV05 module the output is 420% because it is summing up the percentages of all the Locations under US and all the chocolates under each location. So to verify, select any location(lowest level) under US and any particular chocolate(lowest level) in the REV05 module, you will see 5 % only.

 

I hope it helps

 

~Anand

View solution in original post

2 REPLIES 2
ValentineLS
Occasional Contributor

Re: level 1 activity 9.2.5 dimension error

I have succeeded to enter the formula by changing the dimension G1 from G2 in the REV04 module. But even though the formula is working, the result is not the expected one. Would you have an idea as to why ?

ValentineLS_0-1625763033861.pngValentineLS_1-1625763046603.png

 

anand.shekhawat
Super Contributor

Re: level 1 activity 9.2.5 dimension error

@ValentineLS 

The output is correct . In the REV04 module you have entered the value 5% for all the chocolates in the the Country US. But in the REV05 module the output is 420% because it is summing up the percentages of all the Locations under US and all the chocolates under each location. So to verify, select any location(lowest level) under US and any particular chocolate(lowest level) in the REV05 module, you will see 5 % only.

 

I hope it helps

 

~Anand

View solution in original post