Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: group by clause in MDX query

  1. #1

    Post group by clause in MDX query

    hi,

    I'm facing some difficulty in doing group by clause in MDX query.I have list of processor names under different clients
    and these processor names will undergo three shifts likely Morning,Evening and Night.Now my problem is i want to group these processors of selected client by shift. Any suggestions are welcome.

    Thanks and Regards
    Annapurna

  2. #2
    Join Date
    Sep 2007
    Posts
    834

    Default

    I'm not sure if I understand what you need, but I think that you need two dimensions:
    - a dimension with two hierarchies: client, processor
    - another dimension with the shifts (Morning,Evening, Night)

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.