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

Join

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
- 2 days ago
- 5 replies
- 18
- Dan BrockEmployeeyesterday
- Questions & Answers
0
Scheduling Schema Loads between times
Hi All, We are doing some daily loads, which are working ok, but we have some data sources that we want to run multiple times a day, but only between certain hours.…
- Martin CarnegieIncorta User
- APSC
- Martin_Carnegie
- 13 days ago
- 2 replies
- 14
- Martin CarnegieIncorta User2 days 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
- 5 days ago
- 5 replies
- 15
- Marc PaigeIncorta User5 days ago
- Questions & Answers
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
- 5 days ago
- 1 reply
- 12
- Dan BrockEmployee5 days 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
- 2 wk ago
- 2 replies
- 12
- Divya RamachandranEmployee6 days 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
- 2 wk ago
- 5 replies
- 13
- joseph. delpercio8 days 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
- 2 wk ago
- 4 replies
- 14
- DylanEmployee9 days 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
- 13 days ago
- 6
- 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
- 2 wk ago
- 3 replies
- 14
- Ryan SatherIncorta User13 days 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
- 2 wk ago
- 1 reply
- 14
- Ashwin WarrierEmployee2 wk 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
- 1 yr ago
- 5 replies
- 219
- Bhawani Patnaik2 wk 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
- 2 wk ago
- 2 replies
- 6
- Hichem SellamiEmployee2 wk 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
- 2 wk ago
- 2 replies
- 8
- Dylan WanEmployee2 wk 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
- 2 wk ago
- 4
- 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
- 3 wk ago
- 17 replies
- 37
- Dan BrockEmployee2 wk 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
- 2 wk ago
- 6
- 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
- 3 wk ago
- 3 replies
- 28
- Dan BrockEmployee3 wk 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
- 414
- joseph. delpercio3 wk 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
- 3 wk ago
- 4
- 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
- 3 wk ago
- 1 reply
- 8
- Dan BrockEmployee3 wk 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
- 3 wk ago
- 2 replies
- 40
- Amit KothariEmployee3 wk ago
- Questions & Answers
1
CASE Statement for Date columns
My case statement is not working if i am using date columns (See attached image), please suggest how to write or ant other solution.
- Praveen Kumar N
- KPI
- Praveen_Kumar_N
- 3 wk ago
- 3 replies
- 7
- 1
- Praveen Kumar N3 wk ago
- Questions & Answers
0
Error - INC_04050755: Variable ConfiguredBusinessGroup is missing. Make sure its part of your presentation variables or prompts
When I am trying to access the Human Resource EBS blueprints, I am getting the below error for every dashboard:- INC_04050755: Variable ConfiguredBusinessGroup is missing.…
- Alok SinghPartner
- Wipro Limited
- Alok_Singh
- 3 wk ago
- 9
- Questions & Answers
0
Import text from Datalake with upper case file extension
I have some files coming from third party having file extension in upper case ".TXT", Incorta shows those files in schema wizard but when you try to load throws below error "INC_03070701:…
- Mukul RanjanIncorta User
- Starbucks
- Mukul_Ranjan
- 3 wk ago
- 7
- Questions & Answers
0
Trend Line Creation
Is there any simple way to add trend lines to graphs besides formulas?
- joseph. delpercio
- Scientific Games
- joseph_delpercio
- 3 wk ago
- 8
- Questions & Answers

1 2 3 4 5 20 Next

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

Members

View members

Questions & Answers

Set Alert When Data Changes

Scheduling Schema Loads between times

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

CASE Statement for Date columns

Error - INC_04050755: Variable ConfiguredBusinessGroup is missing. Make sure its part of your presentation variables or prompts

Import text from Datalake with upper case file extension

Trend Line Creation

Members

Tags

Home

Tags