-
MDX - How to use negative members
Hi All - The data is not being returned for my "-1" booking indicator. What is the syntax? I tried (), no (), "", ''.....
sum(( {[DIM CUSTOM ACCOUNT].[Underwriting Expenses],[DIM CUSTOM ACCOUNT].[Admin Expenses]},[dim currency].[USD],[DIM Business unit].[TWG_Consol],{[dim book indicator].[(-1)],[dim book indicator].[A],[dim book indicator].[C],[dim book indicator].[G],[dim book indicator].[Z]},{[dim ledger].[actual_usd],[dim ledger].[budget_usd]}) ,[Measures].[budg Posted Total Amt])
-
Couple of quick questions ...
Hi:
What is the data type for the booking indicator you describe as capable of having "negative" members? Are you working within Analysis Services 2k or 2k5?
Let me know, and I'm sure I can offer suggestions to your issues.
Thanks.
Bill
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|