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

Aggregates

Hi,

When Creating a Cube , will it automatically create aggregates?

We are not using any aggregates.

But i am getting an error in the PC while Compressing a cube.

It is showing that "Lock not set " and also "Active, empty,filled Aggregates Present for the Cube" and the PC is stopping there.

After sometime if we do the "Repeat" its working.The data in the Cube is Compressing.

I want to know whether this problem is due to Locking or some other thing.....

Thanks in Advance!!!!

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 03:29 PM

    Hi,

    When you create the cube, the aggregates are not created automatically. You need to explicitly create the aggregates. select your info-provider, in the context menu choose 'Manage'. under the roll-up tab, click on 'Aggregates'. It shows you if there are any aggregates build on your cube.

    Thanks,

    Praneeth.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi JS,

      You might have activated your cube along with the aggregates from the business content, and so there might be some aggregates existing for the cube.

      So when you try to compress the cube the system is proposing for a roll-up for the aggregates which should be done before the compression.

      Check out for any active aggregates on the cube and switch them off or deactivate the aggregates. A icon will be displayed in front of the cube name(after the technical name) if there are any aggregates existing.

      Hope this helps,

      Regards.

  • author's profile photo Former Member
    Former Member
    Posted on Jan 11, 2007 at 08:02 AM

    Hi JS,

    Are you loading some master data attributes also in the process chain. If so, then may be you forgot to include the "attribute change run" step in the process chain. Once you do that before the cube load may be the error would not appear.

    Bye

    Dinesh

    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.