cubevalue

Hey all, I have tried to the following CUBE formulas in order to get a value based on results from two columns within a dataset inside Power Pivot, however they all return blank. =CUBEVALUE("ThisWorkbookDataModel","[Measures].[Path PP Plan Yes]", "[Path].[Pathway Plan].No", "[Service...

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

I brought in a table and loaded it to data model. I created a pivot and then used OLAP tools to convert it to Cube formulas (allowing me to insert columns, etc where a pivot table won't let you). My problem arises when I bring in the next month's data. I've written the formula that hould work...

I have an interesting one here. I'm looking to try and substitute the text from a cell into the measures portion of a CubeValue formula in Excel. The CubeValue references data from a related sheet in PowerPivot and I'm bringing over multiple columns of numbers so it would make life easier if I...

Hi, Aside from going to the ribbon Formulas > Calculations Options and ticking manual is there any other way to disable a cubevalue formula updating unless commanded to update?

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

I have =CUBEVALUE() functions referencing twenty Lists created with Data Validation (Bolded below). =CUBEVALUE("ThisWorkbookDataModel",$B$2,$B$3,$B$4,$B$5,$B$6,$B$7,$E$2,$E$3,$E$4,$E$5,$H$2,$H$3,$H$4,$K$2,$K$3,$K$4,$K$5,$N$2,$N$3,$H$7,$A$1,$A12,B$11) The limitation is that only one value per...

I have a CubeValue Formula that is giving me a very perplexing result. I am trying to pull data for a group of sales items (only 2). When I run the cubevalue formula for each item individually, I get a result, but when I point the CubeValue formula to a named cubeset, I get a #Value ! result...

I have a CUBEVALUE function that works fine for providing a total cost measure for items shipped from a warehouse (Phoenix in the sample below) in a dashboard. Simplified version is: =CUBEVALUE("ThisWorkbookDataModel","[Daily].[Warehouse].[Phoenix]","[Measures].[Total Cost]") However I would...

Hi I’m looking for VBA code to turn off the screen refreshing on key values in cube functions. I have a large Excel spreadsheet with many tabs and it takes 20 minutes for the system to refresh the information from our SQL Server database. I was thinking if I turn off the screen refreshing of the...

Hi I would like to know how to remove a specific reference to a location in a CUBEVALUE formula and have it reference a cell for the location #. Below is my formula and it references location 9000 and I would like it to refer to whatever is in cell C6...

Hi I have written a CUBEVALUE function and it works fine selecting the month from the slicer. But the issue I now have is that i want the month to date sales. But I dont want to have my staff toggle the month. How can I have it just displace this months values. And when we roll into the next...

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 slicer attached to a PowerPivot pivot table that filters for a field called Project_Code. I need to display another field (Project_Text) above the pivot table, that is associated with whichever Project_Code is selected. So, I wrote a measure to be sure that I only return a value...

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

Hi All, I've been trying to find a way to have my macro wait until after my data has refreshed to continue. I'm using Excel 2010. I have combined our Sales Cube & Stock Cube into a PivotTable and then converted the PT into formulas. I need to do this so that I can minimize the amount of data...

Hi, I wonder if it is possible to connecting PowerPivot data from another Excel file? I have a file DATA.xlsx which contains loads of PowerPivot data. Then I have a file for reporting (REPORT.xlsx). In this file I would like to grab values from the PowerPivot model in DATA.xlsx with using cube...

I'm not sure if this is possible, but does anyone have any recommendations on how to improve calculation speed of cube functions? I have a workbook which builds a report and thus has a lot of cells which are basically just cubevalue functions. It takes on average 5 minutes if I make a change...