Community

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
Difference in data between Incorta Insight and generated SQL Output
I have noticed there is difference between the outputs of the Incorta Insight and the output of the SQL generated by the Incorta Insight. The Incorta Analyzer handles the same SQL differently…
- Ishaq Baig
- Savola Group
- Ishaq_Baig
- 3 mths ago
- 1 reply
- 29
- Mike Mascitti3 mths ago
- Questions & Answers
0
I want to display some Dynamic Header in dashboard which is based on some parameter.
I want to create one dashboard where the report should change the Header based on some Parameter. For example for US BU is should display some header and for UK BU is is different.…
- Shubham Mandovara
- TTD
- Shubham_Mandovara
- 3 mths ago
- 26
- Questions & Answers
0
Got error when load schema: INC_03020301: Failed while waiting compaction.
Hi everyone. I have got an error when load schema with materialized view table. this error message is: INC_03020301: Failed while waiting compaction. com.incorta.loader.transformer.…
- Nopu Nguyen
- Human
- Nopu_Nguyen
- 8 mths ago
- 2 replies
- 55
- Martin Carnegie3 mths ago
- Questions & Answers
0
Can we Migrate reports from other reporting tools like OBIEE to Incorta
- Chinmay Kulkarni
- infosys
- Chinmay_Kulkarni
- 3 mths ago
- 1 reply
- 21
- Dylan WanEmployee3 mths ago
- Questions & Answers
0
Convertion
I have "Timedifference" filed which is in string format. but i need sum of time hh:mm example timediff 02:43 10:15 01:25 00:35
- Mahesh Kocherla
- scientific games
- Mahesh_Kocherla
- 3 mths ago
- 17
- Questions & Answers
0
Waterfall Charts
Incorta release 5.0 mentions about waterfall chart being added, where do I find it. I cannot see it in my company's Incorta environments.
- Mukul Ranjan
- Starbucks
- Mukul_Ranjan
- 3 mths ago
- 4 replies
- 26
- Tom WilseckEmployee3 mths ago
- Questions & Answers
- Answered
- Answered
0
Py4JJavaError: An error occurred while calling o903.fit.
Below is the pySpark code I am trying to run:- %pyspark from pyspark.sql import SparkSession from pyspark.ml import Pipeline from pyspark.ml.linalg import Vectors from pyspark.ml.…
- Alok SinghPartner
- Wipro Limited
- Alok_Singh
- 1 yr ago
- 2 replies
- 275
- Hieu Hoang3 mths ago
- Questions & Answers
0
Replace ETL tool with Incora
Can we replace the ETL tool with Incora ? Will it cause any performance issues? Because we have millions of data.
- IncortaVi
- Wipro LTD
- IncortaVi
- 3 mths ago
- 1 reply
- 30
- Dylan WanEmployee3 mths ago
- Questions & Answers
0
Can I create a function ( UDF ) in Incorta? ( use case: csv files show percents, I need to convert to decimal - a *lot* ;-) )
The title sums it up - I have a need to take a text input ( e.g. 16.7% ) and conditionally format the output ( e.g. > 15% green, > 10 yellow, etc. ) Since the comparison operator wants a number I…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 4 mths ago
- 5 replies
- 54
- R. A. Dawson Sr3 mths ago
- Questions & Answers
- Answered
- Answered
0
Shade Columns Table Listing Insignt
Is there a way to shade columns in Incorta Table Listing Insight?
- Bryan Persaud
- SEQSR
- Bryan_Persaud
- 4 mths ago
- 9 replies
- 23
- Tristan BarrientosEmployee4 mths ago
- Questions & Answers
- Answered
- Answered
0
Subtract a Field from a Fixed Number
I am trying to subtract a field without uploading a file. For Example sum(EBS_AR.RA_CUSTOMER_TRX_LINES_ALL.EXTENDED_AMOUNT)-$250,000 I am trying to get the variance between the total (extended…
- Erin Gamage
- Mood Media
- Erin_Gamage
- 4 mths ago
- 3 replies
- 16
- Erin Gamage4 mths ago
- Questions & Answers
0
Use a notebook to manipulate a file before ingesting data?
We have several .csv ( or Excel ) files which have things like subtotals, title rows w/ merged cells, and other things non-conducive to using as an Incorta data source.…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 4 mths ago
- 5 replies
- 56
- R. A. Dawson Sr4 mths ago
- Questions & Answers
0
Hidden subtotals
I want to display subtotals in an aggregate table. I'm getting a message "subtotal for <group1, group2> is hidden" Why? And how do I unhide them? The measure I am using is a decimal formatted as…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 4 mths ago
- 4 replies
- 26
- Ashwin WarrierEmployee4 mths ago
- Questions & Answers
0
How do I connect smartsheet to Incorta
I have a requirement to connect Incorta to smartsheet, but when I am trying with oAuth method getting below error message INC_03071401: ConnectorFactory Error:…
- Mukul Ranjan
- Starbucks
- Mukul_Ranjan
- 4 mths ago
- 1 reply
- 17
- Jacob DockendorfEmployee4 mths ago
- Questions & Answers
0
Column Chart with Date field type as x-axis
The x-axis shows a date field that has sparse dates that are just end-of-month dates. The display shows first of month values for the ticks. Is this just how it works with the date data type?…
- Marc Paige
- GC Services
- Marc_Paige
- 4 mths ago
- 3 replies
- 25
- Anurag MalikEmployee4 mths ago
- Questions & Answers
0
using a pivot with formatted date as column doesn't sort
We are trying to use a friendly formatted date (MMM dd, yyyy) as the column in a formula. This works fine. However, no matter what is put in the sort by bubble, the columns are sorted in alpha order.…
- Marc Paige
- GC Services
- Marc_Paige
- 4 mths ago
- 18
- Questions & Answers
0
What logs need to be truncated
Hi All, I seem to keep finding new logs/working files that I need to clean. This is mostly an issue on my dev system since it does not have as much disk allocated as the others,…
- Martin Carnegie
- APSC
- Martin_Carnegie
- 6 mths ago
- 5 replies
- 56
- Dustin BasilEmployee4 mths ago
- Questions & Answers
0
INC_05060000: Validation on data contained in DASHBOARD with ID [null] failed. Please make sure the data is correct.
Hi, We are running into this error everytime we go to Manage Filter and Prompts. None of the columns have keys defined or "null" as datatype.
- Swapna Tavtum
- Starbucks
- schennam
- 4 mths ago
- 2 replies
- 18
- Swapna Tavtum4 mths ago
- Questions & Answers
0
Sankey usage
I am playing around with this new visualization and am wondering if I can use it in the following situation: I have a table that has a state code and an office code.…
- Marc Paige
- GC Services
- Marc_Paige
- 5 mths ago
- 7 replies
- 31
- Marc Paige4 mths ago
- Questions & Answers
- Answered
- Answered
0
Dynamically pass email id in Data alert
Hi All, I am trying to create a stock out data alert to our stores and the alert should be sent to individual store mangers. when ever an item goes out of stock an alert should get triggered and…
- sandeep vittalam
- James Avery
- sandeep_vittalam
- 4 mths ago
- 4 replies
- 40
- Amit KothariEmployee4 mths ago
- Questions & Answers
0
Aggregation setting to exclude non-null and/or non-zero values
I'm setting some measures to AVERAGE in a dashboard, but what I'd really like is an average of the non-zero values ( in other cases non-null values ). Is there such a setting?
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 4 mths ago
- 3 replies
- 22
- Dan BrockEmployee4 mths ago
- Questions & Answers
1
Conditional Formatting subtotals
Just for the record I did use the "search" function before posting this question ;-) Is it possible to conditionally format subtotals? I envision a use case where the conditions may differ from the…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 4 mths ago
- 13
- 1
- Questions & Answers
0
Using Gregorian Calendar on Insight when joined to two tables in the Insight
Hello - I am trying to see if there is a way to control which date an Insight uses when pulling a field from the Gregorian calendar. For example, in the EBS_AP blueprint,…
- Barbra Jones
- Mood, Inc.
- Barbra_Jones
- 4 mths ago
- 2 replies
- 10
- Barbra Jones4 mths ago
- Questions & Answers
0
Format an measure of time ( calculated ) as MM:SS v. decimal
I have two fields: Number of minutes, Number of Customers. If I have values 9 and 2 and divide I get 4.5 I would like to be able to display 4:30 on my insight.…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 5 mths ago
- 7 replies
- 41
- Anurag MalikEmployee4 mths ago
- Questions & Answers
0
Change Label Names to Reflect Todays Date
Hi, Can I change Label Names to reflect Today's Date. For Eg : I have column Name as DAY-1 : Should show current date DAY-2 : Should Current Date +1 They need to change dynamically . Thanks.
- somesh velupalli
- Scientific Games
- somesh_velupalli
- 4 mths ago
- 1 reply
- 17
- Dustin BasilEmployee4 mths ago
- Questions & Answers

1 2 3 4 5 30 Next

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

Members

View members

Questions & Answers

Difference in data between Incorta Insight and generated SQL Output

I want to display some Dynamic Header in dashboard which is based on some parameter.

Got error when load schema: INC_03020301: Failed while waiting compaction.

Can we Migrate reports from other reporting tools like OBIEE to Incorta

Convertion

Waterfall Charts

Py4JJavaError: An error occurred while calling o903.fit.

Replace ETL tool with Incora

Can I create a function ( UDF ) in Incorta? ( use case: csv files show percents, I need to convert to decimal - a lot ;-) )

Shade Columns Table Listing Insignt

Subtract a Field from a Fixed Number

Use a notebook to manipulate a file before ingesting data?

Hidden subtotals

How do I connect smartsheet to Incorta

Column Chart with Date field type as x-axis

using a pivot with formatted date as column doesn't sort

What logs need to be truncated

INC_05060000: Validation on data contained in DASHBOARD with ID [null] failed. Please make sure the data is correct.

Sankey usage

Dynamically pass email id in Data alert

Aggregation setting to exclude non-null and/or non-zero values

Conditional Formatting subtotals

Using Gregorian Calendar on Insight when joined to two tables in the Insight

Format an measure of time ( calculated ) as MM:SS v. decimal

Change Label Names to Reflect Todays Date

Members

Tags

Home

Tags

Product Announcement

Questions & Answers

Difference in data between Incorta Insight and generated SQL Output

I want to display some Dynamic Header in dashboard which is based on some parameter.

Got error when load schema: INC_03020301: Failed while waiting compaction.

Can we Migrate reports from other reporting tools like OBIEE to Incorta

Convertion

Waterfall Charts

Py4JJavaError: An error occurred while calling o903.fit.

Replace ETL tool with Incora

Can I create a function ( UDF ) in Incorta? ( use case: csv files show percents, I need to convert to decimal - a *lot* ;-) )

Shade Columns Table Listing Insignt

Subtract a Field from a Fixed Number

Use a notebook to manipulate a file before ingesting data?

Hidden subtotals

How do I connect smartsheet to Incorta

Column Chart with Date field type as x-axis

using a pivot with formatted date as column doesn't sort

What logs need to be truncated

INC_05060000: Validation on data contained in DASHBOARD with ID [null] failed. Please make sure the data is correct.

Sankey usage

Dynamically pass email id in Data alert

Aggregation setting to exclude non-null and/or non-zero values

Conditional Formatting subtotals

Using Gregorian Calendar on Insight when joined to two tables in the Insight

Format an measure of time ( calculated ) as MM:SS v. decimal

Change Label Names to Reflect Todays Date

Members

Tags

Home

Tags

Product Announcement

Can I create a function ( UDF ) in Incorta? ( use case: csv files show percents, I need to convert to decimal - a lot ;-) )