cube

  1. K

    Get SSAS cube last process time

    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...
  2. 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...
  3. R

    Cube Function connection refresh to SQL Data Model Source

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

    Add Calculated Members in Pivot Table from SSAS OLAP Cube

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

    Refresh Pivots to and OLAP

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

    Dropdown List -2010

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

    Cube Refresh During Macro

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

    Insert cells in 3-D ranges

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

    Updating a pivot table based on selecting a choice in a list

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

    Getpivotdata() with several elements for each field

    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...
  11. 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...
  12. S

    Pivot Table Filter from cell text

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

    Save file as .csv or .txt file??

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

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top