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
Create KPI from formula pill
Hi all - I'm attempting to create a KPI visual that will be the sum of a formula-generated column in another insight. Does anyone know how to do this?
- Samantha Clute
- ASP
- Samantha_Clute
- 4 days ago
- 1 reply
- 8
- Rich ChlebekEmployee3 days ago
- Questions & Answers
1
Alerts Filter
I've created an alert to only send me the report when certain criteria are met. However I only want to see the rows of data that triggered the alert. How would I accomplish this?…
- Joe Rief
- James Avery Craftsman
- Joe_Rief
- 2 wk ago
- 5 replies
- 34
- 1
- Joe Rief3 days ago
- Questions & Answers
0
Compare two measures - each with their own measure filter
I have an insight w/ several measures from different time periods ( e.g. current week sales, last week sales, current month, last month, current year, last year ) For each measure column I have the…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 4 days ago
- 5 replies
- 13
- Ashwin WarrierEmployee4 days ago
- Questions & Answers
0
Pivot Table Column Order
I have a simple pivot table with three measures and one column (see screenshot). Is there a way to show each measure by the columns, and then the next measure by the columns? I'm on version 5.1.…
- Szara Loring
- eCapital Advisors
- Szara_Loring
- 9 days ago
- 6 replies
- 41
- Steven Peng4 days ago
- Questions & Answers
0
Exporting decimals to Excel in same format as Insight
Hello, I have a question about exporting FX data. Is it possible to keep the dashboard formatting when exporting to Excel? For example an Incorta dashboard displays EUR to GPB as 0.84.…
- Patrick Ackley
- Starbucks Coffee Company
- Patrick_Ackley
- 5 days ago
- 21
- Questions & Answers
0
Honoring Transpose Flag in Aggregated Tables
Hello Community, Happy New Year!!! We are on version 4.9.2, and I noticed that Tranpose flag is NOT honored when we export the aggregated table insight.…
- Srinivas C
- FBP
- Srinivas_C
- 9 days ago
- 18
- Questions & Answers
1
DBVisualizer connection to Incorta ( creds question )
I'm trying to connect to our Incorta Cloud environment with DBVisualizer. I grabbed the server information from "Connect External BI Tools" and can ping successfully ( <server>.incorta.…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 13 days ago
- 8 replies
- 17
- 1
- joseph. delpercio11 days ago
- Questions & Answers
- Answered
- Answered
1
how to refresh the local data file folder contents
While migrating a dashboard, schema, and local data from my development to the production tenant, I copied the data files from the local folder in the development tenant to the same folder structure…
- Marc Paige
- GC Services
- Marc_Paige
- 3 wk ago
- 3 replies
- 36
- 1
- Ahmed MoawadEmployee2 wk ago
- Questions & Answers
1
CVE-2021-44228 Log4j vulnerability
What, if anything, must be done to mitigate this new vulnerability? I am on version 5.0.2 and will not be on 5.1.2 for a while.
- Marc Paige
- GC Services
- Marc_Paige
- 1 mth ago
- 1 reply
- 56
- 1
- Scott BlauerEmployee1 mth ago
- Questions & Answers
- Answered
- Answered
0
Presentation Variable in Aggregate Filer
This is not supported in 5.0.2. Is it on the roadmap to allow the use of a presentation variable in an aggregate filter? Should I put in an enhancement request?
- Marc Paige
- GC Services
- Marc_Paige
- 1 mth ago
- 5 replies
- 28
- Marc Paige1 mth ago
- Questions & Answers
0
Lookup Function returns NULL in dashboard ( generated SQL works in MV )
I have a lookup function: lookup( R.Incorta_PeriodWeek.PeriodWeekEndDate, R.Incorta_PeriodWeek.PeriodWeek, $Incorta_PeriodWeek, date( '1776-07-04' ) ) In my dashboard this returns NULL ( grouped…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 3 replies
- 10
- R. A. Dawson Sr1 mth ago
- Questions & Answers
- Answered
- Answered
0
Using a constant with formatting
Requirement: use a constant double value in the grouping dimension in an aggregated table or the grouping dimension in a listing table with currency formatting.…
- Marc Paige
- GC Services
- Marc_Paige
- 1 mth ago
- 12
- Questions & Answers
0
Can an insight "ignore" a dashboard filter?
I have a dashboard w/ a lot of insights. Nearly all of which I want to prompt-filter with a dashboard prompt for a reporting period. I have an insight or two which I do *not* want filtered by…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 2 replies
- 15
- R. A. Dawson Sr1 mth ago
- Questions & Answers
- Answered
- Answered
1
Replace Zero with blank or "-"
Is there a way to suppress showing zeros? My users would rather see and empty cell or a dash instead of a zero. Here is an example:
- Szara Loring
- eCapital Advisors
- Szara_Loring
- 1 mth ago
- 5 replies
- 18
- 1
- Szara Loring1 mth ago
- Questions & Answers
- Answered
- Answered
0
Rank a subset of a result set
This is an interesting use case - I have a set of departments reporting up to a division. Each department is scored on a series of metrics and given a final score *as is the division* ORG SCORE ===…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 4 replies
- 29
- Anurag MalikEmployee1 mth ago
- Questions & Answers
0
Key Columns in MV
I have a scenario where a MV is populated with data in below columns, all three are key columns. After first run of the load ORD# is NULL, but in next load I have data and it could have more than…
- Mukul Ranjan
- Starbucks
- Mukul_Ranjan
- 1 mth ago
- 4 replies
- 17
- R. A. Dawson Sr1 mth ago
- Questions & Answers
- Answered
- Answered
0
Incorta Analytics view has rows when authoring, loading zero
The title sums it up. I've created a derived table w/ Incorta Analyzer. When I built it - and now when I edit it - it shows 900-some rows being displayed/returned.…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 3 replies
- 13
- R. A. Dawson Sr1 mth ago
- Questions & Answers
- Answered
- Answered
0
Java date format masks for formatDate()
Is there a reason why "hh.mm aa" is not accepted as a format mask for the formatDate() function?
- Marc Paige
- GC Services
- Marc_Paige
- 1 mth ago
- 2 replies
- 10
- Marc Paige1 mth ago
- Questions & Answers
- Answered
- Answered
0
Copy a schema to another *and* move from environment 1 to environment 2
As in the title, I have a schema developed in an environment - let's call it "PROD" and I want to 1) do some major work on it, integrating in new tables and logic while leaving the existing in place…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 5 replies
- 28
- Dylan WanEmployee1 mth ago
- Questions & Answers
0
Materialized View Length Limitation
Is there a limit to the number of characters that can be in a materialized view? I have two that work fine on their own but when I combine them I get errors.…
- Laura Brown
- Mood Media
- Laura_Brown
- 4 mths ago
- 1 reply
- 15
- Joe MillerCommunity Manager1 mth ago
- Questions & Answers
0
Spark Based Extraction
Hi All, We are trying to use the Spark Based extraction to pull a large table from Oracle into Incorta. I have provided all the value as requested during the setup process. Below is a screenshot.…
- sandeep vittalam
- James Avery
- sandeep_vittalam
- 2 mths ago
- 1 reply
- 19
- Dylan WanEmployee1 mth ago
- Questions & Answers
0
Formula with Presentation Variable in Grouping Dimension doesn't offer correct formatting options.
I have a dashboard that uses a formula in the grouping dimension for an Aggregated Table insight. The formatting options listed are for a date data type even though the presentation variable's data…
- Marc Paige
- GC Services
- Marc_Paige
- 1 mth ago
- 11
- Questions & Answers
1
Test Text for Valid Date Content
I am attempting to write a materialized view that selects rows from a table based on whether a text field contains a valid date. I use isdate() to do this in SQL but have not been able to find a…
- Laura Brown
- Mood Media
- Laura_Brown
- 4 mths ago
- 8 replies
- 46
- 1
- Dustin BasilEmployee1 mth ago
- Questions & Answers
- Answered
- Answered
0
Incorta Cloud Rejected 600 records - download file only has 83?
The subject says most of it. I have a file(s)-based table. When I load it I get 600 records rejected, When I download the reject file I only get 83 rows rejected?…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 2 mths ago
- 2 replies
- 21
- R. A. Dawson Sr1 mth ago
- Questions & Answers
2
How to make a REST api call from a Materialized View and load its data
Incorta supports many connectors but it can happen that there is a particular cloud application for which we do not have a connector yet. For eg Pendo is one such application ,…
- Amit KothariEmployee
- Incorta
- Amit_Kothari
- 1 mth ago
- 217
- 2
- Questions & Answers

1 2 3 4 5 32 Next

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

Members

View members

Questions & Answers

Create KPI from formula pill

Alerts Filter

Compare two measures - each with their own measure filter

Pivot Table Column Order

Exporting decimals to Excel in same format as Insight

Honoring Transpose Flag in Aggregated Tables

DBVisualizer connection to Incorta ( creds question )

how to refresh the local data file folder contents

CVE-2021-44228 Log4j vulnerability

Presentation Variable in Aggregate Filer

Lookup Function returns NULL in dashboard ( generated SQL works in MV )

Using a constant with formatting

Can an insight "ignore" a dashboard filter?

Replace Zero with blank or "-"

Rank a subset of a result set

Key Columns in MV

Incorta Analytics view has rows when authoring, loading zero

Java date format masks for formatDate()

Copy a schema to another and move from environment 1 to environment 2

Materialized View Length Limitation

Spark Based Extraction

Formula with Presentation Variable in Grouping Dimension doesn't offer correct formatting options.

Test Text for Valid Date Content

Incorta Cloud Rejected 600 records - download file only has 83?

How to make a REST api call from a Materialized View and load its data

Members

Tags

Home

Tags

Product Announcement

Questions & Answers

Create KPI from formula pill

Alerts Filter

Compare two measures - each with their own measure filter

Pivot Table Column Order

Exporting decimals to Excel in same format as Insight

Honoring Transpose Flag in Aggregated Tables

DBVisualizer connection to Incorta ( creds question )

how to refresh the local data file folder contents

CVE-2021-44228 Log4j vulnerability

Presentation Variable in Aggregate Filer

Lookup Function returns NULL in dashboard ( generated SQL works in MV )

Using a constant with formatting

Can an insight "ignore" a dashboard filter?

Replace Zero with blank or "-"

Rank a subset of a result set

Key Columns in MV

Incorta Analytics view has rows when authoring, loading zero

Java date format masks for formatDate()

Copy a schema to another *and* move from environment 1 to environment 2

Materialized View Length Limitation

Spark Based Extraction

Formula with Presentation Variable in Grouping Dimension doesn't offer correct formatting options.

Test Text for Valid Date Content

Incorta Cloud Rejected 600 records - download file only has 83?

How to make a REST api call from a Materialized View and load its data

Members

Tags

Home

Tags

Product Announcement

Copy a schema to another and move from environment 1 to environment 2