Re: How to identify set (similar as possible)

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Jéjé" <willgart_A_@xxxxxxxxxxxxxx>
Date: Thu, 10 Aug 2006 17:46:42 -0400

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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6DFAF47D-F06E-4E65-AA21-3275E11AE858@xxxxxxxxxxxxxxxx

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.

Prev by Date: Initialization of the data source failed.............. Does anyone know what the fix is?
Next by Date: Re: Creating a dimension having more than 64,000 distinct values
Previous by thread: Initialization of the data source failed.............. Does anyone know what the fix is?
Next by thread: Re: How to identify set (similar as possible)
Index(es):
- Date
- Thread

Relevant Pages

Re: Actions
... Had problems with URL against dimension members...that would only accept one ... > through Analysis Manager, then you may be seeing a known bug with AM. See ... >> Isn't it possible to create an action that brings along currentmember ...
(microsoft.public.sqlserver.olap)
Re: How to identify set (similar as possible)
... currentmember always return a member, ... 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. ...
(microsoft.public.sqlserver.olap)
Re: Linkmember not working in Crossjoin set
... "There's a couple of questions raised by this MDX: ... --> Yes, it is .currentmember ... Unless the selected member is always at the same level as ... Is there a way to setup the time dimension to default to ...
(microsoft.public.sqlserver.olap)
Default Member Property
... Im trying to set a default member for a dimension using a MDX expression: ... But if i dont use Currentmember it works fine: ...
(microsoft.public.sqlserver.olap)
Re: MDX query without total....
... i found out that the Extract function does it... ... > If I have a dimension with and I want to query that cube with that ... > dimension without it returning the values... ...
(microsoft.public.sqlserver.olap)