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…
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 Team, Has anyone upgrade OAS system from the 2024 to 2026 version? if yes, could you please share the resposne files. Regards, Chand
We need to download a report with the order number as the file name. In the main report, we have a data action (hyperlink) on each order number. When we click an order number, the linked report is downloaded with the corresponding order details. Currently, the file is downloaded using the report name. We need to download…
I tried the following expression and it blows up when I select more that one value in the list see image
