olap pivot

I encountered following problem while performing a comparison activity of executing Excel Macro on OLAP cubes in KYVOS and SSAS, using Analysis Services Driver in Excel. There is significant difference in Excel Macro report execution time between the KYVOS and SSAS cubes. Further investigation...

Hello, I'm very new to VBA so pardon me if I have a glaring mistake somewhere. I am currently trying to activate only one slicer button and deactivate all the other ones based on the slicer's caption. So, basically I would loop through the slicer Items and look for a particular phrase and...

Hello, I have OLAP pivot table and in filters I have options where is more then 200 items and for future there can be more items. I need to hide two of them and the others to make visible. This code make visible the items, but I need to hide them and make the others visible. Could anybody...

Hi all. This is my first ever post on MrExcel. :) So I have a bunch of OLAP cubes in excel which need to be updated regularly. I have a field "Markup Range" in Report Filter which has a lot of values from 0.00 to 99.99. Now I need this Markup Range filtered. I filter out the value "0.00" in...

Hi all. This is my first ever post on MrExcel. :) So I have a bunch of OLAP cubes in excel which need to be updated regularly. I have a field "Markup Range" in Report Filter which has a lot of values from 0.00 to 99.99. Now I need this Markup Range filtered. I filter out the value "0.00" in...

Hello - I have an OLAP pivot. I created a named set for columns using the named set builder in excel. I built the set because I can't easily cross years using an OLAP Pivot because I need to pull different Measures in the columns (messy). Column 1 Dec Prior Year for Measure.Period End...

Hi Guys! Please, i need your help ... I need a code to filter an OLAP Pivot Table based on a value from a cell from another worksheet. On sheet1 cell c6 i insert the name of the city. On sheet2 i have an OLAP Pivot Table which have a filter "city". I would like to have a code which...

In my pivot table that is connected to a SSAS OLAP cube, I have a dimension with several values that are the same, but have two different values defined for the same property. For example, dimension value "ABCD" has a property 1 value of both "123" and "789". As a result of this, the pivot...

Hi I'm trying to get HiddenItemsList to work in my OLAP pivot table I have a list of a few thousand products. First I needed to select the top 500 of these (I got the code to work for this). Now I need to select everything except the top 500 - this is where things have got tricky. My code to...