Upvoted. This will be helpful !!!

https://community.oracle.com/products/oracleanalytics/discussion/24400/workforce-management-worker-assignment-real-time-pulling-active-and-inactive-assignment-statuses You can make use of RANK or RCOUNT function to pull only the latest record. Check below threads for samples: Duplicated records on OTBI Report linked to…

https://community.oracle.com/products/oracleanalytics/discussion/24396/unsupported-report-objects-type-catalog I don't think it is possible to upload .catalog files using web services. There is an idea submitted for a similar requirement, please evaluate and upvote: Upload BIP .catalog object via Web Services - Page 2 —…

https://community.oracle.com/products/oracleanalytics/discussion/24399/where-can-i-find-incumbent-details-dates-allocated-in-position-through-subject-area-otbi These details are not stored anywhere in the database. Hence, not available in the subject areas. You need to write a custom BIP report to get these details. Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/comment/63118#Comment_63118 Can you give it a try to create under /custom folder instead of /myfolder? Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/comment/63115#Comment_63115 Hi Bhaskar, The note you shared is about creation of data set manually with a type of webservices. Not about creating the data set using webservices. Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/24397/create-datamodel-using-oracle-web-services Hi Sudhan, Did you try UpdateObject after creation of data model? I couldn't find any working example. Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/comment/63108#Comment_63108 Can you please confirm the steps that you have followed? Additionally, what the output format you are receiving on the SFTP? These details can help in finding the root cause. Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/24389/need-to-get-referrer-job-title-and-referrer-assignment-status-in-otbi I think the only way is to get the required data using logical SQL. Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/24390/otbi-exported-xml-data-model-is-not-show-in-lower-case You can control this behavior at data set properties level. Click on Edit data model → choose properties and choose the case: Thanks.

Hi, Oracle provides a functionality where data can be loaded into multiple languages for most objects in HCM. This data is stored in _TL tables and can be reported using language attribute. For all languages enabled on customer environment, there will be a row in _TL table. If no translation is loaded, each row for a…

https://community.oracle.com/products/oracleanalytics/discussion/24386/documents-uploaded-in-dor-who-can-we-download-using-query-bursting-or-extracts What is your exact requirement? Do you want to create a report and provide a DOR in that or the requirement is to bulk download the DORs? If you want to create a report, then…

Hi Bala, I would suggest you to raise this query on customer connect → integration forum to hear from integration experts or people who may have faced a similar challenge: Integration — Cloud Customer Connect Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/24362/is-bi-publisher-replaced-with-oracle-analytics Are you using a standalone BIP or BIP as part of Fusion SaaS? Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/24351/complete-getting-started-with-fdi-webinar-series-links-to-past-and-upcoming-sessions Great resource !!!

https://community.oracle.com/products/oracleanalytics/discussion/comment/62971#Comment_62971 Hi Abhijit, Your understanding is correct. It will not be possible to execute this DM standalone as confirmed in the post by Swapnil that I shared in my first post: Transactions Print Data Model Parameters — Cloud Customer Connect…

https://community.oracle.com/products/oracleanalytics/discussion/24349/able-that-shows-me-the-creation-or-modification-of-a-data-model Hi Emanuele, This information is stored in metadata tables and is not directly accessible. However, there is a set of BIP audit reports provided by oracle which can give you this…

https://community.oracle.com/products/oracleanalytics/discussion/comment/62964#Comment_62964 It will be great if you can share the query with community. Anyone needing it in future, can reuse. Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/comment/62957#Comment_62957 Hi Abhijeet, Does this mean that when passing the same parameters from ESS job, the output gets generated but not from data model? Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/24344/hey-team-i-want-to-create-an-otbi-report Can you check if you can see this information in PAY_PAY_RELATIONSHIPS_F table? If no, will you be able to provide the exact DFF name used to define these attributes? Oracle Application's Blog: Query to get…