Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 281 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 105 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Display static result based on dynamic data
I am not sure if the subject make sense but here is what I am trying to accomplished.
I created an analysis showing ranking data for example
| Name | Sales % | Ranking |
|---|---|---|
| John | 90% | 1 |
| Peter | 80% | 2 |
| Joe | 70% | 3 |
But then I want when Joe logs in and run this analysis to see ONLY his record and see that he is #3
Or create another analysis that can be based on this but again to show only the log in user record and no one else but then show his record based on everyone else, in this case Joe would be # 3, Peter # 2 etc
Thanks
Joe
Answers
-
Just taking a stab at this. You could create a session variable first to capture the user login. Then create a union report and choose 'intersect' as the set operation. Both reports are same except for, in the first report for the 'Sales%' measure use the 'filter using dim' option and filter the 'Sales%' measure using the User dimension (value captured by session variable). This hopefully does it.
Sorry if it is a dumb idea.
0 -
If you had a snapshot of the rankings at regular intervals it would be a simple case of row-level filtering and not having to worry about a dynamic ranking. To boot, you'd get the ability to show snapshot-over-snapshot increase/decrease in the rankings ...
0