Community Forum

Please enable JavaScript to continue!

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

1
Why do we need Spark
Spark is not mandatory but helps performing distributed processing on Parquet data. Complex stored procedures can be converted to PySpark programs and processed on Spark cluster.…
- Mateen MohammedEmployee
- Mateen_Mohammed
- 7 mths ago
- 1 reply
- 107
- 1
- Swarup MohantyIncorta User17 hrs ago
- Questions & Answers
- Answered
- Answered
2
Videos for real world use case
# Description Link 1 Case Function https://goo.gl/pdy2rN 2 Search by First Letter https://goo.gl/0HYlpm 3 Collector by Customer Name https://goo.gl/cAzjhy 4 Dynamic Group By https://goo.…
- Anurag MalikEmployee
- Anurag
- 23 hrs ago
- 3 replies
- 287
- 2
- Tom FogartyIncorta User2 mths ago
- Questions & Answers
0
Auto join not done on load
Hello, While loading datasets from attached Excel tabs using Schema Wizard, the tables are created and also data loaded BUT the join between the tables (e.…
- Sujit SarkarIncorta User
- Sujit_Sarkar
- 4 days ago
- 3 replies
- 14
- Amit KothariEmployeeyesterday
- Questions & Answers
- Answered
- Answered
0
Showing exact numbers in graphs
Dears, I want to show in the bar and line graphs the exact number of the incidents, however it's showing as 1K, 2K as in thousand abbreviation as in the attached graph.…
- Ghada Ossama
- Business Analyst
- Ghada_Ossama
- 2 days ago
- 2 replies
- 19
- Ghada Ossamayesterday
- Questions & Answers
0
Updating formula columns based on user input
Is it possible to update a formula column embedded within a dashboard based on a user input/prompted filter? For example, there is a report with two columns that displays an item number and the…
- Jack KuehnPartner
- Jack_Kuehn
- 5 days ago
- 1 reply
- 8
- Mohit SaggiEmployee4 days ago
- Questions & Answers
- Answered
- Answered
0
Data Hub/Materialized View question
It seems that Data Hub and Materialized View queries both utilize the compacted parquet files and compaction starts after the incremental load has finished.…
- Tom FogartyIncorta User
- Tom_Fogarty
- 7 days ago
- 1 reply
- 36
- Dylan WanEmployee4 days ago
- Questions & Answers
- Answered
- Answered
0
Disk Cleanup
I've noticed that Incorta does not delete the parquet/compacted files after you remove a schema (or a table within a schema). Is it ok to manually delete the parquet/compacted files that are no…
- Dan NielsenIncorta User
- Technical Product Manager, Inmar
- Dan_Nielsen
- 12 days ago
- 3 replies
- 34
- Dan NielsenIncorta User4 days ago
- Questions & Answers
0
Deleting rows w/o full load
Is there a way to delete unwanted rows from a table without performing a full schema load? I have a large schema that is incrementally populated, and the source data is systematically deleted after…
- Dan NielsenIncorta User
- Technical Product Manager, Inmar
- Dan_Nielsen
- 5 days ago
- 4 replies
- 22
- Hichem SellamiEmployee5 days ago
- Questions & Answers
0
I am unable to connect MYSQL data source
I am unable to connect MYSQL data source, getting below issue while connecting the MYSQL. Please find the error details in below. INC_005002001:Failed to Connect to [test] at [jdbc:mysql://localhost:…
- sivareddyIncorta User
- sivareddy
- 5 days ago
- 12
- Questions & Answers
0
SAP HANA connection
Hi team I am trying to use SAP HANA as the datasource to retrieve data for visualization. I get this error though jdbc driver is installed on my local machine.…
- soumya bIncorta User
- soumya_b
- 6 days ago
- 11
- Questions & Answers
0
Incremental Materialized View in Python
Is it possible to specify the last schema load/refresh time in an incremental python materialized view? For example, in the following incremental code: df_immutable = read("RawClaimRepoSQL2018Q1.…
- Dan NielsenIncorta User
- Technical Product Manager, Inmar
- Dan_Nielsen
- 12 days ago
- 3 replies
- 48
- Amit KothariEmployee8 days ago
- Questions & Answers
- Answered
- Answered
0
Data Refresh Time Access
Is there a way to access the schema / table refresh time via a formula column & the UI. I want to show users the last time the data being leveraged by the dashboard was loaded.
- John PelzEmployee
- John_Pelz
- 7 mths ago
- 6 replies
- 210
- SenthilKumar SivakumarPartner13 days ago
- Questions & Answers
- Answered
- Answered
0
Column Chart Summary Data
See attached image. I'm trying to drill down into a column chart to identify the named accounts that are indicated as "# of accounts". I want to be able to click into the chart and view the names of…
- Hailey StephensonIncorta User
- Hailey_Stephenson
- 2 wk ago
- 20
- Questions & Answers
0
Rows Rejected
Hi, I'm trying to load a sample schema, It loads all tables except Sales table as shown below. All the rows are rejected here. Can someone give me some insights to resolve this issue.
- Mohammed Ashfaq Ali
- Mohammed_Ashfaq_Ali
- 2 wk ago
- 2 replies
- 30
- Matthew HallidayEmployee2 wk ago
- Questions & Answers
0
Consistent Color Graph
I am applying the same graph with same input twice once filtered by current year and once by previous year, however the colors are not consistent between the 2 graphs the same category is colored…
- Ghada Ossama
- Business Analyst
- Ghada_Ossama
- 2 wk ago
- 18
- Questions & Answers
0
Sort Based on a specific condition
How do I sort the tables based on specific condition, for example I am creating a pivot table with the years on top and the names on side and calculating the salary of each.…
- Ghada Ossama
- Business Analyst
- Ghada_Ossama
- 2 wk ago
- 18
- Questions & Answers
0
Stack (Merge) The subcategories in Pivot Table
I want to be able to merge (Stack) the headers of the Pivot table. For example as in the Screen shot using Excel I am able to press on the (+) (-) icon to merge and expand the subcategories.…
- Ghada Ossama
- Business Analyst
- Ghada_Ossama
- 2 wk ago
- 31
- Questions & Answers
0
Column Percentage
How do I apply column percentages in Pivot tables?
- Ghada Ossama
- Business Analyst
- Ghada_Ossama
- 2 wk ago
- 2 replies
- 25
- Ghada Ossama2 wk ago
- Questions & Answers
0
How to pick only numeric values from a column?
Is there a function to pick only numeric values from a column. Say in a column i have "212,34". I want to pick only the numeric value i.e, 21234. Is there a way to pick only the numbers in incorta.…
- SowmyaPartner
- Sowmya
- 1 mth ago
- 9 replies
- 88
- SowmyaPartner3 wk ago
- Questions & Answers
- Answered
- Answered
2
How do make dashboard scheduler on last day of a current month
We can do this simply using data Alerts. 1-Create a new Alert 2-Select the Target Dashboard the is required to be sent by mail 3-Edit Conditions Area Add Any columns I.…
- Rasha MahranEmployee
- Senior Support Engineer
- Rasha_Mahran
- 7 mths ago
- 1 reply
- 103
- 2
- Raghuveer RachakondaIncorta User3 wk ago
- Questions & Answers
- Answered
- Answered
0
Aggregating Distinct Records
Consider the data in the attached Excel file (Customer, Product, Order). I'd like to create a visualization that shows how many distinct males/females have purchased a specific product during a…
- Dan NielsenIncorta User
- Technical Product Manager, Inmar
- Dan_Nielsen
- 2 mths ago
- 1 reply
- 105
- Anurag MalikEmployee1 mth ago
- Questions & Answers
0
How to create formula on account members when Essbase is the data source?
Hello, I hope I can explain this clearly. We have an MDX query on an Essbase datasource. One of the dimensions in our cube is an Account dimension, and we want to create a formula in Incorta,…
- Kevin JacklinIncorta User
- Kevin_Jacklin
- 1 mth ago
- 6 replies
- 72
- Kevin JacklinIncorta User1 mth ago
- Questions & Answers
0
INC_002001105:You are not authorized to VIEW the SCHEMADEFINITION of ID [215]
Hello, I created a data source and schema, and gave edit permissions to someone. This person added an MDX query to the schema and created a dashboard on the schema,…
- Kevin JacklinIncorta User
- Kevin_Jacklin
- 1 mth ago
- 6 replies
- 72
- Lorin SchultzIncorta User1 mth ago
- Questions & Answers
0
Return the start date of each week
Is there a function or combination of functions that will return the start date of each week? For example, if the day were to be anytime between Sunday 10/14/2018 to Saturday 10/20/2018,…
- Jack KuehnPartner
- Jack_Kuehn
- 1 mth ago
- 2 replies
- 109
- Rasha MahranEmployee1 mth ago
- Questions & Answers
0
Year over Year by Week
Does anyone have a way of doing a year over year value within a table by week? I need it in a MM/dd format to omit the year value, so week numbers are not usable.…
- Mark SamuelsIncorta User
- Mark_Samuels
- 2 mths ago
- 5 replies
- 123
- Dan BrockEmployee2 mths ago
- Questions & Answers

1 2 3 4 5 8 Next

Back to top

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

Members

View members

Have a critical support issue or bug? Submit ticket at our support portal:

Contact Support

Categories

Tags