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
Training Exercises
To the community at large: I am working to educate my self-service users. I have been using biweekly sharing sessions with a show-and-tell approach. I ask for specific problems from my community and…
- Marc PaigeIncorta User
- GC Services
- Marc_Paige
- 4 mths ago
- 19
- Questions & Answers
0
Incremental Load with Union Query
Hi, I am trying to tackle delete scenario in source system with below logic in incremental code, its throwing error, any help is appreciated. SELECT 'N' AS IS_DELETED, ST.…
- Mukul RanjanIncorta User
- Starbucks
- Mukul_Ranjan
- 4 mths ago
- 5 replies
- 40
- Mukul RanjanIncorta User4 mths ago
- Questions & Answers
0
Column Percentage
How do I apply column percentages in Pivot tables?
- Ghada Ossama
- Future Group
- Ghada_Ossama
- 2 yrs ago
- 4 replies
- 219
- Kristen Bowman4 mths ago
- Questions & Answers
0
TMT -cf option details needed
Exactly what data does the TMT -cf option copy? Is it only the local data files, or is all data in all of the schemas? The incorta documentation doen't provide this breakdown.
- Peter-Reinhard Hacker
- Northern Trust
- Peter_Hacker.1
- 4 mths ago
- 2 replies
- 9
- Peter-Reinhard Hacker4 mths ago
- Questions & Answers
0
Error Ldap sync
FAIL: Couldn't search with this input due to java.naming.provider.url property does not contain a URL FAIL: java.naming.provider.url property does not contain a URL Security tab for the tenant has…
- Srinivasan
- Confi Com
- Srinivasan
- 4 mths ago
- 3 replies
- 15
- Dylan WanEmployee4 mths ago
- Questions & Answers
2
Rename Table
Can you rename a table within Incorta after it has been loaded via Schema panel?
- Warren BillsIncorta User
- Genworth
- Warren_Bills
- 1 yr ago
- 4 replies
- 66
- 2
- Sunita DattaIncorta User5 mths ago
- Questions & Answers
0
Metadata DB upgrade
Has anyone had to upgrade the metadata DB version? What was the process? Did you have any issues?
- Andy KrejsaTrial User
- vVitamix
- akrejsa
- 5 mths ago
- 3 replies
- 15
- Dan BrockEmployee5 mths ago
- Questions & Answers
0
incorta Quick Start Guide?
Does incorta offer a Quick Start guide for new business users. Something else besides the "docs" link, which can get almost immediately technical. Thanks...Pete
- Peter-Reinhard Hacker
- Northern Trust
- Peter_Hacker.1
- 5 mths ago
- 2 replies
- 25
- Seth LuersenModerator5 mths ago
- Questions & Answers
0
Load table fail as Materialized View
I have a problem with Materialized View(using SQL not Python, I use INNER JOIN between two table which has 300M rows table and 2M rows table) when I try to load table,…
- Nopu Nguyen
- Human
- Nopu_Nguyen
- 5 mths ago
- 2 replies
- 63
- Nopu Nguyen5 mths ago
- Questions & Answers
- Answered
- Answered
0
Convert date to 'yyyymmdd' format in MW
Hi everyone! I want to convert CURRENT_DATE to format 'yyyyMMdd' in materialized view, I try CONVERT, and FORMAT function but it's not supported in SQL of MW, how I can do that ? thank you.
- Nopu Nguyen
- Human
- Nopu_Nguyen
- 5 mths ago
- 2 replies
- 29
- Nopu Nguyen5 mths ago
- Questions & Answers
- Answered
- Answered
0
Using a variable as a field expression in functions
I would like to use a variable as a parameter in functions that take a field expression if possible. For instance, the following syntax works. inList(SALES.COUNTRIES.…
- Vlad Kaminsky
- GNC Consulting, Inc.
- Vlad_Kaminsky
- 5 mths ago
- 5 replies
- 31
- Vlad Kaminsky5 mths ago
- Questions & Answers
0
How do I connect to a Oracle Cloud Database from Incorta?
I need to connect to a Oracle Cloud Database from Incorta, please show me the steps.
- Amit KothariEmployee
- Incorta
- Amit_Kothari
- 5 mths ago
- 1 reply
- 27
- Amit KothariEmployee5 mths ago
- Questions & Answers
- Answered
- Answered
0
IfNUll on another column
I have two columns ie Sales, Profit. So, my requirement is if Sales is Null then 0 else if Sales not Null Profit. I tried using IfNull and IsNull functions but no luck.…
- pavan
- kpipartners
- pavan
- 5 mths ago
- 1 reply
- 18
- Tamer mahfouzEmployee5 mths ago
- Questions & Answers
- Answered
- Answered
0
Level Based measure
Hi , I created level based measure in a report using schema i am getting "INC_04050744: Unexpected error while rendering query". Could you please let me know why i am getting this error? Regards,…
- KHK
- Wipro
- Hari_K
- 5 mths ago
- 2 replies
- 23
- Matthew HallidayEmployee5 mths ago
- Questions & Answers
0
Converting date using toChar function
Hi All, I am trying to do calculations on current date as shown below with in IF statement, but the resulting timetsamp is wrong and is always showing as 12:08:…
- Srinivas C
- FBP
- Srinivas_C
- 5 mths ago
- 3 replies
- 30
- Srinivas C5 mths ago
- Questions & Answers
- Answered
- Answered
0
New Formula - Convert String to Double
Hi everyone. I'm trying to create a basic New Formula in an insight where I take a double data type and multiply it by a string data type. Since this formula won't work,…
- Michelle FoxIncorta User
- National Oilwell Varco
- Michelle_Fox
- 5 mths ago
- 2 replies
- 21
- Michelle FoxIncorta User5 mths ago
- Questions & Answers
0
Variable referencing current Dashboard and Folder Path
Hello All, I would like to reference and display the Dashboard name, Parameters and folder path of the current Dashboard in one of the insight. Can you suggest on how I can achieve this? Thanks,…
- Srinivas C
- FBP
- Srinivas_C
- 5 mths ago
- 14
- Questions & Answers
0
Max Group Limit Error
Hi Team, We are getting below issue when running a dashboard with an aggregated visualization. We tried changing the Max group size value till max of 7.5 mil but it is throwing us the same error.…
- SrinivasPartner
- Wipro Technologies
- Srinivas
- 5 mths ago
- 9 replies
- 24
- SrinivasPartner5 mths ago
- Questions & Answers
0
Filters
Hi, in Dashboard filter's in one environment sample values are coming automatically for filtering, where as in other environment its not displaying the values. We recently upgraded the UAT to 4.7.…
- RamIncorta User
- Cittabase
- Ram
- 5 mths ago
- 11
- Questions & Answers
0
PostgreSQL ODBC and/or JDBC versions
Are there a recommended versions of PostgreSQL ODBC and or JDBC drivers that have been tested with Incorta?
- Ryan SatherIncorta User
- Gate City Bank
- Ryan_Sather
- 5 mths ago
- 14
- Questions & Answers
0
How to get difference for 2 consecutive days when using pivot table
I want to create a dashboard that has filter condition to check the difference between current value and prior value ie. Increase> 50000000 and Increase% > 0.05.…
- Snehal Nandagawli
- TCS
- Snehal_Nandagawli
- 5 mths ago
- 1 reply
- 21
- Anurag MalikEmployee5 mths ago
- Questions & Answers
0
How to define ForEach function
Hi, Could you please let me know how to define below SAP BO function in Incorta . =Sum([Extended]ForEach([Item$ITEM];[Item_Category];[Item_Description];[Item_Sub_Category];…
- KHK
- Wipro
- Hari_K
- 5 mths ago
- 1 reply
- 19
- Dan BrockEmployee5 mths ago
- Questions & Answers
0
Case ,and function
Hi, Please let me know how to define below query at report level using schema? CASE WHEN POLIN.MATCHING_BASIS = 'QUANTITY' AND POHDR.TYPE_LOOKUP_CODE = 'STANDARD' THEN NVL (POLIN.…
- KHK
- Wipro
- Hari_K
- 5 mths ago
- 2 replies
- 40
- KHK5 mths ago
- Questions & Answers
- Answered
- Answered
0
Incorta Download
Hi Everyone, I am new to Incorta. I would like to know the way of downloading the Incorta software and how to use that after 30 days if trail period exoires. TIA Dhanu
- dhanu L
- Tech M
- dhanu_L
- 6 mths ago
- 1 reply
- 17
- Seth LuersenModerator5 mths ago
- Questions & Answers
1
Compare physical schemas, Biz Schemas, Folders, Dashboards between two environments/tenants...
Is there a dashboard to - 1. Compare two physical schemas to compare table SQL, missing joins or formulas between two environments? 2. Compare if two dashboards are having same settings between two…
- sai PedduIncorta User
- Equinix Inc
- sai_Peddu
- 6 mths ago
- 2 replies
- 29
- 1
- Marc PaigeIncorta User5 mths ago
- Questions & Answers

1 2 3 4 5 24 Next

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

Members

View members

Questions & Answers

Training Exercises

Incremental Load with Union Query

Column Percentage

TMT -cf option details needed

Error Ldap sync

Rename Table

Metadata DB upgrade

incorta Quick Start Guide?

Load table fail as Materialized View

Convert date to 'yyyymmdd' format in MW

Using a variable as a field expression in functions

How do I connect to a Oracle Cloud Database from Incorta?

IfNUll on another column

Level Based measure

Converting date using toChar function

New Formula - Convert String to Double

Variable referencing current Dashboard and Folder Path

Max Group Limit Error

Filters

PostgreSQL ODBC and/or JDBC versions

How to get difference for 2 consecutive days when using pivot table

How to define ForEach function

Case ,and function

Incorta Download

Compare physical schemas, Biz Schemas, Folders, Dashboards between two environments/tenants...

Members

Tags

Home

Tags

Product Announcement