Friday, October 21, 2011

OBIEE11g Aggregate At

One of the new feature of 11g is the AGGREGATE AT function. It uses the hierarchical level to pin the the aggregate. Problem is you can’t select a hierarchy level in the formula editor, so you have to some old school typing:




Only month 1 to 6 are selected.

Just like the BY statement you can do multiple levels from different Hierarchies:


Till Next Time

1 comment:

Greg said...

Where do you get the values for "Time Heriarchy", etc.? Is that the name of your time dimension in the RPD?

What I'm trying to do is actually force something to aggregate at the "All" or "Total" or "Top" level of a hierarchy.

Is there a way to do that? What is the syntax of the "AT ____" part of the function? Where do the values come from?