Categories
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