quering dimensional and measure values from multiple cubes

View previous topic View next topic Go down

quering dimensional and measure values from multiple cubes

Post  dpkkry on Wed Jul 18, 2012 5:59 am

I have two cubes named "Sales" and "Production". Both have some shared common dimensions. Now as example, I want to get the followings:

dimensional attributes:
---------------------
Item# (from sales cube)
production location center (from production cube)
measures:
-----------
sales quantity
production quantity
How I will do it in SQL Server 2008 (Standard Edition)? Is it possible to link the two cubes on run-time and pick the necessary result set from them?
If so, How I can do ti.

dpkkry

Posts : 1
Join date : 2012-07-18

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum