Non-Aggregating Hierarchies

#1

One of the requests that we have for our project is to build a calendar
hierarchy that DOES NOT aggregate. Its only to be used for navigation
purposes. I have a hierachy built as follows:

Year
--Qtr
---Month
----Date

In AS2005, there is a attribute property IsAggregatable. I tried to set all
of the IsAggregatable flags to false but I get an error because these
attributes are in a hierarchy. Has anybody done this in 2005 yet?

#2

change this option for the YEAR attribute only.
(not at the dimension level)

"jgb23" <jgb23 (AT) discussions (DOT) microsoft.com> wrote

Quote:

One of the requests that we have for our project is to build a calendar
hierarchy that DOES NOT aggregate. Its only to be used for navigation
purposes. I have a hierachy built as follows:

Year
--Qtr
---Month
----Date

In AS2005, there is a attribute property IsAggregatable. I tried to set
all
of the IsAggregatable flags to false but I get an error because these
attributes are in a hierarchy. Has anybody done this in 2005 yet?

#3

Jeje,

I figured out that using Unaries will work better since there is no
aggregation throughout the whole hierarchy. Thanks for the answer though.

"JÃ©jÃ©" wrote:

Quote:

change this option for the YEAR attribute only.
(not at the dimension level)

"jgb23" <jgb23 (AT) discussions (DOT) microsoft.com> wrote in message
news:4127660D-F140-4F8A-812A-DAD246D215CC (AT) microsoft (DOT) com...
One of the requests that we have for our project is to build a calendar
hierarchy that DOES NOT aggregate. Its only to be used for navigation
purposes. I have a hierachy built as follows:

Year
--Qtr
---Month
----Date

In AS2005, there is a attribute property IsAggregatable. I tried to set
all
of the IsAggregatable flags to false but I get an error because these
attributes are in a hierarchy. Has anybody done this in 2005 yet?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Non-Aggregating Hierarchies

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Non-Aggregating Hierarchies - 08-23-2006 , 02:14 PM

Re: Non-Aggregating Hierarchies - 08-23-2006 , 03:13 PM

Re: Non-Aggregating Hierarchies - 08-23-2006 , 04:03 PM