Hi All,
We have request from Application to create more than 700 report views and schedule every month 1st day
Each report view they have mentioned different different prompt values and they want last one month record for respective sites
Which means admin every month need to update that date period for that 700 reports ( Its very painful for admins to create report view and schedule )
please let me know do you have any other alternative ways to do this we cannot give them access in production environment. to create report view or schedule permission.
Thanks
Nagoole
Hi !
First of all, Cognos has been implemented in your environment as a reporting tool, not as a BI tool and secondly, you do not need to change the Date values in the prompt every month. It can be set dynamically to resolve to the Date range of last month. You will have to more specific in order to get a specific reply as to how to do it.
Have you considered Bursting your report?
I'd go for that if it's possible. See: http://www-01.ibm.com/support/knowledgecenter/SSRL5J_1.1.0/com.ibm.swg.ba.cognos.ug_cr_rptstd.10.1.1.doc/t_cr_rptstd_modrep_bursting_reports.html%23cr_rptstd_modrep_bursting_reports?lang=en (http://www-01.ibm.com/support/knowledgecenter/SSRL5J_1.1.0/com.ibm.swg.ba.cognos.ug_cr_rptstd.10.1.1.doc/t_cr_rptstd_modrep_bursting_reports.html%23cr_rptstd_modrep_bursting_reports?lang=en)