@Rajakumar Burra Can you please accept my answer as that resolved the issue?

@User_TUWA3 Can you check if the article below helps you? BIEE 12C - How To Change Column Header Value Dynamically (Doc ID 2604814.1)

@User_TUWA3 I suggest you to use IndexCol function. Please refer I hope it helps. Regards, Bala.

@Rajakumar Burra I tried this use case. Below is the definition of parameter and expression filter. If the logical query does not return any value, it makes use of the default value of the parameter, which is 'none' in my case. I hope it helps. Regards, Bala.

@Sumanth V -Oracle These policies are only required for those users that need to administrate FDI and its associated OAC and ADW in the tenancy. As per scenario# 2, both Fusion Applications and FDI are associated with the same identity domain within the same cloud tenancy. So, the SSO is already taken care. Does this…

@User_L2TQS As @Ravi Guddanti-Oracle mentioned, these policies are only required for those users that need to administrate FDI and its associated OAC and ADW in the tenancy. As per scenario# 2, both Fusion Applications and FDI are associated with the same identity domain within the same cloud tenancy. So, the SSO is…

@User_L2TQS As per policies granted to the group, the members of this group will FDI Admin Users. Please refer Regards, Bala.

HI @User_TUWA3 To get the first day of the last month, the calculation below can be used because TIMESTAMPADD(SQL_TSI_MONTH, -1, CURRENT_DATE) does not return the first day of the last month. TIMESTAMPADD(SQL_TSI_MONTH, -1, TIMESTAMPADD(SQL_TSI_DAY, -1*DAYOFMONTH(CURRENT_DATE)+1, CURRENT_DATE)) Regards, Bala.

@Mirithu Regarding your requirement #1 , please check if the settings below help. Regards, Bala.

@User_NMOCH You can also check the Oracle Blog below that talks about various SSO solutions for OAS.

@Sarah Beckwith-Oracle I have filed this idea requesting for this functionality in the Oracle Analytics Desktop. You may upvote.

@user13125124 Please access BIP Administration page and navigate to Runtime Configuration → Properties and check if Webservice optimization is set to True.

Hi @user13125124 Please explain the issue a bit more. Are you trying to create an OAC DV connection of REST API type? If so, which is the webservice that you are trying to call?

@Roelof de Groot Please refer

Hi @Victor H Please refer which says "Application Releases contain updates to the data model and new content when available." I would also suggest you to refer to to know the pre-built tables and columns that may get deprecated in FDI releases. This would help you to maintain your customizations across releases. Regards,…

Hi @Krishna90 Please check the formula below helps: case when (sum(case when loan_status = 'RISK' or loan_status = 'REGULAR' then 1 else 0 end) by customer_number) = 2 then 'Changed' else 'Unchanged' end Regards, Bala.

Hi Krishna, It is regarding your 2nd requirement. You may have to modify the formula as needed. My assumption is, the loan status changes from regular to risk only once for a customer. The below formula will help you to identify the customers who changed their loan type. The count of this column will give you the number of…

Hi Martijn, Thank you for the update. So, you never had issues with OAS 6.4 on SUSE15 Linux. As Sumanth mentioned, it is recommended to be on the certified OS version. However, the installer did not fail during pre-requisites checks. To narrow down, as Gianni mentioned, it is better to verify if everything is fine before…

Hi Martijn, To gather additional information, can you tell us the OS version that your OAS 6.4 is running on? Regards, Bala.

The OCI logging does not show the query result of the Init block queries (i.e.) success / failure. Even it fails, the error message is not captured. Thanks, Bala.