Re: Virtual Cubes 2005



Analysis Services 2005 does not support virtual cubes anymore. Now the cubes
can have multiple fact tables (measure groups in AS 2005 terminology), so
there is no need for virtual cubes. in addition, you can narrow the view of
a user with new objects called Perspectives. they are based on a single
cube, similar to virtual cubes, although you cannot set up security on
perspectives.

--
Dejan Sarka
http://www.solidqualitylearning.com/blogs/

<somuthomas@xxxxxxxxx> wrote in message
news:1166184248.774195.247680@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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

PS: My apologises if u already read it before.



.



Relevant Pages

  • RE: Why does my virtual cube always get processed (OLAP 2000)
    ... Do you use Analysis Services Parallel Processing Utility? ... virtual cubes looked like physical cubes and the underlying ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.olap)
  • Program to implement Linked Measure Groups
    ... Analysis Services 2000. ... We have plans to move on to SQL Server 2005. ... In SS05, virtual cubes and linked cubes are replaced by Linked Measure ...
    (microsoft.public.sqlserver.olap)
  • Virtual Cubes 2005
    ... I am working on creating virtual cubes in Analysis Services 2005. ... dont know where to create virtual cubes from a regular cubes. ... I even tried in SQL Server Managment Studio 2005 by connecting to ...
    (microsoft.public.sqlserver.datamining)
  • Virtual Cubes 2005
    ... I am working on creating virtual cubes in Analysis Services 2005. ... dont know where to create virtual cubes from a regular cubes. ... I even tried in SQL Server Managment Studio 2005 by connecting to ...
    (microsoft.public.sqlserver.olap)