Results 1 to 2 of 2

Thread: MDX - How to use negative members

  1. #1
    Join Date
    Sep 2008
    Posts
    1

    Question 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])

  2. #2
    Join Date
    Jun 2004
    Location
    Atlanta and Manhattan
    Posts
    607

    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
  •