Re: Merging or Joining cubes

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I have three cubes in AS. How can I have a seperate cube which retrieves
data from these three cubes and then (similar to join function in T-SQL)
can join the results?

In AS 2000, the easiest way is to create a Virtual cube. In AS 2005, the
easiest way is to have a cube with multiple fact tables (AS 2005 UDM cube is
much more advanced than AS 2000 cube) and then create Perspectives.
In both, AS 2000 and 2005, you can also create Linked cubes.

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


.

Relevant Pages

  • Re: Merging or Joining cubes
    ... I tried multiple fact tables approach, but the problem with this approach is ... My issue is that I'm using this cube as data source in Reporting ... data from these three cubes and then (similar to join function in T-SQL) ... In both, AS 2000 and 2005, you can also create Linked cubes. ...
    (microsoft.public.sqlserver.datamining)
  • RE: LIMIT OF FACT TABLE DATA
    ... Try to check the cube JOINS. ... - Grab the T-SQL that Analysis Server sends to SQL Server while processing the cube. ...
    (microsoft.public.sqlserver.datawarehouse)