Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

quering dimensional and measure values from multiple cubes

Go down

quering dimensional and measure values from multiple cubes Empty quering dimensional and measure values from multiple cubes

Post  dpkkry 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

Back to top Go down

Back to top

- Similar topics

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