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
Filtering on One to Many Relationships
Consider a schema with 3 tables: Animal (base table) - one row per animal (e.g. lion, bear, horse, trout, eagle...) AnimalColor - one row for each animal/color combo,…
- Dan NielsenIncorta User
- Inmar
- Dan_Nielsen
- 4 mths ago
- 7 replies
- 115
- Anurag MalikEmployee5 days ago
- Questions & Answers
0
Business Days Between
Hi everyone, sorry if this has been asked before (I've searched the forum and documentation and can't find a solution). I have a need to be able to calculate business days between two dates…
- Sam
- Zeus
- Sam
- 13 days ago
- 3 replies
- 33
- Sam6 days ago
- Questions & Answers
- Answered
- Answered
0
How to show Hierarchy eg Sr manager->Manager->Asstt Manager->Employee for data Drill Purpose
Can someone guide me how to create Hierarchy in Incorta 3.5. For example : I need details of all Sr managers, right from top level up to bottom level. Sr manager->Manager->Asstt Manager->Employee…
- DelliIncorta User
- Keysight
- Delli
- 6 mths ago
- 7 replies
- 88
- Joe SteinbrunnerIncorta User6 days ago
- Questions & Answers
0
Sharing dashboards not obeying folder structure
I have shared a folder for view and at one point had specific dashboards within the folder shared. I want the folder structure to be obeyed when I share these dashboards.…
- Tom FogartyIncorta User
- Inmar
- Tom_Fogarty
- 12 days ago
- 1 reply
- 11
- Dustin BasilEmployee7 days ago
- Questions & Answers
0
How to load a missing snapshot day
Patching caused the loader to be delayed and a scheduled incremental load of a snapshot for a table was missed. Is there a way to load the missing day into that table?
- Marc PaigeIncorta User
- GC Services
- Marc_Paige
- 7 days ago
- 2 replies
- 16
- Marc PaigeIncorta User7 days ago
- Questions & Answers
- Answered
- Answered
0
How I get more info on an incremental data load error of "Not Completed"?
Hello, I executed an incremental data load that ran for 67 minutes. It finished with an error status, and the message is "Not Completed", however, the Job Details suggest every table loaded.…
- Kevin JacklinIncorta User
- Civeo
- Kevin_Jacklin
- 7 days ago
- 2 replies
- 11
- Kevin JacklinIncorta User7 days ago
- Questions & Answers
- Answered
- Answered
0
Date conversion
I have a Date column in my requirement column name is "last_updated" and data format is "January 8, 2018". I need to get this date as "01/08/2018" or "mm/dd/yyyy" Is there any alternate to convert…
- Kondala Rao KandimallaPartner
- Gspann Technologies, inc
- Kondala_Rao_Kandimalla
- 6 mths ago
- 9 replies
- 159
- Anurag MalikEmployee12 days ago
- Questions & Answers
0
its pyspark create dataframe from list of lists
I have list of lists input alert_highlightsa = [('AML3665823', [('AML-MAS', 'AML-MAS-ALL-ALL-A-M01-MAS', 'Manual Alert Created by Joanne Cegielski', 'Party Group', 'AML3665823', 'N/A', 'N/A',…
- Geetha Boggarapu
- wipro
- Geetha_Boggarapu
- 13 days ago
- 1 reply
- 28
- Subba Jevisetty13 days ago
- Questions & Answers
0
unable to connect MS SQL server in incorta
Hi Team, Please help we are trying to add new data source in our incorta system. when we try to connect getting "Driver:SQLServerDriver:9 returned null " error and it is working fine in SQL…
- DelliIncorta User
- Keysight
- Delli
- 2 wk ago
- 8 replies
- 41
- DelliIncorta User2 wk ago
- Questions & Answers
- Answered
- Answered
0
Implement 'OR' function in prompts or filters
Hi, How do we implement 'OR' function in the prompt or filter section? Example HTS Number 1 begins with <prompt> Or HTS Number 2 begins with <prompt> Or HTS Number 3 begins with <prompt> Or HTS…
- Swapna ChennamIncorta User
- Starbucks
- schennam
- 2 wk ago
- 1 reply
- 16
- Dan BrockEmployee2 wk ago
- Questions & Answers
0
How many times can the ? be used in an incremental SQL?
I have a rather complicated SQL for a table that compares timestamps 3 times in the query. Can I use the ? in all three places?
- Marc PaigeIncorta User
- GC Services
- Marc_Paige
- 2 wk ago
- 1 reply
- 24
- Amit KothariEmployee2 wk ago
- Questions & Answers
- Answered
- Answered
2
How do I create a Slowly Changing Type 2 (SCD) Dimension?
Please show me how to create a Slowly Changing Type 2 (SCD) Dimension where I can track the changes for few fields in a Customer table?
- Amit KothariEmployee
- Incorta
- Amit_Kothari
- 2 wk ago
- 1 reply
- 37
- 2
- Amit KothariEmployee2 wk ago
- Questions & Answers
- Answered
- Answered
0
how to show total
I have a data as below, I need to show a max of all numbers throughout all the columns, how can I achieve this incorta Teams score total Team 1 30 90 Team 2 36 90 Team 3 42 90 Team 4 48 90 Team 5 54…
- venkatRaoIncorta User
- Broadcom
- Rao
- 8 mths ago
- 7 replies
- 173
- Ramaraju Hema KavithaPartner2 wk ago
- Questions & Answers
0
Unable to query the data from table through MV
Hi Folks, When i am trying to load a table from MV, I am facing attached Error. Can any one know this error? please help me. Example: select ACCOUNTING_EVENT_ID from AP_INVOICE_DISTRIBUTIONS_ALL…
- vishnuPartner
- infosy
- vishnu
- 2 wk ago
- 8 replies
- 29
- vishnuPartner2 wk ago
- Questions & Answers
0
schema load status alert
Hi, How to create IncortaMetadata schema using Incorta Metadata source?
- Sandhya RaniPartner
- Quest Global
- Sandhya_Rani
- 3 wk ago
- 4 replies
- 33
- Dustin BasilEmployee2 wk ago
- Questions & Answers
2
Trigger a Incorta Load through a script or similar
We have an external scheduling tool from which can run shell/cmd scripts on a machine.. we want to trigger an incorta job load using this tool (Appworx,…
- Gnaneshwar MuthaluriIncorta User
- genworth
- Gnaneshwar_Muthaluri
- 3 mths ago
- 9 replies
- 119
- 2
- Dhanraj PalaniIncorta User2 wk ago
- Questions & Answers
- Answered
- Answered
0
Boolean Data Type in Schema
When importing data in a Schema, I've noticed there is no data type for boolean or bit available. I know this is a simple question but have not seen any documentation, questions,…
- Joe SteinbrunnerIncorta User
- Inmar
- Joe_Steinbrunner
- 3 wk ago
- 3 replies
- 15
- Amit KothariEmployee2 wk ago
- Questions & Answers
- Answered
- Answered
0
NULL date value in formula
I'm trying to add a formula column on a table that will convert a date string to a date. The string is always formatted "mm/dd/yyyy" *but* there are some rows that have "00/00/0000" or "01/01/1900"…
- Dan NielsenIncorta User
- Inmar
- Dan_Nielsen
- 4 wk ago
- 9 replies
- 61
- Ramaraju Hema KavithaPartner3 wk ago
- Questions & Answers
0
INVALID FORMULA Error when using CASE with Aggregation
Hi All I have data like below Item Quarter TotalCost Item1 FY19 Q4 100 Item1 FY20 Q1 120 The Total Cost Column is a Formula column from Business Schema and has some further calculations behind it.…
- Yogesh BhavePartner
- Infosys Ltd
- Yogesh_Bhave
- 3 wk ago
- 3 replies
- 25
- Yogesh BhavePartner3 wk ago
- Questions & Answers
0
Remove Byte Order Mark in CSV export
We have a couple dashboards we use to export a CSV from to be consumed by some internal systems. In some cases, we are seeing a BOM in the exports but it seems inconsistent.…
- Tom FogartyIncorta User
- Inmar
- Tom_Fogarty
- 4 wk ago
- 4 replies
- 19
- Dustin BasilEmployee3 wk ago
- Questions & Answers
0
Search Box is not working with Formula created in Prompts Section
Hi Team, I have created one Formula in Prompts section of my dashboard by concat two different DB columns "School_ID" & "School_Name" and kept the Formula name as "School_Details".…
- RudraIncorta User
- Quest Global
- Rudra
- 4 wk ago
- 9
- Questions & Answers
0
Add HTML content in Reports
Hi Team, is there any way to add the HTML content and images in the incorta Dashboards ? Thanks, Delli M
- DelliIncorta User
- Keysight
- Delli
- 4 wk ago
- 13
- Questions & Answers
0
Pandas (and other Python libraries) in Materialized View
Hi all, I am a newer user of Incorta, and I'm wondering -- is it possible to import pandas into materialized views? I have installed Anaconda in the Linux environment Incorta is housed,…
- Michael Hadden
- eCapital Advisors
- Michael_Hadden
- 1 mth ago
- 6 replies
- 70
- peddinti satya sashikanthPartner4 wk ago
- Questions & Answers
1
com.incorta.miniThrift.App cores and memory usage
Good Afternoon, We're trying to better understand what this "com.incorta.miniThrift.App" is running in our Spark applications. In addition, it currently appears to be configured at 8 cores and 2GB…
- Ryan DalyIncorta User
- Gate City Bank
- Ryan_Daly
- 1 mth ago
- 2 replies
- 31
- 1
- Ryan DalyIncorta User4 wk ago
- Questions & Answers
0
Error while adding one specific column to MV
Hi, I am seeing the attached error when I am trying to add one specific column to the MV. When I drag and drop that column directly from the base table to the insight,…
- Swapna ChennamIncorta User
- Starbucks
- schennam
- 4 wk ago
- 17
- Questions & Answers

1 2 3 4 5 14 Next

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

Members

View members

Get Help

Product Documentation

Questions & Answers

Filtering on One to Many Relationships

Business Days Between

How to show Hierarchy eg Sr manager->Manager->Asstt Manager->Employee for data Drill Purpose

Sharing dashboards not obeying folder structure

How to load a missing snapshot day

How I get more info on an incremental data load error of "Not Completed"?

Date conversion

its pyspark create dataframe from list of lists

unable to connect MS SQL server in incorta

Implement 'OR' function in prompts or filters

How many times can the ? be used in an incremental SQL?

How do I create a Slowly Changing Type 2 (SCD) Dimension?

how to show total

Unable to query the data from table through MV

schema load status alert

Trigger a Incorta Load through a script or similar

Boolean Data Type in Schema

NULL date value in formula

INVALID FORMULA Error when using CASE with Aggregation

Remove Byte Order Mark in CSV export

Search Box is not working with Formula created in Prompts Section

Add HTML content in Reports

Pandas (and other Python libraries) in Materialized View

com.incorta.miniThrift.App cores and memory usage

Error while adding one specific column to MV

Members

Get Help

More

Tags

Home

Tags