Removing line item dimention from info cube

[Former Member]

Hi All Experts,

Early watch report has suggested us to remove line item dimention and high cardinality from some cubes.

bur our cubes are having data , and when I tried to chekc this in our Dev server, Line Item dimention is disabled when it is filled with data.

but when I delete data from Cube, Line item diemention check box gets enabled.

so does it mean that we can not flag or remove line item dimention form cube if contains data,

and in mine case I have to delete all data from cube and then trensport it to PRD after deleting data from Cube and reload after transport.

Am I correct.

Please advice If I am wrong.

[Former Member · Accepted solution]

you are right..

When u want to change from the Line item to the normal Dim .. u need to drop the existing data from the target and then only the system will allow you to change the same..

And this will needs to be done first in D and then move it to further systems...

thanks

Hope this helps..

[Former Member]

If you change the dimensions of a cube, you have to delete the data OR use the remodelling toolbox.

So you're right.

I didn't use the remodelling toolbox yet. I create a copy of the cube instead and load all data in this 'backup' cube. Then do the changes in your original cube and load back.

But you could also use the remod toolbox.

[Former Member]

thanks for your reply but there is no option for changing dimension type in remodelling tool box.

[Former Member]

Then you can follow the path Siegfried (and I) also mentioned:

copy the cube etc.

[Former Member]

Hi,

yes, you are correct. You have to delete the content of the cube before you can change a line item dim. to a 'normal' dimension. As a workaround you might use a copy of the cube, create and/or copy all update rules to the new cube, and create a new update rule from the old to the new cube. Transport everything to prod, then load you new cube from the old cube and do all the other load as before. Move/copy your queries from the old cube to the new cube as well.

regards

Siggi