Hi @Dhruvjoshi23 and @User_S9YE9, Have you checked this since the July 2024 update? Please see the What's New documentation here: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acswn/index.html#GUID-CFF90F44-BCEB-49EE-B40B-8D040F02D476 This includes improved Sankey diagrams to show resources, materials, and costs in…

Hi @User_9STVF Each offering in the FA (OTBI) source like ERP (Financials) has the equivalent of an 'Application Administrator' role. For details See: https://docs.oracle.com/en/cloud/saas/financials/24b/oafrm/Financial_Application_Administrator_job_roles.html#Financial_Application_Administrator_job_roles If you have a…

Hi @Indra Sardana-Oracle , We have a good blog on this topic here: https://blogs.oracle.com/analytics/post/configure-secure-file-transfer-protocol-connector-in-fusion-analytics Multiple data files would require corresponding subfolders. This is intended to complement our documentation on SFTP connections here:…

Hi @kusuma l -Oracle The KM article you are referring to is specific to circumstances where columns were removed from the project and this left stale pointers. The solution to that is: 1. Copy Visualization to new project resolved the stale pointers to columns 2. Retest " Anchor to" functionality. 3. Or Try Re-creating the…

Hi @User_VDH21 , I don't think this part of your request 'irrespective of Department has been set up or not, we want those employees to show' will be possible at this point. In the Organization Hierarchy, the leaf level should always be the department, so the 'irrespective of Department' requirement is not currently…

Hello @User_VKEU7 , I cannot see the error you mentioned. Could you post that and a little more information on how you are navigating to perform this action? If this is an OLTP question and not a Fusion Data Intelligence question, you will need to repost to the correct forum here:…

Hi @Quinn Thacker Variance calculations can be a little tricky because you have to take grain and other factors into account such as the issue documented here: FAW: Unable To Perform Variance Calculations Using Filter Measure (Doc ID 3013134.1). If pricebook rate and quoted rate are in the Fusion CX Source, you can pull…

Hi @JPK To add to what Ashish said, there are also some good Youtube video showing the implementation of FDI. In Youtube, the videos still have the old name so search for "Oracle Fusion Analytics Warehouse" or "Oracle Fusion Analytics". A good start is this video: https://www.youtube.com/watch?v=i91kj4iKrW8 Followed by…

Hi @Scott_Turner_ , It looks like this report has multiple grains. One option may be to add the first calculated column to your semantic model or add it to a data set. Then use that column in your PERIODROLLING calculation. Our documentation regarding PERIODROLLING is here:…

Hi @user13125124, The link you provided is for the FA / OTBI version of BI Publisher. If you want to use an SSL certificate for the Web Serviceconnection, upload the SSL certificate in Upload Center before you define the connection to the data source. BIPublisher supports only the basic authentication. This does not…

Hi @Scott_Turner_ The PERIODROLLING issue may be a little more complicated and I'm not sure that I understand the issue from the screenshot so you may want to start a new thread on that topic to raise visibility or open a SR. The 'Headcount' filed can sometimes have some caveats as could the 'Volunteer Termination…

Hi @Scott_Turner_ Based on your screenshot, you are using a Filter Function and this is the best option for performance considerations. You could also use 'Times series' functions Ago and Todate. You indicated you want to calculate to the end of each period so instead of using Current_Date, you could use: "HCM - Workforce…

Hi @Kevin Riedy You may a great point with this Community Post. It looks like Christine is pursuing this ER but I received your SR on this topic and I've emailed you a zoom invite to review the specific in more detail. Regards, John

Hi @User_9STVF As Arjun said, the newer update of the FAW Console will look like this. The 'Manage Groups' button will send you to the IDCS Console where you can map Licensed groups to other Custom groups you create and generally administer your Groups. Hope that help. Regards, John

Dear @Bakr Elkassas We do not have a standard method to derive the financial category as you requested but it may be possible to derive them by concatenating the main and subcategory together in a new calculated column. However, that should not be necessary since the Financial Category mapping is already defined in Oracle…

@Jose Cordoba Since this augmentation doesn’t exist, it needs to be removed from "Core"."Dim - Custom_DW_EB_X_RCRTMNT_EVENT_F" SME Step.

Hello https://community.oracle.com/products/oracleanalytics/profile/Phalke%2C%20Gayatri There are a lot of options for filters as documented here: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/filter-your-data.html If you don't think you have any use for the inactive Level2 managers anywhere in your DW, you…

Hi Quinn, Under some circumstances, there are alternatives to using the AGO function or Time Series Functions. Filter functions have some advantages including performance as described here: https://blogs.oracle.com/analytics/post/oracle-analytics-performance-tuning-times-series Regards, John

Hi Allen, You would probably need to log a SR to determine the "why" as it could take some digging. To start, We would need to know the invoices in DW_AP_SLA_INVOICE_SCHEDULE_CF where INVOICE_ACCOUNTING_STATUS_CODE is 'UNACCOUNTED' and the data from AP_INVOICES_ALL and AP_INVOICE_DISTRIBUTIONS_ALL for the same invoices.

Thank you for logging this Enhancement Request. Internally, I have also documented the issue in a new KM Article:FAW:FDI:FDIP: Data Export To CSV Format Is Not Working (Doc ID 3021612.1) and a separate internal Enhancement Request: 36591542