Popular Tags
- OTBI 1,468
- Reporting 1,403
- FDI 1,173
- Fusion AI Data Platform 1,028
- Analysis and Data Visualization 999
- BI Publisher 870
- Analysis 685
- Oracle Fusion Analytics 602
- Administration 556
- OAC 505
- OBIEE 435
- Fusion HCM Analytics 419
- Analytics 414
- Fusion ERP Analytics 402
- BI Publisher Data Models 360
- Security 301
- HCM 274
- BIP 267
- Answers 265
- Analyses 255
- Developers 246
- Oracle Analytics Cloud 231
- Data Modelling and Datasets 230
- ERP Analytics Content 216
- Data Connectivity 212
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Reporting
Discussion List
-
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 1.3K views 4 comments 0 points Most recent by Chainsyssupport Oracle Analytics Publisher Forum -
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…Paul Hassall 422 views 11 comments 2 points Most recent by Paul Hassall Oracle Analytics Publisher Forum
-
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 131 views 3 comments 5 points Most recent by Michal Zima Oracle Analytics 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 31 views 1 comment 0 points Most recent by RanaAshutosh-Oracle Oracle Fusion AI Data Platform Forum
-
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 71 views 2 comments 0 points Most recent by Gianni Ceresa Oracle Analytics Publisher Forum -
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 11 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ć 694 views 2 comments 0 points Most recent by Ante Obradović Oracle Transactional Business Intelligence Forum
-
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 72 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Oracle Transactional Business Intelligence Forum
-
11OTBI 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 1.1K views 42 comments 11 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 Forum
-
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 211 views 5 comments 0 points Most recent by Federico Venturin - Oracle Oracle Analytics Forum
-
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 574 views 4 comments 0 points Most recent by Saahil Umratkar Oracle Transactional Business Intelligence Forum
-
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 262 views 8 comments 0 points Most recent by Federico Venturin - Oracle Oracle Analytics Forum
-
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.JFabroada 641 views 1 comment 1 point Most recent by Simonab-Oracle Oracle Analytics Publisher Forum
-
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…ScottHillier 144 views 4 comments 0 points Most recent by ScottHillier Oracle Analytics Publisher Forum
-
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 11 views 0 comments 0 points Started by SAITEJA_01 Oracle Transactional Business Intelligence Forum
-
How to display one record in two different languages in OTBIHi everyone, I created an OTBI report and clients want to view the output in two different languages. For example: a client creates a job request and that job is shown i…Saher 11 views 0 comments 0 points Started by Saher Oracle Transactional Business Intelligence Forum
-
I'm trying to use a formula that results in a percentage, but instead i'm getting a integer numberHello Oracle Community, This is the formula, that I'm using, (Value A * Value B) / (Value C * Value D) The selected column is the final result of that formula: But, the …
-
BI Publisher ReportDear All, I edited a BI Publisher report, but the modification appears only for the user who modified this report. What should I do to resolve this issue? Please advise,George Mattar 71 views 4 comments 0 points Most recent by Simonab-Oracle Oracle Analytics Publisher Forum