https://community.oracle.com/products/oracleanalytics/discussion/comment/62124#Comment_62124 In your main select clause: add below: Pay_Run_Balances.Balance_Value num_of_hours ,(Pay_Run_Balances.Balance_Value/10) per_day_hours FROM ….. add a new line in from clause: , (select level lvl from dual connect by level <=…

https://community.oracle.com/products/oracleanalytics/discussion/24138/sql-query-to-get-recorded-absences-on-their-time-cards-in-oracle-fusion-cloud Please check if below helps: SQL Query for Time Card Data and Absence Details — Cloud Customer Connect Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/comment/62120#Comment_62120 That was just an example. Instead of below: '80' num_of_hours, to_number('80')/to_number('10') per_day_hours Use your actual table.column names. If you are not able to replicate, share the table name and column name, I can try to…

https://community.oracle.com/products/oracleanalytics/discussion/24135/what-are-the-database-tables-for-opt-in-features-in-oracle-fusion-cloud Also, duplicate of below post: What are the database Tables for Opt in Features in Oracle Fusion Cloud? — Oracle Analytics Can you please close one? Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/24134/what-are-the-database-tables-for-opt-in-features-in-oracle-fusion-cloud You can get these details in ASM_FILTER_OPTIONS_FILTERS table. Please check below MOS note for other related tables: What are the tables or views related to Offerings And Opt In…

https://community.oracle.com/products/oracleanalytics/discussion/comment/62114#Comment_62114 You can write something like below: select papf.person_number ,'80' num_of_hours, to_number('80')/to_number('10') per_day_hours from per_all_people_f papf, (select level lvl from dual connect by level <=…

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.