Help Needed: Pivot Expand/Collapse Buttons Not Showing For 2 Cubes

5

578117

I very much need an answer to my post on 9/30. We have Excel guys pointing
fingers at cube guys and cube guys pointing fingers at Excel guys. All of
our cubes produce the expand/collapse buttons for all dimensions when pulled
into an Excel pivot, except 2 cubes don't. Need to know why? Is it an
Excel setting, or a cube setting? It appears that Excel pivots default that
"show expand/collapse" checkbox to "on". It would be very nice to know what
tells that Excel checkbox to flip to "off" when pointing a pivot at an OLAP
cube...something is detected. All help welcomed!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Expand Collapse not showing for Cube 2
Expanding/Collapse pivot table rows from Analysis Server cube 0
Alternatives to MS Query for Pivot Tables & Cubes 0
Affect a new connection to a pivot table 0
Collapse/Expand Buttons in a Pivot Table 0
Excel pivot tables and SSAS 2
Cell formatting in Excel Pivot Diagram 0
Data Cubes and Pivot Tables 0

Top