Rank function before filter obiee 12c

Question

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.

[Deleted User] · Answer

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.

Sunny86 · Answer

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

[Deleted User] · Answer

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: