Community

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
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
- 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 FoxIncorta User
- National Oilwell Varco
- Michelle_Fox
- 6 mths ago
- 5 replies
- 59
- Dylan WanModerator6 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 MascittiIncorta User
- Northwestern Mutual
- Mike_Mascitti
- 6 mths ago
- 5 replies
- 23
- Hichem SellamiEmployee6 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 Sr6 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 RanjanIncorta User
- Starbucks
- Mukul_Ranjan
- 6 mths ago
- 2 replies
- 21
- Mukul RanjanIncorta User6 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 MayfieldIncorta 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 MalikEmployee6 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 WanModerator6 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 WanModerator6 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 WanModerator6 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
- DylanEmployee6 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 MalikEmployee6 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 MishrifModerator
- Incorta
- Moataz_Mishrif
- 6 mths ago
- 1 reply
- 10
- Moataz-Bellah MishrifModerator6 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 FogartyIncorta User
- Inmar
- Tom_Fogarty
- 2 yrs ago
- 11 replies
- 212
- 1
- Sunita DattaIncorta User7 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 PaigeIncorta User
- GC Services
- Marc_Paige
- 7 mths ago
- 1 reply
- 32
- Dylan WanModerator7 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 MalikEmployee7 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 MayfieldIncorta 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,…
- DylanEmployee
- Facebook
- Dylan_at_facebook
- 2 yrs ago
- 3 replies
- 134
- Dylan WanModerator7 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 RanjanIncorta User
- Starbucks
- Mukul_Ranjan
- 7 mths ago
- 7 replies
- 71
- DylanEmployee7 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 KothariEmployee7 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 BasilEmployee7 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 PaigeIncorta User
- GC Services
- Marc_Paige
- 7 mths ago
- 4 replies
- 27
- Marc PaigeIncorta User7 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 KothariEmployee7 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 MachineniPartner
- wipro
- Ramu_Machineni
- 1 yr ago
- 5 replies
- 88
- 1
- joseph. delpercio7 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

Questions & Answers

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

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...

How to get max value in prompt default filter

Apache Tomcat AJP Connector Request Injection (Ghostcat)

How Table Load Order and MV Load Order work?

Data Dictionary

Sum two formulas column in aggregated table.

AWS Linux install - insufficient disk space message

Avoiding dividing by zero (0)

Level Based Measure

how to save report into PDF format

Members

Tags

Home

Tags

Product Announcement