cube

Hi there. I have a cube that delivers data via a connection to a pivot table. The data looks something like this: Country1 name | Country1 Total 1 | Country1 Total 2 | Country1 Total 3 | Country1 Grand Total Sub-item X | Sub-item X1 ttl | Sub-item X2 ttl | Sub-item X3 ttl | Sub-item...

In excel I make an Analysis Services connection to a data cube and create pivot tables, charts, and whatnot. I would like to be able to show a user how current this data is by showing them when the last cube processing time occurred. Making an analysis services connection to the cube in SQL...

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

Cube Function connection refresh to SQL Data Model Source Creating a PowerPivot table connected to a SQL data source is relatively simple and straight forward. CUBE functions are the next step in creating data presentations. However, there's an issue I discovered that don't know how to...

Hi, I use Excel to query a SSAS OLAP Cube, the return of which I then model into various outputs. I do not have access to amend the cube. I am hoping it is possible to be able to add custom calculated members to some dimensions in excel rather than on the server, but I'm struggling to find...

Hi All, Hopefully there is a simple solution, maybe just a check if nothing is changed on the pivot... (?) The simple code below refreshes several pivot tables, which are linked to an OLAP Cube. I would like to add a piece of code in, so that if the User doesn’t have access to the OLAP Cube...

I am converting an excel 2003 file to excel 2010, which requires changing the cube functions. In 2003, the dropdown list was created using the ReportBuilderAddin function, which is linked to the cube. So, no macros and no defined names. What is the equivalent in excel 2010? Thanks.

Hi All, I've got an issue where I'm trying to get sales from our Sales Cube & Stock Cube to automatically update. Using the CUBEMEMBER & CUBEVALUE formulas I can reproduce the original Pivot table and it will fetch the data. My problem is as follows. The CUBEVALUE & CUBEMEMBER formulas will...

I have a workbook for tracking my billing. In the Totals sheet, I have 3-D ranges to total all the billing per day across each sheet (client). When I insert rows to a particular client's sheet for a given day (to accommodate multiple billing items), the 3-D range does not update to include...

Hello, I was wondering if it's possible to update a filter in a pivot table (with source information coming from an OLAP cube) simply by selecting a choice in a drop down list that is identical to the choices you can filter by. I know that it is possible to filter a pivot table that has it's...

I have some excel pivottable connected to a cube. The data are further used in excel by the getpivotdata() formula. In the example below I have combined two getpivotdata() formulas to calculate the Budget variance. As you see the only difference of the "budget" and the "actuals" are the last...

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

I am using an Excel 2003 Pivot Table to browse an OLAP cube that I’ve created. I would like to add User Name as a filter (page field). The cube has so many User Name records that when I try to use the filter functionality it takes way too long plus it’s difficult to navigate. I would like to...

Hello, I was wondering if you knew a way I could save an excel file as a .csv or .txt file? Unfortunately, my excel file is on multiple tabs (125,000 lines). I'm ultimately trying to save this multiple tab file as a .csv or .txt so I can create an OLAP cube so that I can create a pivot...