Welcome to the Oracle Analytics Community

Popular Tags
- OTBI 949
- Reporting 844
- Analysis and Data Visualization 647
- Analysis 572
- BI Publisher 506
- Administration 499
- obiee 282
- reports 282
- Oracle Fusion Analytics 240
- Analyses 237
- Developers 223
- BI Publisher Data Models 213
- FAW 212
- Data Connectivity 184
- Data Modelling and Datasets 160
- OBI Answers 150
- security 143
- Report Output 133
- Agents 130
- Packaging and Licensing 124
- Home and Catalog 116
- ERP Analytics Content 109
- HCM 105
- OBIEE Answers 102
- Access and Manage Data 102
fusion
Discussion List
-
OTBI: Find the number of Working/Business Days between two dates and exclude Public HolidaysSummary OTBI: Requirement to find the number of Working/Business Days between two dates, therefore the calculation must exclude days that fall on Weekends or Public Holi…rbeet88 352 views 7 comments 0 points Most recent by RichardChan Oracle Transactional Business Intelligence
-
FUSION ANALYTICS: Automate The Uploading Process of Data Files for Oracle Object StorageDisclaimer - This script is provided as an example, and its use is at your discretion. Oracle can’t warrant its execution in your environment or support its output in yo…Amarpreet Nagra-Oracle 16 views 0 comments 0 points Started by Amarpreet Nagra-Oracle Fusion Analytics Warehouse
-
How to get active bip session token from front end of standalone application?Hi, How do we get the active bip session token from Fusion to the standalone application after logging in to Fusion like sso login? Thanks in advance Srimathi
-
Table to retrieve records from Audit reports in Oracle Cloud Fusion ERP 22ASummary: Table to retrieve records from Audit reports in Oracle Cloud Fusion ERP 22A Content (required): Which table in SaaS stores information for Audit Reports? Table …Abhilash K - Deloitte USI 259 views 5 comments 0 points Most recent by SyedMustafaArshad Oracle Transactional Business Intelligence
-
How to restrict the PPM contract data based on the roles of the user logged in in OTBI DashboardSummary: We are trying to restrict the data based on the roles available for the user logged in specifically Principal Investigator role (PI role). Content (required): V…Abhilash K - Deloitte USI 76 views 5 comments 0 points Most recent by Naresh313 Oracle Transactional Business Intelligence
-
We have created few OTBI Infolets and enabled it through sandbox at Sales InfoletsHi Experts, We have created few OTBI Infolets and enabled it through sandbox at Sales Infolets, but these sales infolets are not visible to other users. We need to enabl…Shankar AyyalaSomayajula 42 views 3 comments 0 points Most recent by Shankar AyyalaSomayajula Oracle Transactional Business Intelligence
-
Can we find where an OTBI analysis is used in other items (filter/result of another analysis)We need to make some changes to an OTBI analysis which is used as filter in other analysis/dashboards. Is there any way to find out by which dashboards and analysis this…MaartenDIF 1 view 0 comments 0 points Started by MaartenDIF Oracle Transactional Business Intelligence
-
API to create Subledger Adjusting Journal Entries in Accounts PayableHi All, We are trying to automate the process of creating a subledger adjusting journal entries in account payables and wanted to check if we have any API available to d…
-
4A live lab session for Parameter creationOrganization: Baylor University Many of the workbooks and reports my team and I create would benefit from the use of the parameters tool. However, creating parameters ha…CarolineAnderson 81 views 2 comments 4 points Most recent by Jamie Anderson-Oracle Fusion Analytics Warehouse Idea Lab
-
15Access to BPM Rejection/Approval Rules from BI Reporting toolsWe had a requirement where for a POET report, we had to fetch BPM rejection rules. This rejection rules were applicable for both POs, PORs. We could not find a way to ex…
-
2Access to BPM Rejection/Approval Rules from BI Reporting toolsWe had a requirement where for a POET report, we had to fetch BPM rejection rules. This rejection rules were applicable for both POs, PORs. We could not find a way to ex…Mayank_Khatri 11 views 0 comments 2 points Started by Mayank_Khatri Fusion Analytics Warehouse Idea Lab
-
R13.x Deprecated and New BI View ObjectsSummary This posting includes R13 deprecated Business Intelligence View Objects (BIVOs) that are unavailable for extraction using BI Cloud Connector (BICC) in Oracle App…Rashmi M-Oracle 2.6K views 20 comments 1 point Most recent by Sridhar_Rejeti_1423 Oracle Transactional Business Intelligence
-
Create a Pre-Enrollment Validation Formula for Benefits PlanI have a requirement that needs a validation is the sum of 2 Plan is 5%. But i'm having trouble to find a Fast Formula if the employee is a new hire. because there is on…
-
How do get BI Publisher session token?Hi Experts, How do we get the active bip session token from Fusion to the standalone application after logging in to Fusion like sso login? Thanks in advanceUser_1U7TA 54 views 1 comment 0 points Most recent by PareshSharma Oracle Business Intelligence Applications
-
For data augmentation is it best to place the new data into existing folders or create new ones?When augmenting data, do you typically place your new measures and attributes into existing folders with related data or into new folders? How do you distinguish between…CarolineAnderson 11 views 1 comment 0 points Most recent by Rajesh L-Oracle Fusion Analytics Warehouse
-
Selecting the latest Order revisionSummary Need to retrieve the latest Orders revisions Content Hi, While creating an Analysis to retrieve the Sales Orders details we need to show only the latest revision…Mr H 136 views 10 comments 0 points Most recent by User_259TP Oracle Transactional Business Intelligence
-
3Integrate FAW's Decks and Cards into the Fusion HomepageI propose the integration of FAW's Decks and Cards into the Fusion homepage as a replacement for the slow and outdated Infolets. The modern interface of Decks and Cards …CarolineAnderson 21 views 0 comments 3 points Started by CarolineAnderson Fusion Analytics Warehouse Idea Lab
-
OTBI Report Performance IssueSummary: Customer facing performance issue with the reports developed using OTBI Content (required): Customer developed some of the reports using OTBI reporting tool whe…Praveen Gollu-Oracle 143 views 3 comments 0 points Most recent by Sahithi Kolasani-Oracle Oracle Transactional Business Intelligence
-
1Customer security deposit and its refundFunctionality is required to track the security deposit that is collected from customers and returned to them. Interest should be charged on the deposit at the agreed-up…pavan.x.kumar 21 views 0 comments 1 point Started by pavan.x.kumar Oracle Analytics Cloud and Server Idea Lab
-
Is it possible to do map visualisations in OTBISummary Is it possible to do map visualisations in OTBI Content Hi, Using only Oracle Transactional Business Intelligence (OTBI) with all the limitation of old Oracle Bu…Nathan CCC 67 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
General question have if I move any another orginaizationSummary: Hi Team, If future chance to move other organization from current one, how can i access my current cloud customer connect beacuse i have login through my curren…AjayKumar Maddipati 36 views 2 comments 0 points Most recent by Mandeep Gupta Oracle Transactional Business Intelligence
-
Finding the alphabets from a Alphanumeric in OTBI.Summary: I have a requirement to identify the alphabets (be it upper/lower case) from a string. The format of the sting is as follows: SSN: XXX-XX-XXXX (112-10-1234) TIN…satya_nvs 79 views 2 comments 0 points Most recent by Venkat Koduvayur-Oracle Oracle Transactional Business Intelligence
-
Count positive values and compare with total count to get the aggregated share of positive valuesSummary: How can I count the number of positive values in a column and compare with the total count to get the share percentage of positive values? Content (required): I…Stefan pettersson 67 views 3 comments 0 points Most recent by Stefan pettersson Oracle Transactional Business Intelligence
-
How to create formula to show PR where all lines have processed requisition line flag as yesSummary: We are trying to create an analysis to display those particular requisitions where all lines are processed successfully into PO Content (required): Need help to…JITHU JOSE 47 views 4 comments 0 points Most recent by JITHU JOSE Oracle Transactional Business Intelligence
-
Facing Issue in calculating percentage for an Analysis in OTBISummary: We are trying to create a custom analysis to calculate the month wise percentage of delivered amount being early received including tolerances. We have calculat…Palak Karma 123 views 7 comments 0 points Most recent by Palak Karma Oracle Transactional Business Intelligence
-
Issue with deep link Functionality in OTBI AnalysesSummary: We need a functionality within OTBI Analyses where we click on a particular graph of the analysis, it redirects to the SaaS Page which has particular set of rec…Palak Karma 117 views 3 comments 0 points Most recent by Gaurav Bharadwaj-Oracle Oracle Transactional Business Intelligence
-
Issue with developing analyses for requisition to purchase order cycle timeSummary: We are trying to create a custom analyses as per requirement of customer to analyze the purchase requisition to purchase order cycle time but not able to identi…JITHU JOSE 46 views 2 comments 0 points Most recent by JITHU JOSE Oracle Transactional Business Intelligence
-
Issue while creating analysis using Max and Avg functions in new calculated measure.Summary: We are trying to create a analysis for sales order processing lead time, but we are facing issue as the new calculated measure using avg function is not giving …JITHU JOSE 39 views 3 comments 0 points Most recent by Jahnavi-Oracle Oracle Transactional Business Intelligence
-
Report Location of following seeded reportsHello - We are having a request to implement/customize the following reports but will have to analyze first the complexity of each report. Unfortunately, we are unable t…ZenG 107 views 2 comments 0 points Most recent by Gaurav Bharadwaj-Oracle Oracle Transactional Business Intelligence
-
OTBI Usage and Performance Dashboard SampleReal Time OTBI Usage & Performance Two subject areas are available to monitor OTBI usage and performance: OTBI Usage Real Time: Monitors OTBI usage, including user, anal…Noelle Bartlam-Oracle 675 views 23 comments 0 points Most recent by Community DW Integration Oracle Transactional Business Intelligence