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

Discussion Group for the Dimensional Data Warehouse and Business Intelligence Community


quering dimensional and measure values from multiple cubes

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

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

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

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