- 17.9K All Categories
- 3.3K Industry Applications
- 3.3K Intelligent Advisor
- 60 Insurance
- 534.5K On-Premises Infrastructure
- 137.7K Analytics Software
- 38.5K Application Development Software
- 5.3K Cloud Platform
- 109.1K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.8K Infrastructure Software
- 105.1K Integration
- 41.5K Security Software
MDX Synax Assistance
Not an MDX pro and can't find an example. Logic seems simple, but can't get the syntax down.
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
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.