Hi all,

I've created a data cube in Microsoft Analysis Services with a time
dimension so you can select the year, month and day of data to view.

My problem is that I only want the aggregate data to be visible at day
level.

Just to clarrify, I am holding the stock on hand values by day in a
cube. Adding this up over more than one day yields incorrect figures
because it's adding up how many lollipops I had yesterday with how many
lollipops I have on hand today.

What do I do so that it only shows you totals when you drill down to
'day' view?

Any help would be much appreciated.

Thanks guys.

Tony

AS2K: set the Aggregation Usage property on the dimension to be "custom" and
then you can go into level-by-level and enable/disable. Or you could set
top-only / bottom-only. See BOL. The only issue that you may run into is
that because of the 1/3 rule, the aggregation design wizard won't consider
all possible aggregates -- only those it considers useful. See the write-up
in the beginning sections of the AS Performance Guide on this matter.
http://www.microsoft.com/technet/pro.../ansvcspg.mspx

Or is this AS2K5, in which case, the answers and procedures are very
different because AS2K5 is an attribute-based system; not a hierarchy-based
system like AS2K.

Hope that helps.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


<anasttin (AT) excite (DOT) com> wrote

Hi Dave,

Really appreciate your help but I couldn't find "Aggregation Usage"
property anywhere. Do you mean "Custom Rollup"?

A couple of other complexities I may not have mentioned too.. The time
dimension is a shared dimension and I also have other dimensions that I
only want to show the data of when a single day is viewed and blanks
otherwise.

Am I asking for the impossible?

Also, what do you mean by "see BOL"?

Thanks again.


Dave Wickert [MSFT] wrote:

this option is available on the cube only.
after you have added the dimension in the cube, look at the property of the
dimension
you'll found aggregation informations.

but what you want is to display only the day level.
so you have to hide year and month levels in your cube.
(visible = false)

<anasttin (AT) excite (DOT) com> wrote