Forum Stats

  • 3,770,163 Users
  • 2,253,079 Discussions
  • 7,875,352 Comments

Discussions

MDX Synax Assistance

User_XUC2I
User_XUC2I Member Posts: 45 Green Ribbon
edited Feb 13, 2020 4:40AM in Planning and Budgeting

Hi,

Not an MDX pro and can't find an example.  Logic seems simple, but can't get the syntax down.

Logic:

IF current member of Department dimension is a Descendant of NA_Depts then A + B

ELSE IF the current member of Department dimension is a Descendant of SA_Depts then C + D

ELSE #Missing

I've tried all kinds of combinations and can't get it to validate.  I'm missing something key here or Descendants is not my correct function?

Appreciate any tips.

Tagged:

Best Answer

«1

Answers