Hi,
I am using OBIEE version 12.1.
I have created Analysis 1 with a sort order based on column x
I have created Analysis 2 and would like to set the sort order based on Analysis 1 results
Is that possible to achieve or is there a better work around?
Why don't you just add column x in Analysis 2 as hidden column?
If you have column x in Analysis 1 and few others columns that are shared between Analysis 1 and Analysis 2 (or it would be impossible to sort the way you ask) column x can perfectly exist in Analysis 2 as well...
Because there is no way to say "please sort based on another analysis", so your only option is to reproduce the sort condition in Analysis 2 like you did in Analysis 1.
Both analysis contain different columns and criteria, I can add column x in analysis 2 however the requirement is to sort the order in Analysis 2 by the rank order in Analysis 1
The sort order in Analysis 2 should be based on rank order in Analysis 1
Is that possible to acheive
???
If the two reports are completely different, how could you ever sort one the same as the other? You must have some commonality...
Can you please be a bit more specific about what you mean by basing the sort order on another report column, can't you just duplicate the sort order, alpha ascending etc ?
Richard Chan
Neodata Australia
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
What am I doing wrong here? There is only one selection in the Target Canvas??
In BIP. I was able to group tables. Is this possible in OAC
I creates a parameter "Role Name" and then I put the Role name field in the filter and made a bind to the parameter, When I add the value in the parameter, it works. When I delete it from the parameter it give me <empty> How do I get rid of the <empty>
Hi, all, I have been struggling with connecting to Teradata in OBIEE Admin tool. I can't import Metadata to the RPD that exists. I am not sure about if it is due to my config of ODBC Teradata is incorrect or anything else? Please find the following errors as attached: Many thanks for your help!
Hi Team, Has anyone upgrade OAS system from the 2024 to 2026 version? if yes, could you please share the resposne files. Regards, Chand