Analysis Services 2005 Aggregations?

Hi,

When i try to calculate the cube aggregations it will always give me 0 aggregations... why is this happening? I have about 10 dimensions and if i remove 3 of them (always the same dims) the aggregations are calculated to about 99% so why the hell with that dims it would not calculate? They are Parent-Child Dimensions...

Best Regards,

Luis Sim?es

Looks like a bug to me.

Can you please try and contact Customer Support and open a case about this behavior. It would be helpful if you will be willing to share your cube design.

Thanks.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

|||

How do i contact Customer Support?

About the cube i really can't post anything about it because it is beeing done to a major public entity and i have no authorization to pass schemas, designs or data out of here...

So is there anyway we can synch and try to find the problem?

Best Regards,

Luis Sim?es

|||

http://support.microsoft.com/ph/2855

See if you pass the information to Customer Support in more general terms. How many dimensions, how many attributes per dimension. How many hierarhies in every dimension.
To try and reproduce the problem in generic version of your cube.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

|||

I am doomed! The cube is so slow that i can't do anything with it... Jesus....

Has for the microsoft site i was unable to find a direct way of contact with them unless i have to pay for support...

Do you have any sugestions?

U have msn?

Regards

|||

Luis.

It is really hard or nearly impossible to help you with very short description of the problem.
It is even harder to help if you cannot share any of your data.

Can you try and describe your cube design in general terms like:

Dim1 ( KeyAttr, Attr1 , Attr2 ....) Parent-Child
Attr1 is related to KeyAttr and usage is set to Parent.

Dim2 (KeyAttr, Attr1 , Attr2 ) Regular
Hierarchies Hier1 (Attr2, Attr1, KeyAttr)

....

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

|||

Well i am shure now that the problem lays within the Parent-Child Dimensions because i have created new dimensions for the same purpose but flattened.. no parent-child and the cube gets 95% aggregated...

So basically all my Parent-Child Dimensions are done like the book says...

So i have A Parent Atribute and a Key Atribute

Example: Products Dimension

PARENT_PRODUCT_COD -> this is the parent atribute

PRODUCT_COD -> this is the key atribute

In the parent atribute i also have parameterized the UNARY OPERATOR and ROLLUP FORMULA with the correct columns

So i don't really know where is the problem...

Regards,

|||

The solution for your problem ( I got better description of it through the MS guys in Portugal) is:

For every PC dimension you should change AggregationUsage property of the Parent attribute to None.
For every Key attribute you should set AggregationUsage to Unrestricted.

Once you've done this, you should see aggregation desing algorithm desinging aggregations for you.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Edward,

I have received from Jose Silva (MS Portugal) the changed project, after calculating the aggregations i still get 0%....

It seems it is a known bug by AS 2005 programmers team and probably only solved by a hotfix...

Lets see what happens in the next days... and then i will post the result here so the community can be informed about this problem.

Thank you!

Best Regards,

Luis Simoes
WorldVision Consulting