I have a list as dimension in one of my modules, and I am trying to change that dimension to a subset of the same list. However, when I try to do that, I get the following error message;
"To serve as an access driver, a Top Level Item must be present on any line item dimensions that don’t match those of the target module or line item(s)."
I have never seen this message before, but have tried a few different things. First, I do have one Access driver in the module I am trying to change dimension of, but even when I remove that driver, I get the same message.
Also, I have checked all modules that are connected to the model with the issue, and none of them have an access driver.
It is vital that I get this to work asap, so any help is highly appreciated! Thanks a lot!
I tried this, but got the same error... I traced the error back to the access driver I have in my module, and it is almost like the module doesn't realize that I have removed it before changing dimension.
I did however create a new module that looks like the old one, but with the correct dimensions, and then added the same formulas. And when I added the access driver again, it worked. So issue solved.
The error suggests that your list does not have top level (a top level that all the items in the list roll up to).
So you could try adding in a top level to your list and see if this resolves the issue.
Also it could be that one of the line items in your module may reference a specific list item not a whole list dimension which is preventing you from applying the subset?
Alternatively you could 'rebuild the module' by copying all the formulae from the module and then delete them and remove the access driver and then change the dimension to the subset and copy back the formula and driver access. If this does not work it will highlight which calculations will need to be changed.