I have an analysis that shows the top 10 customers by rank(Revenue). I would like to create a dashboard where one tile shows the rank for a customer name provided via a presentation variable.
You can use an analysis as filter for another one, if you have an analysis giving you the name of the customer, you can use it as filter for the second analysis with the ranking.
Or, of course, use a prompt (either directly or via a presentation variable) for the job.
Thanks for responding. I must not understand your solution correctly. If I try to filter the RANK calculation for just one customer, I always get a RANK of 1. I want to figure out how to get the correct RANK to be returned for a single customer, much like a VLOOKUP would do in Excel.
You maybe aren't really looking for the equivalent of VLOOKUP...
You have dashboard page, this means that you can have multiple analysis in it and therefore not a real need to get a value into another one.
So the question is more about how to get the RANK of a given customer without having all the customers in the analysis, right?
Because as you saw the RANK works, by default, on the set of rows. Which means that if you filter for the customer directly the RANK is going to be 1 because you have only 1 row. OBIEE will always filter on the customer too early, making RANK work only on a single row.
This is why you must use Selection Steps instead of filter in your analysis (Selection Steps is like post-aggregation filters and other manipulations, while filters are pre-aggregation).
In this screenshot I did just that, starting with all the products ("P1 Product") without any filter, and then in Selection Steps I add a 2nd step to keep only one product. I did select one manually (I don't have a variable set), but you see at the bottom of the window that you can override the manual selection with a variable.
I've never been taught what selection steps could be used for. Very cool. What you suggested works perfectly for the hard coded value. But, attempting to use a Presentation Variable will change the company name, but I'm back to RANK = 1. Here is the Step I set up:
If I run the analysis on it's own, I get the correct response for the hard coded value:
However, embedding that analysis on a dashboard, controlled by a prompt with a presentation variable, I get this:
Prompting for a different company, I get the same results. Name is correct but not the rank.
Sorry to be so dense, but I must be missing a step.
Could you look at the logs for the 2 situations? (the one with 32 and the one with 1)
Because in theory it should work, in practice it could depends on other things as well. But here it also goes into the used model etc., and only you have this model.
Also what about the exact product name, version and bundle patch? Is it recent and fully patched? If it isn't the case, it is maybe a bug which has been fixed.
Thanks for your help on this. Your solution would work if OBIEE would cooperate! I've passed this issue to our tech folks to see if they can resolve it. (Or apply a bug fix.)
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (ERP). The session will cover updates on Finance, Projects, and Procurement. Presented by: Ashlesh Bajpai - Vice President, Product Management, Fusion Data Intelligence Shobana…
Good day, please kindly assist. We are creating a graph to calculate the number of assets per milestones. However, the planners have only populated assets for only one milestone from the list of milestones the customer wants to track. Which gives an incorrect view as the project moves past different milestones that it has…
I scheduled the report in OTBI and the agent was run successfully. However, I do not receive the report after the run in my inbox. The addresses are properly recorded, and the report is in an excel format and saved as a pivot table in otbi. What can be the cause?
Anyone has any idea why the OAC documentation on custom viz is not available now? I was able to access till last week - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/build-package-extension.html. Does this mean OAC doesnt support custom viz or custom workbook extensions?
I made a parameter with letter range values… put it into a dashboard filter. Then I created an expression filter to bind it to my last name column in the table with the image I uploaded here. I am getting the following error??? Invalid Expression. Validation of parameter values failed. A general error has occurred. Message…
Does Oracle Analytics Server 2026 include AI features such as a built-in chatbot or AI Assistant? If not, are there any plans or indications that these AI capabilities will be introduced in a future OAS release?
