MDX Functions

[Mantle51]

Hello,
After installing OLAP Services, I thought I'd be able to incorporate the MDX functions(specifically IIF) into my SELECT statements with something like this:

SELECT [Evaluation_Date],fn_tblEvalSwitch([Period_Code])AS
'Period',fn_tblEvalSwitch([Audit_Indicator])AS
'Audited',fn_tblEvalSwitch([Trade_Settle_Indicator]),IIf([Trade_Settle_Indicator])='M', 'Yes', 'No')

FROM tblEvaluation

..but I keep getting "'IIf' is not a recognized function name" error.

Thanks for any assistance........

 

[Qik3Coder]

I know you are doing this get at more than just IIF,
but why don't you just use Case When?

Does it only install to a single datase? or is it for the entire server?

-The answer to your problem may not be the answer to your question.

 

[Mantle51]

It installs to the entire server.

 

[ESquared]

How about asking this in the SQL Server OLAP forum?

[COLOR=black #d0d0d0]When I walk, I sometimes bump into things. I am closing my eyes so that the room will be empty.[/color]

 

[AlexCuse]

Here is a link to the analysis services forum.

forum960

My guess is you are trying to execute against a standard database, not an analysis services database.

Someone there ought to be able to help though.

Good LUck,

Alex

Ignorance of certain subjects is a great part of wisdom