Hi, I'm relatively new to MDX and I will be really thankful if somebody
can help me out . I am trying to create an exception in Panorama.

I have the following Dimension and propertie(s) to that dim:

[Activity Time].[Fiscal Year].&[2007].&[3]

Properties:
Current Fiscal Year: 2007
Fiscal Quarter: 3

I also have another dimension and a calculater member to that dim:
[Last Full P and Q]

Calculated member: Last Full Period

I need to find a way to parse out the 2007 from [Activity Time].[Fiscal
Year].&[2007].&[3] and compare that to the property Current Fiscal
Year:2007 of that dimension and at the same time compare the Fiscal
Quarter:3 property of the Activity Time dimension to the Last Full
Period calculated member of the Last Full P and Q dimension. Thanks for
your help!!!

Josh

I was thinking of something like this but obviously it doesnt work.

cint(Mid(
[Activity Time].CurrentMember.UniqueName,
len("[Activity Time].[Fiscal Year].&[") + 1,
len("2007"))) = [Activity Time].CurrentMember.Properties("Current
Fiscal Year")
AND cint([Activity Time].CurrentMember.Properties("Fiscal Quarter")) >
[Last Full P and Q].[Last Full Quarter]

Thanks

josh


Josh wrote:

Not quite sure what you try to achieve. Ancestor([Activity
Time].currentmember,
Activity Time].[Fiscal Year]).name should give you the year member name.

"Josh" wrote: