# cubeset

1. ### CUBE formula to only include blanks

Hi all, I am having trouble with picking out only blank values in my CUBE formula. Hope someone can help? =CUBEVALUE("ThisWorkbookDataModel","[Measure].[Assessment a.exceeds 45 days]","[Assessment].[Step End Date].["&""&"],"[Service Area].["&A16&"]") Section in bold is where i wish to enter...
2. ### Cubeset (Date Range) - Members that don't exist

Hi Guys, I've got a question regarding the CUBESET Function. =CUBEVALUE("ThisWorkbookDataModel","[Measures].[Sum of Sales Price Ex Tax]","[Orders].[CON Flag].&[1]",CUBESET("ThisWorkbookDataModel","[Orders].[Created Date].&["&\$Q\$2&"]:[Orders].[Created Date].&["&\$R\$2&"]")) This is my current...
3. ### Cubeset with reference to cell with a cubeset

Hi All I would like to ask for help with the below query: In my Excel sheet I have some calculations using cubesets and cubevalues etc Cubeset1 =CUBESET("my Connection","{ FILTER( { FILTER( { DESCENDANTS( [Location].[Location].[All Locations], [Location].[Location].[Store] ) }, ( [Time].[Time...
4. ### Accessing NativeTimeline using Cube functions

Hi, Firstly, apologies I am not an advanced Excel user, so please excuse any obvious gaps in knowledge. Essentially, I am using a TimeLine to select a month that adjusts Pivot table information - easy enough! However, I need to extract the month selected in order to apply to a simple...
5. ### cubeset with condition

Good Day Please can I get help with the following query I have the following cubeset formula and I would like to add a condition but cannot get it to work: below is the formula: =CUBESET("DD_MA","{ ORDER( { { { [Product].[Product].[Womens]} * {[Location].[UDA Brand].[All UDA...
6. ### Cubeset with condition

Good Day Please can I get help with the following query I have the following cubeset formula and I would like to add a condition but cannot get it to work: below is the formula: =CUBESET("DD_MA","{ ORDER( { { { [Product].[Product].[Womens]} * {[Location].[UDA Brand].[All UDA Brand].[Brand1]}...
7. ### cubeset and cubemember functions

This worked: =CUBEVALUE("ThisWorkbookDataModel","[Measures].[Sum of newrev]","[public dates_d].[moy].["&M\$22&"]","[model].[type].&[Technology]", CUBESET( "ThisWorkbookDataModel",( D24, D25) ) ) where d24 and d25 are cubemember functions. Pasting them in didn't work...
8. ### Error: CUBEVALUE Function returns #NUM!

Summary: I'm using excel 2010 with powerpivot add-in. I have constructured a powerpivot with calculated measures. The pivot table is in a worksheet and I can see all the values that I need. I would like to extract specific data from this pivot to make a more complex report. I'm able to...
9. ### Dynamically Rank Stores - Cubeset, CubeRankedMember (works 99,9%, who helps me with the 0,01%)?

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...
10. ### CUBESET for slicer values returning NA

Excel 2013 I have a slicer of vendor names connected to a pivot table, and I use the =CUBESET("ThisWorkbookDataModel",Slicer_Vendor_Name,"Vendor Name") format to return the slicer selections. There are 6 slicers going against this particular pivot table (if that matters). I'm using the...
11. ### Consult a cubemember with another cubemember filter

Hi, I have a table that has, among other information, three that I use most: OC nº Suplier Value 1111 abc 20,00 1112 def 40,00 1113 ghi 60,00 With powerpivot...
12. ### Slicer and Cube Formula Errors

Hello, I searched the forums but haven't seen this issue yet... When using cube formulas that are driven by measures and cubesets driven by formulas, I receive the #N/A error when I deselect from a slicer. This is generated because the cubeset formula for that slicer throws an #N/A... Has...
13. ### CUBESET formulas with several slicers/filters

Hi, I use the CUBESET formula to rank data ("Query") descending by a certain measure ("PIO"), using this formula: =CUBESET("ThisWorkbookDataModel","[Data].[Query].children","Name",2,"[Measures].[PIO]") Now I know if I want to filter data for only one specific country, I can add it as so...
14. ### Cubemember and Cubeset problem

Hello, I am entering the world of cube formulas and I am running into a problem that I haven’t seen a solution to. I have a dataset that has 20 names in it that can be further split into 3 groups: A,B,and C. My problem is displaying the names in a single row that belong to one of groups. For...
15. ### CUBESET and CUBERANKEDMEMBER help

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...
16. ### Dynamic Cube Set Really Slow

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...
17. L

### What is _xlfn.CUBESET?

I have a fairly complex (for me!) Excel 2013 spreadsheet using Power Query and Power Pivot to pull information from various SharePoint Lists, CSV files and OData feeds from other Excel spreadsheets to provide Actual vs Budget on the Maintenance Costs of the houses we have. (We are a Charity...
18. ### Timeline Slicer in values

hello all - what i am trying to do is take the values from a timeline slicer and use them in an IF statement. the formula would look somnthing like this in excel =if((Date)=(Slicer_Datekey),True,False) the slicer_datekey could contain multiple dates. any ideas on how i would approach this? thanks
19. ### Excel Date Filtered Cubeset Issue when using as cubevalue slicer with PY measures

In Excel 2010 I am using the following cubeset to return a targeted list of customers. =CUBESET("MyCube", "Filter({[Date].[Date].[All].[2014]}* {[Territory].[Territory Name].[All].[California]}*{[Customer].[Customer ID].Children},([Measures].[Targeted])>= 1)","Cube Set") This works fine...
20. ### cubeset / cuberanked member

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?

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back