Virtual on Virtual

• Rasbaba

  Old Hand

  Points: 305

  More actions

  October 23, 2003 at 4:03 am

  #160040

  Hi,

  Is there any way to have virtual cubes on top of virtual cubes - analysis services does not allow for this? In this case there are 4 virtual cubes for General Ledger, Sales, Purchasing and Cashflow data; each having 2 measures for actuals and budgets. If not through analysis services, what frontend tool is recommended for this?

  Regards,

  Andre

• Keith Henry

  Hall of Fame

  Points: 3759

  More actions

  October 23, 2003 at 9:08 am

  #479318

  You can specify multiple cubes in an MDX statment

  Keith Henry

  DBA/Developer/BI Manager

  
  
  
  Keith Henry
  

  ---

  
  According to everyone I know I "do something with computers?" for a living, so there you go.