About marcpaige

marcpaige · 10-26-2022

I am trying to do a seemingly simple thing. I thought I could use a result-set approach but it did not work.So, here is the task: group averages of numbers based on a category. An aggregate insight does that well. The problem is I want to put in a fo...

marcpaige · 08-01-2022

I've read and implemented a dense snapshot table. It works exactly as expected. Yay!What I need now is a way to trim the snapshot. The start of the snapshot has a starting date way back when. I want to move that starting date forward so as to limit t...

marcpaige · 07-01-2022

Last night's game at Minute Maid Park was a blast. Thanks, Incorta for a great time!

marcpaige · 07-01-2022

The upgrade guide section for configuring SSO (https://docs.incorta.com/5.2/guides-upgrade-from-5-0-x-to-5-2/#configure-sso) seems to contradict the Secure Login Access documentation (https://docs.incorta.com/5.2/configure-sso/#configure-sso-using-cm...

marcpaige · 05-09-2022

Often, I have experimental tables, MVs, etc. in my development tenant. To keep production clean, these are not migrated through a schema export. I have to hand move the production adds and changes from dev to prod. It would be very useful to have a d...

marcpaige · 11-04-2022

Thanks again, Zach. This makes perfect sense.

marcpaige · 11-04-2022

Jeff, a comment on the try suggestion: when I try to do this I get this error:INC_04050708: The group by columns in the level based measure should be used in the grouping dimensions and have the same order Date_Time.Date.Date.We have found a way to d...

marcpaige · 11-04-2022

I have a follow-up for you Zach. @ZachBreimayer: How would the SQL change for multiple aggregate columns?

marcpaige · 10-28-2022

Thank you, Zach. This is very helpful.

marcpaige · 10-28-2022

To round out the solution: I also had to use an Incorta Analyzer table to calculate the averages and have access to them from the KPI insight. The MV wouldn't allow me to do the calculations in SQL.

User Statistics

User Activity

What is a simple Excel reference is hard in Incorta?

Dense Snapshot Truncation?

Astros beat Yankees 2 - 1!

SSO Confusion for upgrade from 5.1.x -> 5.2

Partial Schema Export

Re: What is a simple Excel reference is hard in Incorta?

Re: Formula to calculate differences from one week count to past week count

Re: What is a simple Excel reference is hard in Incorta?

Re: What is a simple Excel reference is hard in Incorta?

Re: What is a simple Excel reference is hard in Incorta?