Learn

Docs

Support

How to enable Javascript

Questions & Answers

Have a question? Ask it here. Or reply and share your knowledge.

TOPICS MEMBERS

Join this category to participate in conversations and receive notifications when new posts are added.

JOIN

0
Comments in formula?
Is it possible to put comments in a formula?
- Tom FogartyIncorta User
- Inmar
- Tom_Fogarty
- 2 yrs ago
- 3 replies
- 209
- Sunita DattaIncorta User14 hrs ago
- Questions & Answers
1
What is Incorta Excel Add-in
What is Incorta Excel Add-in and what is it used for?
- Ayat AboelnagaEmployee
- Incorta
- Ayat_Aboelnaga
- 2 yrs ago
- 9 replies
- 410
- 1
- Ahmed EsmatEmployeeyesterday
- Questions & Answers
0
To connect Incorta with external API
Hi Team, We have external application that tracks the issues and incidents, they have exposed API's to pull the incident details. Is there a way we can integrate Incorta with this application…
- RudraIncorta User
- Quest Global
- Rudra
- 2 days ago
- 1 reply
- 4
- Dan BrockEmployeeyesterday
- Questions & Answers
0
Padding zeros
Is there a function in Incorta which could you used as LPAD, which pads zeros to the left of string to make the string of a fixed length?
- Mukul RanjanIncorta User
- Starbucks
- Mukul_Ranjan
- 2 days ago
- 5
- Questions & Answers
0
Incorta Error
I am getting following error NC_01020105: Request is missing mandatory parameter(s) reportId. How to debug and solve this ?
- Ajit Dixit
- Al Borg laboratories
- Ajit_Dixit
- 3 days ago
- 5 replies
- 9
- Dan BrockEmployee3 days ago
- Questions & Answers
0
Save and Reuse ML Models
I have built an MV with spark python that creates and tests an ML predictive model. Then it runs a batch of data against the prediction and saves the result. Currently it does this all in one MV.…
- Steve Ware
- Brownells, Inc.
- Steve_Ware
- 9 days ago
- 2 replies
- 14
- Steve Ware9 days ago
- Questions & Answers
0
Uniqueness on new SQL Joins
Does the new SQL join offering in Incorta Labs allow for M:M joins or does the parent still need to be unique like the traditional joins?
- Jack KuehnPartner
- eCapital Advisors
- Jack_Kuehn
- 6 mths ago
- 3 replies
- 30
- Dustin BasilEmployee9 days ago
- Questions & Answers
0
Limit the selection for a Date in dashboard filter
I would like to make the UX for my users better by limiting the selection of the dates listed when using a date field in a dashboard filter. For example:…
- Marc PaigeIncorta User
- GC Services
- Marc_Paige
- 10 days ago
- 1 reply
- 7
- Marc PaigeIncorta User10 days ago
- Questions & Answers
0
Schema Tables Metadata
Hi, does anyone know how to pull a list of table which does not have incremental load setup? I am trying to find it in Inspector and Meta data so far but could not find it yet. Thanks
- Mukul RanjanIncorta User
- Starbucks
- Mukul_Ranjan
- 11 days ago
- 8
- Questions & Answers
0
Label Names for Rolling Months
I have a business view with columns that aggregate monthly usage. This is a rolling aggregation. For example, the column label "Current Month" is the current month (i.e. September).…
- Michelle FoxIncorta User
- National Oilwell Varco
- Michelle_Fox
- 4 wk ago
- 5 replies
- 34
- Dylan WanEmployee11 days ago
- Questions & Answers
0
How to link insights from different sources using a common filter?
Hello, I'm trying to link insights together so they filter on the same key, but the insights have different sources. For example: one insight is based off a business schema with a few select fields…
- Mike MascittiIncorta User
- Northwestern Mutual
- Mike_Mascitti
- 2 wk ago
- 5 replies
- 13
- Hichem SellamiEmployee11 days ago
- Questions & Answers
0
table size be increased after load incremental without column added
Anyone could explain to me why table size be increased after load incremental without column added ?. thank you !
- Nopu Nguyen
- Human
- Nopu_Nguyen
- 2 wk ago
- 6
- Questions & Answers
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
- 2 wk ago
- 3 replies
- 12
- R. A. Dawson Sr2 wk ago
- Questions & Answers
0
Level based matric trend chart
Hi, I have a requirement to build level based matric trend chart, below is the scenario Data INVOICE_ID CLEAN_WEIGHT Date inv1 Valid 10/1/2020 inv2 Not Valid 10/2/2020 inv3 Valid 10/3/2020 inv4 Not…
- Mukul RanjanIncorta User
- Starbucks
- Mukul_Ranjan
- 2 wk ago
- 2 replies
- 14
- Mukul RanjanIncorta User2 wk ago
- Questions & Answers
0
Schema Loads & Time Change
Currently when we set up a schema load schedule the timezone defaults to GMT -5. We are on Incorta 4.7.4. In a few weeks actual time will change to GMT -6 (fall back).…
- Barry MayfieldIncorta User
- Redstone Federal Credit Union
- Barry_Mayfield
- 2 wk ago
- 10
- Questions & Answers
0
Count distinct in formula column
HI, I have logic in formula like this: distinct( if( not( exer.orders.type = 'buy' ), concat( exer.orders.product_id, exer.orders.comp_id ), '' ) ) - distinct( if( exer.orders.…
- Nopu Nguyen
- Human
- Nopu_Nguyen
- 3 wk ago
- 3 replies
- 12
- Anurag MalikEmployee2 wk ago
- Questions & Answers
- Answered
- Answered
3
How to Embed incorta in a webpage using iframe tag
- Moataz-Bellah MishrifModerator
- Incorta
- Moataz_Mishrif
- 2 yrs ago
- 6 replies
- 414
- 3
- Hasnaa IbraheemModerator3 wk ago
- Questions & Answers
0
Dashboard Bookmarks
Hi, Can you please help me with the following, 1. Is there a way that we can change the filter values of a bookmark and re-save it with out deleting the existing bookmark and recreating it a new one.…
- Srinivas C
- FBP
- Srinivas_C
- 1 mth ago
- 2 replies
- 15
- Dylan WanEmployee4 wk ago
- Questions & Answers
0
Display Current Date on Dashboard
How do I display the current date on a dashboard?
- Raj Lalchandani
- Incorta
- Raj_Lalchandani
- 4 wk ago
- 1 reply
- 19
- Dylan WanEmployee4 wk ago
- 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
- 1 mth ago
- 1 reply
- 7
- Dylan WanEmployee1 mth ago
- Questions & Answers
0
How to convert timestamp to Date in MV
HI, I want to convert 9/22/20, 1:58:18 PM to 9/22/20 in MV. Please let me know how to do.
- KHK
- Wipro
- Hari_K
- 1 mth ago
- 1 reply
- 12
- DylanEmployee1 mth ago
- Questions & Answers
0
Full outer join without MW
I have 2 tables: Product and Sell, so I want to get the result like below without use MW, how can I do it, thanks !
- Nopu Nguyen
- Human
- Nopu_Nguyen
- 1 mth ago
- 7 replies
- 25
- Anurag MalikEmployee1 mth ago
- Questions & Answers
- Answered
- Answered
0
How to Disable one SQLApp in Cluster that have two Analytics Nodes
In CMC we can Enable/Disable the SQLApp in all analytics nodes. How to disable all SQLApp in all analytics nodes except only one
- Moataz-Bellah MishrifModerator
- Incorta
- Moataz_Mishrif
- 1 mth ago
- 1 reply
- 7
- Moataz-Bellah MishrifModerator1 mth ago
- Questions & Answers
1
Schedule job for load of individual tables
It seems that Parquet actually captures all of the same rows again in an incremental load but only updates/deleted based on Key in the in-memory database.…
- Tom FogartyIncorta User
- Inmar
- Tom_Fogarty
- 2 yrs ago
- 11 replies
- 197
- 1
- Sunita DattaIncorta User1 mth ago
- Questions & Answers
0
INC_04030373: IO error while reading snapshot file...
I have noticed that if I have a schema in an incremental load and have to stop/start the loader service, this error occasionally occurs. Is there a simple way to clear this error from the…
- Marc PaigeIncorta User
- GC Services
- Marc_Paige
- 1 mth ago
- 1 reply
- 13
- Dylan WanEmployee1 mth ago
- Questions & Answers
- Answered
- Answered

1 2 3 4 5 23 Next

Have a question? Ask it here. Or reply and share your knowledge.

Members

View members

Questions & Answers

Comments in formula?

What is Incorta Excel Add-in

To connect Incorta with external API

Padding zeros

Incorta Error

Save and Reuse ML Models

Uniqueness on new SQL Joins

Limit the selection for a Date in dashboard filter

Schema Tables Metadata

Label Names for Rolling Months

How to link insights from different sources using a common filter?

table size be increased after load incremental without column added

Cognos ( postgres ) connection failing SQL

Level based matric trend chart

Schema Loads & Time Change

Count distinct in formula column

How to Embed incorta in a webpage using iframe tag

Dashboard Bookmarks

Display Current Date on Dashboard

S3 data connection error - which log

How to convert timestamp to Date in MV

Full outer join without MW

How to Disable one SQLApp in Cluster that have two Analytics Nodes

Schedule job for load of individual tables

INC_04030373: IO error while reading snapshot file...

Members

Tags

Home

Tags

Product Announcement