Not able pass the array items to the pivot table in excel which is connected to SSAS cube. RRS feed

  • Question

  • Hi,

    I have a pivot table in excel, the data in pivot table is imported from SSAS cube.

    I will query the data from SQL view and store the data in an array using VBA.

    The data in the SQL view and Data in Array will match. Now I will pass this array items to pivot table for filtering the data. The Code for that is;


    Sheets("Pt_Table3").PivotTables("PivotTable4").CubeFields("[Year].[Year]") .EnableMultiplePageItems =True

    Sheets("Pt_Table3").PivotTables("PivotTable4").PivotFields( "[Year].[Year].[Year]").VisibleItemsList = arrYears()

    I don’t get any errors but the array what I have is not been filtered in the pivot table. What could be the problem? Is there any alternative method to do this?

    Please provide your suggestions and help me to solve this.

    Thanks in advance.

    Friday, August 17, 2012 11:22 AM