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
more than 1 presentation variable with optional field?
I have a need to have to picklist presentation variables in a dashboard. I can define the first or the second using an optional field, but when I try to drag a field over to the second presentation…
- Marc PaigeIncorta User
- GC Services
- Marc_Paige
- 4 mths ago
- 1 reply
- 22
- Anurag MalikEmployee4 mths ago
- Questions & Answers
- Answered
- Answered
0
What is the Date Dimension? How to use it in Incorta?
- Ahmed EsmatEmployee
- Incorta
- Ahmed_Esmat
- 1 yr ago
- 6 replies
- 857
- Moataz-Bellah MishrifModerator4 mths ago
- Questions & Answers
- Answered
- Answered
0
Case statement for Country Maps
Hey All, I am trying to use the Incorta maps because honestly I don't know how to setup the Google Maps. I have had pretty good luck except when wanting to change the name of the country.…
- joseph. delpercio
- Scientific Games
- joseph_delpercio
- 4 mths ago
- 3 replies
- 31
- Dan BrockEmployee4 mths ago
- Questions & Answers
0
How to Implement oracle LISTAGG() function in Incorta?
For a specified measure, Oracle's LISTAGG orders data within each group specified in the ORDER BY clause and then concatenates the values of the measure column - how do we implement the LISTAGG()…
- Amit KothariEmployee
- Incorta
- Amit_Kothari
- 2 yrs ago
- 3 replies
- 323
- Amit KothariEmployee4 mths ago
- Questions & Answers
0
Map Report as per Geo Region
Hi Team, Need a information regarding map report. Our requirement is like to show the map area as per geo region for example Americas, APAC, EMEIA. As per selected geo region,…
- RudraIncorta User
- Quest Global
- Rudra
- 2 yrs ago
- 2 replies
- 118
- joseph. delpercio4 mths ago
- Questions & Answers
0
Set Alert When Data Changes
I'm trying to set up an alert that tells me when an item/part number's cost changes. I have the dashboard built, but I can't figure out how to set an alert on the dashboard.
- Michelle FoxIncorta User
- National Oilwell Varco
- Michelle_Fox
- 4 mths ago
- 5 replies
- 48
- Dan BrockEmployee4 mths ago
- Questions & Answers
0
How to calculate the business day of the month
I need to be able to calculate the business day of the month. I have tried the following formula: Date_Time.Date.workday_seq - lookup( Date_Time.Date.workday_seq, Date_Time.Date.…
- Marc PaigeIncorta User
- GC Services
- Marc_Paige
- 4 mths ago
- 5 replies
- 36
- Marc PaigeIncorta User4 mths ago
- Questions & Answers
- Answered
- Answered
0
How to define CASE,Null,and function in a Single variable
Hi, I defined below variable in MV, now I want to create same variable at report level using tables. Please let me know how to define at report level. (CASE WHEN POLIN.…
- KHK
- Wipro
- Hari_K
- 4 mths ago
- 1 reply
- 33
- Dan BrockEmployee4 mths ago
- Questions & Answers
0
Pivot table : Download XLSX or Export to Excel related 2 Issues
(1) String/text column used as measure (with min/max) on pivot table. Export to excel doesnt show string as output instead some number come up on that column. e.g.…
- Kailas Kundikar
- Northern Trust
- Kailas_Kundikar
- 5 mths ago
- 2 replies
- 31
- Divya RamachandranEmployee4 mths ago
- Questions & Answers
0
Convert Binary Code
My team and working with AS400 data and we need to know how to convert binary data (CCSID 65535) becuase we aren't getting this data when we try to query.…
- joseph. delpercio
- Scientific Games
- joseph_delpercio
- 5 mths ago
- 5 replies
- 15
- joseph. delpercio4 mths ago
- Questions & Answers
- Answered
- Answered
0
Scheduling E-mail with Filters
Hey there, I have a master insight that I want to send out to different users by project type. Is there a way to have the insight filter to a specific filter at time of delivery? @Ari Gnanam
- joseph. delpercio
- Scientific Games
- joseph_delpercio
- 5 mths ago
- 4 replies
- 19
- DylanEmployee4 mths ago
- Questions & Answers
1
How to get more details on Maintenance Pack fixes
I have been reviewing the maintenance packs and one question that I always have when reviewing them is the details on the fixes. For example https://docs.incorta.com/4.7/rn-mps/ for 4.7.…
- Martin CarnegieIncorta User
- APSC
- Martin_Carnegie
- 5 mths ago
- 8
- 1
- Questions & Answers
0
Is there a way to manually compact a table?
I have a large table (85m rows) that I'm using as a source for a MV (python) and I was having an issue getting any rows returned. I know the mv works because it's working in another environment.…
- Ryan SatherIncorta User
- Gate City Bank
- Ryan_Sather
- 5 mths ago
- 3 replies
- 25
- Ryan SatherIncorta User5 mths ago
- Questions & Answers
- Answered
- Answered
0
Sharing Notifications - Too Many Emails
Some users are part of multiple Groups. When a schema is shared across multiple Groups, these users receive duplicate (or more) emails with the same notification.…
- Michelle FoxIncorta User
- National Oilwell Varco
- Michelle_Fox
- 5 mths ago
- 1 reply
- 19
- Ashwin WarrierEmployee5 mths ago
- Questions & Answers
0
where can I download Incorta tool
I am new to this tool, from where can I download and explore on this tool
- venkatTrial User
- venkat
- 2 yrs ago
- 5 replies
- 233
- Bhawani Patnaik5 mths ago
- Questions & Answers
0
Remove join option doesn't remove joins in other schemas
When I remove a table in schema A I'm offered the option to remove all joins related to that table. However, a join initiated from schema B is not removed.…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 5 mths ago
- 2 replies
- 9
- Hichem SellamiEmployee5 mths ago
- Questions & Answers
0
Materialize View Not Rendering
I am running a MV and it returns the records in the initial output, but when I go to save the MV, it just keeps showing me the spinning wheel and it is not rendering the computation.…
- joseph. delpercio
- Scientific Games
- joseph_delpercio
- 5 mths ago
- 2 replies
- 19
- Dylan WanEmployee5 mths ago
- Questions & Answers
0
URL with IP address and not the fully qualified name
Hi All, The tenant url comes up with the ip address and not the fully qualified name. How to fix this. I have update the Node.cfg by replacing the IP address with the hostname and in the…
- Srinivasan
- Confi Com
- Srinivasan
- 5 mths ago
- 9
- Questions & Answers
0
Upsert for Incremental Loading
Has anyone successfully done an upsert on a incremental load without timestamp? Maybe using a primary key or a check sum type function? I don't always have a timestamp in my data sets.
- joseph. delpercio
- Scientific Games
- joseph_delpercio
- 5 mths ago
- 17 replies
- 73
- Dan BrockEmployee5 mths ago
- Questions & Answers
0
Connecting Incorta to SSAS Cube
Has anyone had success connecting to an SSAS Cube via Incorta? If so, how did you do it? Following: @Ari Gnanam
- joseph. delpercio
- Scientific Games
- joseph_delpercio
- 5 mths ago
- 11
- Questions & Answers
0
Incremental Loading without timestamp?
Has anyone successfully been able to do incremental loading for a table without a timestamp?
- joseph. delpercio
- Scientific Games
- joseph_delpercio
- 5 mths ago
- 3 replies
- 37
- Dan BrockEmployee5 mths ago
- Questions & Answers
- Answered
- Answered
0
Incremental load
Hello All, Can any one help me to understand how can we perform the incremental load in Incorta for the tables which does not contain any date columns such as Last Updated Date etc.
- Praveen ManthaPartner
- Axiom Path
- Praveen_Mantha
- 1 yr ago
- 9 replies
- 511
- joseph. delpercio5 mths ago
- Questions & Answers
0
AS400 DB2 Date value as timestamp
Hey All, I have a DB2 system that has time and date in a different column, is there a way to put them together or just use date as the timestamp to load through as an incremental?
- joseph. delpercio
- Scientific Games
- joseph_delpercio
- 5 mths ago
- 6
- Questions & Answers
0
Specific Table Schema Loads
How can I load specific tables out of a schema instead of the whole schema on the scheduler?
- joseph. delpercio
- Scientific Games
- joseph_delpercio
- 5 mths ago
- 1 reply
- 9
- Dan BrockEmployee5 mths ago
- Questions & Answers
0
Materialize View Syntax
In a Materialize Views for sql writing, which formulas do we use? Postgres or SQL Server or Oracle when you are creating off an table loaded into a Schema?
- joseph. delpercio
- Scientific Games
- joseph_delpercio
- 5 mths ago
- 2 replies
- 67
- Amit KothariEmployee5 mths ago
- Questions & Answers

1 3 4 5 6 7 23 Next

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

Members

View members

Questions & Answers

more than 1 presentation variable with optional field?

What is the Date Dimension? How to use it in Incorta?

Case statement for Country Maps

How to Implement oracle LISTAGG() function in Incorta?

Map Report as per Geo Region

Set Alert When Data Changes

How to calculate the business day of the month

How to define CASE,Null,and function in a Single variable

Pivot table : Download XLSX or Export to Excel related 2 Issues

Convert Binary Code

Scheduling E-mail with Filters

How to get more details on Maintenance Pack fixes

Is there a way to manually compact a table?

Sharing Notifications - Too Many Emails

where can I download Incorta tool

Remove join option doesn't remove joins in other schemas

Materialize View Not Rendering

URL with IP address and not the fully qualified name

Upsert for Incremental Loading

Connecting Incorta to SSAS Cube

Incremental Loading without timestamp?

Incremental load

AS400 DB2 Date value as timestamp

Specific Table Schema Loads

Materialize View Syntax

Members

Tags

Home

Tags

Product Announcement