Calculated Members to Regular Measures

#1

Hi All,

Is it possible to convert the Calculated Members of a Cube
as regular measure in another Cube.

As calculated members are calculated only when needed, the
response time of the query gets affected. But for the
regular measures, the values are precalculated and stored
in the cube structure.

Cheers,
Sanka

#2

Is it a techical limitation ?

Quote:

-----Original Message-----
For all practical purposes, no.

tom @ the domain below
www.tomchester.net

"Sanka" <loonysan (AT) mailcity (DOT) com> wrote in message
news:05ef01c342f5$e0ee4c00$a501280a (AT) phx (DOT) gbl...
Hi All,

Is it possible to convert the Calculated Members of a
Cube
as regular measure in another Cube.

As calculated members are calculated only when needed,
the
response time of the query gets affected. But for the
regular measures, the values are precalculated and
stored
in the cube structure.

Cheers,
Sanka

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Calculated Members to Regular Measures

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Calculated Members to Regular Measures - 07-05-2003 , 08:03 AM

Re: Calculated Members to Regular Measures - 07-07-2003 , 10:43 AM