cuberankedmember

Dear Excel gurus, Recently I've build a dashboard to show the performance of our stores. Data has been put in the data model, and I made measures in power pivot (DAX) to measure performance. To dynamically rank my stores in Excel I've used the CubeSet and CubeRankedMember functions in excel...

I have an olap database which I am connecting to and I'm wondering if it is possible to pull back a list of all of the cubemembers beneath a level of hierarchy. So for example, I have a pivot table which is connected to the database. It displays team names as rows. I can expand each team...

Hi this is my first post, I have just started using cubedata and am trying to get some top 10 info based on different measures It needs to be dyanmic by week. What I have works but is incredibly slow is their a more effieicent way to write my query, Otherwise I may have to go back to using the...

Hi As a newbi in using excel cube formulas I have a problem I hope someone could be helping with. Issue: Getting top 5 top- and bottomcount for Customergroup. The count should respect: Selected Company dimension (there are several companies 10-15) Selected invoiceperiod dimension Cubeset...

Imagine you have a db with [user], [customer] and [number of receipts]. Within every receipt you have both a username (cashier) and a customer name. I would like to use cuberankedmember to find top 10 users according to number of receipts where user name is equal to customer name any suggestions?