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

Join

0
Average number of strings
I was looking to create a dashboard that had an average number of new accounts per month. Easy right? I selected a pivot table and placed the calculated month for the main column,…
- Marc PaigeIncorta User
- GC Services
- Marc_Paige
- 9 hrs ago
- 1 reply
- 8
- Marc PaigeIncorta User4 hrs ago
- Questions & Answers
- Answered
- Answered
0
Aggregate Report
Hello Incorta, I am having an issue creating an aggregate report. When creating a Pivot or Aggregate report the QTY & Amount Measures return " The result set is too large and exceeds the max group…
- Patrick AckleyIncorta User
- Starbucks Coffee Company
- Patrick_Ackley
- yesterday
- 2 replies
- 20
- Dustin BasilEmployee13 hrs ago
- Questions & Answers
0
Can we create users from a active directory list?
Can we create users from a active directory list? Or need to add one after one? Or is there a way where i can create a excel list , with user name, Display name, Email?
- Ramu MachineniPartner
- wipro
- Ramu_Machineni
- 6 days ago
- 3 replies
- 20
- Dustin BasilEmployeeyesterday
- Questions & Answers
0
Incorta failed to read '$' in SQL query.
Hi Team, I was trying a SQL query which is running fine in Oracle, but getting failed in incorta. Incorta is unable to read the entire query from the '$' sign. Query: SELECT jt.…
- RudraIncorta User
- Quest Global
- Rudra
- yesterday
- 2 replies
- 11
- Dan BrockEmployeeyesterday
- Questions & Answers
1
Incorta can be integrated with Okta(Identity Mgmt) tool?
Hi team, Is Incorta can be integrated with Okta(Identity Mgmt) tool? If yes, can you please share some documents for it? Thank you, Ramu
- Ramu MachineniPartner
- wipro
- Ramu_Machineni
- yesterday
- 1 reply
- 5
- 1
- Matthew HallidayEmployeeyesterday
- Questions & Answers
0
Sharing dashboards not obeying folder structure
I have shared a folder for view and at one point had specific dashboards within the folder shared. I want the folder structure to be obeyed when I share these dashboards.…
- Tom FogartyIncorta User
- Inmar
- Tom_Fogarty
- 1 mth ago
- 2 replies
- 26
- Naresh KumarPartner3 days ago
- Questions & Answers
0
File extension?
Hi All, Source data will be loaded to Incorta load service in the form of parquet files, can some one please let me know what is the extension for the saved files? Thank you, Ramu
- Ramu MachineniPartner
- wipro
- Ramu_Machineni
- 9 days ago
- 3 replies
- 14
- Ahmed MoawadEmployee6 days ago
- Questions & Answers
0
Pivot Table Measures Structure
Is there a way to stack measures in a pivot table on top of each other, rather than having them grouped side by side, bucketed by the column dimension?
- Mark SamuelsIncorta User
- Shutterfly
- Mark_Samuels
- 9 days ago
- 1 reply
- 9
- Seth LuersenModerator8 days ago
- Questions & Answers
0
Incorta Table/View not available
I have a table I created from an incorta data source. It is an aggregated table. I need to evaluate the aggregate results to assign another value to the row.…
- amy yosteIncorta User
- Pickup
- amy_yoste
- 9 days ago
- 3 replies
- 9
- Seth LuersenModerator8 days ago
- Questions & Answers
5
Formula functions tips.
- Ahmed EltanahyEmployee
- Incorta
- Ahmed_Eltanahy
- 1 yr ago
- 1 reply
- 1,889
- 5
- Hannah KirkEmployee8 days ago
- Questions & Answers
- Answered
- Answered
0
Can Incorta become source system ?
Hi All, Can Incorta become source system for other target system? Like, we load the data from diff source(DB) to Incorta (target) system. In other side,…
- Ramu MachineniPartner
- wipro
- Ramu_Machineni
- 9 days ago
- 1 reply
- 14
- Dan BrockEmployee9 days ago
- Questions & Answers
0
How to achieve this decode statement
Hi, I want to achieve the below logic in Incorta. DECODE(CODE, NULL, NULL, DATE) Code - Varchar field; Date- Date field If Code is null return null else return date. Thanks,
- Gautham
- Cittabase
- Gautham
- 3 mths ago
- 5 replies
- 52
- Anurag MalikEmployee13 days ago
- Questions & Answers
1
Column is not getting showed up even after loading the table successfully.
I am not able to access a column while developing an insight in a dashboard even after the table (which contains the column) and the column have been successfully loaded into the Incorta memory.…
- Alok SinghPartner
- Wipro Limited
- Alok_Singh
- 3 wk ago
- 5 replies
- 33
- 1
- Amit KothariEmployee13 days 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
- 6 mths ago
- 5 replies
- 121
- Dustin BasilEmployee2 wk ago
- Questions & Answers
0
Using Session Variables in Load Filter syntax
Can we use session variables in Load Filter (specified in table details in schema) ? If yes, what is the syntax? I have created a session variable GLOBAL_CURR_CD_Sample.…
- IndumathiPartner
- Cittabase
- Indumathi
- 2 wk ago
- 1 reply
- 16
- Hichem SellamiEmployee2 wk ago
- Questions & Answers
- Answered
- Answered
0
Quickbooks connector
I thought that there was a way to connect to Quickbooks but i am not finding any documentation on this. Was I imagining it?
- amy yosteIncorta User
- Pickup
- amy_yoste
- 3 wk ago
- 1 reply
- 16
- Dustin BasilEmployee3 wk ago
- Questions & Answers
0
Incremental load
Hello All, Can any one help me to understand how can we perform the incremental load in Incorta for the tables which does not contain any date columns such as Last Updated Date etc.
- Praveen ManthaPartner
- Axiom Path
- Praveen_Mantha
- 7 mths ago
- 8 replies
- 239
- Amit KothariEmployee3 wk ago
- Questions & Answers
0
2nd Level aggregate on specific groups
I have a requirement which needs aggregation to be applied, on aggregated data, on specific groups. Something similar to the pseudo-SQL statement below.…
- Naresh KumarPartner
- Pramati Technologies
- Naresh_Kumar
- 1 mth ago
- 8 replies
- 43
- Matthew HallidayEmployee4 wk ago
- Questions & Answers
0
Using a Business View to Update a Historical Table
How bad of an idea is it to use a business schema as a source for a historical table in schema? We have a requirement to keep a snapshot of customer data on a monthly basis.…
- Ryan SatherIncorta User
- Gate City Bank
- Ryan_Sather
- 4 wk ago
- 3 replies
- 19
- Dan BrockEmployee4 wk ago
- Questions & Answers
0
Incremental Query visibility
I am having some incremental load issues and would like to see the actual query used. Is it available in the audit somewhere? I am trying to triage the issue before resorting to a support ticket.
- Marc PaigeIncorta User
- GC Services
- Marc_Paige
- 1 mth ago
- 4 replies
- 27
- Marc PaigeIncorta User4 wk ago
- Questions & Answers
0
Loader Service getting stopped automatically when trying to load any shema.
Hi We are using Incorta version 4.4 and there is one issue that we are facing that whenever we are trying to load any schema ,Loader service is getting automatically stopped.…
- harshPartner
- wipro
- harsh
- 4 wk ago
- 1 reply
- 19
- Hichem SellamiEmployee4 wk 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
- 3 mths ago
- 6 replies
- 50
- harshPartner4 wk ago
- Questions & Answers
0
Exception for Tables Not Populating
Is there a way to trigger an exception or e-mail if a specific table does not populate data when refreshed?
- Mark SamuelsIncorta User
- Shutterfly
- Mark_Samuels
- 1 mth ago
- 4 replies
- 22
- Joe SteinbrunnerIncorta User1 mth ago
- Questions & Answers
0
Filtering on One to Many Relationships
Consider a schema with 3 tables: Animal (base table) - one row per animal (e.g. lion, bear, horse, trout, eagle...) AnimalColor - one row for each animal/color combo,…
- Dan NielsenIncorta User
- Inmar
- Dan_Nielsen
- 5 mths ago
- 7 replies
- 150
- Anurag MalikEmployee1 mth ago
- Questions & Answers
0
Business Days Between
Hi everyone, sorry if this has been asked before (I've searched the forum and documentation and can't find a solution). I have a need to be able to calculate business days between two dates…
- Sam
- Zeus
- Sam
- 1 mth ago
- 3 replies
- 50
- Sam1 mth ago
- Questions & Answers
- Answered
- Answered

1 2 3 4 5 15 Next

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

Members

View members

Get Help

Product Documentation

Questions & Answers

Average number of strings

Aggregate Report

Can we create users from a active directory list?

Incorta failed to read '$' in SQL query.

Incorta can be integrated with Okta(Identity Mgmt) tool?

Sharing dashboards not obeying folder structure

File extension?

Pivot Table Measures Structure

Incorta Table/View not available

Formula functions tips.

Can Incorta become source system ?

How to achieve this decode statement

Column is not getting showed up even after loading the table successfully.

Aggregate Filter by Formula

Using Session Variables in Load Filter syntax

Quickbooks connector

Incremental load

2nd Level aggregate on specific groups

Using a Business View to Update a Historical Table

Incremental Query visibility

Loader Service getting stopped automatically when trying to load any shema.

Schema load finished with errors

Exception for Tables Not Populating

Filtering on One to Many Relationships

Business Days Between

Members

Get Help

More

Tags

Home

Tags