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

Hello, It does not look like there is any problem with your logic but little tweeks may be required depending on the results. To troubleshoot this, include the calculated column with at least 1 fact and 1 measure from each Subject Area you use in the calculation in a Tabular (Table) Workbook. Change the aggregation method…

Hi Mohan, BIACM is a part of OBIA. The UI does not allow all jobs to be deleted all at once but if you have a unique situation, you could delete the source(s) from _BIACOMP.C_DATA_SERVER and that would work. You should log a SR with OBIA before doing that to discuss the root problem and see if there are alternatives. BICC…

Hi Allen, Regarding you question on whether we may be able to see this capability of having payments which are unaccounted in the fact table in 24R2. I do not see any Enhancement Request that has been accepted for this so the answer is 'No'. I don't think this will ever be a part of the OOTB content since this is a Data…

Hi Vasanthakumar, The beginning of your Report path should look more like: "reportPath": /"Custom/Link-To-FAW/PersonDetails/EMR_Person_Assignment_Report.xdo",,"runInChunkMode": true Regards, John

Hi Scott, I don't see the Headcount in your tabular workbook so it is a little hard to compare the two. I create a Visualization similar to yours with a Case statement. This matches what I see in the Tabular Workbook if I include the 2 columns.

Anecdotally, the recommended order to activate is as follows: --------------------------------------------------------------- Active First: * Employee Expense * Purchase Receipt * General Ledger * Accounts Payable * Assets * Project Commitment * Purchase Agreement * Procurement Spend * Project Billing * Purchase Order *…

Hello, Just a FYI .. This community is for OBIA and BICC extract questions should be posted to the OTBI community. Regards, John