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
Migrating db view with calls to custom db functions?
I am trying to load into Incorta a database view which takes over two hours to load 32 million rows. I have the DDL for the view and some columns involve case statements that call different custom…
- Chris Chen
- PMsquare
- Chris_Chen
- 4 days ago
- 3 replies
- 12
- Dylan WanEmployee3 days ago
- Questions & Answers
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
- 9 days ago
- 1 reply
- 11
- Rich ChlebekEmployee8 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
- 9 days ago
- 5 replies
- 17
- Ashwin WarrierEmployee9 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
- 10 days ago
- 25
- 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
- 2 wk ago
- 22
- 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
- 2 wk ago
- 6 replies
- 44
- Steven Peng9 days ago
- 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
- 2 wk ago
- 8 replies
- 17
- 1
- joseph. delpercio2 wk ago
- Questions & Answers
- Answered
- Answered
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
- 3 wk ago
- 6 replies
- 39
- 1
- Mark Samuels8 hrs ago
- Questions & Answers
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
- 1 mth ago
- 3 replies
- 37
- 1
- Ahmed MoawadEmployee3 wk 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
- 12
- R. A. Dawson Sr1 mth ago
- Questions & Answers
- Answered
- Answered
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
- 57
- 1
- Scott BlauerEmployee1 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
- 16
- 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
- 19
- 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
- 32
- Anurag MalikEmployee1 mth ago
- Questions & Answers
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
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
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
- 12
- Questions & Answers
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
Does ( should ) Conditional Formatting export to PDF?
I have a dashboard with many columns being conditionally formatted. It works in HTML, but when I export to PDF there's no conditional formatting at all.…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 2 replies
- 16
- R. A. Dawson Sr1 mth ago
- Questions & Answers
1
Compare aggregation with fixed number
The data model looks like this: I have an insight that sums the per-order-line gross profit (not shown, but comes from the Order_Line table), grouped by OrderDate (from the Order table) and…
- Steve W
- Brownells, Inc.
- Steve_Ware
- 1 mth ago
- 3 replies
- 31
- 1
- R. A. Dawson Sr1 mth ago
- Questions & Answers
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
Rounding inconsistently
[edit to add that the other rows with serial numerals != 5 are rounding as expected] I have a source file with text values ( "text" column in the picture ) - I use a formula column to return a…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 2 mths ago
- 3 replies
- 21
- R. A. Dawson Sr1 mth ago
- Questions & Answers
0
Import Schema Failed
It shows import failed when I import schema. The error is a duplicate entry, But I don't have any schema with the same name.
- suxinji
- Sounthern Utah University
- suxinji
- 2 mths ago
- 2 replies
- 21
- Divy Srivastava2 mths ago
- 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

Migrating db view with calls to custom db functions?

Create KPI from formula pill

Compare two measures - each with their own measure filter

Exporting decimals to Excel in same format as Insight

Honoring Transpose Flag in Aggregated Tables

Pivot Table Column Order

DBVisualizer connection to Incorta ( creds question )

Alerts Filter

how to refresh the local data file folder contents

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

CVE-2021-44228 Log4j vulnerability

Using a constant with formatting

Can an insight "ignore" a dashboard filter?

Replace Zero with blank or "-"

Rank a subset of a result set

Incorta Analytics view has rows when authoring, loading zero

Java date format masks for formatDate()

Key Columns in MV

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

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

Does ( should ) Conditional Formatting export to PDF?

Compare aggregation with fixed number

Presentation Variable in Aggregate Filer

Rounding inconsistently

Import Schema Failed

Members

Tags

Home

Tags

Product Announcement

Questions & Answers

Migrating db view with calls to custom db functions?

Create KPI from formula pill

Compare two measures - each with their own measure filter

Exporting decimals to Excel in same format as Insight

Honoring Transpose Flag in Aggregated Tables

Pivot Table Column Order

DBVisualizer connection to Incorta ( creds question )

Alerts Filter

how to refresh the local data file folder contents

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

CVE-2021-44228 Log4j vulnerability

Using a constant with formatting

Can an insight "ignore" a dashboard filter?

Replace Zero with blank or "-"

Rank a subset of a result set

Incorta Analytics view has rows when authoring, loading zero

Java date format masks for formatDate()

Key Columns in MV

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

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

Does ( should ) Conditional Formatting export to PDF?

Compare aggregation with fixed number

Presentation Variable in Aggregate Filer

Rounding inconsistently

Import Schema Failed

Members

Tags

Home

Tags

Product Announcement

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