olap

The data I get from Corporate comes in as an OLAP PivotTable. Some of the Dimensions(Text Fields) have Properties associated with them. For example a Project has a "Project Name" and "Project Manager" property. In the PivotTable tools /Options ribbon there is an OLAP Tools drop down for Property...

I have the code below that I got from another thread hear. It works great but I want to change my array. Currently I have to list each account number. Can I make it so that my array is linked to a name range. My name range can look like either of the Below. I want to filter my cube data in the...

Hi all I have a pivot table with data from an OLAP connection. It usually works fine. Today though all values were 0 after updating data. Waiting for a bit to make sure the underlying data was processed I updated again to no avail. I spent a lot of time and finally found that if I went to one...

Here is the situation. I'm trying to record the filter settings of an OLAP based pivot table. I plan to switch sources to a different OLAP in a different program (but containing the same data) and then rebuild the pivot with new pivotfield and pivot item names. I have setting the fields done...

Hi - bit of background. I'm trying to set up an OLAP cube via VBA to update 2 tables - one is for the current month, and the other is for all history UP THROUGH last month. For example, if the selection is March 2015, I want one to pull everything in March, and the other to pull everything...

Hello, I've managed to filter OLAP Pivots before if the CurrentFieldName was one option. Now, I have a range of dates that cannot be selected using the between function because the OLAP Cube isn't set up that way. I've set up a date table in my workbook that has all the possible dates between a...

Need help using this Excel 2013 feature. Under the pivot table tools, using OLAP tools I can convert my regular pivot table into formulas. This allows me to insert colums, do formulas and so on..... My dificulty is that when there is new data on the source table (a new row), this new data (or...

Hi there, Would anyone know how to allow users to adjust a filter for a pivot table (external data source - OLAP cube) on a protected sheet? When I try to change the filter I get the following error: That command cannot be performed on a protected sheet because the source for this PivotTable...

Hi there, I have created a set of reports containing cube functions (reports are connected to OLAP). What I need is for my code to continue executing as soon as the OLAP connection refresh has finished. Now, the code carries on whilst the refresh is still happening.. This results in reports...

Dear colleagues, I have a macro that loops through and updates reports that include cube formulas (OLAP). The problem is that my VBA code just would not wait for cube functions to refresh and calculate. I spent a good few hours searching web to find that...

So creating the PivotTable connections under Slicer Tools is easy enough. The problem I am having is that my PivotTables pull data from an OLAP data source, and the pivot tables themselves are using Grouped fields. Now, as Microsoft notes on one of their support sites, "Slicers can only be...

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

Hello, Not entirely sure if this is possible... I'd like to somehow get a count of how many locations each player has scored 5 or more points in, details below. Basically there is an Olap cube set up which I do not have access to change. As a simplified example the data that I have is set...

Hi, We are experiencing intermittent transport errors when connecting to a SSAS cube from pivot tables within excel. I'm wondering if anyone has experienced this and has a solution. Details: Excel 2010, SP1 Version 14.0.6112.5000 MS SQL Server 2008 R2, SSAS version 10.50.1600.1 Connection...

Hello, Is it possible to create a named set in MDX with OLAP data that contains a subtotal? So if I have a field now called "ID" and I know that some of the IDs are in group 1 and some are in group 2, I know I can create a named set to just show group 1 - it would involve the visualtotals...

Hello, I'm using Excel 2010 with an OLAP cube and I need some help with named sets via MDX. Is it possible to create a named set which basically groups and subtotals data? So if I have 10 employees and they are equally divided in 2 states is it possible to create a named set which is like...

Hello, I'm on Excel 2007, Windows 7 Issue: I have about 35 pivot tables in one workbook, about 4 per sheet (fyi this is not by my choice). I need to point all the Pivot Tables connections to the same shortcut on my computer which itself in turn points to the OLAP in the company's network...

hi gurus; i was going to ask how to set a pivot table filter for over 4500 items, but instead of asking that, i went ahead and recorded a macro that almost did what i needed, except not 4500 times! My Marco generator efforts yieded this; Sub SetAmSurgProcCodes() ' ' SetAmSurgProcCodes Macro '...

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