Hi,

I would like to use lookupcube to access to one more cube. I could not
specify time range in lookupcube functions.


the following is not working. If I just specify a year (2002), it works.

with
MEMBER [Measures].[ManHours] AS
'LookupCube("Cube_Extra",
"(" + "[Dim_Time].[Year - Quarter - Month -
actualDate].[Year].&[2002].&[2]:
[Dim_Time].[Year - Quarter - Month -
actualDate].[Year].&[2002].&[12]"
+ ", [Measures].[manHoursWorkedTotal])"
)
'

thanks,

Guangming

you'll need to be referencing the time dimension member of the cube you are
currently in ( let's say cube [Current Cube] that has a time dimension like
this [Time].[CurrentMember ) and hopefully both cubes have the same naming
for the time dimension:

so your calc should look something like this:

MEMBER [Measures].[ManHours] AS '
LookupCube( "Cube_Extra",
"(" + MemberToString([Time].CurrentMember)
+ ", [Measures].[manHoursWorkedTotal])"
)
'

"Word 2003 memory Leakage" wrote:

thank you very much,

I am working in sql server 2005 beta 2. I put all fact tables in one cube,
and this solved the problem. I can set the right time dimensions to all fact
tables. Then I get the measures from each fact tables all sliced by the time
specified.

It is similar to a join in SQL. Is there a way to join two cubes rather than
specifying time dimensions to each fact table.

Guangming

"mike" wrote: