viewing an hierarchical dimension with Excel -
07-15-2003
, 08:02 AM
HI,
with Microsoft Analysis Services I have created a cube containing an
hierarchical dimension.
the creation of the cube went fine
when I want to view the cube with Excel and I start drilling down the
dimension I get first the right data, although from a certain level
(level 9) I get wrong data (#N/A values) and the tree-structure also
goes wrong
when I view the cube with another tool (Cognos PowerPlay), I always
get the right data. So, according to me it has something to do with
Excel
Can somebody help me ?
Erik |