Hi,

I am using the following syntax for a default member in the time
dimension.

Tail(Filter([Period].[445].[Month].members,[Period].[445].currentmember.properties("Complete")="Y"))

I wanted to default our Time dimension on the month that is complete.
The above syntax is accepted - but in the cube - doesn't execute it.

I tried another method -
default member:
{Tail({(Tail([Period].[445].members).item(0).item(0))} +
Filter(LastPeriods(7,Tail([Period].[445].members).item(0).item(0)),Not
IsEmpty([Measures].[Data Flag])))}
Did not avail.

Eventhough - Both of these work fine as Named Sets...
And I have run out of thoughts. Can you help?

Can you explain this .
its is not clear
"I wanted to default our Time dimension on the month that is complete. "
"Harsh" <creative (AT) mailcity (DOT) com> wrote

erties("Complete")="Y"))

Well, our months are flagged as "complete" everytime they are tallied.
I just wanted the time dimensions to default on that month.

You can see the syntax above.

Thanks

Did you try:
Tail(Filter([Period].[445].[Month].members,[Period].[445].currentmember.prop
erties("Complete")="Y")).item(0).item(0)
?
I use the following with success:
tail([ValuationDate].children,1).Item(0).Item(0)
Jim

"Harsh" <creative (AT) mailcity (DOT) com> wrote

erties("Complete")="Y"))

Thanks a lot. That worked.

Now I have the second piece of my puzzle...

Conditional default.
Default on the Complete month normally.
But Default on Aggeregate (All level) in case the hierarchy is switched.

What do you mean by "... hierarchy is switched"?

"Harsh" <creative (AT) mailcity (DOT) com> wrote