Hi @JPK , As Ram said, we will need more details to address your specific details. These are best provided in a SR since some of it may be private. The Adhoc-112 message probably will not be changed because it is not specific to Oracle ETLs and its been around for a long time. We may be able to enhance it to add some…

Hi @Vaigu_27 , Yes, you can use Presentation Variables in FDI's OAC. They are commonly used in Dashboard filters, Column Prompts and Variable Prompts. The OAC documentation on that is here: If you find this reply to your question useful, others might as well. By clicking the “Yes” button for “Did this answer the question?”…

Hi @Dhruvjoshi23 and @User_S9YE9, Have you checked this since the July 2024 update? Please see the What's New documentation here: This includes improved Sankey diagrams to show resources, materials, and costs in workbooks. Use the Node Height Stretch property for enhancements such as node width adjustment, column height,…

Hi @User_9STVF Each offering in the FA (OTBI) source like ERP (Financials) has the equivalent of an 'Application Administrator' role. For details See: If you have a chance, review this Youtube video regarding Data Validation for additional details: If you find this reply to your question useful, others might as well. By…

Hi @Indra Sardana-Oracle , We have a good blog on this topic here: Multiple data files would require corresponding subfolders. This is intended to complement our documentation on SFTP connections here: If you find this reply to your question useful, others might as well. By clicking the “Yes” button for “Did this answer…

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: Regards, John

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: Followed by this video to activate the subscription. Hope…

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 There are a lot of options for filters as documented here: If you don't think you have any use for the inactive Level2 managers anywhere in your DW, you may just want to do a data augmentation and create a Presentation column that does not include it.

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: Regards, John