If the column you need is not part of the prebuilt model, you can create a data augmentation. Here´s the BIVO lineage. R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet — Cloud Customer Connect

I´m glad that I asked. What you mention is a characteristic of every data warehouse based on a star schema model, which in fact is the most used one. Star Schema vs Snowflake Schema: Differences & Use Cases | DataCamp

FAIDP is based on PaaS services that run on OCI, but it´s a SaaS service offering licensed by users. Oracle Fusion AI Data Platform

Metrics will get aggregated automatically. Find a good attribute, score will work better than Genre (as it has only 2 possible values).

Hi @Stefano_Mazzocca I´m curious about your comment on historical data handling. FDI offers full capabilities to store and analyze historical data. If you check the tables information at Overview you can find a number of snapshot tables.

It seems like you have a SUM aggregation on Age. Check if these videos help you. How to Use Plots to Show the Distribution of Data in Oracle FDI How to Identify and Highlight Outliers in Oracle Fusion AI Data Platform

Hi Tamer, your subscription is for AI Data Platform (AIDP). Fusion AIDP is a different SKU, which includes ADW + OAC + prebuilt models and pipelines.

Once your BIP data is in ADW you can use it to create a Data Augmentation, which is typically an extension to an existing table. Then you can expose these new columns to a subject area using Semantic Model Extensions. You may want to check the videos at FDI Implementers Series - Oracle Video Hub .

You can schedule DV reports in XLSX and PDF using native features. First configure your Mail Settings in OAC Console. Then locate you workbook, click Actions, then Schedule (or Inspect).

Hi buddy, I understand what you want ideally, but I have suggested you use what is readily available. On the other hand, FTE is a person count based on Assignment Status Type Code IN ('ACTIVE','SUSPENDED'). Typically those records don´t have Assignment End Date set, but you can build a report having Assignment End Date set…

I think you haven´t got an answer because your questions is specific to your organization. Whatever field your company has been using to identify those branches needs to be added.

You can plot future workforce records using the built-in Forecast capabilities of OAC, based on different models. How to Add a Forecast Line to a Visualization in Oracle Fusion AI Data Platform

Pretty much every object in Fusion has a system column for Last_Update_Date. FDI pipelines work based on this information. You may want to revisit your data extract and include those columns.

The EPM Connector supports extracting EPM dimensions and data. You may look into recreating rollups using Calculations in FDI or other artifacts. The pipeline won´t consume a license from EPM side, but data consumption in FDI will require regular ERP or SCM FDI license.

When you say somehow available, you can bring this data to FDI using data augmentation/SME.

I suggest you create an SR with Oracle Support.

@StylasYour may want to create a Local Subject Area, so you can ensure to keep good dashboard performance along with your customizations. Create a Purpose-Built Local Subject Area

Have you tried changing the join type? Understand Dataset Table Joins

You may want to leverage an SFTP connection, but I don´t think it can handle the decryption task. Load Data from an SFTP Source into Fusion Data Intelligence (Preview)

For points 1 and 2 you can leverage migrating your settings using a Data Configuration bundle, as per About Bundles . For point 4 you may use a Content, SME or Security bundles too. As for point 3 data validation, we can assume Prod database is different from Dev. So it makes sense to validate your Prod data. As for point…