Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: cda compund queries does not preserve orginal sort

  1. #1
    Join Date
    Nov 2008
    Posts
    271

    Default cda compund queries does not preserve orginal sort

    Hi,
    I have two mdx queries in cda and try to join them in a compound query. I expect that the left side join column sorting is preserved in the compound. Instead, a new alphabetical order for the column is presented in cda. This forces me to applying the sorting in postfetch, but I really would like to avoid this computation for performance reason. Is there a different way to solve this issue? And, is this an intended behaviour or is it a bug?

    Many thanks in advance for your replies
    Regards
    Andrea Torre
    twitter: @andtorg

    join the community on ##pentaho - a freenode irc channel

  2. #2
    Join Date
    Nov 2011
    Posts
    1,229

    Default

    This seems to be by design. There's an explicit removal of sorts before the data is fetched. Why is that, I have no clue.
    Pedro Vale
    --
    CTools Product Development
    http://www.webdetails.pt

  3. #3
    Join Date
    Sep 2010
    Posts
    18

    Default

    Quote Originally Posted by Ato View Post
    Hi,
    I have two mdx queries in cda and try to join them in a compound query. I expect that the left side join column sorting is preserved in the compound. Instead, a new alphabetical order for the column is presented in cda. This forces me to applying the sorting in postfetch, but I really would like to avoid this computation for performance reason. Is there a different way to solve this issue? And, is this an intended behaviour or is it a bug?

    Many thanks in advance for your replies
    Regards

    Same problem here. I use Inner join and the same result as you

    I dont know why is this way by design when you need to order keys just to do the join anyways.

Tags for this Thread

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.