Hi @Xavier H. , The solution to this is to edit the data model using text editor instead of BIP. Follow the steps mentioned in below MOS note: Fusion BI Publisher - How to Get Around Lexical References When Customizing a Seeded Data Model (Doc ID 2318462.1) Thanks.

Hi @Kartik Mali-Oracle , I couldn't find a way to remove it when viewing the report using link. But once you add it in the navigator, it shouldn't see xdo: Thanks.

Hi @Victor H, Unfortunately, there is no documentation available for this except for DOR deep links. I had raised an idea already for DOR and Oracle delivered: But for other than DOR, no documentation available for other modules. For learning, check if below MOS note helps: Thanks.

Hi @Susan Anderson , Which subject are you are using? Thanks.

Check if below thread helps: Thanks.

Hi @Mohamed Mohsen, This is not possible. Once the user have access to BIP data model and select from a table, they can access data from all tables. @user10597052, Secured views work well for end user who just has access to run a report. But for a person with create data model access, this is not possible to restrict data…

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.