Hello @Shradhanjali, If CSE_ASSETS_B was configured as the Asset DFF source, an Asset-related folder/attributes should become available after activation and data load. The documentation is here for https://docs.oracle.com/en/cloud/saas/analytics/26r3/fascm/manufacturing-subject-area-metric-details.html Possible causes…

Hi @Priya Parthiban, A successful Absence Management reload should refresh data and it should not normally remove local subject areas. Was that a Production instance? Check permissions first. If that does not help and if you have the same Local SA in a Dev instance, you could migrate it to Production in a Semantic Model…

Hello @User_UFO63, That would be unexpected behavior that might require a SR. Try these steps to see if the issue persists. Make a copy of the workbook before editing the Data Action, so you retain the working configuration if the save fails. In the Data Action, use Anchor To → Add Data and add all required columns in one…

Hi @Rich R, OK so you are including 'Manager Person Number' in the Workbook so a separate result is displayed for each manager? SUM(...) combines results across multiple rows/managers. That is useful for totals, but it can turn a manager-level result into the same rolled-up value repeated on every manager row.…

Hi @Shivalik, Yes, you can create a Data Augmentation followed by a Semantic Model extension using source objects other than PVOs. See the documentation here: https://docs.oracle.com/en/cloud/saas/analytics/26r3/fawag/augment-data.html Regards, John

Hello @Rich R. "Current" would have to be as of the time of the last Pipeline. You would have to start by creating a Data Augmentation to bring in any required HCM source attributes that don't already exist in Workforce Core. Then create a custom fact. In FDI Console → Application Administration → Semantic Model…

Hi @Richard Halford I think the SR is the best way to go on this issue. I have not heard of others having this issue after the 26.R3 update. If you are getting a 500 error, that is pretty serious and it would need to be addressed with urgency via a SR. Regards, John

Hello @Keerthi Chinthapatla In case you need additional details, the OTBI community is here Oracle Transactional Business Intelligence Forum - Oracle Regards, John

Hi @Govardhana Gurumal I see you posted this question a while ago and did not receive a response. If you created the MV with an automatic refresh and then based a SME directly on that MV, you don't need to refresh it. Also, derived data is not included in the FDR functionality. See the documentation here:…

Hi @Piotr Kiewro A Local Subject Area is not the starting point for using HCM in FDI. You would need to configure and activate the HCM functional areas in FDI. The documentation starts here: https://docs.oracle.com/en/cloud/saas/analytics/26r2/fahia/offerings-functional-areas-hcm.html and the documentation for activating…

Hello @Armia Garas, At minimum, you should assign each user the relevant module’s FDI Consumer group in OCI IAM: FAW_LICENSED_ERP_CONSUMERS FAW_LICENSED_HCM_CONSUMERS FAW_LICENSED_SCM_CONSUMERS FAW_LICENSED_CX_CONSUMERS This gives home-page/shared-content access only—no Console, pipelines, connections, data flows,…

Hi @User_VY0EK Yes, you need to run a full load after a P2T. Regards, John

Hello User_VY0EK, What you’re seeing is expected. FDI does not provide a live percentage-complete display or a real-time functional-area-by-functional-area completion tracker for a data-source Reset & Reload. You can see: Request History — Console > Data Configuration > Request History Pipeline Settings / Last Refresh Date…

Hello @Maddy Clayton We may need to see the logical SQL to help with this. We have not seen fan traps on this but it could be a grain issue caused by an effective-dated join overlap or use of multiple facts. Start building a new workbook with a single Workforce Core fact and a delivered distinct worker/headcount metric.…

Hi @SaravananPandian You could create multiple Canvases, each with its own Pivot. Also, one Dashboard could include multiple pivot Visualizations. You generally can’t merge several existing pivot views into one. Build one pivot from the combined data instead. If the pivots are from the same FDI subject area: Create or edit…

Hi @Rosita Santosuosso, BI reports do typically timeout after running for 10 minutes. If the issue is limited to one user, that user likely has access to more data than the rest and a default filter should be added to the report. The goal should be to define reports to run in a minute or less. See these OBIA Performance…

Hello @Abd_Razak_Mohamed As Mandeep said, there is no standalone Negotiations Subject Areas but there are many Negotiations related metrics in the Procurement Subject Areas as described here: Procurement Regards, John

Hello @User_P7BGD The workaround with the CSV mentioned by you and Brendan is the only alternative. As mentioned in the documentation here: There are different row limits for formatted and unformatted data and it is dependent on the Compute size. What Sizing Options Are Available to You? Unformatted data limit: Comma…

Hello @Ajinkya V , No. FDI does not natively support “consume Subject Area A but author only against Subject Area B” for a single user identity. In FDI, authoring is a user-wide capability. If a user has the Author system role, they can create workbooks against every subject area they are permitted to read. The Read-only…

Hello @Ajinkya V , No, FDI does not currently document a supported role configuration that provides all three requirements simultaneously: DV consumption only. DV workbook export. No visibility or access to Classic. Creating a custom role may be possible but HCM security is complicated enough and you should stick with the:…