Hello,

does someone could
explain me why if I
use or not
the storage with a
performance of 100%
calculated members
do not display
immediately in my
client program.

Thanks

In AS2000 Calculated Members are always evaluated on the fly, regardless of
storage options.
FYI, it is usually not a good practice to select 100% performance gains,
since this will result in growing storage requirements and longer cube
processing times, with little difference in query performance.
Usually, 10 to 30% should be adequate. The best setting for a specific cube
can only be determined by testing.

HTH,
Brian
www.geocities.com/brianaltmann/olap

"%u" wrote:

A little elaboration on what Brian states...

A "100% performance gain" doesn't ensure that all possible aggregations
are made. You can achieve, that more aggregations are made by increasing
the "fact table size" in the cube editor, and then run the storage
design wizard again, but even then MSAS might "trick" you.

But as Brian states a 100% performance gain is very rarely, if ever,
needed, so if your performance is at all aggregation-related (it might
be CPU, memory etc. instead), it is more likely, that you don't have the
RIGHT aggregations for your needs.

You could try to use the "usage based optimization" wizard, which
suggests aggregations based on the queries, that have already been made
to the cube.

If this doesn't help you either, you could be forced to make your own
storage design, which I have done on a couple of occasions. In the "SQL
Server Accelerator for BI" package, which MS offers free of charge,
there is, amongst other tools, a tool included for making your own
storage design. It is downloadable from
http://www.microsoft.com/sql/ssabi/default.asp

Best regards
Dan Reving

%u wrote:

Thanks for your help but you did not respond exactly to my question.

I just need to know if the calculated members are included
in the stored agregations ?

Thank you.

Please read my post again. I did answer your question.
Regards,
Brian

"%u" wrote: