Simple question appears when reading BOL

<cut here>
The following example returns TRUE if [Time].[Fiscal].CurrentMember is a
leaf member:

IsLeaf([Time].[Fiscal].CurrentMember)
<cut here>

But if CurrentMember is set, this request will generate an error. Is it
possible to identify such situation before evaluating IsLeaf?

Thank you in advance for help.

CurrentMember can be used against 1 dimension only, not against a set.

use the Extract function to extract 1 dimension only from your set, then use
the currentmember
IsLEaf(Extract(<<my set>>, [Time].[Fiscal]).CurrentMember)


"igorkov" <igorkov (AT) discussions (DOT) microsoft.com> wrote

"Jéjé",

the problem is that you never know either is CurrentMember is a member or
set (lets assume). So i'd like to create a construction something like this

IIF( [Time].[Fiscal].CurrentMember is set, IsLeaf(Extract.....),
IsLeaf([Time].[Fiscal].CurrentMember)

Thank you.

"Jéjé" wrote:

currentmember always return a member, not a set.

what you don't know is if the dimension is currently used in a set!
using the extract function on a set when you don't know if the set contain
this dimension or not raise an error when the dimension is not here.
try to use the iserror function or convert the set to string and test the
string himself using string comaprison functions.



"igorkov" <igorkov (AT) discussions (DOT) microsoft.com> wrote