OTBI
Discussion List
-
Text AnalyticsSummary step by step procedure to proceed Text Analytics in OBIEE 11gContent Hi, I need step by step procedure to proceed Text Analytics in OBIEE 11g. I'll be happy to r…Andrews J Stanley 21 views 2 comments 0 points Most recent by Nathan CCC General Transactional Reporting (OTBI) -
how to auto run an analysis with promptSummary: I have created an analysis with prompts. I want that when an analysis is run, it should display the output with default prompt option 'All Column Values'. Curre…Dilpreet Kaur 1 view 1 comment 0 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI) -
Why does the table edit page return results but the results page error?Summary: I have created a case when clause in my OTBI report which should return a column of show or group based on the criteria. When I see it in the table edit view, i…Dawn Cawston - CPS 1 view 1 comment 0 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI) -
R13 21D Financials OTBI database mapping with ViewObjectsSummary: Where can we find R13 21D Financials OTBI database mapping with ViewObjects? Content: Where can we find R13 21D Financials OTBI database mapping with ViewObject… -
Export OTBI to CSV includes excluded columnsSummary: How do we ensure that OTBI reports exported into CSV, do not include the excluded columns. Content (required): Currently I have a learn report that I have filte…Dawn Cawston - CPS 11 views 1 comment 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI)
-
Person Records Secured By AOR Does Not Restrict Data Reflected In OTBI ReportsSummary: Hello Everyone ! I am trying to secure the data returned by HR_ANALYST job role by using an AOR with a scope of Department. Although, it works fine in the HCM U…Maruvada Sanat Kumar-Oracle 21 views 1 comment 0 points Most recent by Maruvada Sanat Kumar-Oracle General Transactional Reporting (OTBI)
-
No. of rows in the CSV output file of ESS job in Oracle CloudSummary: Hi, We are seeing the below error in the CSV output file of an ESS job in the Oracle Cloud. Flatten data truncated due to MaxRows=2000000 has been reached. Is t…User_MN9VB 1 view 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI)
-
Query to find the HRBP Representative of an Employee in HCM DatabaseSummary: Find a 'HR Business Partner' of an Employee in HCM Database - to create a report on Employee and his/her 'HR Business Partner Representative' details. Content (…User_H69RU 251 views 1 comment 0 points Most recent by Vijay Ramani VJ General Transactional Reporting (OTBI)
-
Selecting the latest Order revisionSummary Need to retrieve the latest Orders revisionsContent Hi, While creating an Analysis to retrieve the Sales Orders details we need to show only the latest revision …Mr H 22 views 8 comments 1 point Most recent by Andrew_Schmitz General Transactional Reporting (OTBI)
-
Issue Combining Multiple SAs - blank fieldsSummary: Issue with combining two SAs: Workforce Management - Worker Assignment Real Time & Recruiting - Recruiting Real Time Trying to put a flex field from Recruiting …Andrew Mc 1 view 1 comment 0 points Most recent by Sahithi Kolasani-Oracle General Transactional Reporting (OTBI)
-
Performance Tile Filter not producing correct resultsSummary: I am trying to produce a measure for number of maternity cases currently in progress where the visa permit type has not been entered (is null). It produces resu…Marcus Aurelius 1 view 5 comments 0 points Most recent by Marcus Aurelius General Transactional Reporting (OTBI)
-
OTBI Report Too Slow / Not Generating ResultsSummary: Have created a report to pull all roles for all users (Audit purposes), and admittedly there is an excessive amount of data to pull. That being said, when runni…User_DKPSX 11 views 10 comments 0 points Most recent by Matthew Voss General Transactional Reporting (OTBI) -
Users are unable to create new Analysis Reports in the Transactional Business Intelligence windowSummary: Content (required): Users are not able to see any option in the "New" tab in Transactional Business Intelligence window to create OTBI reports (Analysis/Data Mo…Dian Minshan 1 view 4 comments 0 points Most recent by Dian Minshan General Transactional Reporting (OTBI) -
Is there a way to limit OTBI Dashboard Prompt values based on securityHello, Is there a way to limit/restrict the OTBI Dashboard Prompt values based on security / data roles assigned to current user ? We are seeing that the analysis, when …
-
Pull a report of OTBI User Folder AccessSummary We need to be able to pull a report of all user access to all OTBI folders.Content We need to be able to pull a report of all user access to all OTBI folders. To…Steph Hamelbeck 80 views 3 comments 10 points Most recent by User_ZTN0B General Transactional Reporting (OTBI)
-
Convert varchar to date datatype in OTBISummary: Hi All, I am looking for To_date function to convert from varchar to date datatype in OTBI but To_date function is not available. Content (required): Is it poss…Surya Anbazhagan 1 view 6 comments 0 points Most recent by A.JOSH General Transactional Reporting (OTBI)
-
How to generate Dynamic Password Protected BIP report output?Summary How to generate Dynamic Password Protected BIP report output?Content Hi All, I have written a post on How to generate Dynamic Password Protected BIP report outpu…Rajeev Nayan 54 views 1 comment 10 points Most recent by A.JOSH General Transactional Reporting (OTBI)
-
Is there a way to find what reports/anaylsis are set up for Bursting?Summary Is there a way to find what reports/anaylsis are set up for Bursting?Content Hello I need to find out what reports/analysis have been created and set to burst ou…Helen Thomas-53877 48 views 6 comments 0 points Most recent by Raghavan p-Oracle General Transactional Reporting (OTBI)
-
Can Available Credit Limit For A Customer be Performed in OTBI?Summary: Can Available Credit Limit For A Customer be Performed in OTBI? Content (required): How can we check Open Credit Limit for a customer account in OTBI Report Do …Stephen Johnson-Oracle 11 views 1 comment 0 points Most recent by Nathan CCC General Transactional Reporting (OTBI)
-
Help with an OTBI or SQL query to produce a list of all job codes with Grade informationSummary: Hi All, I am hoping someone can help me - I have been struggling with a report request for a while now and I didn't think it was going to be this hard Our busin…PamS 21 views 16 comments 0 points Most recent by Mandeep Gupta General Transactional Reporting (OTBI)
-
Does anyone have any suggestions to help me fix this issue?Summary: Dashboard performance issue Content (required):Pivots populate within seconds within the analyses report. However, running through the dashboard it can take up …Donna Fazio 1 view 1 comment 0 points Most recent by Nathan CCC General Transactional Reporting (OTBI)
-
Briefing Book is not updated if we change the filter condition of AnalysisSummary: I have created a updateble briefing book based on an analysis, later we updated the analysis using filter condition as per requirement, but Briefing Book is not…Shubham Singh 1 view 4 comments 0 points Most recent by Nathan CCC General Transactional Reporting (OTBI) -
Add to briefing book option takes 10-15 Min to load on published Dashboard over homepageSummary: We have created a custom dashboard which contains multiple analysis, when we click on any analysis to Add to briefing books it takes around 10-15 mins to give t…Shubham Singh 1 view 0 comments 0 points Started by Shubham Singh General Transactional Reporting (OTBI)
-
How to remove timezone from OTBI PromptHi, I have created OTBI analysis using custom SQL.I have taken the following Subject area Learning Management real Time , Person Real Time , Learning Records real time. …Praveen_Chouhan 1 view 1 comment 0 points Most recent by Pulkit Kumar Jain General Transactional Reporting (OTBI)
-
Excel/Data Model only runs once then I have to close AnalyticsSummary: The help desk was trying to help me with the installation of the BI Publisher Template Builder for Excel and the Oracle ADF 11g Desktop Integration Add-in for E…
-
Approval date not extractedSummary: Content (required): Hello everybody, In editing a report concerning various information about a job requisition. We needed to extract the "Approval Date" of a j…Gerardo Peluso 1 view 1 comment 0 points Most recent by ravikiran goda-Oracle General Transactional Reporting (OTBI)
-
Reports performance issueSummary: Report ending up with exception "oracle.xdo.template.ProcessCancelledException: FOBlock was cancelled after 0 seconds" Content (required): How to improve report…Azfar128 1 view 1 comment 0 points Most recent by ravikiran goda-Oracle General Transactional Reporting (OTBI)
-
Workforce Management - Checklist Real Time doesn't contain Pending WorkersSummary: I need to report on those colleagues who haven't completed a certain checklist task prior to employment which would mean reporting on Pending workers. However a…MattW 1 view 1 comment 0 points Most recent by ravikiran goda-Oracle General Transactional Reporting (OTBI)
-
Group by Ethnicity and Headcount in AnalysisSummary: Issue in Analysis when count of ethnicty is added in Case statement Hi Team, I have taken the Employee Ethnicity Analysis from Line Manager Dashboard from the d…Darius Sunder 1 view 0 comments 0 points Started by Darius Sunder General Transactional Reporting (OTBI)
-
Changing date format to remove comma - OTBI ReportSummary: Been working on an Absence Calendar for a Dashboard and the prompt for Year dislays as '202,0'. Is there a way to change the format so it displays as '2020'. Co…User_DKPSX 31 views 4 comments 0 points Most recent by User_DKPSX General Transactional Reporting (OTBI)