Community

Learn

Docs

Support

How to enable Javascript

Latest Posts

0
data_agent_server ( Incorta Cloud ) datatypes? Default schema fails with Null datatype
I'm having an issue w/ my cloud instance trying to run the Metadata schema. It is failing on loading the data_agent_server - the data type for the two columns is Null - changing to String allows the…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 4 days ago
- 3
- Questions & Answers
0
Migration of Incorta *data* ( Incorta Cloud )
Use case: I'm setting up a snapshot table in Incorta using getdate() as part of my key and doing incremental builds. If I run that daily for a week, then unit test, UAT,…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 2 wk ago
- 1 reply
- 15
- Questions & Answers
Re: Find all references to a table If I were doing it right now, today, I'd export the content, unzip, open Notepad++ and do a "find in files" search and replace. Then rezip and import. Painful if you have a lot of business schemae…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 2 wk ago
- 1
- Questions & Answers
- Reported - view
Re: Excel plugin for Incorta Cloud The dawn breaks, the birds sing, and the day begins with a working Excel plugin! If anyone has followed the saga, I was trying to get the plugin and make it work on my local machine.…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 3 wk ago
- 2
- Questions & Answers
- Reported - view
Re: Excel plugin for Incorta Cloud Still looking for Excel plugin help - - as a bonus, how do I change the question status from "Answered?"
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 4 wk ago
- Questions & Answers
- Reported - view
Re: Retiring and Replacing a Business Schema? The consultant answer of "it depends" applies here. Assuming you are retiring and replacing the business schema because there have been significant changes,…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 4 wk ago
- 1
- Questions & Answers
- Reported - view
Re: Excel plugin for Incorta Cloud Has anyone successfully implemented this?
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Excel plugin for Incorta Cloud I got the link to download the plugin from support today *and* permission to post it here: https://drive.google.com/file/d/1bSTezbXpXtN6ERHQiTGC8dTwQLdyhI98/view?usp=sharing
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- Questions & Answers
- Reported - view
0
Compound Join?
[edit to add 4.8.5 - but looking to upgrade so SQL Joins won't be a viable answer unless they are back w/ the next release ( please! ). I want to create a compound join: Table1.ORDERDATE >= TABLE2.…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 1 reply
- 12
- Questions & Answers
- Answered
- Answered
0
Data source local file upload size limit?
I get this error ( and it's sibling error in Edge ) when trying to upload a large CSV file so I assume there is a limit. I looked through the docs for connectors - file system and didn't see any…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 1 reply
- 28
- Questions & Answers
- Answered
- Answered
Re: Conditional Distinct Count? Thank you Anurag!
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Excel plugin for Incorta Cloud I did make my way to enable the Excel plugin**, but still need to get it downloaded. ** It's a bit confusing, but on the admin portal the section to "Connect External BI Tools" is not used to…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Test Text for Valid Date Content Here's the ( an? ) enhancement request no. INC-33138 for the global UDF.
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 1
- Questions & Answers
- Reported - view
0
Excel plugin for Incorta Cloud
I'd like to install and use the Excel plugin for Incorta Cloud, but looking at the documentation under Integrations -> Microsoft Excell Add-in shows what appears to be instructions for on-prem or…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 5 replies
- 33
- Questions & Answers
- Answered
- Answered
0
Conditional Distinct Count?
I have a scenario where I want to count the number of orders when a flag is set ( sometimes I want to count when set to zero, sometimes when <> 0 ). Basically,…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 2 replies
- 28
- Questions & Answers
- Answered
- Answered
Re: Level based measures limitation question @Anurag Malik Thank you - I wanted to make sure I wasn't creating too many extra steps to get what I need.
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Level based measures limitation question Note my current workaround is to create level-specific aggregates in MVs and then create a master MV combining my atomic level data with higher level columns as dimensions: e.g.…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- Questions & Answers
- Reported - view
0
Level based measures limitation question
Is it accurate to say that level based measures can only be used when the group is used in the insight? And, when that group is the only group in the insight? I'm on 4.8.…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 3 replies
- 17
- Questions & Answers
- Answered
- Answered
Re: "Key" option greyed out in column properties @Dustin Basil Thank you!
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- Questions & Answers
- Reported - view
1
"Key" option greyed out in column properties
I have a three column table: PK alternate PK measure I can use the drop-down to identify PK as a key, but the option is greyed out for alternate PK. I don't think it has any practical effect,…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 2 replies
- 6
- 1
- Questions & Answers
- Answered
- Answered
Re: Sort prompt values? @Dustin Basil Ah - I presume this was something introduced post 4.9.7. Yet another incentive to update! Thank you.
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- Questions & Answers
- Reported - view
0
Sort prompt values?
I have a prompted dashboard. The prompt field is text and in the prompt dialog is a presented in a (seemingly) random order. Can I force these to display alpha? Or any sort options?
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 2 replies
- 17
- Questions & Answers
- Answered
- Answered
Re: Connect to S3 troubleshoot If I were this person ( I am, in fact, this person ) I'd start by digging into the documentation and finding that you must modify the URI from S3:// to S3a:// after copy/pasting from AWS.
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- Questions & Answers
- Reported - view
0
Connect to S3 troubleshoot
It seems connectors are conspiring against me ;-) I'm getting : Error INC_03070502: ConnectorFactory Error: error creating a file descriptor for path: When trying to connect to S3 as a data source.…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 1 reply
- 8
- Questions & Answers
- Answered
- Answered
0
File security ( encryption ) options for GDrive, Dropbox, etc.
We are exploring using a cloud repository to store source files - I'm looking for a doc or docs on what file encryption we can use ( e.g. for GDrive Google will encrypt on the way up and decrypt on…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 2 mths ago
- 8
- Questions & Answers

1 2 3 4 Next

R. A. Dawson Sr

R_A_Dawson_Sr

PMsquare

Senior Consultant

United States

data_agent_server ( Incorta Cloud ) datatypes? Default schema fails with Null datatype

Migration of Incorta data ( Incorta Cloud )

Compound Join?

Data source local file upload size limit?

Excel plugin for Incorta Cloud

Conditional Distinct Count?

Level based measures limitation question

"Key" option greyed out in column properties

Sort prompt values?

Connect to S3 troubleshoot

File security ( encryption ) options for GDrive, Dropbox, etc.

R. A. Dawson Sr

Home

Tags

Product Announcement

data_agent_server ( Incorta Cloud ) datatypes? Default schema fails with Null datatype

Migration of Incorta *data* ( Incorta Cloud )

Compound Join?

Data source local file upload size limit?

Excel plugin for Incorta Cloud

Conditional Distinct Count?

Level based measures limitation question

"Key" option greyed out in column properties

Sort prompt values?

Connect to S3 troubleshoot

File security ( encryption ) options for GDrive, Dropbox, etc.

R. A. Dawson Sr

Home

Tags

Product Announcement

Migration of Incorta data ( Incorta Cloud )