如何在 Cognos 中备份一组查询?
我有一个文件夹,其中包含 Cognos 中的一组查询。我尝试通过将单个查询导出到记事本来备份它。但是,如果我想一次备份一个文件夹中的所有查询,最好的方法是什么?我非常感谢您在这个问题上的帮助。
I have a folder containing a set of queries in Cognos. I have tried backing up an individual query by exporting it to notepad. But if I want to back up all the queries in a folder at a time, what would be the best way? I would appreciate your help on this issue.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(4)
这是 Cognos 实例中的一个常见问题,在该实例中,有多个报表作者创建 BI 内容。
我建议看一下 MotioCI - 它旨在对 Cognos 实例中的内容进行自动版本控制。这意味着只要有人对 Cognos 内容进行更改,您就会知道是谁做的以及他们更改了什么。
它还使您能够查看 Cognos 对象的修订历史记录(如果需要,允许您恢复到早期版本)。
http://www.motio.com/products/ci/versionControl.do
This is a common problem in Cognos instances where you have multiple report authors creating BI content.
I would suggest taking a look at MotioCI - its designed to do automated version control for content in your Cognos instance. This means anytime someone makes a change to Cognos content, you'll know who did it and exactly what they changed.
It also gives you the ability to look at the revision history on Cognos objects (allowing you to revert back to an earlier version if desired).
http://www.motio.com/products/ci/versionControl.do
除非您具有管理员访问权限,否则我不确定如何将所有查询保存在文件夹中。作为一种解决方法,我发现这种保存本地副本的方法比记事本更快。当您按照这些步骤操作时,您将能够在本地打开和保存 Cognos 8 xml 文件。我发现这在开发新报告时很有帮助。
http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.ug_cr_rptstd.8.4.0.doc /ug_cr_rptstd_id29382cr_rptstd_modrep_open_save_report_l.html
Unless you have Admin access, I'm not sure of a way to save all queries in a folder. As a work-around, I've found this method of saving local copies faster than notepad. When you follow these steps you'll be able to open and save Cognos 8 xml files locally. I find this helpful when developing new reports.
http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.ug_cr_rptstd.8.4.0.doc/ug_cr_rptstd_id29382cr_rptstd_modrep_open_save_report_l.html
您可能想查看第三方工具,例如 MetaManager,它可以为您提供存档/恢复功能,而且它看起来像许多其他工具。
http://www.bspsoftware.com/Products/ImplementationBasedSoftware/IntegratedArchiveService /tabid/203/Default.aspx
You may want to check out a thirdparty tool such as MetaManager which could give you archive/recovery plus it looks like many other tools.
http://www.bspsoftware.com/Products/ImplementationBasedSoftware/IntegratedArchiveService/tabid/203/Default.aspx
有一些像上面的人已经回答过的工具,因此我没有使用过,所以我不能说。
当我在 Cognos 项目中工作时,我通常会创建一个“分支”(实际上是 Cognos Connection 中的一个文件夹)并每天进行导出。备份生成的文件。
尽管我不建议手动复制粘贴报告的 XML(耗时且可能导致错误),但早在 2007 年就有一个大项目,这些 XML 文件救了我们一命。
There are some tools like the above people who have answered thus I haven't used any so I cannot say.
When I work in a Cognos project I usually create a "branch" (actually a folder in Cognos Connection) and export on a daily basis. The resulting files are backed up.
Although I wouldn't recommend to manually copy-paste the XML of the reports (time consuming taks and could lead to errors), back in 2007 there was this big project where those XML files saved our arses.