- 17.9K All Categories
- 3.3K Industry Applications
- 3.3K Intelligent Advisor
- 60 Insurance
- 534.8K On-Premises Infrastructure
- 137.8K Analytics Software
- 38.6K Application Development Software
- 5.4K Cloud Platform
- 109.2K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.9K Infrastructure Software
- 105.1K Integration
- 41.5K Security Software
CrossJoin - Is there a way to exclude a member from results?
Appreciate any help or suggestions.
I'm doing an allocation ASO MaxL script. However, I have a member that has a formula on it and need to exclude it. Problem is 'BalanceSheet' is an Ancestor of it. Is there a way to exclude it in my CrossJoin statement?
Basically I want to include all Lev0 members of BalanceSheet EXCEPT AC_322000101 as it has a formula on it:
ERROR - 1260052 - Syntax error in input MDX query on line 11 at token 'Account.AC_322000101' .
ERROR - 1241192 - Allocation terminated with Essbase error 1260052 in POV.
My Code I'm trying. Not sure if 'Except' is correct or not:
execute allocation process on database APP.DB with
amount "([Periodic - EUR])"