Community

Learn

Docs

Support

How to enable Javascript

Latest Posts

Re: Can I create a function ( UDF ) in Incorta? ( use case: csv files show percents, I need to convert to decimal - a *lot* ;-) ) Thanks Dan - that would work. I did get a response from support and they've also logged an enhancement request: INC-33138
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 4 wk ago
- Questions & Answers
- Reported - view
Re: Can I create a function ( UDF ) in Incorta? ( use case: csv files show percents, I need to convert to decimal - a *lot* ;-) ) @Arvind kumar Thanks Arvind, creating the column isn't an issue, creating 50+ using the same formula is just painful ;-) I do like the idea of having another product to do some wrangling pre-Incorta…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Use a notebook to manipulate a file before ingesting data? Bumping
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Can I create a function ( UDF ) in Incorta? ( use case: csv files show percents, I need to convert to decimal - a *lot* ;-) ) Bumping - I logged a support ticket asking this information as well ( Request #12541 ) but no answer yet.
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Hidden subtotals @R. A. Dawson Sr Apologies - I forgot to type "Thank you!" in that last reply! I really do appreciate the community page and your responses!
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Hidden subtotals Ah - it does indeed! That's an odd combination of defaults, but I see the utility in being able to choose which level subtotals to be displayed. I've asked elsewhere but do you happen to know if/how…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- Questions & Answers
- Reported - view
0
Hidden subtotals
I want to display subtotals in an aggregate table. I'm getting a message "subtotal for <group1, group2> is hidden" Why? And how do I unhide them? The measure I am using is a decimal formatted as…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 4 replies
- 20
- Questions & Answers
0
Can I create a function ( UDF ) in Incorta? ( use case: csv files show percents, I need to convert to decimal - a *lot* ;-) )
The title sums it up - I have a need to take a text input ( e.g. 16.7% ) and conditionally format the output ( e.g. > 15% green, > 10 yellow, etc. ) Since the comparison operator wants a number I…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 5 replies
- 47
- Questions & Answers
- Answered
- Answered
Re: Use a notebook to manipulate a file before ingesting data? @Dylan Wan - I created Request #12495 for this question. Anything you can do to help prod the answer would be awesome!
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- Questions & Answers
- Reported - view
1
Conditional Formatting subtotals
Just for the record I did use the "search" function before posting this question ;-) Is it possible to conditionally format subtotals? I envision a use case where the conditions may differ from the…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 12
- 1
- Questions & Answers
Re: Aggregation setting to exclude non-null and/or non-zero values Thanks Dan - I'll give this a go today! Is there any "behind the scenes" difference between putting a calc like this in an insight v. a business view? I think I recall both should execute at runtime?…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- Questions & Answers
- Reported - view
0
Aggregation setting to exclude non-null and/or non-zero values
I'm setting some measures to AVERAGE in a dashboard, but what I'd really like is an average of the non-zero values ( in other cases non-null values ). Is there such a setting?
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 3 replies
- 16
- Questions & Answers
0
Use a notebook to manipulate a file before ingesting data?
We have several .csv ( or Excel ) files which have things like subtotals, title rows w/ merged cells, and other things non-conducive to using as an Incorta data source.…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 5 replies
- 48
- Questions & Answers
Re: Format an measure of time ( calculated ) as MM:SS v. decimal Thank you Anurag. I'm getting closer, but the above drops the leading zero in cases like 10.13 which results in 10:82 v. 10:08 I changed "int" to "double" and changing the multiplier to .…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Format an measure of time ( calculated ) as MM:SS v. decimal Our immediate need is in a list column "Average Time" which would display 4.5 minutes as 4:30 Eventually we'd also like it to display that way on a visualization ( e.g. a gauge )
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 2 mths ago
- Questions & Answers
- Reported - view
0
Format an measure of time ( calculated ) as MM:SS v. decimal
I have two fields: Number of minutes, Number of Customers. If I have values 9 and 2 and divide I get 4.5 I would like to be able to display 4:30 on my insight.…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 2 mths ago
- 7 replies
- 38
- Questions & Answers
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
- 2 mths ago
- 1 reply
- 25
- Questions & Answers
- Answered
- Answered
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
- 2 mths 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
- 2 mths ago
- 2 replies
- 31
- 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
- 3 mths 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
- 3 mths 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
- 3 mths 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
- 3 mths ago
- 4 replies
- 36
- 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
- 8 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
- 8 mths ago
- Questions & Answers
- Reported - view

1 2 Next

R. A. Dawson Sr

R_A_Dawson_Sr

PMsquare

Senior Consultant

United States

Hidden subtotals

Can I create a function ( UDF ) in Incorta? ( use case: csv files show percents, I need to convert to decimal - a lot ;-) )

Conditional Formatting subtotals

Aggregation setting to exclude non-null and/or non-zero values

Use a notebook to manipulate a file before ingesting data?

Format an measure of time ( calculated ) as MM:SS v. decimal

Runtime Security formula - can I use "inlist" referencing a table from another schema?

File-based snapshot table best practice

Extracting ~28 million rows, loading zero, schema shows 28M rows in table, analyzer zero

R. A. Dawson Sr

Home

Tags

Product Announcement

Hidden subtotals

Can I create a function ( UDF ) in Incorta? ( use case: csv files show percents, I need to convert to decimal - a *lot* ;-) )

Conditional Formatting subtotals

Aggregation setting to exclude non-null and/or non-zero values

Use a notebook to manipulate a file before ingesting data?

Format an measure of time ( calculated ) as MM:SS v. decimal

Runtime Security formula - can I use "inlist" referencing a table from another schema?

File-based snapshot table best practice

Extracting ~28 million rows, loading zero, schema shows 28M rows in table, analyzer zero

R. A. Dawson Sr

Home

Tags

Product Announcement

Can I create a function ( UDF ) in Incorta? ( use case: csv files show percents, I need to convert to decimal - a lot ;-) )