Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Aggregate function using 'BY'

I'm able to do 'aggregation group by' from answers using below syntax,
Max("Date of manufacture" BY "Lot Number") -- Works perfect from answers. i wanted to implement same in RPD to allow user to make use of this column for ad-hoc reporting.
But the word "BY" is not a key word and admin tool is not recognising the above syntax.
Please suggest an alternate solution for this.
Answers
-
In the RPD you can set the aggregation to MAX on the logical measure and then by setting the correct content level force the "by" or let it free based on the analysis the users build.
0