List of Contributions

Michael Walter

TX HHSC

Contact Details

TX HHSC

My Content

1 to 6 of 6 total
Posted By Michael Walter Jan 29, 2021 10:55 AM
Found In Egroup: Cognos Analytics
\ view thread
Having worked with both, there are some pretty significant differences between SAS and Cognos, and I suspect you're looking at a largely manual process. But if I was looking at a significant volume of reports to migrate, I would at least investigate costs and success rates of an automated tool. A quick ...
Posted By Michael Walter Dec 31, 2020 1:38 PM
Found In Egroup: Cognos Analytics
\ view thread
Been working with Cognos 8+ years, now, and quite sure I don't know it all... But I found how to add comments early on, and will share a tip that's been quite helpful to me. Comment your filters at the top with a short description of what they do, e.g.: #/* TransDate in Range per params */# [MyDataS ...
Posted By Michael Walter Nov 24, 2020 1:05 PM
Found In Egroup: Cognos Analytics
\ view thread
The most likely explanation for the performance degradation is that your database has no index reflecting your concatenated "column," and therefore has to perform a complete scan to honor your filter. You could work with your DBA to create a calculated index to match your concatenated column, but this ...
Posted By Michael Walter Nov 20, 2020 11:46 AM
Found In Egroup: Cognos Analytics
\ view thread
"FIRST_DAY" is not a Cognos function, but it appears to be a vendor-specific one in IBM DB2 (see, https://www.ibm.com/support/knowledgecenter/SSCRJT_7.0.0/com.ibm.swg.im.bigsql.commsql.doc/doc/r0061474.html). What DB is your function running against? In any event, per the above, " BETWEEN FIRST_DAY(((CURRENT_DATE) ...
Posted By Michael Walter Nov 9, 2020 7:06 PM
Found In Egroup: Cognos Analytics
\ view thread
I believe these instructions are what you are looking for: https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_cr_rptstd.doc/t_cr_rptstd_wrkdat_build_report_using_your_own_sql_mdx_rel.html Be aware that there are many negatives to bypassing the Cognos metadata layer in ...
Posted By Michael Walter Oct 20, 2020 10:30 AM
Found In Egroup: Cognos Analytics
\ view thread
We're still using Cognos 10.x here, and I don't have a direct answer as to whether a single shared network location for images can be made to work, but I can offer the solution I've used in our multi-server environment, based on IBM's tech notes on the "missing images" in output issue. I always use the ...