Hi @user10597052, There is no way to restrict the access only to certain tables for a specific user. If a user has access to any table, he/she will get access to all the tables. However, in HCM, there are few tables which are marked as sensitive data which will not retrun any data if the user doesn't have appropriate…

Hi @Kauan_Bohn , You may create a different data set in your data model based on tables and then try to join it with data set created using OBI EE source. In the same data set, you will not be able to add columns from direct tables. Thanks.

Hi @Jefry Carpio , This is not possible currently. Please evaluate the below idea and upvote: Thanks.

Hi @Suprit , There is no option to get these details from backend. Only option is to check from Reports Job history which is not viable in case the expected count is too high. There is an idea raised already to expose backend tables: Thanks.

Please check below MOS notes: FA BICCC : Data Lineage Document for DFFs and Their Associated VOs (Doc ID 2463485.1) How to Review Database Lineage Mappings, Check For Columns and View Objects for BICC PVOs? (Doc ID 2626555.1) Thanks.

Hi @Shanmukhi , Unfortunately, there is no way of getting these details from backend currently. There is an idea submitted for same: Expose Table for Bursting Output Results — Oracle Analytics Please upvote the idea so that it can be considered for future enhancements. Thanks.

I agree @User_VICIT. XDOTIMEZONE should work as well. But what I shared was a workaround from SQL side. Can you share the syntax you are using in your template? Thanks.

If you just want to pass multiple values, instead of giving an option to choose multiple values from a list, then you can use the workaround mentioned in below MOS note: Fusion Applications - How to Pass Multiple Values in a Single Parameter to Custom ESS Job that Submits Custom BI Publisher Report (Doc ID 2774925.1)…

Hi @User_WBLBP , The status is same still i..e multi select is not supported through ESS jobs. Once it is available, the MOS doc which I shared earlier either will get an update or will be archived by Oracle. Also, the idea link I shared still doesn't say that the functionality is available. The idea status changes when…

Hi @User_VICIT, If you have the SQL ready to get user's preferred timezone, then you can use below function Data model and try: CAST(wlif.start_date AT TIME ZONE wlaf.time_zone AS DATE) actual_date_time where wlaf.time_zone —> timezone from user preferences. Thanks.

Hi @User_VICIT , Can you please elaborate a bit more? Are you trying to convert some date time from a backend table to a time in a timezone specified at "User >> Set Preferences >> Regional >> Time Zone specific" ? Thanks.

Hi @User_UNRLP , If the requirement is to send a static PDF, you can check the below blog post: Thanks.

Hi, This is not supported currently. Is It Possible To Enable Multiple Selection Setting For ESS Job Parameters (Doc ID 2871349.1) There is already an idea submitted, please upvote: Enable multi selection parameters in ESS job — Oracle Analytics Thanks.

Hi @User_UNRLP , The separate attachment which you want to deliver is that a static attachment or the contents change? Thanks.

Hi @User_UNRLP , This is supported. You can create an RTF template with all your header/footer and images and in the bursting definition use PARAMETER6 as False. This will use the RTF data as email body. Let me know if this suffice your requirements. Thanks.

Hi @Paulina Vega , As per the Oracle docs, employee role doesn't have access to this subject area: Workforce Management - Worker Assignment Real Time (oracle.com) Thanks.

You need to enable audit policies and then you can get the required data. Please check below thread for more details: Role Assignment history of users — Cloud Customer Connect (oracle.com) Thanks.

Hi @Ivony Ann Paula Salango , Is your question around OTBI analysis or a data model based BIP? If this is related to OTBI, please check the response on below thread: OTBI Analysis rearranging Column Order different in CVS and EXCEL — Cloud Customer Connect (oracle.com) Thanks.

Also, check if you can create something as suggested on below thread using REST APis: List of all Agents created in OTBI — Cloud Customer Connect (oracle.com) Thanks.

As per my knowledge, there is no direct way of doing it. However, you can use workaround as mentioned in below MOS note: Fusion OTBI - How to find all of your BI Agents in your system (Doc ID 1672432.1) Thanks.