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: 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. If these are OOTB reports, you should log a SR that includes the Session log from the OAC Console…

Hello @Anders W. Langholm, Supporting References are available in OOTB Subject Areas as for example documented here: In the title you mentioned Local Subject Areas and the use case for that would need to be understood and we would need to get more specifics on what you are seeing. Local Subject Areas are often used as a…

Hi @User_3512R, This preview feature has a lot of caveats and requirements as documented here: 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: If you have a specific circumstance or problem please log a SR or provide the specifics here. Regards, John

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.

Hello @Lauriane Massin Whitaker Security context has a one-to-one relationship with data roles. The contexts are earmarked for users based on data roles inherited through job roles. Security administrators can assign security context values to users to limit access. The users must have the data role through the group…

Hi @ClayJ , To add to what Ashish said, the first Workbook 'Diversity Analysis' is more general in nature and the "Diversity Analysis - Person Count" is more specific and assignment specific. Before reading the Metric Calculation Spreadsheet, you should review the Data Lineage Guide here: Comparing PERSON_ID in the HCM -…

Hi @Billy Mak With an issue like this with totals, you should test it in a Generic Tabular format first. Often times, the issue is limited to the Pivot View. If the issue duplicates in the Table View, you should check aggregation settings and eliminate duplicates within one of the attributes. If you find the Total issue,…

Hi @SERGIO BARRETO , This may be an IDCS "Session Duration" setting. Per DocID: 3008618.1 User Timeouts are controlled by IDCS when IDCS is the only identity provider. To change this for a user from the FAW Console goto Security > Users > Manage Users. Then under "Identity domain" on the left select: Settings > Session…