Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
Note: Forums will be making significant UX changes to address key usability improvements surrounding search, discoverability and navigation. To learn more about these changes please visit the announcement which can be found HERE.
SQL Server Developer Center >
> 
> 
Why SSAS perform 'order by' operation when process a cube?

Answered Why SSAS perform 'order by' operation when process a cube?

  • Saturday, August 04, 2012 9:22 AM
     
     
    Sign In to Vote
    0

    When I process a cube, SSAS 2008 R2 retrieves data from Oracle data source and automatically perform 'order by' clause.

    How to avoid this?

     

All Replies

  • Saturday, August 04, 2012 10:39 AM
     
     Answered
    Sign In to Vote
    0

    Hello,

    It depends on the measure types you are using, if SSAS performs an order. If you e.g. have a DISTINCTCOUNT the SSAS do an order to get the data in a sorted order. 

    Olaf Helper
    * cogito ergo sum * errare humanum est * quote erat demonstrandum *
    Wenn ich denke, ist das ein Fehler und das beweise ich täglich
    Blog Xing