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
To calculate time between dates of weekdays only.
Can I calculate the time between two dates including only weekdays for e.g. 1/9/15 2:23:40 PM and 1/15/15 4:06:10 PM between these two dates if I use timebetween(D1,…
- Root_08012020
- INFOSYS
- Root_08012020
- 13 days ago
- 5 replies
- 34
- Anurag MalikEmployee3 days 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
- 5 days ago
- 2 replies
- 13
- Anurag MalikEmployee3 days ago
- Questions & Answers
0
Comments in formula?
Is it possible to put comments in a formula?
- Tom FogartyIncorta User
- Inmar
- Tom_Fogarty
- 1 yr ago
- 2 replies
- 188
- Mukul RanjanIncorta User5 days ago
- Questions & Answers
0
Internal IO exception for Incremental Python Code
I am trying to setup incremental logic for a MV in Python, but getting error "INC_004028001:Internal IO exception". Below is the code I am using, appreciate any help on this error message from…
- Mukul RanjanIncorta User
- Starbucks
- Mukul_Ranjan
- 5 days ago
- 5
- Questions & Answers
0
Mulit Source vs. Incorta Table?
I have a team that is using Incorta tables. In the schema, the icon and text show "Multi Source" and "Incorta View". Each of these tables use a single source table.…
- Marc PaigeIncorta User
- GC Services
- Marc_Paige
- 5 days ago
- 7
- Questions & Answers
1
What is Incorta Excel Add-in
What is Incorta Excel Add-in and what is it used for?
- Ayat AboelnagaEmployee
- Incorta
- Ayat_Aboelnaga
- 1 yr ago
- 7 replies
- 318
- 1
- Martin CarnegieIncorta User6 days ago
- Questions & Answers
0
MV on a remote (Azure datalake) parquet location
I am trying to read parquet files directly from a remote Azure location. I dont want to load data within Incorta as there are frequent writes and dont want data inconsistency issues.…
- Srinivasa Vasu
- Starbucks
- Srinivasa_Vasu
- 2 wk ago
- 2 replies
- 23
- Ahmed MoawadEmployee10 days ago
- Questions & Answers
0
Incremental load from Data Lake
I have data loading from Azure Data Lake Storage (ADLS) using Data Lake connection in Incorta, when I enable incremental load for this table, how does Incorta find the incremental data ?…
- Mukul RanjanIncorta User
- Starbucks
- Mukul_Ranjan
- 11 days ago
- 2 replies
- 17
- Mukul RanjanIncorta User11 days ago
- Questions & Answers
0
Can we change the data in incorta report?
Hi Can we re name column data in incorta? Nothing but edit Aliase in tableau/ rename the data. Like: If (month ) = 'may' then 'May' else (Month ) end.
- Ramu MachineniPartner
- wipro
- Ramu_Machineni
- 12 days ago
- 1 reply
- 12
- Dustin BasilEmployee12 days ago
- Questions & Answers
0
how to change dashboard schema
Hi All, I have created schema name "A" and dashboard on top of the same schema. Now i have created another scheme with more tables "A+". Can some one please tell me how can i point my dashboard to…
- Ramu MachineniPartner
- wipro
- Ramu_Machineni
- 13 days ago
- 1 reply
- 14
- Dan BrockEmployee13 days ago
- Questions & Answers
0
('Py4JJavaError', ':', Py4JJavaError(u'An error occurred while calling o100.parquet.\n', JavaObject id=o101))
('Py4JJavaError', ':', Py4JJavaError(u'An error occurred while calling o100.parquet.\n', JavaObject id=o101)) I'm getting this error when Im trying to load a MV in Incorta.…
- harshPartner
- wipro
- harsh
- 2 wk ago
- 1 reply
- 9
- Dustin BasilEmployee2 wk ago
- Questions & Answers
0
NoLock on sql statements in table extract
I have a sql statement that extracts the data from a table that is affecting the database availability to others when it runs. I'd like to add 'no lock' to the statement but when i do so,…
- amy yosteIncorta User
- Pickup
- amy_yoste
- 2 wk ago
- 4 replies
- 15
- Dustin BasilEmployee2 wk ago
- Questions & Answers
- Answered
- Answered
0
Formatting options
Where i can see more formatting options, like front size, type, ...... i am seeing only two options with limited set of functions, show values, legends...…
- Ramu MachineniPartner
- wipro
- Ramu_Machineni
- 2 wk ago
- 4 replies
- 17
- Dan BrockEmployee2 wk ago
- Questions & Answers
0
Trendlines
Does Incorta support trendlines in the bar chart or line graph insights? if so, how ?
- amy yosteIncorta User
- Pickup
- amy_yoste
- 1 mth ago
- 3 replies
- 36
- Gary WinerIncorta User2 wk ago
- Questions & Answers
2
Internal Server Error - Schema Status Is Not Complete
I'm getting this error message when opening the schema maintenance on a specific schema. This schema was imported from another server. On the original server, I receive no error,…
- Joe SteinbrunnerIncorta User
- Inmar
- Joe_Steinbrunner
- 1 mth ago
- 9 replies
- 33
- 2
- Dan BrockEmployee2 wk ago
- Questions & Answers
- Answered
- Answered
0
Top N in 4.5.X
Is there a different way to limit dashboards for Top N in the newer versions of Incorta? All the documentation I see on it is by sorting on the measure amount and subsequently limiting the number of…
- Jack KuehnPartner
- eCapital Advisors
- Jack_Kuehn
- 1 mth ago
- 2 replies
- 16
- Dan BrockEmployee1 mth ago
- Questions & Answers
0
Schedule dashboard through CLI
Hi, can we schedule a dashboard through CLI?
- RamIncorta User
- wipro
- Ram
- 1 mth ago
- 2 replies
- 27
- RamIncorta User1 mth ago
- Questions & Answers
0
SQL INSERT INTO
Is it possible to add records to a table from outside the Incorta User Interface? INSERT INTO table_name ( column1 , column2 , column3 , ...) VALUES ( value1 , value2 , value3 , ...…
- Todd GaluskaPartner
- eCapital Advisors
- Todd_Galuska
- 1 mth ago
- 2 replies
- 16
- Todd GaluskaPartner1 mth ago
- Questions & Answers
2
How to Embed incorta in a webpage using iframe tag
- Moataz-Bellah MishrifModerator
- Incorta
- Moataz_Mishrif
- 1 yr ago
- 2 replies
- 265
- 2
- SrinivasPartner1 mth ago
- Questions & Answers
0
Issue with iframe
Hi, We are working on creating an iframe to call a specific incorta dashboard into iframe. We are currently able to display the dashboard in the iframe. We are facing following issues 1.…
- SrinivasPartner
- Wipro Technologies
- Srinivas
- 1 mth ago
- 8
- 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
- 7 mths ago
- 10 replies
- 178
- Marc PaigeIncorta User1 mth ago
- Questions & Answers
0
List of Business Schema details
Does anyone have any recommendations for quickly pulling all of the columns and rows inside a business schema using the GUI? For example, I have a BS that has 27 views and approx 150 columns and I'd…
- Michelle FoxIncorta User
- National Oilwell Varco
- Michelle_Fox
- 1 mth ago
- 3 replies
- 21
- Dan BrockEmployee1 mth ago
- Questions & Answers
0
How to query catalog using POSTGRESQL
When trying the PostgresSQL connector, queries can be successfully built that can bring data, with some conditions, but if trying to review data model catalog, response errors.…
- Dave WilliamsIncorta User
- Dave_Williams
- 1 yr ago
- 6 replies
- 350
- Dan BrockEmployee1 mth ago
- Questions & Answers
0
Multiple IsDescendant Filters
Is it possible to select multiple values for filtering by descendant hierarchy? As an example, I have a list of companies with a hierarchy setup. I would like to apply a filter with multiple parents…
- Joe SteinbrunnerIncorta User
- Inmar
- Joe_Steinbrunner
- 1 mth ago
- 2 replies
- 7
- Joe SteinbrunnerIncorta User1 mth ago
- Questions & Answers
- Answered
- Answered
0
Load incremental data
Hi - I have 2 data files that have the same fields. 1st file contains the header and 2nd file contains the data and no header. On my schema table, I turned on "incremental" button and select these…
- Yao MessanIncorta User
- Inmar
- Yao_Messan
- 1 mth ago
- 3 replies
- 37
- Dustin BasilEmployee1 mth ago
- Questions & Answers

1 2 3 4 5 16 Next

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

Members

View members

Get Help

Product Documentation

Questions & Answers

To calculate time between dates of weekdays only.

Grouping and Ranking based on Report Prompt in Incorta

Comments in formula?

Internal IO exception for Incremental Python Code

Mulit Source vs. Incorta Table?

What is Incorta Excel Add-in

MV on a remote (Azure datalake) parquet location

Incremental load from Data Lake

Can we change the data in incorta report?

how to change dashboard schema

('Py4JJavaError', ':', Py4JJavaError(u'An error occurred while calling o100.parquet.\n', JavaObject id=o101))

NoLock on sql statements in table extract

Formatting options

Trendlines

Internal Server Error - Schema Status Is Not Complete

Top N in 4.5.X

Schedule dashboard through CLI

SQL INSERT INTO

How to Embed incorta in a webpage using iframe tag

Issue with iframe

Filtering on One to Many Relationships

List of Business Schema details

How to query catalog using POSTGRESQL

Multiple IsDescendant Filters

Load incremental data

Members

Get Help

More

Tags

Home

Tags