-
Fusion Analytics Autonomous database series: Understanding the default schema's provided
Oracle Fusion Analytics Warehouse provides default schemas (also known as users) such as the ADMIN schema and OAX_USER schema. You can create custom schemas to meet your customization requirements. The ADMIN schema enables you to access the Oracle Autonomous Data Warehouse instance associated with your Oracle Fusion…
-
NEW! Oracle Fusion Analytics Product Roadmaps
All, You can now find the Oracle Fusion Analytics Product Roadmap in the Knowledge Center:
-
How to remove duplicates from multiple subject areas?
We are trying to configure an OTBI report having the following subject areas: Workforce Management - Workforce Real Time, Workforce Management - Workforce Event Real Time, Workforce Management - Person Real Time, Workforce Management - Work Relationship Real Time, Workforce Management - Planned Schedules Real Time,…
-
Direct Report Headcount
In FAW, we want to generate reports that outline the Span of Control for Direct Reports using the delivered SA and there's no delivered fact for direct report headcount so far. How do you report out the direct report headcount of each manager? Thank you! Rgds, LipLooi
-
Only to include THEN VALUE not the ELSE value of CASE STATEMENT who have both input values
We are trying to pull out a input value by using the following case statement: CASE WHEN "Payroll - Element Entries Real Time"."Element"."Element Name" IN ('Incentive Plan') THEN CASE WHEN "Payroll - Element Entries Real Time"."Input Value"."Input Value Name" IN ('STI Target%','STI Target %') THEN "Payroll - Element…
-
Can we customize the labels of 9 box in the talent review tab of line manager dashboard report
Can we customize the labels of 9 box in graphical view in the talent review tab of line manager dashboard report
-
Fusion Analytics Autonomous database Series: Exploring Data loads with ADW
Oracle Autonomous Database provides many different options to load data into your database. Oracle Database Actions provides a web-based interface with development tools, data tool, administration, and monitoring features and lets you load or access data from local files, from cloud storage, or from remote databases. This…
-
Fusion Analytics Autonomous database Series:Exploring ADW Performance Telemetry
Database statistics provide information about the type of database load and the resources being used by the database. To effectively measure database performance, statistics must be available. Oracle Database generates many types of cumulative statistics for the system, sessions, segments, services, and individual SQL…
-
HCM Analytics - statuses of workflows
Hi, In FAW is it possible to have an overview about workflows and theis statuses? What are the existing workflows for vacation, termination, changing personal information, offer, expenses and who is holding (approval) the process? Thanks,
-
Fusion Analytics Autonomous database Series
Playlist includes topics on Autonomous Datawarehouse- Connecting via SQL developer Autonomous Datawarehouse- Schema Exploration Autonomous Datawarehouse -Using Custom Schema Exploring Autonomous Data Warehouse (ADW) Exploring Autonomous Data Warehouse- Performance Telemetry Exploring Data loads with Autonomous Data…
-
How to get Data Actions to show up with multiple data anchors?
When creating a data action, if multiple data anchors are selected, the data action disappears altogether. The current workaround is to create a data action for each fact needed, but this creates a lot of clutter and repeated work. Is there any way to get them to show up even with multiple data anchors?
-
Fusion Analytics Tech Tips : Custom Case Study PVO using Data Augmentation and Semantic Modelling
The document describes how to extract data from Fusion through data augmentation in FAW and then use it to build new subject areas . If your use case is The basic procedure The steps you'll need to take include: Prerequisite for custom public view objects Understanding the source data Data Augmentation process Data…
-
Fusion Analytics Tech Tips: Creating a custom data model using the Semantic Model Extensions
There may be times when the many ready-to-use data models provided in Oracle Fusion Analytics Warehouse (FAW) don't fully cover the extent of the reporting you want to do. Fortunately, FAW is highly customizable and allows you to create custom data models using the semantic model and any externally sourced data source.…
-
Fusion Analytics Tech Tips –Salesforce Data Extraction using OAC Dataflows
Salesforce is a leading CRM software application with a wide customer base, Hence often Oracle FAW customers like to compliment the vast analytical capabilities provided by Oracle Fusion cloud data with the custom data sourced from Salesforce.com ( Commonly referred to as SFDC), This is an easily achievable objective, we…
-
How to properly average the differences in dates by month?
We are looking to create a new measure which will subtract the dates 'Requisition Line Approval Date' from 'PO Creation Fiscal Date'. Then we would like to Average the result by a monthly basis. The goal would be to have a bar chart with monthly average for the difference of the dates. We are able to get the proper result…
-
Fusion Analytics Autonomous database Series: Introduction
Autonomous Data Warehouse Oracle Autonomous Data Warehouse is the world’s first and only autonomous database optimized for analytic workloads, including data marts, data warehouses, data lakes, and data lakehouses. With Autonomous Data Warehouse, data scientists, business analysts, and nonexperts can rapidly, easily, and…
-
Fusion Analytics Extensiblity Series: Case study-Data Augmentation (Part 2 of 4)
In this series, we will discuss the use case and showcase the steps to bring in the custom object (created in Oracle Fusion Application) into Fusion Analytics and model it for analytical reporting. This is a 4-part series. The current part covers the Data Augmentation Part 1- Use-Case Discussion. Part 2- Data Augmentation…
-
Asset Joins for Disposal and Additions BIP report
We have added 4 joins and the 4th join below is causing a time out issue and can't figure out a way around it. We are using parameters and a date range of only a month via scheduled process. We will be adding the Period as a parameter as well, but at this time we have not done so, due to this other issue. LEFT OUTER JOIN…
-
would to customize settlement letter on netting receivable
I would to customize settlement letter on netting receivable, but it 's denied to change. Who can gui me to change it. thanks!
-
API to create Subledger Adjusting Journal Entries in Accounts Payable
Hi 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 do so?
-
How to apply SUMIF in FRC ?
few codes will give negative balance while few codes will give positive balance we want sum total of all positive amount together and sum of all negative amount together. but these balances keep changing from positive to negative.
-
Moved: OTBI: Join Corporate Card Data with Expenses Data
This discussion has been moved.
-
How to create balance the transaction
In current process if a transaction was unbalanced at total debit and total credit at the time of transaction creation system was picking the rounding off account from the specify ledger option and balancing out. but we need a solution at the AHCS level either by formula to be created and attached to JLR . so that which…
-
Adding a parameter at performance document level
Hi Team, We are trying to add a parameter to the report (which renders performance rating information of the employee) and attaching it to the instruction of a questionnaire. Our expectation was as soon as the manager accesses that report, it should open up and show the data only of that particular employee for whom…
-
Create Better Reports in Fusion CX Analytics
Learn how to create effective and timely reports in Fusion CX Analytics by using the Reporting Authoring Tips that are updated regularly in the Reference for Fusion ERP Analytics. Tips include filtering, brushing, currency, performance, and much more. Follow this link to start creating better reports today!
-
Create Better Reports in Fusion SCM Analytics
Learn how to create effective and timely reports in Fusion SCM Analytics by using the Reporting Authoring Tips that are updated regularly in the Reference for Fusion SCM Analytics. Tips include filtering, brushing, currency, performance, and much more. Follow this link to start creating better reports today!
-
Fusion HCM Analytics at Oracle CloudWorld 2023: Don't miss these sessions!
Joining us at Oracle CloudWorld this year? I've gone through the list of sessions and picked out the ones that I wouldn't want to miss for Fusion HCM Analytics! People-first Leadership with AI & ML-powered People Leader Analytics Oracle Fusion Analytics Roadmap, Strategy, and Vision Oracle Analytics Cloud Roadmap,…
-
Fusion Data Intelligence Tech Tips : Playlist
This playlist includes topics on Implementation pre-requisites Creation and deployment of Bundles and its best practices Semantic Model best practices Data Augmentation objects Parameters and Prompts in Data Visualization BLS, and Eloqua managed connectors Transformation feature in Data Augmentation Data Pipeline event…
-
Difference between data Augmentation and semantic model extension in FAW
I am learning FAW and have some doubts around data augmentation and semantic model extension. As per my understanding data augmentation is used to bring additional attributes/DFF from existing subject area but we can not create new subject areas. in Sematic model extension, we can bring the data from any source but it…
-
How to validate data in FAW?
Hi, I have followed all the steps mentioned in Oracle document to create an user to validate the data after load in FAW. But still when tried to provided the Source Credentials under Data Validation for the user created, there is an error saying 'The user does not have appropriate privileges in the source system' Am I…
