Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Sum is displayed twice

  1. #1
    Join Date
    Jan 2008
    Posts
    5

    Default Sum is displayed twice

    I use very simple MDX query:

    select NON EMPTY {[Measures].[SUM of staging_cdr_plain.call_cost]} ON COLUMNS,
    NON EMPTY
    {[staging_cdr_plain.operator_name.staging_cdr_plain.operator_name]} ON ROWS
    from [test2]
    WHERE [staging_cdr_plain.command.staging_cdr_plain.command].[TELA]


    but I do not why all sum in measure (call_cost) and I do not understand number is displayed twice in (Analysis Pivot). Result look like this:

    Measures
    staging_cdr_plain.operator_name | SUM of staging_cdr_plain.call_cost
    All staging_cdr_plain.operator_name | 2222 2222
    -----------------------------------------------------------------------------
    Slicer: [staging_cdr_plain.command=TELA]

    It should be 2222 instead 2222 2222

  2. #2
    Join Date
    Nov 1999
    Posts
    1,618

    Default

    I agree that's weird. When you press the 'MDX' button in the viewer, does the MDX still look the same? If you take out the 'NON EMPTY', do you still get two columns?

    Julian

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.