Aggregation in Virtual Cube

#1

Hello,

When I create a virtual cube, does it stores the aggregations physically in
the disk or calculates on the fly?

Thanks,

Ajit Singh

#2

There is no data storage for virtual cubes -- queries are shuttled to the
underlying physical cube(s). Only when the aggregated value is not in the
physical cube does the agg occur on-the-fly.

tom @ the domain below
www.tomchester.net

"Ajit Singh" <ajit (AT) test (DOT) com> wrote

Quote:

Hello,

When I create a virtual cube, does it stores the aggregations physically
in
the disk or calculates on the fly?

Thanks,

Ajit Singh

#3

Thanks Tom for the info.
"Tom Chester" <publicNOSPAM (AT) tomchester (DOT) net> wrote

Quote:

There is no data storage for virtual cubes -- queries are shuttled to the
underlying physical cube(s). Only when the aggregated value is not in the
physical cube does the agg occur on-the-fly.

tom @ the domain below
www.tomchester.net

"Ajit Singh" <ajit (AT) test (DOT) com> wrote in message
news:OBwqpw2rDHA.1196 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
Hello,

When I create a virtual cube, does it stores the aggregations physically
in
the disk or calculates on the fly?

Thanks,

Ajit Singh

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

Aggregation in Virtual Cube

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

Aggregation in Virtual Cube - 11-20-2003 , 07:57 AM

Re: Aggregation in Virtual Cube - 11-20-2003 , 11:41 AM

Re: Aggregation in Virtual Cube - 11-21-2003 , 01:53 AM