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
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 BasilEmployee5 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 Gopinath5 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 MuthaluriIncorta User
- genworth
- Gnaneshwar_Muthaluri
- 1 yr ago
- 15 replies
- 210
- 3
- Jeff WilgusEmployee5 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 MishrifModerator6 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 vittalamIncorta User
- James Avery
- sandeep_vittalam
- 7 mths ago
- 1 reply
- 20
- DylanEmployee6 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 BrockEmployee6 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 BrockEmployee6 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. delpercio6 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 PalaniappanPartner
- Cittabase Solutions Pvt Ltd
- Nivetha_Palaniappan
- 1 yr ago
- 3 replies
- 100
- RamIncorta User6 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 KothariEmployee
- Incorta
- Amit_Kothari
- 6 mths ago
- 1 reply
- 38
- Amit KothariEmployee6 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 KothariEmployee6 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 NielsenIncorta User
- Inmar
- Dan_Nielsen
- 2 yrs ago
- 6 replies
- 192
- Roy HiggsEmployee6 mths ago
- Questions & Answers
0
How does Incorta handle Source deletions of rows ?
How can Incorta support hard deletes in Source System ?
- Amit KothariEmployee
- Incorta
- Amit_Kothari
- 2 yrs ago
- 4 replies
- 495
- Roy HiggsEmployee6 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 WanEmployee6 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 PaigeIncorta User
- GC Services
- Marc_Paige
- 7 mths ago
- 4 replies
- 31
- Marc PaigeIncorta User6 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 MahranEmployee
- Incorta
- Rasha_Mahran
- 7 mths ago
- 1 reply
- 24
- Rasha MahranEmployee7 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 MahranEmployee
- Incorta
- Rasha_Mahran
- 7 mths ago
- 1 reply
- 29
- Rasha MahranEmployee7 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 CarnegieIncorta User
- APSC
- Martin_Carnegie
- 7 mths ago
- 1 reply
- 72
- 1
- Brian KeareEmployee7 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 Gnanam7 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 WrubelEmployee7 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

Questions & Answers

Inspector Tool load error

Power BI vs Incorta

Inspector Metadata load issue - Not completing

Materialized views

Trigger a Incorta Load through a script or similar

Zookeeper not starting

Unable to see table in the formula builder

How to define Decode in Materialized View

How to perform update/delete in materialized view

Error Connecting to MongoDB

Grouping and Ranking based on Report Prompt in Incorta

ldap_sync issue

How do I schedule a dashboard to download the data to a shared folder?

UNION in Incorta

Presentation variable in insight title

Deleting rows w/o full load

How does Incorta handle Source deletions of rows ?

Join Tables Using System Generated IDs

Invalid formula?

How to define Sign function in formula

How to Extract part of data in string within Incorta

Create a calculated formula based on distinct values

Incorta version release

how to load data into Incorta Schema tables

Format as percent w/ 1 decimal place ( or 3 or .... n )

Members

Tags

Home

Tags

Product Announcement