Okay this question will actually be multiple questions in one.
I'm trying to generate a visual in Primavera Analytics (which uses the OBIEE software as a basis).
It's a cloud implementation and I have no way of changing the Datamodel so I'd like to solve it with the Reporting Programs abilities only.
Now for one graph I want the user to input which project he would like to see a graph like below Picture:
The easiest way would be to prompt the user for the Proj_ID (eg. 545). However, the user has absolutely no Idea which values correspond to which project. So giving them a dropdown with [91,246,545] will be absolutely pointless.
What would be better is to give them a list of Proj_Names [Project X-VS0, Project X-VS1, Project X-VS2, Project Zepplin-November,...] and then use the corresponding Proj_ID as a filter However:
- Is it possible to store not the prompted field but a different one (Prompting Proj_Name, but storing Proj_ID)?
- I guess It IS possible to do a two-way prompt (asking user to select Project Name, then in a next page ask for a Proj_ID where it is already filtered and so only 1 value is in the dropdown storing that value once the user selects it).But this is a process I would rather not follow.
- Is it possible to do a "lookup calculation" in the filter of an analysis (e.g. "WHERE Proj_ID=(Select Proj_ID FROM "Table" WHERE Proj_Name = @{varProjectSelected} LIMIT 1)")
Thanks in advance!
Matthias