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
Order of Tabs Rearranging Upon Refresh
Is there a threshold on how many tabs you can have on a dashboard? Currently have one with ten tabs and every time it is refreshed, the tabs change order. Seems to be unique to this one dashboard.…
- Mark Samuels
- Shutterfly
- Mark_Samuels
- 3 days ago
- 2 replies
- 12
- Joe MillerCommunity Manager3 days ago
- Questions & Answers
0
Sorting by row total in a Pivot table
Hi - I've created a Pivot table, and need to retrieve the top 30 values: Example layout Location BOG COP DYS KAM KAR MID MOR NAR NEB Total Item & Description Amt Amt Amt Amt Amt Amt Amt Amt Amt…
- Greg Chaseling
- Civeo
- Greg_Chaseling
- 4 days ago
- 7 replies
- 16
- Greg Chaseling3 days ago
- Questions & Answers
1
Date variable substitution in pyspark
I am writing a MV where I am incrementally loading the data from the table. In Incremental block, I am trying to get the maximum of last_update_date from MV and using it as filter to get the delta…
- Gopinath Vijayan
- JAC
- Gopinath_Vijayan
- 5 days ago
- 2 replies
- 15
- 1
- Dylan WanEmployee4 days ago
- Questions & Answers
1
Unscheduling emailing / notifications / sharing of dashboard
It is unclear how to unschedule or delete a scheduled emailing of a dashboard. There is nothing I can see in the documentation either. This is for version 4.9.…
- Jared Prins
- Alberta Pensions Services Corporation
- Jared_Prins
- 10 days ago
- 2 replies
- 23
- 1
- Jared Prins4 days ago
- Questions & Answers
- Answered
- Answered
0
Replacing two values in the same formula
Hi, What would be the syntax to using a single formula to replace 2 different values? Right now I'm using the formula below that works for a single state, but also trying to replace Penn.…
- John Finnerty
- Quanta Services
- John_Finnerty
- 11 days ago
- 2 replies
- 10
- John Finnerty11 days ago
- Questions & Answers
- Answered
- Answered
0
Suppress Data From Showing Until A Filter Is Applied
I am trying to see if there is a way to suppress rows from appearing in a table until a filter is applied. Is that possible? Thank you!
- Doug Hoppe
- Stanford University
- Doug_Hoppe
- 12 days ago
- 2 replies
- 18
- Tim McCarthy10 days ago
- Questions & Answers
0
Drill Down Dashboard
Hello, I'm having an issue with the drill down. I have 2 dashboards they both have the column Request_ID and I drill down on this column, but when it open the second dashboard it takes the…
- nalzahrani
- master works
- nalzahrani
- 3 wk ago
- 3 replies
- 23
- Dylan WanEmployee2 wk ago
- Questions & Answers
0
data_agent_server ( Incorta Cloud ) datatypes? Default schema fails with Null datatype
I'm having an issue w/ my cloud instance trying to run the Metadata schema. It is failing on loading the data_agent_server - the data type for the two columns is Null - changing to String allows the…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 3 wk ago
- 4
- Questions & Answers
0
Incremental load records flag type
Dear, I have a scenario as the below: I'm loading a table from the database that has a creation date and update date, which will be used in the incremental load later.…
- IncortaUser
- MW
- IncortaUser
- 3 wk ago
- 6 replies
- 22
- Dylan WanEmployee3 wk ago
- Questions & Answers
0
Save and Reuse Sklearn ML Models
Hi, I try to save and reuse ML model in Incorta. But this models builded with Sklearn. There is some ways to save Spark and Incorta ML models but I cnt find any about others libs like Sklearn.…
- Omer AKGUL
- MDSap Turkey
- Omer_AKGUL
- 1 mth ago
- 2 replies
- 31
- Omer AKGUL1 mth ago
- Questions & Answers
0
How to pass run time parameters to MV
OBI Direct DB SQL is being converted to Incorta. it has subqueries and Presentation variable(s) referred in each subquery. Oracle OBI sql generates the data based on the variables passed.…
- Manikandan AnanthaPadmanabhan
- Infosys
- Manikandan_AnanthaPadman
- 1 mth ago
- 1 reply
- 30
- Dylan WanEmployee3 wk ago
- Questions & Answers
1
vague error message
I have a materialized view in Python and when I try to load returns this error: com.incorta.api.exceptions.DataException: INC_03070101: Failed to load data from [spark://xxx.xxxxx.…
- Chris Chen
- PMsquare
- Chris_Chen
- 1 mth ago
- 4 replies
- 15
- 1
- Dustin BasilEmployee1 mth ago
- Questions & Answers
0
Migration of Incorta *data* ( Incorta Cloud )
Use case: I'm setting up a snapshot table in Incorta using getdate() as part of my key and doing incremental builds. If I run that daily for a week, then unit test, UAT,…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 1 reply
- 16
- Justinzak1 mth ago
- Questions & Answers
0
Find all references to a table
Suppose you create a new table in a schema called Stock2. You then plan to replace all references of the old table Stock1 with the new table Stock2. Is there a way on a managed Incorta instance (i.e.…
- Bryan Welch
- Brownells
- Bryan_Welch
- 1 mth ago
- 3 replies
- 16
- Bryan Welch1 mth ago
- Questions & Answers
1
Count of records +/- x% of the average
I need to show the min, average, max rate with a count of records that fall above or below the average rate. I have tried using the following formula but it doesn't work: count( if( staffing.…
- Marc Paige
- GC Services
- Marc_Paige
- 1 mth ago
- 4 replies
- 20
- 1
- Marc Paige1 mth ago
- Questions & Answers
- Answered
- Answered
0
Bookmarks Migration
Do we have ability to export just bookmarks across the Incorta landscape?
- Divy Srivastava
- GDIT
- Divy_Srivastava
- 1 mth ago
- 13
- Questions & Answers
0
Time value format in Tenant.xml file
When I was going through "tenant.xml" file in tenant export, I found that all the times are stored as "1630609519137" format. How do I convert it to regular date-time format? Thanks, Srinivas Chava
- Srinivas C
- FBP
- Srinivas_C
- 1 mth ago
- 2 replies
- 15
- Srinivas C1 mth ago
- Questions & Answers
- Answered
- Answered
0
How to connect MangoDB with Incorta
- Raju Jam
- Wipro
- Raju_Jam
- 1 mth ago
- 1 reply
- 12
- Dylan WanEmployee1 mth ago
- Questions & Answers
0
Retiring and Replacing a Business Schema?
Does anyone have any tips on how to best retire and place a business schema that's used across many different dashboards?
- Melinda Albert
- ASP
- Melinda_Albert
- 1 mth ago
- 2 replies
- 22
- R. A. Dawson Sr1 mth ago
- Questions & Answers
0
Unable to schedule report
Hi All, Can someone please advice me why i am unable to schedule my report to email. Getting below error. Error INC_05071804: Internal Scheduler Exception [Unable to store Job : '9.…
- Ramu
- Techwish
- Ramu
- 1 mth ago
- 3 replies
- 10
- Ramu1 mth ago
- Questions & Answers
0
Compound Join?
[edit to add 4.8.5 - but looking to upgrade so SQL Joins won't be a viable answer unless they are back w/ the next release ( please! ). I want to create a compound join: Table1.ORDERDATE >= TABLE2.…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 1 reply
- 13
- Dylan WanEmployee1 mth ago
- Questions & Answers
- Answered
- Answered
0
Data source local file upload size limit?
I get this error ( and it's sibling error in Edge ) when trying to upload a large CSV file so I assume there is a limit. I looked through the docs for connectors - file system and didn't see any…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 1 reply
- 29
- Dylan WanEmployee1 mth ago
- Questions & Answers
- Answered
- Answered
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
- 1 mth ago
- 5
- Questions & Answers
0
Excel plugin for Incorta Cloud
I'd like to install and use the Excel plugin for Incorta Cloud, but looking at the documentation under Integrations -> Microsoft Excell Add-in shows what appears to be instructions for on-prem or…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 2 mths ago
- 5 replies
- 35
- R. A. Dawson Sr1 mth ago
- Questions & Answers
- Answered
- Answered
0
Salesforce data to Incorta
We are trying to run a scheduled job to incrementally pull data from Salesforce. The load fails with the following message whenever it tries to run from the scheduled job.…
- Sathya Natarajan
- Scientific Games
- Sathya_Natarajan
- 2 mths ago
- 1 reply
- 18
- Dustin BasilEmployee1 mth ago
- Questions & Answers

1 2 3 4 5 31 Next

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

Members

View members

Questions & Answers

Order of Tabs Rearranging Upon Refresh

Sorting by row total in a Pivot table

Date variable substitution in pyspark

Unscheduling emailing / notifications / sharing of dashboard

Replacing two values in the same formula

Suppress Data From Showing Until A Filter Is Applied

Drill Down Dashboard

data_agent_server ( Incorta Cloud ) datatypes? Default schema fails with Null datatype

Incremental load records flag type

Save and Reuse Sklearn ML Models

How to pass run time parameters to MV

vague error message

Migration of Incorta data ( Incorta Cloud )

Find all references to a table

Count of records +/- x% of the average

Bookmarks Migration

Time value format in Tenant.xml file

How to connect MangoDB with Incorta

Retiring and Replacing a Business Schema?

Unable to schedule report

Compound Join?

Data source local file upload size limit?

Materialized View Length Limitation

Excel plugin for Incorta Cloud

Salesforce data to Incorta

Members

Tags

Home

Tags

Product Announcement

Questions & Answers

Order of Tabs Rearranging Upon Refresh

Sorting by row total in a Pivot table

Date variable substitution in pyspark

Unscheduling emailing / notifications / sharing of dashboard

Replacing two values in the same formula

Suppress Data From Showing Until A Filter Is Applied

Drill Down Dashboard

data_agent_server ( Incorta Cloud ) datatypes? Default schema fails with Null datatype

Incremental load records flag type

Save and Reuse Sklearn ML Models

How to pass run time parameters to MV

vague error message

Migration of Incorta *data* ( Incorta Cloud )

Find all references to a table

Count of records +/- x% of the average

Bookmarks Migration

Time value format in Tenant.xml file

How to connect MangoDB with Incorta

Retiring and Replacing a Business Schema?

Unable to schedule report

Compound Join?

Data source local file upload size limit?

Materialized View Length Limitation

Excel plugin for Incorta Cloud

Salesforce data to Incorta

Members

Tags

Home

Tags

Product Announcement

Migration of Incorta data ( Incorta Cloud )