January 11, 2011 at 10:01 pm
I,Have 2 OLAP cubes.one is cube1 & another one is cube2
in cube1 & cube2 i have some dimensions(d1.dim,d2,d3...),(D1.dim.D2,D3.....)
some measures...
how to get the information from cube2
when we query(MDX) in cube1
plz hlp me....
in my sys
SQl Server Enterprise Edition 2008,MS Visual Studio(BIDS) 2008
Thanks in advance..
[font="Verdana"]SRIHARI(:~[/font]
January 12, 2011 at 5:20 am
Use linked cube feature if you are doing development. In MDX query, you can use lookupcube function. Here is one example,
-- LOOKUPCUBE( «Cube Name», «Numeric Expression»)
WITH MEMBER [Remote Measure AdventureWorks]
AS
LOOKUPCUBE(
"[Adventure Works]"
,"[Measures].[Internet Sales Amount]"
)
,FORMAT = "0,000.00"
SELECT [Remote Measure AdventureWorks] on 0
FROM [Mined Customers]
Thanks,
Amit G
http://www.msbiconcepts.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply