making a dimension smart

Hi,

We have a cube with a client dimension which has lots of rows and about 60 attributes.

The table looks like this

ID, first name, infix, lastname, street, housenumber, postal code, city, gender.

The users want to see all the attributes..

Analysis server is making calculations on every attribute.

The users are only intrested in ID, city and gender but they don't want to loose the other attributes.

How can I tell analysis server that it should not make calculations on the first name, infix and lastname, street, housenumber and post code?

I tried setting the attribute IsAggregable to false but that didn't work.

Any suggestions ?

With regards,

Constantijn Enders

If you don't want the data to aggregate, set the AggregationUsage property to None in the Attributes tab, in the Dimension window (possibly the bottom left window) under the Cube structure tab in VS.

C
|||

what type of calculations you do?

usually you do calculations in numeric values...

you can set aggregation to none...

give more details...

Regards