Skip to Content
author's profile photo Former Member
Former Member

Removing line item dimention from info cube

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 09, 2008 at 12:07 PM

    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..

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 09, 2008 at 12:07 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 09, 2008 at 12:09 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.