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
MV can not load value
I have created MV like this: SELECT EXADATA_URIM.TT_URIM.URIM_DEN_NO, EXADATA_URIM.TT_URIM.URIM_HKK_DATE, EXADATA_URIM.TT_URIM.URIM_HKK_TIME FROM EXADATA_URIM.TT_URIM WHERE EXADATA_URIM.TT_URIM.…
Nopu Nguyen
Human
Nopu_Nguyen
7 mths ago
1
reply
23
Dustin Basil
Employee
7 mths ago
Questions & Answers
0
Large Excel file load
I have a user that needs to upload a large excel file. The file is well beyond the maxPostSize limit. What happens if I change the limit to allow the new size?…
Marc Paige
Incorta User
GC Services
Marc_Paige
7 mths ago
1
reply
27
Dylan
Employee
7 mths ago
Questions & Answers
0
Upgrade documentation from 4.8 to 4.8.2
On the documentation site, there are instructions for upgrading to 4.8 from various previous versions. However, I cannot find instructions for the point upgrade.…
Marc Paige
Incorta User
GC Services
Marc_Paige
7 mths ago
15
Questions & Answers
0
Count distinct in Pivot Table
Hi everyone, I want to count distinct a column like above image, but the total column look like works wrong. I dont dont know why and how I can do it correct ? thank you !
Nopu Nguyen
Human
Nopu_Nguyen
7 mths ago
2
replies
35
Nopu Nguyen
7 mths ago
Questions & Answers
Answered
Answered
0
Get error when load MW after upgraded to version 4.8.2
Hi everyone! After upgraded to 4.8.2 and load MV, I get an error like this: com.incorta.api.exceptions.DataException: INC_03070101: Failed to load data from [spark://BIPDB01:…
Nopu Nguyen
Human
Nopu_Nguyen
7 mths ago
2
replies
61
Nopu Nguyen
7 mths ago
Questions & Answers
Answered
Answered
0
Customers' Last Purchase Dates
I need help to create a formula column to pull customers' last purchased dates. Thanks.
Remelie Perley
Advanced Sterilization Products
Remelie_Perley
7 mths ago
1
reply
18
Anurag Malik
Employee
7 mths ago
Questions & Answers
0
"$" used in Column Name
Hi, I have a table which consists of columns having "$" used in it's name. When I am trying to pull these columns in a SQL query, it is not taking into account and throwing me an error.…
Alok Singh
Partner
Wipro Limited
Alok_Singh
7 mths ago
1
reply
11
Amit Kothari
Employee
7 mths ago
Questions & Answers
0
Changing default date format in dashboard prompt
Hi, Is there is a way to change the date format for a column in the dashboard prompt?
Gautham
Cittabase
Gautham
8 mths ago
1
reply
31
Dylan Wan
Moderator
7 mths ago
Questions & Answers
0
Schema load finished with errors
when i load data from tables by (load now -> Full ) i get errors with the messages say : IO Error: Failed to create/update PK index for table Pleas help.
Ahmed Omar
Crystal
Ahmed_Omar
1 yr ago
8
replies
124
Moataz-Bellah Mishrif
Moderator
7 mths ago
Questions & Answers
0
Filter
How do I filter by the parent ID so that it shows Parent Prj Child Pr Lvl1, Child Pr Lvl1 Prj Pr Lvl2 Pr, and so on so forth.
Ramses Brazao
ASP
Ramses_Brazao
7 mths ago
1
reply
20
Dylan Wan
Moderator
7 mths ago
Questions & Answers
0
Join in alias table
Hi everyone! I have 3 tabled with join like this: URIM->BTN->AREA I have created alias table BTN_1 from BTN with same join. And how i can get name filed in AREA table from URIM via BTN_1(maybe it…
Nopu Nguyen
Human
Nopu_Nguyen
7 mths ago
1
reply
23
Dan Brock
Employee
7 mths ago
Questions & Answers
1
Is Undo feature available in Incorta ?
I cannot find any Undo feature specially with Insight/Dashboard development... Same is also the case with Schema, Table, Business View creation as well.…
Hari Katta
Extreme Networks
Hari_Katta
7 mths ago
1
reply
16
1
Dan Brock
Employee
7 mths ago
Questions & Answers
0
Training Exercises
To the community at large: I am working to educate my self-service users. I have been using biweekly sharing sessions with a show-and-tell approach. I ask for specific problems from my community and…
Marc Paige
Incorta User
GC Services
Marc_Paige
7 mths ago
19
Questions & Answers
0
Incremental Load with Union Query
Hi, I am trying to tackle delete scenario in source system with below logic in incremental code, its throwing error, any help is appreciated. SELECT 'N' AS IS_DELETED, ST.…
Mukul Ranjan
Incorta User
Starbucks
Mukul_Ranjan
7 mths ago
5
replies
65
Mukul Ranjan
Incorta User
7 mths ago
Questions & Answers
0
Column Percentage
How do I apply column percentages in Pivot tables?
Ghada Ossama
Future Group
Ghada_Ossama
2 yrs ago
4
replies
240
Kristen Bowman
7 mths ago
Questions & Answers
0
TMT -cf option details needed
Exactly what data does the TMT -cf option copy? Is it only the local data files, or is all data in all of the schemas? The incorta documentation doen't provide this breakdown.
Peter-Reinhard Hacker
Northern Trust
Peter_Hacker.1
7 mths ago
2
replies
10
Peter-Reinhard Hacker
7 mths ago
Questions & Answers
0
Error Ldap sync
FAIL: Couldn't search with this input due to java.naming.provider.url property does not contain a URL FAIL: java.naming.provider.url property does not contain a URL Security tab for the tenant has…
Srinivasan
Confi Com
Srinivasan
7 mths ago
3
replies
19
Dylan Wan
Moderator
7 mths ago
Questions & Answers
2
Rename Table
Can you rename a table within Incorta after it has been loaded via Schema panel?
Warren Bills
Incorta User
Genworth
Warren_Bills
1 yr ago
4
replies
75
2
Sunita Datta
Incorta User
8 mths ago
Questions & Answers
0
Metadata DB upgrade
Has anyone had to upgrade the metadata DB version? What was the process? Did you have any issues?
Andy Krejsa
Trial User
vVitamix
akrejsa
8 mths ago
3
replies
20
Dan Brock
Employee
8 mths ago
Questions & Answers
0
incorta Quick Start Guide?
Does incorta offer a Quick Start guide for new business users. Something else besides the "docs" link, which can get almost immediately technical. Thanks...Pete
Peter-Reinhard Hacker
Northern Trust
Peter_Hacker.1
8 mths ago
2
replies
31
Seth Luersen
Moderator
8 mths ago
Questions & Answers
0
Load table fail as Materialized View
I have a problem with Materialized View(using SQL not Python, I use INNER JOIN between two table which has 300M rows table and 2M rows table) when I try to load table,…
Nopu Nguyen
Human
Nopu_Nguyen
8 mths ago
2
replies
86
Nopu Nguyen
8 mths ago
Questions & Answers
Answered
Answered
0
Convert date to 'yyyymmdd' format in MW
Hi everyone! I want to convert CURRENT_DATE to format 'yyyyMMdd' in materialized view, I try CONVERT, and FORMAT function but it's not supported in SQL of MW, how I can do that ? thank you.
Nopu Nguyen
Human
Nopu_Nguyen
8 mths ago
2
replies
34
Nopu Nguyen
8 mths ago
Questions & Answers
Answered
Answered
0
Using a variable as a field expression in functions
I would like to use a variable as a parameter in functions that take a field expression if possible. For instance, the following syntax works. inList(SALES.COUNTRIES.…
Vlad Kaminsky
GNC Consulting, Inc.
Vlad_Kaminsky
8 mths ago
5
replies
42
Vlad Kaminsky
8 mths ago
Questions & Answers
0
How do I connect to a Oracle Cloud Database from Incorta?
I need to connect to a Oracle Cloud Database from Incorta, please show me the steps.
Amit Kothari
Employee
Incorta
Amit_Kothari
8 mths ago
1
reply
38
Amit Kothari
Employee
8 mths ago
Questions & Answers
Answered
Answered
0
IfNUll on another column
I have two columns ie Sales, Profit. So, my requirement is if Sales is Null then 0 else if Sales not Null Profit. I tried using IfNull and IsNull functions but no luck.…
pavan
kpipartners
pavan
8 mths ago
1
reply
22
Tamer mahfouz
Employee
8 mths ago
Questions & Answers
Answered
Answered
1
3
4
5
6
7
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