Error when changing list dimension to subset

HI,

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!

Accepted answers

fredrickstraube

Hi,

It worked to "rebuild" the module with the correct dimensions from the beginning.

Thanks a lot!

All comments

karank_*4578

@fredrickstaube

try this

download ur module to excel in blueprint mode this is just to save your formulas

then remove all formulas and access drivers

change dimension

put ur formulas back

usman.zia

Hi @fredrickstraube

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.

I hope this helps,

Thanks,

Usman

fredrickstraube

Hi,

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.

Thanks a lot!

fredrickstraube

Hi,

It worked to "rebuild" the module with the correct dimensions from the beginning.

Thanks a lot!

Ala_CHKIR

Dear All

I have the same problem when trying to remove the top level of two members list

I'm trying this to gain space,

what whould be the solution ?

Thank you

rob_marshall

@Ala_CHKIR

If you have a line item that is summing the data in the list, you will need to have the top level.

Hope this helps,

Rob

usman.zia

Hi @Ala_CHKIR,

When you want to make a structural change the best thing to do is:

1. Copy the module

2. Copy save and then remove the formulas

3. Make the structural change

4. Paste back the formulae

5. See if this causes any issues and then address the formula changes.

I hope this helps!

Constantin

Hi @fredrickstraube ,

SOLUTION:

To solve it, I removed all the DCA linked to the line items from that module and then I could change the dimensions of accordingly.

Hope this helps 🙂

Thank you!

KishoreBK

I Removed all the DCA to the line items of the module and you may change the dimensions.

aduesing

I received the same error, even though I had deleted the DCA. I had previously copied the module. By removing the DCA also from the copied module, I was finally able to change the applied list.

freddy

For this, copy the DCA somewhere and remove it. Then change the dimension and get back the DCA.

Navink

Hi @fredrickstraube
Even I faced similar kid of issues, below were my observations

1.Have a line item that is summing the data in the list, Changed the summary as per the need.

2. Added the top level as per the requirement, if the top level is not there.

Removed the formulae before changing the applies to and re-applied it.

Faced similar issue while changing the applies to for DCA Modules (subset to entire list or vice versa), for that we should make sure if there is no summing up Line item. Sometimes it will work if we remove and re-apply all the formulae after changing the dimensions.

Hope things work.

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…