Categories
- All Categories
- 4 Oracle Analytics Sharing Center
- 9 Oracle Analytics Lounge
- 182 Oracle Analytics News
- 39 Oracle Analytics Videos
- 15.3K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 62 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Rank function before filter obiee 12c

Dears,
Customer Dashboard
Trying to develop a customer dashboard. Need to filter report by customer ID.
But we need to display rank of customer by overall customers. As we are filtering the report
for specific customer ID unable to use rank(income by None). can somebody help to resolve the issue.
Precalculating the rank and store it in the table could be troublesome as everyday 50k records getting added and table has millions of records.
Answers
-
can it be done it obiee
0 -
You don't use a filter for that as it cuts off the data stream. You use Selection Steps and override the member selection with a prompt or a presentation variable:
0 -
This is very good and working fine except the performance is very poor because of huge data set. Can there be a better option which can run better in terms of performance
0 -
Performance is another topic. Please close this one and open a new thread where you provide *precise* information about your data set and its storage.
0