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
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
- 11 hrs ago
- 1 reply
- 2
- nalzahrani7 hrs 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
- 11 days ago
- 1 reply
- 18
- Dylan WanEmployee4 days 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
- 4 days ago
- 3
- 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
- 6 days ago
- 6 replies
- 16
- Dylan WanEmployee6 days 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
- 11 days ago
- 2 replies
- 25
- Omer AKGUL10 days 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
- 13 days ago
- 4 replies
- 14
- 1
- Dustin BasilEmployee12 days 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
- 2 wk ago
- 3 replies
- 14
- Bryan Welch13 days 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
- 2 wk ago
- 1 reply
- 15
- Justinzak2 wk ago
- 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
- 3 wk ago
- 2 replies
- 12
- Srinivas C3 wk ago
- Questions & Answers
- Answered
- Answered
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
- 3 wk ago
- 4 replies
- 15
- 1
- Marc Paige3 wk 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
- 3 wk ago
- 10
- 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
- 1 mth ago
- 5 replies
- 33
- R. A. Dawson Sr3 wk ago
- Questions & Answers
- Answered
- Answered
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
- 21
- R. A. Dawson Sr4 wk ago
- Questions & Answers
0
How to connect MangoDB with Incorta
- Raju Jam
- Wipro
- Raju_Jam
- 1 mth ago
- 1 reply
- 11
- Dylan WanEmployee1 mth ago
- Questions & Answers
0
How to control Insight Name & Measure Column header based on the Presentation Variable runtime value
Is there a way display the Insight name dynamically according to the Presentation Variable chosen by user? Also, the Column header of the Measure field with a formula,…
- Hari Katta
- Extreme Networks
- Hari_Katta
- 8 mths ago
- 6 replies
- 61
- Szara Loring1 mth ago
- Questions & Answers
- Answered
- Answered
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
- 9
- Ramu1 mth ago
- Questions & Answers
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
- 28
- Dylan WanEmployee1 mth ago
- Questions & Answers
- Answered
- Answered
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
- 12
- Dylan WanEmployee1 mth ago
- Questions & Answers
- Answered
- Answered
0
Conditional Distinct Count?
I have a scenario where I want to count the number of orders when a flag is set ( sometimes I want to count when set to zero, sometimes when <> 0 ). Basically,…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 2 replies
- 28
- 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
- 1 mth ago
- 1 reply
- 14
- Dustin BasilEmployee1 mth ago
- 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
- 1 mth ago
- 6 replies
- 26
- 1
- Dustin BasilEmployee1 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
Runaway Load detection?
Is there a way to set up a trigger to fire when a schema load has runaway? I had a load that was taking much longer than average and want to trigger an email if this happens.
- Marc Paige
- GC Services
- Marc_Paige
- 1 mth ago
- 2 replies
- 13
- Marc Paige1 mth ago
- Questions & Answers
- Answered
- Answered
0
Performance optimization
I would like to load only a handful of tables from a set of 500 tables to be loaded into memory. I set the performance optimization on for only these handful of tables.…
- Sathya Natarajan
- Scientific Games
- Sathya_Natarajan
- 1 mth ago
- 1 reply
- 25
- Joe MillerCommunity Manager1 mth ago
- Questions & Answers
0
Level based measures limitation question
Is it accurate to say that level based measures can only be used when the group is used in the insight? And, when that group is the only group in the insight? I'm on 4.8.…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 3 replies
- 17
- R. A. Dawson Sr1 mth ago
- Questions & Answers
- Answered
- Answered

1 2 3 4 5 30 Next

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

Members

View members

Questions & Answers

Drill Down Dashboard

How to pass run time parameters to MV

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

Incremental load records flag type

Save and Reuse Sklearn ML Models

vague error message

Find all references to a table

Migration of Incorta data ( Incorta Cloud )

Time value format in Tenant.xml file

Count of records +/- x% of the average

Bookmarks Migration

Excel plugin for Incorta Cloud

Retiring and Replacing a Business Schema?

How to connect MangoDB with Incorta

How to control Insight Name & Measure Column header based on the Presentation Variable runtime value

Unable to schedule report

Data source local file upload size limit?

Compound Join?

Conditional Distinct Count?

Salesforce data to Incorta

Test Text for Valid Date Content

Materialized View Length Limitation

Runaway Load detection?

Performance optimization

Level based measures limitation question

Members

Tags

Home

Tags

Product Announcement

Questions & Answers

Drill Down Dashboard

How to pass run time parameters to MV

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

Incremental load records flag type

Save and Reuse Sklearn ML Models

vague error message

Find all references to a table

Migration of Incorta *data* ( Incorta Cloud )

Time value format in Tenant.xml file

Count of records +/- x% of the average

Bookmarks Migration

Excel plugin for Incorta Cloud

Retiring and Replacing a Business Schema?

How to connect MangoDB with Incorta

How to control Insight Name & Measure Column header based on the Presentation Variable runtime value

Unable to schedule report

Data source local file upload size limit?

Compound Join?

Conditional Distinct Count?

Salesforce data to Incorta

Test Text for Valid Date Content

Materialized View Length Limitation

Runaway Load detection?

Performance optimization

Level based measures limitation question

Members

Tags

Home

Tags

Product Announcement

Migration of Incorta data ( Incorta Cloud )