Incorta
Community
Learn
Docs
Support
How to enable Javascript
Login
Sign Up
Login
Search
Home
Community
Questions & Answers
Have a question? Ask it here. Or reply and share your knowledge.
TOPICS
MEMBERS
Filter
Active
Newest
Popular
Most likes
Most replies
Most views
Status
Answered
Unanswered
Tags
Clear filter
Join this category to participate in conversations and receive notifications when new posts are added.
JOIN
0
incorta API to check the schema status
Hi Team, Please let us know do we have any pre-build python script to check the schema status via API. Thanks, Delli M
Delli
Incorta User
Keysight
Delli
7 days ago
15
Questions & Answers
0
Last Modified dates for MV/Tables in a schema
Hi, How do I retrieve the creation date, created by, modified by, modified date details for all the objects (such as tables/MVs/Alias/Incorta tables) with in a physical schema? Thanks,…
Srinivas C
FBP
Srinivas_C
4 wk ago
7
replies
32
Delli
Incorta User
7 days ago
Questions & Answers
0
correlated column is not allowed in a non-equality predicate
Hi Team, I am getting the error "correlated column is not allowed in a non-equality predicate" when trying to use "<=" operator in corelated subquery with aggregate.…
Haripriya
Infosys
Haripriya
10 days ago
1
reply
13
Amit Kothari
Employee
9 days ago
Questions & Answers
0
PK Migration Tool usage
I am prepping to upgrade to 5.0.2 and working through the pre-upgrade steps. After the upgrade the guide shows scripts that must be performed. The first is the PK Migration tool scripts.…
Marc Paige
Incorta User
GC Services
Marc_Paige
10 days ago
6
Questions & Answers
1
Date Difference Formula Field-Dashboard
Hi, I have two fields-PO Delivery Date and Promise Delivery Date I would like to add a formula field that should calculate the difference in terms of no of days from both the above-listed fields?…
rakesh
PSP
rakesh
1 yr ago
9
replies
90
1
Anand
10 days ago
Questions & Answers
Answered
Answered
1
Scheduling E-mail with Filters
Hey there, I have a master insight that I want to send out to different users by project type. Is there a way to have the insight filter to a specific filter at time of delivery? @Ari Gnanam
joseph. delpercio
Scientific Games
joseph_delpercio
11 days ago
4
replies
36
1
Dylan
Employee
10 mths ago
Questions & Answers
0
Case statement for Country Maps
Hey All, I am trying to use the Incorta maps because honestly I don't know how to setup the Google Maps. I have had pretty good luck except when wanting to change the name of the country.…
joseph. delpercio
Scientific Games
joseph_delpercio
11 days ago
3
replies
48
Dan Brock
Employee
10 mths ago
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
13 days ago
1
reply
16
Dustin Basil
Employee
13 days ago
Questions & Answers
0
Alias Tables Duplicate rows
I have a question on Alias Table, does it duplicate the whole table or just create an Alias for creating join in different way as original table.
Mukul Ranjan
Incorta User
Starbucks
Mukul_Ranjan
2 wk ago
1
reply
15
Arvind kumar
2 wk ago
Questions & Answers
0
Kill Schema Load using CLI
Hello Community!! Can you please provide any info on how to kill any particular running schema load jobs using CLI? Our ultimate goal is for automating to kill any loading jobs for particular schema…
Srinivas C
FBP
Srinivas_C
2 wk ago
7
replies
30
SenthilKumar Sivakumar
Partner
2 wk ago
Questions & Answers
Answered
Answered
0
Retrieve Dashboard recipients information
We have setup dashboards to be sent as HTML email attachments . We wanted to get the dashboard recipients list as a part of audit/usage dashboard. We could not find recipient information stored in…
SenthilKumar Sivakumar
Partner
LSC Communications
senthil
3 wk ago
2
replies
24
SenthilKumar Sivakumar
Partner
2 wk ago
Questions & Answers
0
Sankey usage
I am playing around with this new visualization and am wondering if I can use it in the following situation: I have a table that has a state code and an office code.…
Marc Paige
Incorta User
GC Services
Marc_Paige
3 wk ago
6
replies
17
Marc Paige
Incorta User
2 wk ago
Questions & Answers
0
Address Verification/Enrichment
Hi , Is there any way to enrich/verify addresses in incorta ?
IncortaVi
Wipro LTD
IncortaVi
3 wk ago
4
replies
23
Dylan Wan
Moderator
3 wk ago
Questions & Answers
Answered
Answered
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
R. A. Dawson Sr
3 wk ago
Questions & Answers
2
Map Chart based on County
Ok, another question about maps, this time related to the "county" option. The main question I have is how do you handle counties where the multiple states have the same county name? For example,…
Dan Nielsen
Incorta User
Inmar
Dan_Nielsen
2 yrs ago
4
replies
215
2
Anurag Malik
Employee
3 wk ago
Questions & Answers
0
Global Variable used correctly?
I have a very long string (469 characters comma-separated quoted list) that I have set in a global variable. The global variable content is in a similar form to this: 'a','b','c',…
Marc Paige
Incorta User
GC Services
Marc_Paige
1 mth ago
4
replies
24
Marc Paige
Incorta User
3 wk ago
Questions & Answers
2
Incorta Integration with Web API
HI, I want to check if there is any native functionality available in Incorta to connect to Web API and extract the real-time data along with parse /load this data into Incorta.…
NP
Trial User
CS
marigold_pen
1 yr ago
2
replies
193
2
Seth Luersen
Moderator
3 wk ago
Questions & Answers
0
Automatic handling of DST?
Is there a way to specify that DST is observed? Scheduled dashboards that were set up in standard time, were delivered an hour late after the time change this past weekend.
Marc Paige
Incorta User
GC Services
Marc_Paige
1 mth ago
4
replies
31
Marc Paige
Incorta User
1 mth ago
Questions & Answers
Answered
Answered
0
Merits of using Incorta Cloud
Hi, Is there any document, which tells me what are the advantages of migrating to Incorta cloud from the Stand Alone Machines?
Ram
Incorta User
Keysight
Ram
1 mth ago
2
replies
22
Ram
Incorta User
1 mth ago
Questions & Answers
0
Comments in formula?
Is it possible to put comments in a formula?
Tom Fogarty
Incorta User
Inmar
Tom_Fogarty
2 yrs ago
5
replies
258
Ashwin Warrier
Employee
1 mth ago
Questions & Answers
1
SQL App fetch size - Default Value
What is the default value for SQL App fetch size? Is there a recommendation for tuning this for different size datasets? Thanks,
Ryan Sather
Incorta User
Gate City Bank
Ryan_Sather
1 mth ago
2
replies
13
1
Anurag Malik
Employee
1 mth ago
Questions & Answers
0
Document Checklist
Incase of migrating Incorta Instance from Standalone Machine to Incorta Cloud, do we have any default checklist to check the integrity of reports,tables and all?
Ram
Incorta User
Keysight
Ram
1 mth ago
2
replies
14
Ram
Incorta User
1 mth ago
Questions & Answers
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
R. A. Dawson Sr
1 mth ago
Questions & Answers
3
How to Embed incorta in a webpage using iframe tag
Moataz-Bellah Mishrif
Moderator
Incorta
Moataz_Mishrif
2 yrs ago
7
replies
552
3
Hasnaa Ibraheem
1 mth ago
Questions & Answers
0
Custom Radio button in filter and prompts
Hi everyone, Can I create a custom radio button in filter and prompts with filter value is [all, parent store(which storeid is 1,2,3), children store(which storeid is 11, 12, 21, 22, 31,…
Nopu Nguyen
Human
Nopu_Nguyen
1 mth ago
3
replies
21
Nopu Nguyen
1 mth ago
Questions & Answers
Answered
Answered
1
2
3
4
5
25
Next
Have a question? Ask it here. Or reply and share your knowledge.
Members
View members
Tags
View all tags
Login
Sign Up
Home
Community
Questions & Answers
Implementation Best Practices
Events
Knowledge Base
Product Announcements
Learn
Help Articles
Product Videos
Introduction to Incorta (17 Videos)
How To Videos
Tags
View all tags
Product Announcement
Incorta 5
is now Generally Available