Administrative Discussions

Resolved! How to Avoid Counting Nulls in a DISTINCT Expression

Using DISTINCT() with an IF() in a formula expression leads to incorrect computation as nulls are not handled by default for an on-premise Incorta environment.

SQL Audit Log - Sessions or something similar

When viewing the SQLi Audit log in _IncortaMetadata there are a combination of entries that are related. There is a BEGIN and COMMIT before each statement. There is also a separate set of BEGIN, and COMMIT when I sent a statement using the Initial SQ...

Resolved! Fix Columns doesn't replicate when dashboard is emailed ( HTML or PDF )

I have a very wide insight on a dashboard. In order to make it more legible and fit nicely on a PDF I've fixed the column width and made them narrow enough to fit nicely on screen. However, the sizing does not seem to be honored when the dashboard...

Schema failure - table behavior question

If a schema loads, but finishes with errors e.g. 10 table schema and 3 tables fail how does Incorta treat the incoming data for the successful tables? Is it configurable? I can see that sometimes I want whatever up-to-date data I can possibly ...

Resolved! Incremental load last load time precision

I have a table w/ incremental loading enabled using " <timestampcolumn> > ? " Troublingly, I have some duplicate rows with the same <timestampcolumn> values ( and all other values ). I'm not sure why, but the load time was the same time ( w/ in 4...