Cache calculated member

hi,

i have several calculated mebers in my cube that take a long time to be evaluated.
so i would like to evaluate the the calculation during processing my cube and store it directly in the cube.

So far i only found the "CACHE" statement that would fulfill my needs but i dont get it to work correctly

my calculated members looke like this;
CREATE MEMBER CURRENTCUBE.[MEASURES].[Kaufpreis je Wohnflaeche m2 Max]
AS MAX({descendants([Immobilien].[Geographie].currentmember, [Immobilien].[Geographie].[Immobilie], self)},[Measures].[Kaufpreis]),
VISIBLE = 1;

the [Immobilien].[Geographie]-Hierachie looks like this:
Immobilien
Land
PLZ
Immobilien
Immobilie

what would the CACHE-Statement look like to cache this calculated member in the cube?
any other ideas how to solve this problem?

thanks,
Gerhard

Unfortunately Cache statement is not supported in AS2005.

Future versions of the product might give you ability to cache results of the calcualtions directly.

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

|||thanks for your quick response

even though its not supported, i would like to test it out a bit

so what would the cache-statement look like for my calculated member?|||

Not supported, in part means I cannot encourage enyone using parts of the product that are not tested and might lead to unexpected results. Even for the test purposes. Sorry.

Closer to the release of the next version of the product you should be able to sign up for beta testing program to get to try new features.

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

|||

Does anyone know if it will be supported in SP2? I would help us a lot too.

When is SP2 due, does it have a date yet?

Regards,

GJ

|||Not sure of the release date but a new December CTP is now available...|||CACHE statement is not supported in SP2 either. But by looking at your original question, the CACHE statement wouldn't have helped in this case anyway.|||

Is it going to be supported in the future?

Also i recall you once said ther were no known issues with it, but it was not supported becuase there was no time to have it tested enough. Is it in 2005 as an undocumented feature or has it been removed alltogether?

I tried cache (subcube) in a script, it doesn't throw an error but i couldn't find any canges in behaiviour either.

Regards GJ