Discussion Locked

MS SQL Analysis Service-Excel Interface

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Currently in Excel 2000 I can only use Pivot Tables function to retrieve data from Analysis Service OLAP Cube. However, using this function I have to browse through every member to select what I need. I want to find out whether there is any third party add-in that lets a user to input the member values in an input area in the spreadsheet and the add-ins will retrieve the data accordingly.

2 replies

by dklippert

If placing the "member value" in the page area of a Pivot table is not practical, have you tried recording a macro of your search and then using the resulting code and a Input box to retrieve the data?

by leo-sun

To my understanding, the pivot table does not accept selection criteria inputted in an input area (cells within the spreadsheet).

This discussion is closed to new replies.