Please may I have your assistance with the following issue?

My objective is to override a calculated member if it has a value in a
different cube

Just a bit of background this calculated member is a baseline which is based
on a date range however the user has the option to override the value which I
have chosen to hold in a different cube. Perhaps there is a better way of
doing it?

The details are as follows. I have a virtual cube that consists of the 2
following cubes

Cube 1

Dimensions:

Application
Location
isWeekendForDay
Time_day

Measures:

Bytes
Ave Time
Util


Cube 2

Dimensions:

Profile
Application


Measures

Abs Bytes
Abs Ave Time
Abs Util

MDX :

with

SET aaiBLDates AS
'NONEMPTYCROSSJOIN({[Time_day].[2005-05-01 00:00:00]:[Time_day].[2005-05-31
00:00:00]},{[isWeekendForDay].[All isWeekendForDay]},1)'

set aaiApps as
'{[application].members}'

MEMBER Time_day.Baseline AS
'iif(
ISEMPTY(([Measures].[Abs Bytes],[Profile].[All Profile].[2])),
AVG(aaiBLDates),
[Measures].[Abs Bytes]
)', SOLVE_ORDER=120


SELECT { crossjoin({[Time_day].Baseline},{ [MEASURES].[bytes], [MEASURES].
[Ave Time]}) } ON 0,
aaiApps ON 1
FROM vaaiApplication_day
--where ([Location].[All Location].[108],[isWeekendForDay].[All
isWeekendForDay])


The member Time_day.Baseline needs to handle if I have an 'Abs Bytes' value
for a given profile and application then this needs to override the value
based on the date range.
The above is a scaled down version of the full MDX statement.
The above SELECT statement would have multiple cross joins for different
Time_day members
The above gives me error
'Unable to display cell properties, Infinite recursion detected during
execution of calculated member baseline, an error occured during attempt to
get cell value'

Any advise would be greatly appreciated

Thanks

John


--
Message posted via http://www.sqlmonster.com