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

1
Capture source table and column name in Report
Is there a formula function or some way to find the source table and column name in report?
- Mukul RanjanIncorta User
- Starbucks
- Mukul_Ranjan
- 7 days ago
- 2 replies
- 7
- 1
- Mukul RanjanIncorta User7 days ago
- Questions & Answers
0
Remove a schema table column
What is the recommended process for removing a column from a schema table in Incorta?
- Ron
- Northwestern Mutual
- Ron
- 12 days ago
- 1 reply
- 15
- Dan BrockEmployee11 days ago
- Questions & Answers
- Answered
- Answered
0
How to login from external tools with SSO?
We have Single Sign-On (SSO) turned on for our Incorta environments, but we also plan on connecting externally with tools like Power BI. Problem is, with SSO for the UI enabled we need separate…
- Mike MascittiIncorta User
- Northwestern Mutual
- Mike_Mascitti
- 2 wk ago
- 2 replies
- 12
- Mike MascittiIncorta User2 wk ago
- Questions & Answers
0
Map Chart (with Incorta map) showing % of total
I am trying to use a map chart at the state level. I can show a simple aggregation by state with a count of accounts. What I would like to do is show the percent of the total population for each…
- Marc PaigeIncorta User
- GC Services
- Marc_Paige
- 2 wk ago
- 6 replies
- 19
- Marc PaigeIncorta User2 wk ago
- Questions & Answers
- Answered
- Answered
0
Connecting with SQLAlchemy
Has anyone ever tried to connect to Incorta externally using the python package SQLAlchemy? We're trying to use it along side the python driver psycopg2 and we get the error 'Failed to Parse query'…
- Mike MascittiIncorta User
- Northwestern Mutual
- Mike_Mascitti
- 2 wk ago
- 2 replies
- 10
- Mike MascittiIncorta User13 days ago
- Questions & Answers
0
IS Number
Is there a way to check if the string contains all numbers?
- Mukul RanjanIncorta User
- Starbucks
- Mukul_Ranjan
- 3 wk ago
- 12
- Questions & Answers
0
Can the MySql database be backed up while the platform is up?
I recently had an instance where the database got corrupted somehow. I am going to institute an automated daily backup of the database. Can the mysqldump utility be run while the platform is running?…
- Marc PaigeIncorta User
- GC Services
- Marc_Paige
- 3 wk ago
- 4 replies
- 17
- Marc PaigeIncorta User3 wk ago
- Questions & Answers
- Answered
- Answered
0
How to use distinct in Table and Pivot table
How to use distinct in Table and Pivot table to count measure value? Regards, KHK.
- KHK
- Wipro
- Hari_K
- 3 wk ago
- 11
- Questions & Answers
1
Moving data from incorta to some other system
Hi, We have loaded lots of reporting data into Incorta. I would like to copy all the loaded data to some other system. Is there anyway to consumer all the loaded data and move to some other system?
- Baskar Sikkayan
- Apple
- Baskar_Sikkayan
- 4 wk ago
- 15
- 1
- 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
- 1 mth ago
- 1 reply
- 19
- Dan BrockEmployee1 mth ago
- 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
- 1 mth ago
- 2 replies
- 18
- Mukul RanjanIncorta User3 wk ago
- 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
- 1 mth ago
- 5 replies
- 9
- Dan BrockEmployee1 mth 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
- 1 mth ago
- 2 replies
- 19
- Steve Ware1 mth 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
- 1 mth ago
- 1 reply
- 11
- Marc PaigeIncorta User1 mth 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
- 1 mth ago
- 11
- 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
- 1 mth ago
- 5 replies
- 16
- Hichem SellamiEmployee1 mth 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
- 1 mth 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
- 1 mth ago
- 3 replies
- 15
- R. A. Dawson Sr1 mth 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
- 1 mth ago
- 11
- 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
- 1 mth ago
- 2 replies
- 15
- Mukul RanjanIncorta User1 mth ago
- 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
- 1 mth ago
- 3 replies
- 16
- Anurag MalikEmployee1 mth ago
- Questions & Answers
- Answered
- Answered
0
Display Current Date on Dashboard
How do I display the current date on a dashboard?
- Raj Lalchandani
- Incorta
- Raj_Lalchandani
- 1 mth ago
- 1 reply
- 20
- Dylan WanEmployee1 mth ago
- 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
- 1 mth ago
- 5 replies
- 43
- Dylan WanEmployee1 mth 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
- 2 mths ago
- 2 replies
- 17
- Dylan WanEmployee1 mth 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
- 2 mths ago
- 1 reply
- 9
- Dylan WanEmployee2 mths ago
- Questions & Answers

1 2 3 4 5 23 Next

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

Members

View members

Questions & Answers

Capture source table and column name in Report

Remove a schema table column

How to login from external tools with SSO?

Map Chart (with Incorta map) showing % of total

Connecting with SQLAlchemy

IS Number

Can the MySql database be backed up while the platform is up?

How to use distinct in Table and Pivot table

Moving data from incorta to some other system

To connect Incorta with external API

Padding zeros

Incorta Error

Save and Reuse ML Models

Limit the selection for a Date in dashboard filter

Schema Tables Metadata

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

Schema Loads & Time Change

Level based matric trend chart

Count distinct in formula column

Display Current Date on Dashboard

Label Names for Rolling Months

Dashboard Bookmarks

S3 data connection error - which log

Members

Tags

Home

Tags

Product Announcement