Hi @User_EBVBI, It depends on the specifics and circumstances of the scenario but since this is a custom table, its in a custom schema so you have control over it and you can manually delete the records. If you also need to delete it from the data source, you may just want to delete it there first and allow your Pipeline…

Hello @Gautham B and @Francisco Mtz. Sometimes this is just a UI issue. Could you check to see if the CAA subject area is available and reports are working for CAA? Regards, John

Hi @Srikanth Reddy Roddam, You followed the right documents. So, what exactly do you mean by 'we are not getting any data in Payroll'? Are the DW tables not populated with any records after your Pipelines complete? If you create new Workbooks with 1 column, do you see data? Regards, John

Hi @Stefano_Mazzocca, What happens if you replace: when User Person Type = 'Somministrato' with when User Person Type like '%Somm%' Also test the 'User Person Type' part of the phase by recreating the Key Metric from scratch. This could be a metadata issue and you may need to log a SR to let us look into it in more detail.…

Hi @Lauriane Massin Whitaker, OAC has a Period Rolling function under 'Time Series Calculations' You should be able to use that to create a calculated column and achieve your goal. Regards, John

Hi @User_3512R, To enable the prediction feature, see the documentation here: https://docs.oracle.com/en/cloud/saas/analytics/24r3/fawwn/index.html#GUID-27505232-5CDD-41B3-9ED2-C253139B49CA If you have a Dashboard error, you could provide the error and circumstance details here and/or in a SR. Regards, John

Hi @User_VZA0C, This question seems to have been posted to the wrong forum. There is a BI Publisher forum here: https://community.oracle.com/products/oracleanalytics/categories/bi-publisher Regards, John

Hi @Kauan_Bohn, To confirm, you want to access your transactional FA data from FDI? You should try to use the FDI Subject Areas first and augment them as required. The OTBI logical SQL should provide some clues on the joins and keys. Regards, John

Hi @User_3512R, Are the OAC performance issues specific to some Dashboards, charts, etc and not others? Is the issue intermittent? If these are custom reports, you could review this blog here for Performance Enhancement ideas.…

Hello @Anders W. Langholm, Supporting References are available in OOTB Subject Areas as for example documented here: https://docs.oracle.com/en/cloud/saas/analytics/24r3/faiae/advanced-configurations.html#GUID-0ACA4711-CE84-470E-837A-42E058310A76 In the title you mentioned Local Subject Areas and the use case for that…

Hi @User_3512R, This preview feature has a lot of caveats and requirements as documented here: https://docs.oracle.com/en/cloud/saas/analytics/24r3/fawag/managing-data-connections.html#GUID-F6A725BC-711F-4303-8512-685CE54C9528 Please review these and verify each requirement is met. Regards, John

Hi @User_3512R, The general information to manage Data Access through Security Assignments, is documented here: https://docs.oracle.com/en/cloud/saas/analytics/24r3/fawag/manage-data-access-security-assignments.html#GUID-F24DA54B-FD00-43B9-9450-095B598240D3 If you have a specific circumstance or problem please log a SR or…

Hi @Rich R, You may need to log a SR for a question like this since its HR related and we could not get a lot of required data on an individual ex-employee here in the community. In general, you could check to see if the status of this employee was 'fixed' in HCM at some point with an updated status well after the fact. If…

Hi @User_3512R, This sounds like expected behavior. One period vs six periods could equate to a huge difference in the number of records. You may want to set defaults on these periods to return the current period only. Then allow user to select more periods as required. Regards, John

Hi @Amanda Hope, To add to what Sumanth said, we also have a KM Article for this: (Doc ID 2970167.1) in addition to the documentation. When you terminate an active instance, the associated Oracle Analytics Cloud and Oracle Autonomous Data Warehouse instances along with data and customizations get deleted. However, the…

Hi @Shiva Uppushetty To add to what Sumanth said, we do have an 'Oracle Enterprise Data Management Cloud' connection type as described here. However, this connection type only supports the CSV data format. CAA does offer more options than a CSV file. Regards, John

Hi @User_VOEDY, I don't think this issue is FDI related. You would need to ask about that here: Welcome to Cloud Customer Connect (oracle.com) Regards, John

Hi @Sathyaprakash M, For '2. Actual BIP report(from Fusion)', there is no Timestamp in BIP so you should look back to the datatype in the Fusion source. Regards, John

Hi @Anand Singh, The Formatted Excel format does have a 25k limit. So, in your Workbook, make sure you are returning all rows. Scroll down to the last record and check how many records have returned. Regards, John

Hi @Sathyaprakash M, We will probably need a little more information to answer this. What is the datatype in the source? Try entering a Date Format and a different Timestamp format.