Popular Tags
- OTBI 1,428
- Reporting 1,383
- FDI 1,062
- Analysis and Data Visualization 976
- BI Publisher 840
- Analysis 673
- Oracle Fusion Analytics 577
- Administration 555
- OBIEE 429
- OAC 407
- Analytics 382
- BI Publisher Data Models 346
- Security 288
- Answers 264
- HCM 256
- Analyses 253
- BIP 247
- Developers 243
- Data Modelling and Datasets 223
- Data Connectivity 208
- ERP Analytics Content 205
- BI Publisher Report Templates 201
- Report Output 183
- Oracle Analytics Cloud 168
- Customizing Reports 156
Welcome to the Oracle Transactional Business Intelligence Community Forum!
Whether you're a seasoned user or just starting your journey with OTBI, the solution for transactional reporting in Fusion Apps, this forum is your go-to for questions and discussions. Connect with experts, seek advice, share insights, and post product recommendations in the Idea Lab.
If you're new to OTBI, visit our Doc Library and OTBI Resources pages for more details and answers to common questions - links to these and more are available in the Knowledge Base: https://community.oracle.com/products/oracleanalytics/kb/articles/62-resources-for-oracle-transactional-business-intelligence-otbi
For OTBI inquiries on subject areas and use cases, please direct your questions to one of our OTBI pillar forums (HCM, ERP, SCM, Sales, Field Service) on Customer Connect to receive tailored assistance.
Whether you're a seasoned user or just starting your journey with OTBI, the solution for transactional reporting in Fusion Apps, this forum is your go-to for questions and discussions. Connect with experts, seek advice, share insights, and post product recommendations in the Idea Lab.
If you're new to OTBI, visit our Doc Library and OTBI Resources pages for more details and answers to common questions - links to these and more are available in the Knowledge Base: https://community.oracle.com/products/oracleanalytics/kb/articles/62-resources-for-oracle-transactional-business-intelligence-otbi
For OTBI inquiries on subject areas and use cases, please direct your questions to one of our OTBI pillar forums (HCM, ERP, SCM, Sales, Field Service) on Customer Connect to receive tailored assistance.
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Oracle Transactional Business Intelligence
Discussion List
-
TimeStampDiff in Hours Excluding WeekendsHi, Anyone can help how can I get the timestampdiff in hours between two dates: ("Procurement - Purchase Orders"."Requisition Lines"."DW_FA_X_REQ_LINE_TIMESTAMPS_LASTAPP… -
OTBI condition not workingHello, We're trying to create a custom OTBI report with the below requirement. - If employees reported hours is null/blanked, it should return 'WO' value Please see the … -
Hi, Can any one help me on this?. i want a SQL query to join cost center with HCM departmentI'm trying to get the join between cost center and HCM department, But it kept return nulls when i try to join them together as it shown in the below query (SELECT pcak.… -
Issue with number of direct reportees in OTBI reportHi All, Facing issue with number of direct reportees, its showing inaccurate direct reportees. Logic for direct reportees →COUNT("Assignment Manager List Unsecured"."Per…
-
we have questin text and answer report but all questions are coming in columnsSummary: Hi , we have questin text and answer report but all questions and answers are coming in columns. so we get multiple records for each employee i mean 7 questions…
-
Query to get fetch Archived Transaction Summary dataHi Expert, Does anyone have a query to fetch the Archived Transaction Summary data? I would really appreciate it if you could share a BI query here. Thank you in advance…
-
Remove the EDIT option for Custom reports in OTBIHello , I have a question regarding the restriction of access rights for OTBI. We would like to remove the EDIT option that every report has (please see below) . These r…
-
show all categoryHello All, I am working with OTBI and the customer ask to add a choice for all supplier as you can see in the picture here I want to add a prompt for all. Is there a way…
-
OTBI Dashboard Prompt: Year, Quarter,MonthHi Team, We are working on a customizing line manager dashboard, Workforce Event page. The used column are are not giving correctly result by using the delivered facts l…
-
SQL query in OBIEE SQL prompt errorHi, I tried last 12 months in YYYYMM format as a SQL query result in OBIEE sql prompt. but its throwing error. Select TO_CHAR( ADD_MONTHS( TRUNC(SYSDATE,'year') , LEVEL-…
-
Issue: Category Hierarchy Level Field Data Not PopulatingHello, I am facing an unusual issue in an OTBI analysis report where I need to display category hierarchies (Level 1, 2, and 3) as per business requirements. Although I …
-
Automatic Backup of All Custom BI Reports and AnalysesFusion Applications BI - How To Take a Automatic Backup of All Custom BI Reports and Analyses Hello, We want to take backup of All Custom BI Reports and Analyses & custo…
-
CORS: Setting Access-Control-Allow-Origin header values for BI AnalysisSummary How to set the Access-Control-Allow-Origin for BI analysis. Content Hey, I am working with BI analysis (Sales Cloud Reports and Analytics) in Oracle Sales Cloud.…
-
Reference Relationship in BI PublisherContent Hi, I created an interview which loads data about a certain order - it then needs to go into boxes and I need to create shipping labels 1. The user adds an insta…
-
Logged In User Details ReportHi , I need to create an OTBI report to fetch details of all users who logged into Oracle CRM on a particular day. Unfortunately, I couldn't find any suitable subject ar…
-
Email is not Receiving if we specify from email group as client email group address in burstingHi All, If we specify the from email as no-reply@oracle.com/donotreply@oracle.com something like this in bursting at data model level we are getting emails ,as per the b…
-
Is there any vulnerability scan available/possible on queries written in BI Reports?We create custom BI reports mainly on Oracle Financials Cloud. We would like to apply vulnerability scan on custom codes we develop for BI Reports. Is there any Oracle t…
-
-
Briefing Book not displaying complete outputHi, I created a briefing book which is not giving the complete output of the dashboard page. The dashboard has some visualization and out of them 1 is a pivot table. So,…
-