cubemember

  1. M

    PowerPivot report - getting multiple filter values and calculating prior year data

    Thanks in advance! I'm creating a PowerPivot based report in Excel 365. I'm reporting actual quarterly sales data, performance against plan, and performance against prior year. There is a calendar table that links to the data table. I'm deriving prior year quarter by taking the value of the...
  2. C

    CUBEVALUE

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

    Excel OLAP cube formulas

    I have created an Excel user form that incorporates locked fields that populate with customer information from a SQL server by way of OLAP CUBEVALUE formulas. It works great, however I have run into a problem b/c I have other CUBEMEMBER information that I need to display per user selection...
  4. D

    CUBEMEMBER Solution Needed - showing a result that's not in the data

    I'm working on a CUBEMEMBER string and it always returns me the last value regardless of whether that value is in the table or not. here's the actual text. =CUBEMEMBER("ThisWorkbookDataModel",{"[Program Entry].[PROGRAM KEY].&[PROGRAM KEY DESCRIPTION]","[Program Entry].[PLANNER...
  5. O

    PowerPivot, have ID, want to display name - CUBEMEMBER & CUBEMEMBERPROPERTY & GETPIVOTDATA won't work.

    This should be simple, but I've fought it for DAYS. HELP! Excel 2010. PowerPivot with 3 tables. A few PowerPivot pivot's are in my Excel sheet. On a regular sheet, in a regular cell, in A1 I want to enter a customer ID. In A2, I want to display the customer's name. I can get measures &...
  6. D

    Wait for Cube Values to return data before continuing macro

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

    =CUBEMEMBER Function

    Hello, I am wondering if someone can help me. I created a pivot table and then converted the pivot table to be formula based. I am trying to create a YTD report based on the years 2008 and 2009. Is it possible to modify the CUBEMEMBER function for each YTD column? i.e. =CUBEMEMBER("Invoice...

Watch MrExcel Video

This Week's Hot Topics

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?

Disable AdBlock

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
Top