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
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 Ranjan
Incorta User
Starbucks
Mukul_Ranjan
6 mths ago
23
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 Fox
Incorta User
National Oilwell Varco
Michelle_Fox
6 mths ago
5
replies
59
Dylan Wan
Moderator
6 mths 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 Mascitti
Incorta User
Northwestern Mutual
Mike_Mascitti
6 mths ago
5
replies
23
Hichem Sellami
Employee
6 mths 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
6 mths ago
14
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
6 mths ago
3
replies
20
R. A. Dawson Sr
6 mths 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 Ranjan
Incorta User
Starbucks
Mukul_Ranjan
6 mths ago
2
replies
21
Mukul Ranjan
Incorta User
6 mths 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 Mayfield
Incorta User
Redstone Federal Credit Union
Barry_Mayfield
6 mths ago
23
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
6 mths ago
3
replies
35
Anurag Malik
Employee
6 mths ago
Questions & Answers
Answered
Answered
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
6 mths ago
2
replies
21
Dylan Wan
Moderator
6 mths ago
Questions & Answers
0
Display Current Date on Dashboard
How do I display the current date on a dashboard?
Raj Lalchandani
Incorta
Raj_Lalchandani
6 mths ago
1
reply
34
Dylan Wan
Moderator
6 mths 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
6 mths ago
1
reply
27
Dylan Wan
Moderator
6 mths 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
6 mths ago
1
reply
24
Dylan
Employee
6 mths 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
6 mths ago
7
replies
39
Anurag Malik
Employee
6 mths 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 Mishrif
Moderator
Incorta
Moataz_Mishrif
6 mths ago
1
reply
10
Moataz-Bellah Mishrif
Moderator
6 mths 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 Fogarty
Incorta User
Inmar
Tom_Fogarty
2 yrs ago
11
replies
212
1
Sunita Datta
Incorta User
7 mths 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 Paige
Incorta User
GC Services
Marc_Paige
7 mths ago
1
reply
32
Dylan Wan
Moderator
7 mths ago
Questions & Answers
Answered
Answered
0
How to get max value in prompt default filter
I have selected a date column in prompt and for "default filter" , I am using "$currentDate". Existing Scenario : sometimes due to load timings data for $currentDate is not yet populated.…
Gautham
Cittabase
Gautham
7 mths ago
1
reply
39
Anurag Malik
Employee
7 mths ago
Questions & Answers
0
Apache Tomcat AJP Connector Request Injection (Ghostcat)
What would be the Incorta recommended method for addressing the Apache Tomcat AJP Connector Request Injection (Ghostcat) vulnerability?
Barry Mayfield
Incorta User
Redstone Federal Credit Union
Barry_Mayfield
7 mths ago
7
Questions & Answers
0
How Table Load Order and MV Load Order work?
For Incorta 3.x table load order, does higher mean it will load sooner or later. ie does 11 load before 10? also do materialized views and tables both use the same queue,…
Dylan
Employee
Facebook
Dylan_at_facebook
2 yrs ago
3
replies
134
Dylan Wan
Moderator
7 mths ago
Questions & Answers
0
Data Dictionary
Hi, I am trying to create a data dictionary for business users in Incorta, it should give details of all the business schemas and the filed names, label, description and source column/formula.…
Mukul Ranjan
Incorta User
Starbucks
Mukul_Ranjan
7 mths ago
7
replies
71
Dylan
Employee
7 mths ago
Questions & Answers
0
Sum two formulas column in aggregated table.
Hi, I have created 3 formulas column: formula_1, formula_2, formula_3. In formula_3, I want to sum formula_1 and formula_2 like: formula_1 + formula_2.…
Nopu Nguyen
Human
Nopu_Nguyen
7 mths ago
2
replies
38
Amit Kothari
Employee
7 mths ago
Questions & Answers
Answered
Answered
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
Dustin Basil
Employee
7 mths ago
Questions & Answers
Answered
Answered
0
Avoiding dividing by zero (0)
I have a business formula field with the following formula: if( OPS_Metrics.CallCountbyDay.IsPhoneActivity = 0, 0, OPS_Metrics.CallCountbyDay.IsRightPartyConnect / OPS_Metrics.CallCountbyDay.…
Marc Paige
Incorta User
GC Services
Marc_Paige
7 mths ago
4
replies
27
Marc Paige
Incorta User
7 mths ago
Questions & Answers
1
Level Based Measure
Hi, I created Level Based Measure in the report as below but am getting zero values. Can any one help me? sum( EBS_AR.RA_INTERFACE_LINES_ALL.AMOUNT, groupBy( EBS_ITEM_COMMON.…
KHK
Wipro
Hari_K
7 mths ago
2
replies
29
1
Amit Kothari
Employee
7 mths ago
Questions & Answers
1
how to save report into PDF format
Hi All, Can we save incorta Dashboard / report in to PDF file & can we send it to email? Thank you, Ramu
Ramu Machineni
Partner
wipro
Ramu_Machineni
1 yr ago
5
replies
88
1
joseph. delpercio
7 mths ago
Questions & Answers
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