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
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 BasilEmployee7 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 PaigeIncorta User
- GC Services
- Marc_Paige
- 7 mths ago
- 1 reply
- 27
- DylanEmployee7 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 PaigeIncorta 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 Nguyen7 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 Nguyen7 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 MalikEmployee7 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 SinghPartner
- Wipro Limited
- Alok_Singh
- 7 mths ago
- 1 reply
- 11
- Amit KothariEmployee7 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 WanModerator7 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 MishrifModerator7 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 WanModerator7 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 BrockEmployee7 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 BrockEmployee7 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 PaigeIncorta 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 RanjanIncorta User
- Starbucks
- Mukul_Ranjan
- 7 mths ago
- 5 replies
- 65
- Mukul RanjanIncorta User7 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 Bowman7 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 Hacker7 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 WanModerator7 mths ago
- Questions & Answers
2
Rename Table
Can you rename a table within Incorta after it has been loaded via Schema panel?
- Warren BillsIncorta User
- Genworth
- Warren_Bills
- 1 yr ago
- 4 replies
- 75
- 2
- Sunita DattaIncorta User8 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 KrejsaTrial User
- vVitamix
- akrejsa
- 8 mths ago
- 3 replies
- 20
- Dan BrockEmployee8 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 LuersenModerator8 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 Nguyen8 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 Nguyen8 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 Kaminsky8 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 KothariEmployee
- Incorta
- Amit_Kothari
- 8 mths ago
- 1 reply
- 38
- Amit KothariEmployee8 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 mahfouzEmployee8 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

Questions & Answers

MV can not load value

Large Excel file load

Upgrade documentation from 4.8 to 4.8.2

Count distinct in Pivot Table

Get error when load MW after upgraded to version 4.8.2

Customers' Last Purchase Dates

"$" used in Column Name

Changing default date format in dashboard prompt

Schema load finished with errors

Filter

Join in alias table

Is Undo feature available in Incorta ?

Training Exercises

Incremental Load with Union Query

Column Percentage

TMT -cf option details needed

Error Ldap sync

Rename Table

Metadata DB upgrade

incorta Quick Start Guide?

Load table fail as Materialized View

Convert date to 'yyyymmdd' format in MW

Using a variable as a field expression in functions

How do I connect to a Oracle Cloud Database from Incorta?

IfNUll on another column

Members

Tags

Home

Tags

Product Announcement