level 1 activity 9.2.5 dimension error

ValentineLS

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

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 ?

 

anand.shekhawat

@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

anonymous86

Just wasted an hour of my time working this out, no idea why there isn't at least a hint about this in the instructions given that Level 1 is meant to be for absolute beginners. Anyway, the solution to your problem is to go into REV05 in blueprint mode and change the Summary for both line items to "average", once you do this it pulls through 5% just as the screenshot in the course.

Yogendrsingh5july

HEY Team,

once i add this formula in the 9.2.5 activity in the

REV05 Price Growth Rates Staging Module 

'REV04 Price Growth Rates'.Unit Price %[LOOKUP: 'SYS04 Location Details'.Country, LOOKUP: 'SYS06 Product Details'.Product Family]

under the unit price list item

not able to do it further to this, kindy help me through this

Rnilsson

@Yogendrsingh5july Have you been able to solve it yet?

Otherwise, could you provide us with a screenshot of the blueprint view of REV04, SYS04 and SYS06. And make sure to include the headings "format" and "applies to" (zoom out if you need to).

Yogendrsingh5july

Hi @Rnilsson i am unable to get the right total in the module, this is 11.3.4

my module has values in forecast where it was mentioned that it should have no value.

due to this while filling the formula in the REP03 profit and loss report it is taking reference from here rather than OTH01 NON EMOPLOYEE EXPENSE

KINDLY GUIDE ME HOW TO CORRECT

I am sharing the screenshot in a order for you to see

this is where the forecast should have no value as mentioned while importing the data.

this is the answer i am looing for attaching below

this is what my report is showing

this is my setting for the forecast

this is the value it is supposed to pick form this module for it to work right

as per this formula

IF 'SYS09 Version Details'.Forecast? THEN 'OTH01 Non Employee Expenses'.Shared costs ELSE 'DATA01 P&L Actual and Budget'.Shared Costs

kindly help

Rnilsson

Yogendrsingh5july

two things: how is your native version set? does your sys09 return

Since OTH01 seem to have the correct numbers but all lines in your report seem to return values from other modules it is to assume the version may be incorrect.

I think the other faults occurs due to import errors.

The formulas you have posted seem correct. But there should definitely not be values in the forecast. I don't know if its a formatting on your browser but the fact that the numbers are black and not blue is a bit strange as that would usually indicate that the numbers are there due to a formula.

However my suggestion is to mark all line items in the modules, and press the delete button (to get a clean slate) or delete the list members and re-do the entire import.
After removing the current data go to the action tab. Find the import action, press edit and make sure the mapping of version looks like the attached image:

tomholland

changing the dimension G1 from G2 in the REV04 module.