Dear All,
Regarding the performance, would using SQL view better
than using cognos filter?
e.g. View (select * from CompanyTable where CompanyCode=1)
VS Cognos filter (Company Code=1)
and if I selected large number of database instance in catergory (For ease of using centrally cat, so I out almost
all instance in it), would it affect the performace? Or I better use each cat for each report instead of 1 cat many reports?
Regarding the performance, would using SQL view better
than using cognos filter?
e.g. View (select * from CompanyTable where CompanyCode=1)
VS Cognos filter (Company Code=1)
and if I selected large number of database instance in catergory (For ease of using centrally cat, so I out almost
all instance in it), would it affect the performace? Or I better use each cat for each report instead of 1 cat many reports?