cubeset

I use a CUBESET formula combined with CUBERANKEDMEMBER to generate a list of, say, brands with several filters which users can select from cells in the excel worksheet. One of these in the CUBESET is a date range. I also want to use this date range in the sort_by argument part of the CUBESET...

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

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

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

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

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

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]}...

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

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

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

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

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

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

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

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

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

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

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

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