-
Export data from FAW to Excel
Hello, Is it possible to export data from FAW to Excel for use in another application? Is there any internal feature available for this purpose? If not, what would be the suggested solution?
-
"Reset the Data Warehouse" Running for very long time
Summary: Hi All, We tried the "Reset the Data Warehouse" option in FAW and this is running for very long time 12+ hours. We are getting this banner after that. Any inputs on how long it should take to complete this ? Thanks, Bharath Content (required): Version (include the version you are using, if applicable): Code…
-
DFF's on Configurable Account Analysis
Hello All, Is there any way to add DFF's from your Journal Lines to the configurable Account Analysis? It is available in the OOTB Subject area but would like to know if anyone has any work around or ideas for how to accomplish this.
-
If customer dimension is not added to segments,will it impact analytics around customer
If customer dimension is not added to segments,will it impact analytics around customer .What level of reporting can be done around customer with other segments or do we have any restiction on same.
-
NEW! Oracle Analytics Summit London 2024!
NEW! Oracle Analytics Summit London 2024! 🇬🇧 Join the Oracle Analytics product leadership team and the Oracle Analytics Leaders on March 13 for a full day of conversation and collaboration with Oracle Analytics Executive Vice President T.K. Anand and GVP Product Management Gabby Rubin & Stefan Schmitz to discover the…
-
NEW! Oracle Analytics Summit London 2024!
NEW! Oracle Analytics Summit London 2024! 🇬🇧 Join the Oracle Analytics product leadership team and the Oracle Analytics Leaders on March 13 for a full day of conversation and collaboration with Oracle Analytics Executive Vice President T.K. Anand and GVP Product Management Gabby Rubin & Stefan Schmitz to discover the…
-
Goal Plan assignment
Hi all, We need to create a DV for tracking the performance goals status, per review period and per business unit. It should display how many distinct employees have created 1 or more performance goals in their goal plan. It should also display how many distinct employees have not created any performance goals. The FAW…
-
Which FAW table stores indirect Reportees data?
I am looking for a table/column in FAW that stores the data for indirect reportees of a manager. dwc_manager_dn_dh_tbl table stores the data for direct reportees only (i.e., where manager type is LINE_MANAGER) I want to see where the other manager type, for instance, Global Directory Manager of a person is being fetched in…
-
Fusion Analytics - Data Pipeline is Disabled Notifications and Action Plan for FAW Admin
Please note FAW Admin Email/Alias provided in FAW OCI Console will receive notifications if there is any new-release/upgrade/error-issues etc notifications for the FAW Instance. We suggest using an Email-Alias in OCI-FAW Console so that any such email notification can be shared/distributed with all FAW Admin team members -…
-
FDI :Playlist on Deployment of artifacts
The Playlist includes the 1- deployment of Bundles for Content, Security, Data Aug, Semantic Model 2- best practices around bundles 3- deployment of Artifacts on ADW 4- deployment of Datasets https://videohub.oracle.com/playlist/dedicated/1_urdg2cxd/1_vpcr728h
-
in FAW implementation videos and documentation FAW ADW Dataguard is not set up.
Only ADW backups are taken daily. In that case how is FAW DR implemented ? As its a SaaS service does Oracel automatically restore FAW in a secondary region ? https://videohub.oracle.com/playlist/details/1_4mvj7205/categoryId/188027173
-
What is the BICC store for FND_USER
I do not find any BICC VO that has mapping to FND_USER, can anyone please provide details.
-
Global Filters Across Subject Areas
Looking to show these two subject areas within one canvas with a shared global filter. Currently only able to achieve this through the classic view dashboard, is this achievable in the Data Visualization? Subject Areas: Financials - AR Transactions Financials - AP Invoices
-
Introducing My Oracle Rewards!
Get involved. Get noticed. Get rewarded. Introducing My Oracle Rewards My Oracle Rewards is our new loyalty program to recognize and reward our customer advocates. With My Oracle Rewards, you'll earn points when you share your Oracle success story that you can redeem for Oracle merchandise, exclusive experiences, exam…
-
Can FAW allow the options to 'Include Filters' and 'Include Title' while exporting to Excel?
When the functionality of Export File is selected in FAW, the toggles to 'Include Filters' and 'Include Title' are only available for PowerPoint, Acrobat, Image and Data. If the user selects Excel (xlsx), the screen changes and only allows to save. The data populates in excel without the filters selected. Can we have to…
-
FAW SCM Module Enablement
Hello, we already have HCM module and we recently enabled SCM module and we can see the catalog objects for SCM...but they throw error with tables and view not available. When I check the Subject Areas, I do not see any SCM subject areas as well. All I can see is catalog objects after enabling SCM offering. Is there…
-
Fusion Analytics Warehouse - How to restrict users' ability to view entire organisation?
I have created a simple dashboard on utilising “HCM – Goals and Career Development” however upon testing for different Manager across our organisation it seems that the Hierarchal security has not applied. Leader can view all goals that have been created across the organisation instead of only being able to view goals of…
-
How to make read only DFF that has value set ?
I have a DFF on a request screen that i want to make it read only but it has value set so when i make it read only the data doesn't show
-
Candidate Source Tracking
HCM does not appear to have full UTM functionality available. UTM Medium & UTM Source are the only paramaters that seem to be available in our environment. What options are available to track specific campaigns, media types, etc?
-
how to set a user preference date format in BIP for PO creation date
Summary: Either it should be mm/yy/dd or dd/mon/yyyy etc whatever user has setup in his preferences Content (required): Can you please help me in how can the date format should be set as per user preferences in BIP report. in my case I'm displaying the PO creation date in RTF, so in the output the date format should be…
-
How to export out the User to Group mapping that is configured in FAW?
I don't see a way to export the user-group-role mapping from FAW. The Security related subject area allows to generate a report wherever Security Contexts are added. There is one for Audits also. But I don't see a way to generate a report that provides a matrix of user-to-group mapping. Is this possible?
-
I am using free tier oracle cloud how to upgraded account for free for FAW subscription
I am using free tier oracle cloud how to activate / upgrade account to use the Fusion Analytics Warehouse.
-
How to change the Database connection in the existing FRS report
Hi Team, While migrating the report to test to Dev1 we are facing problem. Note: We created a report in the Test instance using the GG Database connection. Now the problem is that the report is not working while being migrated to Dev1 instance. Because the Dev1 database connection differs from the TEST instance. Kindly…
-
how to run the request from Schedule Integrations page => Scheduler search custom screen run custom
Good Day how to run the request from Schedule Integrations page => Scheduler search custom screen run custom Physical Stock Adjustment Scheduler from the completion of the prior run. what I need is in EBS if I want to run any concurrent request I have 2 options from the start of the prior run OR from the completion of the…
-
Aggregation Issues in a table
Hi, Is there a way to prevent automatic aggregation for other columns in a table? In this example, I only want the average payment terms to be aggregated by Net Days. Alternatively, is there a calculation that aggregates the average payment terms by net days?
-
Facing issue for using the SUBSTR function with negative number in eText Template
We have requirement to print the last 4 digits from summed value in eText template. We have used the below code to print the last 4 digits but its not working. please let me know if any one of you worked on similar requirement. SUBSTR((SUM(TO_NUMBER(Balance_Record[BASE_BALANCE_NAME=’Net…
-
Workforce Compensation Plan - Submit for Approval Comment field missing?
On the Workforce Compensation Plan landing page, how to we turn on the Comment field in the 'Submit for Approval' popup? We had it last year and now its gone. Not seeing it anywhere in the configuration.
-
Skipped due to an issue with the joins
Hi All, I created a custom dimension using data augmentation in FAW , after the completion , pipeline status in successfully completed whereas the semantic model status shows an error i.e. Skipped due to an issue with the joins . Can someone help me with this please. Please refer the attached screenshot. Thanks.
-
Expression Filter that will exclude the latest/maximum month?
Hi, The challenge here is how to exclude the latest month since Dec-24 is not complete and shouldn't be included in the reporting yet. Also, since I am using the ‘CURRENT_DATE’ function, the earliest month, which is Dec-23, also becomes incomplete.
-
Deploy in minutes the required network components for an Oracle Private Fusion Analytics instance.
If you are considering a private Fusion Analytics instance, read the blog post published today, Deploy Network Components for Oracle Fusion Analytics Service Endpoints. It contains a downloadable package that creates an example network environment in minutes. Use the environment to provision an example Fusion Analytics…
