Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 213 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations 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