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.)
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
The user icon in the upper-right corner of OAC (DV) is displaying more menu options for our non-admin users than we wish to display. We would like to restrict these to only "Profile" and "Sign Out" for regular users. Is there a way to customize these menu items? Especially if we can control this via security, that would be…
What is wrong with this code
Am I missing something or is there no way to search through previous posts to make sure I don't duplicate a question? All I see on the filter options are tags or status… a general search for a word or phrase would be helpful.
We were under the impression that when exporting a visualization in DV to CSV format hidden columns would be include from the grammar panel. This is not happening. See below for a screenshot showing 3 hidden columns that do not appear when exporting the pivot table to CSV. This seems to have worked a month or so back but…
Migrated RPD from obiee12c to OAS 2024. post migration when we try to access dashboards on OAS we are getting below error: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000) State: HY000. Code: 43275. [nQSError: 43275] Message returned from OBIS…
