Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Current Member in an IIF Clause

Status
Not open for further replies.

boligoma

IS-IT--Management
Feb 11, 2003
31
MX
Hi again,

In a MDX sentence I want to put this value:

set [Signo] as '(IIF ([measures].[ColumnaNivel1].CurrentMember.Name IS '010.Ventas',-1,1))'

I tried in the cube as a calculated member and I had no problem at all. But as a "Set" or as a "member" condition the MDX shows me the following error: "Expecting SELECT, near... "

The question is: In a set or member statement how I use the iif clause for an especific member of a dimension?

Regards,


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top