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
Inspector Tool load error
Schema: Inspector Metadata How to fix this? IO error occurred during extracting: Cannot run program "chmod": error=24, Too many open files BUSINESS_SCHEMA_VIEWS- INC_03010101:…
Srinivasan
Confi Com
Srinivasan
5 mths ago
3
replies
20
Dustin Basil
Employee
5 mths ago
Questions & Answers
1
Power BI vs Incorta
Hi, Could you please anyone elaborate the Power BI tools vs Incorta. What is difference between with it ? Please help on this
Rajesh
Psiog Digital
Rajesh.1
10 mths ago
4
replies
131
1
Shankar Gopinath
5 mths ago
Questions & Answers
0
Inspector Metadata load issue - Not completing
Please help - Temp file for [InspectorMetadata.SCHEMA_TABLES._#0040JOIN#0040_LINEAGE_REPORT.zxc] in path /nfs/ict/app/Incorta/Tenant/XXX/snapshots/InspectorMetadata.SCHEMA_TABLES.…
Srinivasan
Confi Com
Srinivasan
5 mths ago
19
Questions & Answers
0
Materialized views
Hi Team, I have created two MV's (CUST_TRX_V,SALES_BY_CUSTOMER_MV) in the Customer Schema of my Incorta Application. Two MV's are created, i can see the records for CUST_TRX,…
Anil Kumar Katari
Caprium
Anil_Kumar_Katari
5 mths ago
7
Questions & Answers
3
Trigger a Incorta Load through a script or similar
We have an external scheduling tool from which can run shell/cmd scripts on a machine.. we want to trigger an incorta job load using this tool (Appworx,…
Gnaneshwar Muthaluri
Incorta User
genworth
Gnaneshwar_Muthaluri
1 yr ago
15
replies
210
3
Jeff Wilgus
Employee
5 mths ago
Questions & Answers
Answered
Answered
0
Zookeeper not starting
Zookeeper is not starting at all. What can cause this. verson 4.7.2
Srinivasan
Confi Com
Srinivasan
6 mths ago
3
replies
11
Moataz-Bellah Mishrif
Moderator
6 mths ago
Questions & Answers
0
Unable to see table in the formula builder
Hi All, I am trying to build some calculated columns using the formula builder when creating a table in a schema. I am trying to use the lookup function to build the columns.…
sandeep vittalam
Incorta User
James Avery
sandeep_vittalam
7 mths ago
1
reply
20
Dylan
Employee
6 mths ago
Questions & Answers
0
How to define Decode in Materialized View
Hi, can anyone help me how to convert below query in Materialized View? ROUND(DECODE (ACOST.ORGANIZATION_ID, APARM.COST_ORGANIZATION_ID, DECODE (ACOST.COST_TYPE_ID, CTYPE.COST_TYPE_ID, NVL (ACOST.…
KHK
Wipro
Hari_K
6 mths ago
1
reply
16
Dan Brock
Employee
6 mths ago
Questions & Answers
0
How to perform update/delete in materialized view
I have created an MV with complex logic involving large tables and aggregate functions. As part of a new request, I need to update/delete certain records as well as change column data type.…
Gautham
Cittabase
Gautham
6 mths ago
1
reply
19
Dan Brock
Employee
6 mths ago
Questions & Answers
0
Error Connecting to MongoDB
Hey team, Anyone else faced this similiar error when connecting to MongoDb and if so, how did you resolve? Communications link failure The last packet sent successfully to the server was 0…
joseph. delpercio
Scientific Games
joseph_delpercio
6 mths ago
12
replies
35
joseph. delpercio
6 mths ago
Questions & Answers
0
Grouping and Ranking based on Report Prompt in Incorta
My table CUSTOMER_TRX_MV has the below sample , INVOICE_RANK will partition the records based on customer# and order by invoice date RANK ()OVER ( PARTITION BY CUSTOMER# ORDER BY invoice_date DESC)…
Nivetha Palaniappan
Partner
Cittabase Solutions Pvt Ltd
Nivetha_Palaniappan
1 yr ago
3
replies
100
Ram
Incorta User
6 mths ago
Questions & Answers
0
ldap_sync issue
TypeError: sync_directory_with_ldap() takes from 1 to 2 positional arguments but 5 were given Delivered script : sync_directory.py
Srinivasan
Confi Com
Srinivasan
6 mths ago
7
Questions & Answers
0
How do I schedule a dashboard to download the data to a shared folder?
Need to know the steps to schedule a dashboard to download the data to a shared folder
Amit Kothari
Employee
Incorta
Amit_Kothari
6 mths ago
1
reply
38
Amit Kothari
Employee
6 mths ago
Questions & Answers
Answered
Answered
0
UNION in Incorta
Dear all, is there a known issue concerning the union in incorta? I'm trying to a SQL union with a table in one of my schema and whenever I execute the query,…
Luigi Riccio
Starbucks
Luigi_Riccio
6 mths ago
5
replies
53
Amit Kothari
Employee
6 mths ago
Questions & Answers
0
Presentation variable in insight title
Hi Team, I am using presentation variable in my dashboard and using the same in insight title as well. But when I change the value of my presentation variable,…
Pragya Shukla
Wipro Ltd
Pragya_Shukla
6 mths ago
34
Questions & Answers
0
Deleting rows w/o full load
Is there a way to delete unwanted rows from a table without performing a full schema load? I have a large schema that is incrementally populated, and the source data is systematically deleted after…
Dan Nielsen
Incorta User
Inmar
Dan_Nielsen
2 yrs ago
6
replies
192
Roy Higgs
Employee
6 mths ago
Questions & Answers
0
How does Incorta handle Source deletions of rows ?
How can Incorta support hard deletes in Source System ?
Amit Kothari
Employee
Incorta
Amit_Kothari
2 yrs ago
4
replies
495
Roy Higgs
Employee
6 mths ago
Questions & Answers
0
Join Tables Using System Generated IDs
Can you join tables using system generated IDs (i.e. Account ID in Salesforce.com)?
Remelie Perley
Advanced Sterilization Products
Remelie_Perley
6 mths ago
1
reply
8
Dylan Wan
Employee
6 mths ago
Questions & Answers
0
Invalid formula?
The parts of this formula are all valid. However, when put together, the message "INVALID FORMULA" is displayed. The schema and table names have been sanitized,…
Marc Paige
Incorta User
GC Services
Marc_Paige
7 mths ago
4
replies
31
Marc Paige
Incorta User
6 mths ago
Questions & Answers
Answered
Answered
0
How to define Sign function in formula
Hi, Please let me know how to define below formula using tables. DECODE (SIGN (XLA_MTL_TRANSACTION_ACCOUNTS.BASE_TRANSACTION_VALUE), 1, XLA_MTL_TRANSACTION_ACCOUNTS.…
KHK
Wipro
Hari_K
6 mths ago
11
Questions & Answers
0
How to Extract part of data in string within Incorta
Question: I'm trying to determine if there is a solution within incorta (ideally a formula column in my schema) to split up a string value and extract part of it to its own column.…
Rasha Mahran
Employee
Incorta
Rasha_Mahran
7 mths ago
1
reply
24
Rasha Mahran
Employee
7 mths ago
Questions & Answers
0
Create a calculated formula based on distinct values
We are trying to create a logic where we want the distinct count of a dimension when a measure equals a certain value problem: *when a distinct function is enclosed into a sum function it works as…
Rasha Mahran
Employee
Incorta
Rasha_Mahran
7 mths ago
1
reply
29
Rasha Mahran
Employee
7 mths ago
Questions & Answers
1
Incorta version release
Hi All, I am not sure if it is just me, but does it seem like major version releases are coming so fast that I do not even know what one to go with? We have been stuck on 4.…
Martin Carnegie
Incorta User
APSC
Martin_Carnegie
7 mths ago
1
reply
72
1
Brian Keare
Employee
7 mths ago
Questions & Answers
0
how to load data into Incorta Schema tables
I'm trying to load data from outside using other etl tool like SSIS/Nifi into incorta schema. I tired connecting incorta schema with pgadmin4 client on port 5436 but it let me to do only select…
Ari Gnanam
SG
Ari_Gnanam
7 mths ago
4
replies
31
Ari Gnanam
7 mths ago
Questions & Answers
0
Format as percent w/ 1 decimal place ( or 3 or .... n )
Are the only "percent" format options in an Insight rounded or 2 decimals? How can I present percents as n.n% ? Thank you and apologies if this is obvious ... Oh, and 4.7.3
R. A. Dawson Sr
PMsquare
R_A_Dawson_Sr
7 mths ago
1
reply
25
Dave Wrubel
Employee
7 mths ago
Questions & Answers
1
3
4
5
6
7
24
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
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 4.9
is now Generally Available (GA)!!!