Popular Tags
- OTBI 1,393
- Reporting 1,364
- FDI 946
- Analysis and Data Visualization 937
- BI Publisher 814
- Analysis 660
- Administration 551
- Oracle Fusion Analytics 541
- OBIEE 420
- Analytics 336
- BI Publisher Data Models 335
- OAC 321
- Security 265
- Answers 260
- Analyses 253
- Developers 239
- HCM 236
- BIP 231
- Data Modelling and Datasets 217
- Data Connectivity 205
- ERP Analytics Content 198
- BI Publisher Report Templates 184
- Report Output 180
- Agents 151
- Customizing Reports 146
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Reporting
Discussion List
-
7Excel & CSV Export Date to Use the Correct Time ZoneCurrently when users export data in Excel or CSV format (i.e. unformatted), dates are exported in raw format and converted to UTC time zone (refer the note at Analysis a…Neil M 1 124 views 0 comments 7 points Started by Neil M 1 Oracle Analytics Cloud and Server Idea Lab -
Employee signature picture in reportHello Everyone, Can anyone tell me how I can show an employee's handwritten signature in my report? Thank you.
-
BIP Report to Get Last 30 Days User Login DetailsThe Import User Login History Ess Job is scheduled and we tried ASE_USER_LOGIN_INFO table to fetch the last 30 days users login history but it only gives last login deta…Chainsyssupport 1K views 4 comments 0 points Most recent by Chainsyssupport Oracle Analytics Publisher
-
Is there a way to generate a list of reports with it's pathis there a way to generate a list of reports and their path available in custom folder?
-
23D Broke BI Reports when using views and different languagesFrom 23D we have noticed that any BI reports/data models using tables that factor in the users language no longer return the values based on the users language. Even run…
-
5Stacked Bar Chart Total issueOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): LCRA Description (Required): There se…Narayanan Ramachandran 130 views 3 comments 5 points Most recent by Michal Zima Oracle Analytics Cloud and Server Idea Lab -
General Guidance regarding GLOBAL_PERSON_PVOGood morning, Our Data and Analytics team has hooked up to BICC using a FiveTran connector. The PVO they are connected to is the GLOBAL_PERSON_PVO one. They are interest…SeanWesche 23 views 1 comment 0 points Most recent by RanaAshutosh-Oracle Oracle Fusion Data Intelligence
-
Integration between Oracle analytics publisher and IBM fileNetSummary: Hi All, Our customer Owns IBM FileNet for file management and is used universally. They are generating a lot of certificates and template-based output using BIP…SiddharthDang-Oracle 61 views 2 comments 0 points Most recent by Gianni Ceresa Oracle Analytics Publisher -
2Report to identify terminated employees in Oracle workflowHi Team, We are looking for two reports: 1.) Report to identify terminated employees in Oracle workflow. Suppose employee A is present in PO,AP,GL etc approval and the h…Nidhi Chhajed 13 views 0 comments 2 points Started by Nidhi Chhajed Oracle Transactional Business Intelligence Idea Lab
-
Number columns are in text format in Excel exportHi, when our users export the data from Business Intelligence Publisher report to Excel, they want to perform additional analyses. Hence, they need to perform calculatio…Ante Obradović 571 views 2 comments 0 points Most recent by Ante Obradović Oracle Transactional Business Intelligence
-
The columns like BANK_NAME and BANK_BRANCH_NAME are blank in iby_ext_bank_account tableWe have a requirement to generate a report retrieving the details of changes made by an employee to their bank details in the payment methods page. We have created a use…Anusha B S 61 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Oracle Transactional Business Intelligence
-
9OTBI Audit ReportsDescription We need reports for auditing modifications to OTBI reporting components. Only mod dates show, so we have no visibility into which user made the change or wha…Jeff Rich-Terillium 807 views 42 comments 9 points Most recent by Parag Hiremath Oracle Transactional Business Intelligence Idea Lab
-
ReplaceI am using the measure specified below to replace '-' for '/' in string. CASE WHEN "Input Value"."Input Unit of Measure"='D' THEN REPLACE(CAST("Element Entry Value"."Dis…Julia Kiszelewska1234 21 views 0 comments 0 points Started by Julia Kiszelewska1234 Oracle Transactional Business Intelligence
-
Calendar table in ODVHello , I have a question with ODV. Is it possible to create a custom calendar table in ODV ( with spreadsheet or sql query) and then link it to a report dates columns i…User_RS68A 171 views 5 comments 0 points Most recent by Federico Venturin - Oracle Oracle Analytics Cloud and Server
-
Can we run the OTBI Analysis from Scheduled Processes?Hi Folks, Is there any way to make the OTBI Analyses available under Scheduled Processes so that it is easy for all users to run them straight from the Scheduled Process…Saahil Umratkar 409 views 4 comments 0 points Most recent by Saahil Umratkar Oracle Transactional Business Intelligence
-
Catalog Object Links in OAC dashboardHi all, We are migrating OBIEE 12c reporting to OAC. In OBIEE, some PDF, XLS files were kept in res/s_Alta directory. These files could be opened from dashboards by addi…Debadrita Ghosh-Oracle 234 views 8 comments 0 points Most recent by Federico Venturin - Oracle Oracle Analytics Cloud and Server
-
20OAC Agent/IBOT report output of excel/csv to a file system LocationOrganization Name Thomson Reuters Description In OBIEE 11g to send report output to any file location, we use to create agent with “Invoke Server Script” on the Action t…Amit Kotarkar 393 views 7 comments 20 points Most recent by SteveF-Oracle Oracle Analytics Cloud and Server Idea Lab
-
BI Publisher Data Model - Is there a way to configure a parameter to accept multi-line free texts?Users can only input single line of texts on a Free text field parameter.
-
BI Publisher Interactive Output VERY WEIRD behavior. Inbuilt total characters per row restriction ?I've written a BIP report and am using the interactive output. I noticed it was only bringing back about 95 of my 3000 rows that the data model retrieved. I used a param…
-
How to add Refund amount column in Refund listing report in OTBI report in oracle fusion.Could you please help us of how to add Refund amount column in Refund listing report in OTBI report in Oracle fusion Receivables.SAITEJA_01 12 views 0 comments 0 points Started by SAITEJA_01 Oracle Transactional Business Intelligence