Excel drill-down pivot table

Excel drill-down pivot table

Post by bWFsa2 » Wed, 02 Nov 2005 08:18:11


Hi,

I have a cube that I created in AS2005, I have a hierarchy defined. When I
create a pivot table based on that cube, I can not drill down to the next
level. My hierarchy is based on Dimension Facility. Facility State is root
level, facility zip is next level. I know I can't drill-through in excel, but
I should be able to drill-down easily. Can anyone lend a hand?
thanks!


--------------------------------------------------------------------------------
Mg
 
 
 

Excel drill-down pivot table

Post by Denny Le » Thu, 03 Nov 2005 02:27:13

Which version of pivot are you using - Office Web Components 11, Excel 2003,
etc? When you create a dimension, you will automatically create attributes
(Facility State, Facility Zip) and often you will need to create a hierarchy
as well (Hierarchy) for your dimension of "Dimension Facility". If you are
using OWC 11 and Excel 2003, you will be able to see the Hierarchy
hierarchy, Facility State attribute, and Facility Zip attribute but you can
only drill down the Hierarchy hierarchy (the advantage now is that you can
cross join the Facility State and Facility Zip attributes which you could
not do in AS2k). But if you're using an older OWC or Excel client, the
pivot may not be able to see all of the options (just the dimension) and
hence your problems with drilling down (as it most likely is choosing an
attribute instead of the hierarchy).

--
HTH!
Denny Lee
<dennyglee_at_hotmail_dot_com>

Blog at:: http://www.yqcomputer.com/

 
 
 

Excel drill-down pivot table

Post by bWFsa2 » Thu, 03 Nov 2005 07:01:02

Thank you Denny Lee for answering, I appreciate it so very much!!!!!
YOU ARE CORRECT!! THAT WAS IT ---RIGHT ON!!
I CAN'T TELL YOU HOW MUCH THIS MEANS TO ME!!!!!!!!!!!

THANK YOU - THANK YOU - THANK YOU - THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
; ) ; )
 
 
 

Excel drill-down pivot table

Post by Denny Le » Sat, 05 Nov 2005 04:04:03

No problem at all :-)

--
HTH!
Denny Lee
<dennyglee_at_hotmail_dot_com>

Blog at:: http://www.yqcomputer.com/