Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Excel 2007 - Cube slice

1 view
Skip to first unread message

Antoon

unread,
Dec 23, 2009, 5:50:04 AM12/23/09
to
Let's take a simple example.

In Excel 2007 I connect to a cube and create a pivot table with a
time-hierarchy on columns and one measure.
Now when I filter the time hierarchy to f.e. "2009" and "2009 Q1" and "2009
January", I get three columns with the same value for the measure.

This is not what I would expect from a cube. I would expect to get three
different values one for "2009 january" one for "2009 Q1" and one for the
whole year "2009".

Is there a way to achieve the desired result in excel ?

Regards
Antoon

Classiarius

unread,
Dec 23, 2009, 8:53:56 AM12/23/09
to

Most often I've seen this is a result of a problem with dimension
design. I'd highly recommend the "BIDS Helper" add-in from CodePlex
and then you can run, in addition to many other things, a dimension
health check. Your time dimension and/or hierarchy likely needs work.

0 new messages