This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Supporting user’s default currency based on location and doing currency conversion
Define a internal session variable called MyCountry:
query(_IncortaMetadata.USER.COUNTRY,
_IncortaMetadata.USER.LOGINNAME = $user,
_IncortaMetadata.USER.TE...
Introduction
When replacing your current Informatica ETL processes, there are many approaches you can take to seamlessly transition to Incorta. This document will cover some of the best practices around how to manage an Informatica migration to Inco...
Introduction
There are many Oracle Service ERP (Fusion) modules like Oracle Trade Management or Oracle CPQ which do not integrate with Oracle BICC. In these cases, you can use other available methods, like Oracle BI Publisher (BIP) reports, to publ...
For a specified measure, Oracle's LISTAGG orders data within each group specified in the ORDER BY clause and then concatenates the values of the measure column. How do we implement the LISTAGG() function in Incorta?
We can implement this using Spark...
If you do not see CSV as a valid output then edit the BIP report and click "View List" in the far right. Then in the screen shown navigate to output formats (these are the allowed output formats) - click on csv and save. After this, schedule shows th...
We do not have a connector to Enovia , they are two things we can do in the meantime - 1) If they have rest APIs then you can call the API via MV and pull data via that, check article [community.incorta.com].2) See if they allow data extracts to csv ...
Here is Anurag's video that shows how to calculate max date from a table column and default that to a date prompt in the dashboard: https://youtu.be/9CdKnTh2CiM
In compaction, the most recent record gets selected. For the first question the last one wins. For the second, the last is picked.
For the order of operations:Increments is scanned in order, and duplicates are marked. Once finished, we remove dupli...
.png "Employee"){kind=icon}
