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

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
- 207
- 3
- Jeff WilgusEmployee2 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
- 3 mths ago
- 3 replies
- 11
- Moataz-Bellah MishrifModerator3 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
- 4 mths ago
- 1 reply
- 19
- DylanEmployee3 mths ago
- Questions & Answers
0
Aggregate Filter by Formula
I have an aggregated table that shows a selected company's prescriptions and compares them to the rest of the industry. The table groups by a drug category,…
- Dan NielsenIncorta User
- Inmar
- Dan_Nielsen
- 1 yr ago
- 12 replies
- 240
- Mark SamuelsIncorta User3 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
- 3 mths ago
- 1 reply
- 13
- Dan BrockEmployee3 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
- 3 mths ago
- 1 reply
- 18
- Dan BrockEmployee3 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
- 3 mths ago
- 12 replies
- 23
- joseph. delpercio3 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
- 9 mths ago
- 3 replies
- 85
- RamIncorta User3 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
- 3 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
- 3 mths ago
- 1 reply
- 25
- Amit KothariEmployee3 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
- 4 mths ago
- 5 replies
- 47
- Amit KothariEmployee3 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
- 3 mths ago
- 32
- 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
- 1 yr ago
- 6 replies
- 183
- Roy HiggsEmployee3 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
- 446
- Roy HiggsEmployee3 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
- 3 mths ago
- 1 reply
- 8
- Dylan WanEmployee3 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
- 4 mths ago
- 4 replies
- 30
- Marc PaigeIncorta User3 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
- 3 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
- 4 mths ago
- 1 reply
- 19
- Rasha MahranEmployee4 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
- 4 mths ago
- 1 reply
- 18
- Rasha MahranEmployee4 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
- 4 mths ago
- 1 reply
- 65
- 1
- Brian KeareEmployee4 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
- 4 mths ago
- 4 replies
- 26
- Ari Gnanam4 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
- 4 mths ago
- 1 reply
- 17
- Dave WrubelEmployee4 mths ago
- Questions & Answers
0
Getting Month Start Date from Month Year
I have a dashboard with a presentation variable of Month Year called my_pv and want to filter by Month Start Date based on the selected Month Year. I have explored the use of session variables but…
- Marc PaigeIncorta User
- GC Services
- Marc_Paige
- 4 mths ago
- 9 replies
- 27
- Anurag MalikEmployee4 mths ago
- Questions & Answers
- Answered
- Answered
0
listagg function in Incorta
Hi, Can you please tell me,on how to implement the below listagg function in Incorta LISTAGG( RA_CUSTOMER_TRX_LINES_ALL.ATTRIBUTE14,',') WITHIN GROUP ( ORDER BY RA_CUSTOMER_TRX_LINES_ALL.…
- RamIncorta User
- Cittabase
- Ram
- 4 mths ago
- 9 replies
- 40
- Amit KothariEmployee4 mths ago
- Questions & Answers
- Answered
- Answered
0
Scheduling Schema Loads between times
Hi All, We are doing some daily loads, which are working ok, but we have some data sources that we want to run multiple times a day, but only between certain hours.…
- Martin CarnegieIncorta User
- APSC
- Martin_Carnegie
- 5 mths ago
- 4 replies
- 30
- Martin CarnegieIncorta User4 mths ago
- Questions & Answers

1 2 3 4 5 23 Next

Have a question? Ask it here. Or reply and share your knowledge.

Members

View members

Questions & Answers

Trigger a Incorta Load through a script or similar

Zookeeper not starting

Unable to see table in the formula builder

Aggregate Filter by Formula

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 )

Getting Month Start Date from Month Year

listagg function in Incorta

Scheduling Schema Loads between times

Members

Tags

Home

Tags

Product Announcement