Hi @Mihaela Predincea-Oracle ask is not ow to customize ask is how to check the source used in that data model ,coud take the ref. of attached screen short and share how I can check which all tables or subject area involve in that data model.

Can you guide me on how to schedule a weekly frequency for SFTA data augmentation in the FDI interface, while the fusion pipeline is set for a daily data load?

@Paul Bordage-Oracle : Please find the relationship diagram

we can achieve custom column header using variables.Can you elobrate the scenario on basis of what these values will change dynamically.

@JohnW-Oracle : Thank you for sharing document link.I have already followed the mention document. I am still not clear if I have multiple files of same structure how creating subfolder will help in that scenario.I can understand multiple files of different structure sub folder will help to create multiple DA but scenario…

If we can set up an account with Functional Administrator on the FAW side and whatever role is required on the OTBI side, we would be able to run the scheduled validations without concern about running into false alarms due to security restrictions on one side or the other. : NO you need to have role on the other side that…

Do you know - if there is a role on the OTBI side - that provides somewhat of a "global" access data-wise, similar to the Functional Administrator role on the FAW side. : Fusion end custom role can be created which will inherit all the required permission for all OTBI subject area as far i know by default no role exist.

For non-scheduled validations, it seem to be using the security of the person running the validation in FAW (both on FAW and OTBI) : Correct for non-scheduled validations, it use the security of the person running the validation in FAW What about scheduled validations? Do these run as the person who scheduled the…

Yes we can have last data load/update date and time displayed on FAW/FDI reports using "Common Warehouse Refresh Statitstic" Subject Area

To my knowledge we can not check what kind of changes done was that report layout or data model.

Hi Jhanavi, Tried rounding off also but its not working not able to find out what is root cause for this abrupt behaviour. Regards, Indra Sardana

Hi Jahanvi, That is Table View. Regards, Indra Sardana

Anirban even with single column report same behaviour:

No Siddharth this is not union report. Regards, Indra Sardana

Thanks Bharath and Sahithi and Wayne Issue was with column length defined at physical layer it was Varchar2(7) instead of Varchar2(200) Regards, Indra Sardana

Thanks Bharath, but as explained due to mismatch of data type number and varchar for header we can't use union of reports and we used session/repository variable. Regards Indra Sardana

In RPD also column is Varchar

Gianni Ceresa , Thanks for correcting me, I have changed now.

Hi All, Thanks for your input using repository variable we are able to achieve same . Regards, Indra Sardana

Thanks Wayne.....Will try to create session/repository variable in our scenario