Hi My Source table is Big Query Table and Target table is Big Query Table.I have created MV and sent to Data Destination getting below error.Big Query Table DateTime Format is as below. I have written formula forEXT_LAST_UPDATE DATE as COALESCE( to...
Hi,Period_Name like 08-25,09-25 .i want to Create a formula column Year from Period name and store Current year and past two years in that year column like below . Next year dynamically change the values to 2024,2025 and 2026. Please let me know how ...
Hi,I have added Invoice_amount column from AP_Invoices_all table and trying to add Invoice_amount column from AP_Invoice_Distributuons_All table in Business view.After adding Invoice_Amount column from second table in BV Column Name already exists me...
Hi Team, I am trying to put up a list of schema and tables orginated from which data connection, as I find the data source table from metadata, which cannot be connected to any schema. Is there a way i can see the datasource, schema table in a tabel...
in Incorta For Developers course, Lab: Schema Workshop, Check#2 and Check#3,the instructor made an Alias table while the analysis or even the design can be done successfully without making it, as there was no more than one relation between the same t...
