Hi,

I am working on creating virtual cubes in Analysis Services 2005. I
dont know where to create virtual cubes from a regular cubes. I
searched the internet to know more but all they say is Analysis Manager
Tree pane, right click select virtual cube. I dont understand where
the Analysis Manager Tree is?? is in SQL Managment Studio or in MS
Visual Studio???

I even tried in SQL Server Managment Studio 2005 by connecting to
Analysis server, then selecting the cubes under databases and right
clicking it. But only a REFRESH option appears.

Please guide to how to create it...

Thanks in Advance.

Somu

Hi Somu
in SSAS 2005 there are no term "Virtual cube". The cube could have as many
fact tables as you want.

Ramunas


<somuthomas (AT) gmail (DOT) com> wrote

in a cube you can add another cube (or another measure group from another
cube); search for linked measure group information

there is no longer the virtual cube concept.

Also in 1 cube you can use multiple fact tables, each one will create a new
measure group.


<somuthomas (AT) gmail (DOT) com> wrote