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 >
> 
> 
CubeRankedMember MDX in Excel

Respondida CubeRankedMember MDX in Excel

  • Saturday, August 11, 2012 1:31 AM
     
     
    Sign In to Vote
    0

    Hi -- The following code works great in excel:

    CUBESET(“PowerPivot Data”,”TopCount(([Combined_Data].[Month].[January],[Combined_Data].[Company Name].children),10,[Measures].[Sum of Prod Rev c])”,”TOP 10 companies”)

    However, in excel if I have to replace children in the above statement and give reference to the CELL which has multiple Children ("(Multiple Items)") selected, how can I do that?

    Thanks

    Krish

     

All Replies

  • Tuesday, September 04, 2012 2:59 PM
     
     Answered
    Sign In to Vote
    0

    Hi Krish,

    you can use CUBESET as well. If your filter with multiple items is in cell B2 (for example), put in the cell C2

    CUBESET("PERFORM CPG Demo";B2)

    after,  your formula should be

    CUBESET(“PowerPivot Data”,”TopCount(([Combined_Data].[Month].[January],$C$2),10,[Measures].[Sum of Prod Rev c])”,”TOP 10 companies”)

    HTH

    Bye

    Norman

    Norman