Popular Tags
- OTBI 1,392
- Reporting 1,361
- FDI 944
- Analysis and Data Visualization 932
- BI Publisher 812
- Analysis 660
- Administration 551
- Oracle Fusion Analytics 540
- OBIEE 420
- BI Publisher Data Models 334
- Analytics 334
- OAC 315
- Security 261
- Answers 260
- Analyses 253
- Developers 239
- HCM 233
- BIP 229
- Data Modelling and Datasets 215
- Data Connectivity 205
- ERP Analytics Content 196
- BI Publisher Report Templates 183
- Report Output 180
- Agents 151
- Customizing Reports 146
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
OTBI
Discussion List
-
Data model with parameter with "Select all"Summary Data model with parameter with "Select all" Content Hi, we created a data model based on several analisys and we want to add a parameter which filters by Employe…Giuseppe 1234 1.2K views 10 comments 0 points Most recent by Nirmal-64675 Oracle Transactional Business Intelligence -
Restricting access to OTBI Subject area and data elements within a subject areaSummary How do we restrict subject area access to a user through security role? Content Subject area access is driven by duty roles. A duty role 'Workforce Transaction A…Lakshmi Balram-19973 61 views 1 comment 0 points Most recent by User_AEMC1 Oracle Transactional Business Intelligence
-
Time in role reportSummary I need to create a time in role report Content I need to create a time in role report. In our old system we had a calc which said minimum Effective Date for Empl…Peter Kirwan 61 views 2 comments 0 points Most recent by Clyde Ramcharan-61521 Oracle Transactional Business Intelligence
-
Report Employee Photo in Custom DashboardSummary Is there a way to display an employee photo in a custom dashboard? Content We have a custom Talent Profile dashboard and I am wondering if there is a way to pull…Brenda Jacks-49721 101 views 5 comments 0 points Most recent by Sandor Banfi-52443 Oracle Transactional Business Intelligence
-
InitCap without EvaluateSummary Trying to arrive at "normal" case for names without Evaluate function Content Names in our system are entered inconsistently and the goal is to be consistent wit…Rob F 42 views 2 comments 0 points Most recent by RichardChan Oracle Transactional Business Intelligence
-
Exporting report in CSV adds extra space to fieldSummary CSV report adds a space to a field, which doesnt happen when report is exported via Excel. Content Hi, I have one report which is automatically scheduled to be s…3487945 101 views 2 comments 0 points Most recent by 3487945 Oracle Transactional Business Intelligence
-
Calculate Yesterday date based on CURRENT_DATE variableSummary Calculate Yesterday date based on CURRENT_DATE variable Content Hello, how do I could calcolate obtain yesterday date based on current_date field in an OTBI anal…Giuseppe 1234 284 views 2 comments 0 points Most recent by RichardChan Oracle Transactional Business Intelligence
-
OTBI Data Security is not working for Documents of Record Real Time Subject AreaSummary OTBI Data Security is not working for Documents of Record Real Time Subject Areakrishiveth 21 views 1 comment 0 points Most recent by krishiveth Oracle Transactional Business Intelligence
-
Data Sync licensingSummary Want to know if we need to license data sync separately. Content Hi BI Experts, I am posting this on behalf of my colleague. We need the below details. Do we nee…Santhosh K Gaddam 41 views 4 comments 0 points Most recent by RichardChan Oracle Transactional Business Intelligence
-
How to do MAX Date Logic less than Prompted AsOfDate in AnalysisSummary Trying to get the maximum Salary Change Date in OTBI Analysis Content I am trying to convert a filter to SQL to get the maximum Salary Change Date that is less t…Brenda Jacks-49721 82 views 1 comment 0 points Most recent by rashid ramzan-45341 Oracle Transactional Business Intelligence
-
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…Aaron Leggett 41 views 1 comment 0 points Most recent by Satish Kumar-21650 Oracle Transactional Business Intelligence
-
report on user account details - Role NamesSummary SQL for reporting on employees roles Content Can someone see how to stop the multiple rows from returning in below SQL? select "PER_USERS"."USERNAME" as "USERNAM…Peter Kirwan 212 views 4 comments 0 points Most recent by Ramesh Nakka Oracle Transactional Business Intelligence
-
Pivot table in analysis - aging bucketsSummary how to create a pivot table with columns as calculated field Content i am trying to create date buckets of 0-30 days, 30-60 days in OTBI. I was able to add a cal…new.bi 41 views 1 comment 0 points Most recent by JF Carpentier-23261 Oracle Transactional Business Intelligence
-
Date Formatting - Excel ExportSummary Can't filter by year and month on OTBI export Content When exporting my analysis to excel the date column is not formatted so I can filter by year, month and day…Matt M 81 views 4 comments 0 points Most recent by Matt M Oracle Transactional Business Intelligence
-
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…Aaron Leggett 41 views 1 comment 0 points Most recent by Suvankar Dasgupta Oracle Transactional Business Intelligence
-
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…Aaron Leggett 71 views 3 comments 0 points Most recent by Antony Hooper-29731 Oracle Transactional Business Intelligence
-
Cell Splitting based on special characterSummary Split a field into two columns based on character Content Suppose I have a field (Name) in Last Name, First Name format. I want to make this into two columns ins…Kristen Magno 61 views 2 comments 0 points Most recent by Kim Welker Oracle Transactional Business Intelligence
-
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…Evan Jenkins 41 views 1 comment 0 points Most recent by Caroline Gladwin-Oracle Oracle Transactional Business Intelligence
-
SQL IS NULL errorContent Hi We're trying to create multiple reports where we want to bring back a column with no data in (e.g. Missing Bank Details where the employee does not have a ban…Aaron Leggett 73 views 3 comments 0 points Most recent by Neil Peacock Oracle Transactional Business Intelligence
-
Format prompt selectionsSummary Add specific formatting to prompted selections Content Is there a way to format the selections that show for prompts? For instance i need to have a prompt that f…User_EQ8R5 61 views 4 comments 0 points Most recent by User_EQ8R5 Oracle Transactional Business Intelligence