Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel add-in: no drill through
Excel does not natively support drill through to cubes. You have to write custom MDX code in excel and pass it to the olap server and parse through the recordsets that it will return. You can do this with ADO and/or adomd. Unfortunately this is not a trivial thing to do.- pokeyshnj
- Post #2
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
New members of dimension auto added and selected to excel pivot
I have an excel pivot that is linked to to an OLAP cube. We are using both XP and Excel 2003, with AS 2K sp4. (This problem was also occuring in sp3) Say, I have 3 values in a olap dimension located on either the page or row axis today: ABC Company DEF Company XYZ Company I select only 2, ABC...- pokeyshnj
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
