I'm not really familiar with the LookupCube function, but I'm trying...
I'm alos using AS 2000

Here's my problem. I'm trying to get a measure from another cube, but I'm
running into problems with the time dimension. The 2 cubes don't have the
same time dimension, However, the time dimension I'm using in my cube
([time].[Tenants] is a view built of the [Time].[Calendar] dimension in the
2nd cube. When I use the below call to lookup a measure in the 2nd cube, it
will not compute unless I use the 2nd cubes time dimension. Can I use my
time dimension and if so, how to I link it up.

Thanks for the help!!!

iif([Property].[Mgt].currentmember.level.ordinal<>0,LookupCube("Units" ,"([Measures].[Avg
Count],"+[Time].[Calendar].CurrentMember.Uniquename+","+[Property].[Mgt].CurrentMember.UniqueName+","+[PropertyStatus].CurrentMember.Uniquename+")"),
iif([Property].[MSA].currentmember.level.ordinal<>0,
LookupCube("Units","([Measures].[Avg
Count],"+[Time].[Calendar].CurrentMember.Uniquename+","+[Property].[MSA].CurrentMember.Uniquename+","+[PropertyStatus].CurrentMember.Uniquename+")"),
LookupCube("Units","([Measures].[Avg
Count],"+[Time].[Calendar].CurrentMember.Uniquename+","+[Property].[Market].CurrentMember.Uniquename+","+[PropertyStatus].CurrentMember.Uniquename+")")))

I think I might have found a work around. I added the Tenants Hierarchy to
the lookup cube and it may be working. At the end of this sprint, I going to
suggest a redo strategy for this client's environment. Crazy!

"Scott Mescall" wrote: