Can you use exception in the groovy script Crossjoin statement
Summary:
I'm using the following in the groovy script Crossjoin statement
{FILTER (Descendants([Accounts], [Accounts].dimension.Levels(0)), ([Accounts].CurrentMember.MEMBER_TYPE <> 2 AND NOT [Accounts].CurrentMember.Shared_Flag))}. Is there a way to add an exception to the statement?
Something like
{FILTER (Descendants([Accounts], [Accounts].dimension.Levels(0)), ([Accounts].CurrentMember.MEMBER_TYPE <> 2 AND NOT [Accounts].CurrentMember.Shared_Flag AND NOT (Descendants([HC_TOTAL], [HC_TOTAL].dimension.Levels(0))))}
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
"Crossjoin(Crossjoin(Crossjoin(Crossjoin(Crossjoin(Crossjoin(Crossjoin(Crossjoin(Crossjoin(Crossjoin({FILTER (Descendants([INCOME], [INCOME].dimension.Levels(0)), ([Accounts].CurrentMember.MEMBER_TYPE <> 2)),FILTER (Descendants([BALSHEET], [BALSHEET].dimension.Levels(0)), ([Accounts].CurrentMember.MEMBER_TYPE <> 2)),FILTER (Descendants([IT_CONTRACTOR_FTES], [IT_CONTRACTOR_FTES].dimension.Levels(0)), ([Accounts].CurrentMember.MEMBER_TYPE <> 2)),FILTER (Descendants([FTE_TOTAL], [FTE_TOTAL].dimension.Levels(0)), ([Accounts].CurrentMember.MEMBER_TYPE <> 2)),FILTER (Descendants([HC_TOTAL], [HC_TOTAL].dimension.Levels(0)), ([Accounts].CurrentMember.MEMBER_TYPE <> 2)),FILTER (Descendants([Total Planned Capital], [Total Planned Capital].dimension.Levels(0)), ([Accounts].CurrentMember.MEMBER_TYPE <> 2))},{Descendants([Output Type], [Output Type].dimension.Levels(0))}),{Descendants([Total Geography], [Total Geography].dimension.Levels(0))}),{[Jan]:[Dec]}),{FILTER (Descendants([Reporting View], [Reporting View].dimension.Levels(0)), ([Reporting View].CurrentMember.MEMBER_TYPE <> 2 AND NOT [Reporting View].CurrentMember.Shared_Flag))}),{Descendants([Intercompany], [Intercompany].dimension.Levels(0))}),{Descendants([Product], [Product].dimension.Levels(0))}),{FILTER (Descendants([Cost Center], [Cost Center].dimension.Levels(0)), ([Cost Center].CurrentMember.MEMBER_TYPE <> 2 AND NOT [Cost Center].CurrentMember.Shared_Flag))}),{Descendants([Years], [Years].dimension.Levels(0))}),{[endofperiod],[Mavg]}),{[$qToScenario]})"