Create a cube in analysis services out of more than one fact table.

Is it possible to create a cube in analysis services that has columns from
more than one fact table as long as the fact tables share the same data
grain and dimensions?

Thanks for any advice.

Regards,
Anthony


.

Relevant Pages

  • Analysis Services Query Log Inconsistency
    ... Analysis Services 2000 allows up to 128 dimensions per cube; ... level in each dimension a particular query uses. ...
    (microsoft.public.sqlserver.olap)
  • Spoof shared dimension for virtual cube
    ... just getting back into Analysis Services again, ... Two cubes, ... Cube1 has 10 more dimensions, ... I'm sure it's possible to get this result with MDX (which I'm still not ...
    (microsoft.public.sqlserver.olap)
  • Re: ROLAP Dimension Question
    ... The Analysis Server has its own caches -- including caches for calculations. ... So if an attribute changes in the dimension table but Analysis Services ... I have a Cube. ... If a member gets added to one of my dimensions, it will not appear in my ...
    (microsoft.public.sqlserver.olap)
  • Re: dimensions and cube aggregs
    ... You might consider looking at the Analysis Services Performance Guide. ... > I have 8 dimensions that are needed for various queries. ... > I am trying to use them all in 1 cube, ... > The problem is the aggregations get a bit out of hand even at 20%. ...
    (microsoft.public.sqlserver.olap)
  • memory usage in SQL Server Analysis Services 2005 (SSAS)
    ... I am running the enterprise edition of Analysis services 2005. ... cube that has 4 dimensions and 2 years of test ... I was able to setup the cube and process around 43 million rows easily ... further and found that the CPU on the server spikes to 100% when I ...
    (microsoft.public.sqlserver.olap)