Popular Tags
- OTBI 1,508
- Reporting 1,423
- FDI 1,306
- Fusion AI Data Platform 1,054
- Analysis and Data Visualization 1,017
- BI Publisher 900
- Analysis 699
- Oracle Fusion Analytics 635
- OAC 591
- Administration 566
- Fusion HCM Analytics 459
- Fusion ERP Analytics 455
- Analytics 454
- OBIEE 444
- BI Publisher Data Models 371
- Security 305
- Oracle Analytics Cloud 300
- HCM 295
- Fusion Data Intelligence 289
- BIP 272
- Fusion Data Intelligence FDI 268
- Answers 267
- Analyses 258
- Developers 250
- Data Modelling and Datasets 238
Reporting
Discussion List
-
10Function to convert Timestamp to different timezonesDescription Need a function in OAC to convert timestamp from one timezone to another, either in the prepare stage while creating the dataset or in visualization calculat… -
Is it possible to show the "job" of the manager in the "Assignment Manager (Unsecured)" Dimension?I am creating a report to look at if employees who are direct or indirect reports for a manager are in the same function area. For example, if a top level manager is HR,…Max W 21 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence Forum -
13MyCalculation - Order by Name and by Attribute/MeasureIn FAW/OAC, we would like the ability to sort the My Calculations folder. The ability to Sort by Attributes/Measures and then by the name of the Calculation would be ide… -
Project Number for Payables Invoices in JournalsGood Day, Where can I pull the correct project number field for payables sources? We use 3 subject areas for our report where both Journals Real Time are mainly used: - …JMLMIII 31 views 3 comments 0 points Most recent by Gianni Ceresa Oracle Transactional Business Intelligence Forum
-
How to present % sign in Analysis?How can we present the % sign in Analysis? We could not find the % symbol in FAW. This is needed for our reports as some of the reports show comparative analysis and req…Syed Fahad 52 views 5 comments 3 points Most recent by Krishna Prasad Kotti-Oracle Oracle Fusion Data Intelligence Idea Lab -
5Description not available when selecting hierarchy, only code is availableIs it possible for the user to see the account description in addition to the account code? Presently when we select hierarchy it only shows the code and there is no opt…Syed Fahad 21 views 0 comments 5 points Most recent by Syed Fahad Oracle Fusion Data Intelligence Idea Lab
-
4Searching all the levels for any dimensionIs there a way to say search all levels? For example if we want to search any account code which appears in multiple levels or hierarchies how can we achieve that. For i…Syed Fahad 61 views 0 comments 4 points Most recent by Syed Fahad Oracle Fusion Data Intelligence Idea Lab
-
recruiting - recruiting event real timeHello Expert, I need your help. recruiting - recruiting real time recruiting - recruiting event real time I'm using above mentioned two subject areas to get the recruiti…Saher 31 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence Forum
-
How long does ERP data gets committed to Oracle databaseHi, This question is raised due to a production issue we had when extracting reports from the ff table: AP_HOLDS_ALL PO_DISTRIBUTIONS_ALL These are 2 out of 34 tables th…mikaromo 11 views 1 comment 0 points Most recent by Rajesh L-Oracle Oracle Business Intelligence Applications Forum
-
OTBI_PIVOT_INDEXHi, If anyone knows how to use index on pivot table in OTBI, I would greatly appreciate your help. Thank you. Regards, MelekMelek Cinar 11 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence Forum
-
How to transpose data from rows to columns in OTBIHello Expert, I want to show row data as column I have two types. Personnel No and Account Name, and I want to show these two values as column and identifier as data lik…Saher 211 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Oracle Transactional Business Intelligence Forum
-
Security audit logs for the systemI am trying create Bi report that has table and columns that show the detail to who add delete and edit the data such as the user and their email etc.Khalid Aldosari-Oracle 131 views 8 comments 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher Forum
-
Maximum report data size for offline (scheduled) reports value changeHi Team, Greetings! How do we change the value for the parameter "Maximum report data size for offline (scheduled) reports value change" as highlighted in below screensh…Parag Hiremath 41 views 1 comment 0 points Most recent by Prabhu Krishnamoorthy -Oracle Oracle Transactional Business Intelligence Forum
-
Saved Customization report being deleted in OTBIUser cases: There are multiple users encountering deleted saved customization report in OTBI and it happens intermittently. Description of need: To have an audit log on …Nicole Sy 21 views 2 comments 0 points Most recent by Nicole Sy Oracle Transactional Business Intelligence Forum
-
Payroll Legal Entity Registration Unit Field NavigationHello everyone, I have a requirement that needs to be pulled into the report, and I want to map it first in the UI/Front End. Can anyone provide where to find this field…Chris Carloff 11 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Oracle Transactional Business Intelligence Forum
-
How can we confirm impacted reports before removing the subject area access from some rolesThere are many reports are developed using some subject area and saved in different folders. Can i check how many reports would be impacted before removing the access? F…Manoj Yadav 4 views 1 comment 0 points Most recent by Bharat Agrawal Oracle Transactional Business Intelligence Forum
-
Parameters Failing to Load on BIPSummary When trying to run a report in BIP, the parameters are blank Content Hi All, When I'm trying to run a report in BIP, I am getting entirely blank space where the …Luke Sharma 286 views 5 comments 0 points Most recent by User_VM7CY Oracle Analytics Publisher Forum
-
Due Date field from Receivables Transaction Real Time is not displaying any data/valueEven though we tried with the most basic fields but the Due Date value is not getting displayed (Screenshot 1). Only when we are adding due date field from Receivables: …Rahul Kumar Gupta.-Oracle 42 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence Forum
-
OAC DV Dataset not visible in BIP Data ModelI've created a data set in OAC DV which is based on Essbase cube, the data set is accessible from DV and Analytics but when I'm trying to create a Data Model using DV Da…SaurabhJaiswal-Oracle 173 views 3 comments 0 points Most recent by GayathriAnand-Oracle Oracle Analytics Publisher Forum
-
Embedding OTBI Report Directly in HCM without Page Composer or Page IntegrationHi there, I'm wondering if there are other ways to embed reports or include links to reports directly in HCM without using Page Composer or Page Integration tools. I saw…Ruby Hui 72 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence Forum