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
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
- 12 hrs ago
- 1 reply
- 3
- Dustin BasilEmployee17 min 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
- 22 hrs ago
- 1 reply
- 5
- Amit KothariEmployee22 hrs 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
- yesterday
- 7
- Questions & Answers
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
- 2 days ago
- 1 reply
- 10
- Tamer mahfouzEmployee2 days ago
- Questions & Answers
- Answered
- Answered
0
Changing default date format in dashboard prompt
Hi, Is there is a way to change the date format for a column in the dashboard prompt?
- Gautham
- Cittabase
- Gautham
- 2 days ago
- 8
- Questions & Answers
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
- 4 days ago
- 2 replies
- 14
- Matthew HallidayEmployee2 days 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
- 6 days ago
- 3 replies
- 14
- Srinivas C3 days 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
- 7 days ago
- 2 replies
- 12
- Michelle FoxIncorta User7 days 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
- 7 days ago
- 9
- 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
- 8 days ago
- 9 replies
- 8
- SrinivasPartner7 days 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
- 7 days ago
- 5
- 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
- 8 days ago
- 4
- 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
- 8 days ago
- 1 reply
- 6
- Anurag MalikEmployee8 days 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
- 9 days ago
- 1 reply
- 12
- Dan BrockEmployee9 days 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
- 2 wk ago
- 2 replies
- 15
- KHK9 days 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
- 1 mth ago
- 1 reply
- 8
- Seth LuersenModerator2 wk 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
- 1 mth ago
- 2 replies
- 19
- 1
- Marc PaigeIncorta User2 wk ago
- Questions & Answers
0
Inspector Tool load error
Schema: Inspector Metadata How to fix this? IO error occurred during extracting: Cannot run program "chmod": error=24, Too many open files BUSINESS_SCHEMA_VIEWS- INC_03010101:…
- Srinivasan
- Confi Com
- Srinivasan
- 2 wk ago
- 3 replies
- 13
- Dustin BasilEmployee2 wk ago
- Questions & Answers
1
Power BI vs Incorta
Hi, Could you please anyone elaborate the Power BI tools vs Incorta. What is difference between with it ? Please help on this
- Rajesh
- Psiog Digital
- Rajesh.1
- 5 mths ago
- 4 replies
- 78
- 1
- Shankar Gopinath2 wk ago
- Questions & Answers
0
Inspector Metadata load issue - Not completing
Please help - Temp file for [InspectorMetadata.SCHEMA_TABLES._#0040JOIN#0040_LINEAGE_REPORT.zxc] in path /nfs/ict/app/Incorta/Tenant/XXX/snapshots/InspectorMetadata.SCHEMA_TABLES.…
- Srinivasan
- Confi Com
- Srinivasan
- 2 wk ago
- 6
- Questions & Answers
0
How Table Load Order and MV Load Order work?
For Incorta 3.x table load order, does higher mean it will load sooner or later. ie does 11 load before 10? also do materialized views and tables both use the same queue,…
- DylanEmployee
- Facebook
- Dylan_at_facebook
- 1 yr ago
- 2 replies
- 99
- Anil Kumar Katari2 wk ago
- Questions & Answers
0
Materialized views
Hi Team, I have created two MV's (CUST_TRX_V,SALES_BY_CUSTOMER_MV) in the Customer Schema of my Incorta Application. Two MV's are created, i can see the records for CUST_TRX,…
- Anil Kumar Katari
- Caprium
- Anil_Kumar_Katari
- 2 wk ago
- 4
- Questions & Answers
3
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
- 1 yr ago
- 15 replies
- 182
- 3
- Jeff WilgusEmployee2 wk ago
- Questions & Answers
- Answered
- Answered
0
Zookeeper not starting
Zookeeper is not starting at all. What can cause this. verson 4.7.2
- Srinivasan
- Confi Com
- Srinivasan
- 3 wk ago
- 3 replies
- 9
- Moataz-Bellah MishrifModerator3 wk ago
- Questions & Answers
0
Unable to see table in the formula builder
Hi All, I am trying to build some calculated columns using the formula builder when creating a table in a schema. I am trying to use the lookup function to build the columns.…
- sandeep vittalamIncorta User
- James Avery
- sandeep_vittalam
- 2 mths ago
- 1 reply
- 16
- DylanEmployee3 wk ago
- Questions & Answers

1 2 3 4 5 21 Next

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

Members

View members

Questions & Answers

Load table fail as Materialized View

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

Using a variable as a field expression in functions

IfNUll on another column

Changing default date format in dashboard prompt

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...

Inspector Tool load error

Power BI vs Incorta

Inspector Metadata load issue - Not completing

How Table Load Order and MV Load Order work?

Materialized views

Trigger a Incorta Load through a script or similar

Zookeeper not starting

Unable to see table in the formula builder

Members

Tags

Home

Tags

Product Announcement