Hello @Kauan_Bohn, Thank you for the question. This is likely possible in FDI Subject Areas without having to search for a Foreign Key but it seems like your question was not intended for the warehouse side. You may want to pose this question here: https://community.oracle.com/products/oracleanalytics/categories/otbi…

Hello @Anders W. Langholm, I see you never received a response on this question. We would probably need to see the SQL to offer more. In general, filtering on a Description can be problematic because they vary. It looks like your "Medarbejdernummer" column and the description column are the same thing. Do you have multiple…

Hi @Anupam Chaudhari, The 'accounted' requirement is the same for many functional areas and it will not be extracted from the source until it is accounted. You could use OTBI to queries on the source side or create a customization for the same on the FDI side. Regards, John

Hello @Prasath Thank you for the question. I have not seen this exact error before but the steps to setup the approved sender are here: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/use-smtp-mail-server-oracle-cloud-infrastructure-email-delivery.html You can Create approved senders here: Hope that helps.…

Hi @Bhumin Kamdar, Thank you for the question. The answer is probably 'it depends'. If you are using OAC in a standalone way and EPM>PBCS is your only source, then OAC's Oracle EPM Cloud connector would likely be the best choice. If OAC is being used as a part of FDI or if you have other data sources and especially other…

Hello @Anders W. Langholm, Thank you for the question. I do see a "HCM - Workforce Core"."Citizenship"."Nationality" and "Nationality Code". Does this give you what you need? Regards, John

Hello @FDI_USER, Thanks you for the question. First, a prerequisite for Oracle Fusion ERP Analytics is to link financial categories with natural accounts. The documentation on that prerequisite is here: After confirming that, the steps to map data security assignments to users to enable data level access is here: Lastly,…

Hi @Paras Negi, Thank you for the question. To start troubleshooting this issue, you should query this same data using the two Natural Account Names and both Fiscal periods in the source using OTBI. If you see data in the source for Fiscal Period Jan-25 for the Natural Account Name ending with *100, then create a similar…

Hello @Anna-MariaP, Thank you for the question. It appears to be intended for the Fusion HCM or OTBI Community. You can access the OTBI community here: https://community.oracle.com/products/oracleanalytics/categories/otbi Regards, John

Hi @Raluca Balan-Oracle, To clarify a couple things from your question.. Does this user have access to the Dataset? Is this user able to add fields from the Dataset to the Workbook and return data successfully? Thanks, John

Hi @A.J., I didn't realize it when I first responded but we did have a Bug on this and it was scheduled to be fixed in the 25.R2 release. For your reference, the Bug number is: 37830535 Regards, John

Hello @A.J.. Your results are a little unexpected. This issue may require a SR. As a test, could you replace your Assignment Category Code and Assignment Category from the HCM - Positions Subject Area with the same from the HCM - Workforce Core Subject Area as follows: It would be interesting to see if you get different…

Hello @User_WYAB5, Thank you for the question. This is the FDI forum (Oracle Fusion Data Intelligence). Questions related to FRS (Financial Reporting Studio) can be answered by the Oracle Fusion General Ledger Cloud Service (Fusion Cloud ERP) forum here: https://community.oracle.com/ou/categories/financials Regards, John…

Hello @User_WYAB5, Thank you for the question. This is the FDI forum (Oracle Fusion Data Intelligence). Questions related to FRS (Financial Reporting Studio) can be answered by the Oracle Fusion General Ledger Cloud Service (Fusion Cloud ERP) forum here: https://community.oracle.com/ou/categories/financials Regards, John

Hi @PRATHEEK, As Bhaskar mentioned, someone else will need to chime in regarding the licensing question or you could talk to your salesperson about that. To add to Bhaskar's comments, one of the main advantages of FDI is the ease of integrating external data and in my experience most customers are doing that. We could…

Hello @Neha Bhatt, It sounds like this issue may be on the Fusion Applications ERP side so you should pose the question here: https://community.oracle.com/products/oracleanalytics/categories/otbi or here: https://community.oracle.com/customerconnect/categories/fusion-apps-administration-forum In this community, we address…

Hi @User_UE94E Please post OTBI questions to this forum: https://community.oracle.com/products/oracleanalytics/categories/otbi Regards, John

Hi @Pedro Peña The Reference Guide including Absence Plans is here: https://docs.oracle.com/en/cloud/saas/analytics/25r2/fahia/appendix-report-authoring-tips-hcm.html#GUID-BC4E8F24-F348-4810-B164-20C044FAED96 You should see: Content based on facts in the Employment Plan Participation folder: Time – Year/QTR/Month* or Time…

Hi @Molly P, It looks like you posted this a while ago and did not get a response. The documentation you mentioned is still the primary source of migration information and it does document a manual process. This is supplemented with KM Article number: KB171076 Regards, John

Hi @PRATHEEK, We may need to get some additional information to answer this fully like the logical and/or physical query. A SR may be required for that unless you can hide the PI. Do you have a Time dimension in this Workbook? One example of something to check is your Aggregation Method. In OAC, with the Workbook open and…