Sage Intelligence Connector - Adding a duplicate or alias table

Question

Sage 2019 
 
 I created a Data Container. I added a table and would like to add an alias of the same table with a left join. 
 
 When I attempt to add the table, a message informs me the table has already been added. In Crystal or Access, I am allowed to do this, and the table is added with same name with a number as an alias. 
 
 Is there a way to do this in SI? 
 
 Thanks 
 
 paula

jcnichols · Accepted Answer

Hi Paula, Yes you can add an Alias of the same table. 
 Here's are example ( From the Sage MAS Consolidation Report Designer Add-In - Fiscal Year Detail 1-0) 
 "GL_FiscalYear" INNER JOIN "GL_FiscalYearDetail" AS FP1 ON "FP1"."FiscalYear" = "GL_FiscalYear"."FiscalYear" LEFT JOIN "GL_FiscalYearDetail" AS FP2 ON "FP2"."FiscalYear" = "FP1"."FiscalYear" AND "FP2"."FiscalPeriod" = "FP1"."FiscalPeriod" -1 
 
 John Nichols 
 Sage

Sage 100

Sage Intelligence Connector - Adding a duplicate or alias table

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING