+ Reply to Thread
Results 1 to 1 of 1

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

  1. #1
    Registered User
    Join Date
    08-17-2012
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    1

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

    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;


    Please Login or Register  to view this content.

    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.
    Last edited by arlu1201; 08-29-2012 at 01:14 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1