How to enable Javascript

Latest Posts

0
Runtime Security formula - can I use "inlist" referencing a table from another schema?
I built schema MV_SCHEMA and want to use a formula like this - note the reference to ABC schema: inList( $user, $ABCSuperUserFilter ) Where $user is, er, the user and $ABCSuperUserFilter is:…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 13 days ago
- 1 reply
- 16
- Questions & Answers
Re: File-based snapshot table best practice @Dylan Wan Thank you! We'll give this a shot straight away!
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 3 wk ago
- 1
- Questions & Answers
- Reported - view
0
File-based snapshot table best practice
I have a need for an Incorta table which will be populated weekly via file upload. The measures are not additive over time. The furthest upstream we can get to the data is pulling a query result…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 3 wk ago
- 2 replies
- 21
- Questions & Answers
Re: SQL App fetch size - Default Value A lot will depend upon the RDBMS and table size ( both width and depth ). I just did some quick benchmarks against SQL Server and 1 million was too high.…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Extracting ~28 million rows, loading zero, schema shows 28M rows in table, analyzer zero Thanks Seth -- I was under the ( apparently incorrect ) assumption that non-optimized just meant that the table wasn't in RAM, not that it couldn't be seen by analyzer.…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Extracting ~28 million rows, loading zero, schema shows 28M rows in table, analyzer zero It is not ( was not ) optimized by design since I won't be using this to analyze - just as a source for a MV. I did switch it to Optimized and am testing it now.…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- Questions & Answers
- Reported - view
0
Extracting ~28 million rows, loading zero, schema shows 28M rows in table, analyzer zero
I don't have direct access to the CMC, so I'm a bit limited in my troubleshooting, but what should I be looking at if a table isn't loading. As in the title,…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 4 replies
- 33
- Questions & Answers
Re: Cognos ( postgres ) connection failing SQL @Dan Brock Hi Dan - yes, it works fine in Incorta. I have a case open ( 9900 ) w/ an INC filed: INC-26960 We were able to get it working by disabling a system property on the server.
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 6 mths ago
- Questions & Answers
- Reported - view
Re: Cognos ( postgres ) connection failing SQL adding - down the log file a bit I find this: ERROR: [18:17:12] [gosales | System | Init] INC_090101001: IO Error while reading snapshot from file: . Please make sure that the latest snapshot file…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 6 mths ago
- Questions & Answers
- Reported - view
0
Cognos ( postgres ) connection failing SQL
I have a connection defined from Cognos Analytics to an Incorta instance 4.9 - the connection tests fine ( currently ) but when I try to pull data I get an error ( file attached ) -- Data source…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 6 mths ago
- 3 replies
- 20
- Questions & Answers
0
S3 data connection error - which log
In connecting - attempting to connect - to an S3 bucket I'm getting an error with a a message saying: INC_01020102: System Error. Please ask Administrator to check the log files.…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 6 mths ago
- 1 reply
- 27
- Questions & Answers
Re: AWS Linux install - insufficient disk space message I get all mad and stuff about pedantic lecturing unless I'm totally lost ..... and I'm totally lost ;-) Here's the directory I created: drwxrwxr-x 2 ec2-user ec2-user 4096 Sep 8 20:25 tmp
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 7 mths ago
- Questions & Answers
- Reported - view
Re: AWS Linux install - insufficient disk space message @Dustin Basil I did: java -Dlax.nl.env.iatempdir=/devtmpfs -jar incorta-installer.jar ( I tried a few different directory paths ) ========= Incorta Analytics requires at least 1 GB of free disk…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 7 mths ago
- Questions & Answers
- Reported - view
0
AWS Linux install - insufficient disk space message
Attempting an install on AWS Linux and getting Incorta Analytics requires at least 1 GB of free disk space in the temporary directory "/devtmpfs". If this space is not available,…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 7 mths ago
- 6 replies
- 12
- Questions & Answers
- Answered
- Answered
0
Format as percent w/ 1 decimal place ( or 3 or .... n )
Are the only "percent" format options in an Insight rounded or 2 decimals? How can I present percents as n.n% ? Thank you and apologies if this is obvious ... Oh, and 4.7.3
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 10 mths ago
- 1 reply
- 26
- Questions & Answers
0
Remove join option doesn't remove joins in other schemas
When I remove a table in schema A I'm offered the option to remove all joins related to that table. However, a join initiated from schema B is not removed.…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 11 mths ago
- 2 replies
- 13
- Questions & Answers
Re: Uninstall on linux - just delete IncortaAnalytics folder? @Martin Carnegie Thank you much!
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: SQL joins - troubleshoot non-working @Siva Kowsika Hi Siva - thanks for responding. I should have updated this topic and marked it as resolved. I had an issue w/ Spark configuration.
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
0
Uninstall on linux - just delete IncortaAnalytics folder?
I have a fresh install on an AWS box to which we just assigned a static IP ( the install was done w/ the prior IP ). Since I don't have any content yet to be preserved,…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 yr ago
- 4 replies
- 37
- Questions & Answers
- Answered
- Answered
0
AWS Linux - start on system start
I have an AWS Linux instance w/ Incorta installed. What I want to do is have the Incorta processes start on system start. I'm trying both crontab and rc.local but am not having a lot of success.…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 yr ago
- 13
- Questions & Answers
0
SQL joins - troubleshoot non-working
I have a couple simple schemas ( one of them is the Incorta "Sales" schema, the other part of Cognos' Great Outdoors sales schema ). Both of them work as expected until I try to create a SQL Join…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 yr ago
- 2 replies
- 42
- Questions & Answers
Re: JDK version @Moataz-Bellah Mishrif You've got it correct. I can try the OpenJDK11 ( I've gotten pretty good at adding and removing java stuff ;-) ) but as I expect to be doing this somewhat frequently for…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 yr ago
- Questions & Answers
- Reported - view
Re: JDK version @R. A. Dawson Sr - update - the community link steps seem to have worked. I can now start CMC.
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 yr ago
- Questions & Answers
- Reported - view
Re: JDK version @Dan Brock Hi Dan - I'm installing 4.6 I'm looking at the install guide here: https://docs.incorta.com/4.6/install-java/ and am now trying this: https://community.incorta.…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 yr ago
- Questions & Answers
- Reported - view
0
JDK version
I tried getting the openjdk reference version 11 ( after trying the most up-to-date version of 13 ) and I'm getting this: Error: OpenJDK 11 is not supported, Please install OracleJDK 1.8.…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 yr ago
- 5 replies
- 29
- Questions & Answers

1 2 Next

Back to top

R. A. Dawson Sr

R_A_Dawson_Sr

PMsquare

Senior Consultant

United States

30
9
1

Follow