Categories
- All Categories
- Oracle Analytics Learning Hub
- 19 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 232 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 86 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Aggregate formula
Summary
Aggregate formula
Content
Hi all,
I am not sure what i do wrong using aggregate at formula. Perhaps i do not understand its purpose.
if I enter Total revenue as a measure into the formula below and product family as dimension, i get an error.
How can i enter this calculation correctly?
Regards
Answers
-
Hi There,
The AGGREGATE AT function will work only with hierarchical column, refer to below mentioned blog explaining more on same:
https://gerardnico.com/wiki/dat/obiee/obis/aggregate_atPlease also refer to oracle document on function "AGGREGATE AT"
Thanks and Regards,
Syed Hamd Salman0 -
If you want to control aggregation, we recommend use of “aggregation method” in the viz properties. While calcs can be used, the viz properties are the recommended approach.
0 -
Good links, I will keep it for future.
0 -
Thanks Adam
You advice fixes the problem.
However, i am trying to make to work the aggregate function located in the calculation console but i can not figure out why it does work
0
