Dsyasani on 06 Mar 2018 04:58:31
Excel Grouping Functions is not available in Analyze in Excel, According to MSFT Analyze in Excel is a read only connection and For grouping, Excel need to call CREATE SESSION CUBE statement and read only connection doesn't support this MDX statement(Create Session Cube). But without Excel Grouping functions we lose critical functionality on excel based reports. We need this Grouping/ungrouping to be enabled on Analyze in Excel.