Please check if, by any chance conditional format or data format is enabled. If none of these issue then SR.

Hi Stephanie, I am not sure why you still getting hyperlink. But this is not certainly a bug, I just re-verified (see attached) and don't see this error. I hope you didn't forget to save the report or may be you need to completely log-off from everything and try again. Thanks Jagadish

Prompt

Hey Dario, Did you try using presentation variable. That might work for you. One of the report I developed with logical SQL and I used presentation variable worked perfectly. Although, I am not sure if this works for you since you are joining two subject areas, you can just try, I don't see any reasons it fail but I am not…

Got it. Yes it is possible. Please see attached screenshot. Thanks Jagadish

Hi Paul, You can do it in two different ways; 1. Right click on the column header in the analysis and move left or right. 2. Hit the edit button on the analysis and drag and drop your columns where you want them to be. Please let me know if my answer is different than what you are asking. Thanks Jagadish

Frankly speaking not sure why this hasn't set to default by Oracle but this is happening since the upgrade. The BICS which is Oracle's new product has this issue and same UI used in the OTBI, may be this issue is carried over.

Here is the attached document.

Hey Simon, Follow the steps attached in the document, you will see your results in full table view. Hope this is what you are trying to achieve right? Thanks Jagadish

Hi Ashish, One of the report I developed using Logical SQL, I passed values through Presentation Variable and that way I am able to sync up the analysis and prompt. I have attached the screenshots for your reference. See if this is something that can help you. Thanks Jagadish

Just take out this part IFNULL("Requisition Identification"."Req. Identifier"))),0.0) should be look like below, or just play around with it. EVALUATE_AGGR('MIN(CASE WHEN %1 = ''Application Review'' AND %2 IN (''Passed Application Review'', ''Rejected - Application Review'', ''Application Review - Rejected'') THEN %3…

Hi Kim, This is the formula I developed for my Time in Process calculations. I had some UDF fields too in the below formula which may not work for you hence I have taken them out. Try and see if this works for you also (if same fields are available it will work else you need to change the fields). This formula has all you…

Hi, Please use this code. It will work, all you have to do is convert both Identifiers as char. Cast ("Requisition Identification"."Req. Identifier" as char)||'-'|| cast ("Candidate Identification"."Candidate Identifier" as char) Thanks Jagadish