In Analysis Services : Calculated Members

How do I perform a test like this:

if ProjectCategoryID = "some_value" then return VALUE1 else return VALUE2

Found the IIF function but not familiar with the syntax.... Will only return
#ERR or some errormessage

The formula should look something like this.....

iif([ProjectCategory].[Project Category Id] =
"FP_Revenue",[Measures].[SalesAmount_RevenueHC],0)

The dimension [ProjectCategory] has only one level [Project Category Id]

You might be looking to syntax:
iif([ProjectCategory].[Project Category Id].CurrentMember.Name =
"FP_Revenue",[Measures].[SalesAmount_RevenueHC],0)

Vimmas

"Tale Liereng" <TaleLiereng (AT) discussions (DOT) microsoft.com> wrote

Another option would be to do an "IS" comparison on an actual member,
you also then have the option to link to the member ID rather than the
name which should insulate you against possible changes in the member
name and I believe has a performance advantage over doing a string
comparison.


iif([ProjectCategory].[Project Category Id].CurrentMember IS
[ProjectCategory].[Project Category Id].&[<id>],[Measures].
[SalesAmount_RevenueHC],0)


--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <Oi7YIj2RGHA.1844 (AT) TK2MSFTNGP12 (DOT) phx.gbl>, Vimas (AT) nospam (DOT) nospam
says...