https://community.oracle.com/products/oracleanalytics/discussion/24136/hi-i-need-a-query-to-split-the-salaried-hours-as-8-hrs-day-from-the-state-of-earnings Can you please elaborate your query a bit more? What are you trying to build is it an OTBI or a BIP or in FDI? Thanks.

This will be a great enhancement to the product. We often face scenario's where usage of an attribute change over time (or the attribute is not required) anymore. In such scenario's we manually have to dig each report to find if the particular attribute is being used or not. Upvoted !!!

https://community.oracle.com/products/oracleanalytics/discussion/24126/the-xml-which-we-have-pulled-for-the-job-history-doesnt-hold-the-job-status If you are trying to display the status of individual bursting details, then that is not possible to get. There is an idea submitted for same. Please evaluate and upvote: Expose…

https://community.oracle.com/products/oracleanalytics/discussion/24125/display-more-than-200-rows-in-otbi-while-running-an-adhoc-query There is already an idea submitted for same. Please review the existing and upvote there and close this idea. Increase the count of maximum rows from data model query — Cloud Customer…

I can see a similar idea already submitted on cloud customer connect many years back having more than 70+ votes. It will be good to consolidate the idea at a single location and use all the votes there. Required ESS Schedule Process Job Name — Cloud Customer Connect Please review the below idea and upvote if you feel that…

https://community.oracle.com/products/oracleanalytics/discussion/comment/62073#Comment_62073 Below MOS note confirms that the job names are not stored in backend tables (In case you need a reference to official documentation): What are the Tables Where the ESS Jobs and Custom Job Sets are Stored? (Doc ID 2430380.1) And you…

https://community.oracle.com/products/oracleanalytics/discussion/comment/62033#Comment_62033 Hi Sreekanth, I have checked and I couldn't find anything related to translation of job names data. If you notice any ESS job definition, there are no translation option available: in whatever language you create the job, you will…

This is a long pending enhancement from Oracle. All selected attributes in a data model should be available for use while defining the remote file name. Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/comment/61937#Comment_61937 Are you not able to create two date parameters following the approach on below link? https://community.oracle.com/customerconnect/discussion/585077/how-to-embed-bip-report-in-otbi-dashboard-with-date-prompt-parameter

https://community.oracle.com/products/oracleanalytics/discussion/comment/61898#Comment_61898 You can't get all these things translated. Status comes from a lookup named HRC_LOADER_ESS_STATE and in this lookup, you can get translated values for status. Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/comment/61965#Comment_61965 I don't see a direct way of doing it. You can definitely call BIP reports from groovy with the approach given in below note: How To Call BIP Report Webservice From App Composer using Groovy Script (Doc ID 2150332.1) Can you try…

https://community.oracle.com/products/oracleanalytics/discussion/24111/need-translated-names-in-the-otbi-report Hi Sambhav, This is currently not supported. OTBI pulls data based on your language preference set. So, displaying the data in multiple languages at same time is not supported. Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/comment/61883#Comment_61883 What translated information exactly you need from history table? Is it the job name? Thanks.

This is a long pending enhancement. We should be able to report the data created from UI. I understand this might be a major revamp as this data is stored as metadata. So, any solution - webservices rather than direct table access will also be helpful. Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/comment/61862#Comment_61862 Is it possible to share the navigation from application and a screen shot showing data in UI? You can mask the sensitive data in your screen shot. Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/comment/61861#Comment_61861 That's right. Thanks.

Please check sample given on below support note to convert it as per User preferences: How To Set Date As Per User Preference Time zone in Fusion Applications BI Publisher Report (Doc ID 2864734.1) Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/24086/oracle-bi-reports-in-report-output-the-dates-are-not-coming-as-per-the-format-set-in-user-preference The dates by default are shown in date timestamp format as stored in DB. If you need any particular format, you need to define that in your BI data…

https://community.oracle.com/products/oracleanalytics/discussion/comment/61856#Comment_61856 I am able to find it under Calculation Component Details: In your original post, you mention about PAYE scheme reference attribute. Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/24083/how-to-translate-the-data-in-a-bip-report-to-another-language Not all the data is translated in fusion HCM. Only the base tables having a name ending with _TL contains translated data. So, what this essentially means is not all the objects are…