olap pivot filter

Hi, I'm trying to create a custom group/category (w/o using the "group" feature) in an OLAP Pivot table that has the ability to show the associated group's detail. I have tried Calculated Members and Fields created using MDX but the resulting group/category doesn't show any detail. The two...

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

I'm looking for a way to paste a list of values into a filter search on an OLAP pivot rather than click each value. I saw a way to do this years ago but cannot find it. I saw mention of an add-in, but not sure which one. - Pete

Hello everyone I`m new here and I have no knowledge regarding VBA (none what so ever) so I apologize in advance I would highly appreciate if someone could help me regarding VBA OLAP Pivot Filter for an Array I`ve recorded a macro that looks like this: Sub Team() ' ' Team Macro ' '...

Hi all, I am trying to filter a Pivot Table that has a OLAP source, by multiple ItemId's in the worksheet. The values that I want to filter by is in cell A2 and down. The list of ItemId's that should be visible in the Pivot Table could be anything from 1 to 500 As a small test i wrote the...

Hi all, Thank you for your help ahead of time! Below is my current code. My goal is to filter a very large pivot table (connected to an OLAP Cube) with a user defined keyword. The keyword is entered through a separate userform and stored in variable pdk1. When I run this code I get an overflow...

Hi all, Thanks for your help in advance! I am trying to use a slicer to filter through my OLAP cube pivot table. When I loop through all Slicer Items I get an overflow message so I replaced .Count with .VisibleSlicerItems.Count and now I am getting an "Object doesn't support this property or...

I have a sheet with a set of Olap Pivot tables that I would like to be able to update with the push of a button to the VisibleItemsList in 1 of the cubes. The below code works to grab the name of the Pivot Field if there is only 1 item selected but there are times when we will need to grab more...

I have had posted a similar issue earlier, but it did not solve my problem. Therefore, I try again. My Pivot table gets data from a OLAP Cube. Using the macrorecorder i got this code by setting a new date in the filter and then update the Pivot table. I can manually change the date and it will...

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! yes I know it - there are a lot of questions about this tast on the internet and also here om Mr Excel. but still, i cant get right! - Please help me :confused: I have several pivot tables based on a OLAP Cube (the same cube). What i want is to update to a specific Date (from a Cell) in...

Hi Everybody, I'm glad to join Excel Forum community. I'm a biginner in vba, and I come here to ask for help. Here is my problem : I wish to apply a filter on an Olap Pivot filed. When I use VBA recorder, I got the following : <code> sub Macro1...

Hi I've read a number of posts and I've got part way through on this problem but not all the way. I have a spreadsheet which has a menu page where the user selects a business unit by inputting a value into a cell (using validation dropdown so spelling is correct) I want this cell selection to...

Good day, I am running into run-time error '1004': Application-defined or object-defined error on the line where I try to filter the OLAP Pivot by GrpNm. Does anyone know the solution to this? Sub IdentifySpike() Dim rw As Integer Dim GrpNm As String rw = Selection.Row GrpNm =...