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
Do you know if connections that do not use TLS will be affected by the September 2026 update? Regards, Alison.
Hi Team, We would like to raise an enhancement request for the SSO/SAML configuration guidance for OAS 2026. We have already raised multiple SRs regarding OAS 2026 SSO configuration. However, we are facing difficulties getting the required guidance, as the available documentation does not clearly cover the OAS 2026 SSO…
We are planning to archive the Contract and Lease data currently sourced from the External Source as Contract and Lease accounting functions are being migrated to Oracle's CLM and Lease Accounting modules. At this stage, only active and partially closed records are being converted into Oracle and the remaining historical…
The difference column is a calculation, and I would like to average that row.
We are trying to convert our OAS reports to OAC and one of the parameters in the where clause of the report is what I am trying to make in OAC. I created a calculation as follows and I am trying to put it into a filter . The code validates EVALUATE('GREATEST ( TRUNC ( NVL (%1, TO_DATE (''1/1/2013'', ''mm/dd/yyyy'') ) ),…
