About Maran_Rengasamy

Maran_Rengasamy · 11-28-2024

Hi Team,I have created a business view with Formula Columns.In one Formula Column(ORG_SLS) logic, I'm using the existing formula columns. When I use the ORG_SLS column in dashboard, I'm getting the below error."INC_10010110: The column doesn’t contai...

Maran_Rengasamy · 08-13-2024

Hi All,As per the company policy, we are not supposed to use Meterialized View(except Bridge table) and Incorta SQL for any data mapping logic. I have two tables INVOICE_PAYMENTS and INVOICE_DISTRIBUTIONS. The INVOICE_ID is the Join Key for these tw...

Maran_Rengasamy · 05-29-2024

Hi,I have created a Alias table and using it in my report. The Formula Columns in the base table not showing any values in my report. If I use the Base table in Report, the formula columns showing the correct values.Any idea on this issue? Is there a...

Maran_Rengasamy · 04-18-2024

Hi Team,Can anyone explain how to do period-based Incremental load based on the Ship_Date column(Date format. not timestamp)?In our current ETl tool, we delete the last 3 months(Ship_Date) records from the Data Warehouse table and load the last 3 mon...

Maran_Rengasamy · 04-10-2024

Hi Team,I'm new to Incorta and started to learn this wonderful tool.I'm trying to create an SQL Server Data Source connection in my Trail version environment but getting the below error while testing the connection.ErrorINC_03070502: Failed to Connec...

Maran_Rengasamy · 08-16-2024

Hi Joe,Thanks for the confirmation.

Maran_Rengasamy · 05-30-2024

Hi RADSr,I found the issue. Earlier I added a join and then removed. somehow the Join reference is not removed properly. The Query Plan showed the Join reference. So I recreated the Alias table and it's working fine now.Thanks for your time on this i...

Maran_Rengasamy · 05-29-2024

Hi RADSr,There is no join in the Alias table.Created a formula columns in base table and loaded(full) the table.Then created a Alias table and used it in the report.

Maran_Rengasamy · 04-29-2024

Excellent!!! Thanks for your input. I think the alternative method will work for my case.

Maran_Rengasamy · 04-24-2024

Hi Joe,Thanks for your response. The Ship_Date is in Date format(yyyy/mm/dd). Source data is in Oracle DB and the target table is in SQL Server. Below are some sample dates.I'm trying to keep the history data(for example 2017/01/01 to today) and try...

User Statistics

User Activity

Issue in Business View Formula Column

How to Create a Cross JOIN without using MV or Incorta SQL

Formula Columns not working in the Alias table

Period Based Incremental Refresh

SQL Server new Data Source connection Error

Re: How to Create a Cross JOIN without using MV or Incorta SQL

Re: Formula Columns not working in the Alias table

Re: Formula Columns not working in the Alias table

Re: Period Based Incremental Refresh

Re: Period Based Incremental Refresh