"Level Mismatch on Common Dimension" Error when Changing Parent of List
Originally we had A1 Expense Group, A2 Expense Category, and A3 Expense Account. We added A3 Subcategory and changed the naming of A3 Expense Account to A4 Expense Account.
We have been unable to change the Parent of A4 Expense Account to be A3 Expense Subcategory. Attempting to change this gives the error "Level Mismatch on Common Dimension."
We have done the following:
- Cleared out any formulas using a parent clause and the associated account hierarchy
- After that didn't work, we made a model copy and removed all formulas from the model to try picking it apart one-by-one, but are still getting the same error with all formulas removed.
Any ideas on what to try next?
Answers
-
In the List area, look in the Reference in Applies To and Referenced as Format, it has to be in there.
1 -
Thank you @rob_marshall. Turns out it was due to a ratio summary in a filter module we were using to allow users to select different levels of the hierarchy on an app page.
2 -
This is exactly my issue atm too and I cannot for the life of me find a link I'm missing. Did the ratio reference show up anywhere at all? I've gone through the Referenced in Applies to and Referenced as Format. I've left 3 modules with reference in applies to……………. a bit worried to keep picking it away when half of it is not my work…… any other clues pls?
(and I've done the model export and searched in excel too). Where can I see formulas for DCA? This model also has selective access…. but not at this level, or the one above that I'm trying to remove…
0 -
0
-
@WendyJones - You can extract the line items view & filter on the DCA column to check all the modules/line items used as DCAs and then do a vlookup to get the formulas.
0
