Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!
General Transactional Reporting (OTBI)
Discussion List
-
Extracting Configuration Options via OBIEEContent Hi All I've been asked to try and export the configuration options of expenses (Setup and Maintenance > Manage Policies By Expense Category). Now, I can export t… -
Hands-On Training/Consulting Svcs on OBI DashboardsSummary Hands-On Training/Consulting Svcs on OBI DashboardsContent Hello:) Can anyone recommend a consulting services that provides hands-on training for OBI Dashboards?… -
OBIEE Visual AnalyzerSummary Is visual analyzer available with OBIEEContent Hi we are looking for ways to load external data to OBIEE for reporting purpose. I saw the article https://develop…
-
report on user account details - Role NamesSummary SQL for reporting on employees rolesContent Can someone see how to stop the multiple rows from returning in below SQL? select "PER_USERS"."USERNAME" as "USERNAME…
-
Is there an Enhancement Request for BICS "exceeded configured maximum number of allowed input recordSummary Our BICS users get this error message when trying to look at years worth of data. Our users have to run multiple reports now in BICS to get the results. In OBIEE…
-
Pivot table in analysis - aging bucketsSummary how to create a pivot table with columns as calculated fieldContent i am trying to create date buckets of 0-30 days, 30-60 days in OTBI. I was able to add a calc…
-
how to set a pivot table as default view in analysisSummary how to set a pivot table as default view in analysisContent Hi is there a way to set a pivot table view when running an analysis. For some reasons the table view…
-
Exporting to Excel & Word WrapSummary I want cells with longer text to wrap automatically when I export an analysis to excel 2010.Content I have a built an analysis that pulls in requisition user com… -
Date Formatting - Excel ExportSummary Can't filter by year and month on OTBI exportContent When exporting my analysis to excel the date column is not formatted so I can filter by year, month and day …
-
Concatenating Multiple Columns with Commas and SpacesSummary Trying to concatenate multiple columns in OBI Recruiting LegacyContent Hello, I'm trying to concatenate multiple columns with spaces and commas in OBI Recruiting…
-
Auditing on ReportsSummary Auditing on ReportsContent Hello All, I am looking at option how we can have an Audit on Reports. We have created a report which is consumed by 3rd party via Web…
-
OTBI Security HelpContent Hi All, We are deploying some reports to production for the HR team to use. We are confused with the way the security works in regards to the reports. Ideally, w…
-
BI Cloud Extract IssueSummary BI Cloud Extract IssueContent Extract ran successfully in BI Cloud Connector Console but unable to view them in Universal Content management. As per MOS doc - Fu…
-
Time To Find CalculationSummary Time To Find Calculation - need Days on Hold metric by Candidate!Content Hi - I'm hoping to get some help on an issue that we have had for several years now. Cur… -
Adding subtotal breaks into a BI Publisher table reportSummary How do I add subtotal breaks into BI Publisher report?Content In an Analysis created with subject areas it's easy to add subtotals by going into the view under C… -
Use multiple prefix variables in a reportSummary Using multiple prefix variables on advanced tab of a reportContent Is is possible to have more than one prefix variable in the "Prefix" section on the advanced t…
-
Oracle Data WarehouseContent Hi In order to utilize the full capability of Oracle Reporting (OTBI), do we need to purchase the Data Warehouse? We are currently under the impression that we a…
-
How to run an OTBI Analysis and save output without having it deliveredSummary How to run an OTBI Analysis and save output without having it deliveredContent Is there a way to schedule an OTBI Analysis to run periodically and save the outpu…
-
Problem with adding days in a date(sql)Summary Problem with adding days in a date (sql)Content Hi All, I’m building a bi report and I have the following problem when building the data model. Oracle provides A…
-
Cell Splitting based on special characterSummary Split a field into two columns based on characterContent Suppose I have a field (Name) in Last Name, First Name format. I want to make this into two columns inst…
-
Concatenate non text fieldsSummary Function Concat does not support non-text types.Content Is there a way to concatenate non-text fields? I would like to concatenate Req id and Candidate id to cre…
-
Return Candidate Name only for Specific CSW Selection steps/statusesSummary How to modify my SQL statement to remove redundanciesContent Hi! I've created a report to return all Open Requisitions as well as Filled Requisitions for the pas…
-
data Model ReportContent Hi, How to create Promotion data model report based on promotion employees regards, nivaetha -
Help with my SQL CodeSummary Help with my SQL CodeContent I am trying to create a BIP Report to show Document Payslips pdf uploaded for each employee (with HDL) which covers the Tables like …
-
Audit Related: Last Logon SessionSummary Last LogOn Session: Looking for a audit related report that shows last time accessing OracleContent I am able to query HCM related tables (such as per_users) to …
-
Users information in reportSummary I need to create (or use one that exists) that will give me basic information on the usersContent Hi, I need to create (or use one that exists) that will give me… -
Currency in reportsSummary When the users login with diffrante currency then $ the amount is correcet but the currency code is still $Content In user preferences you can define witch curre…
-
Email prompt does not allow for quotation markSummary Email prompt does not allow for quotation markContent We have a report built in Performance that pulls in a manager's full reporting hierarchy (both direct and i… -
Conditional Formatting on Column Sub-TotalContent Hello, I've built a sickness report that counts the number of instances of sickness and number of days sickness over a time period. I've figured out how to add a… -
Field Level Security and Folder PermissionsSummary We want all user types to share one folder, but have user type permissions that can restrict certain confidential fieldsContent Hi - We are trying to find the be…