在 Cognos 8.4 BI/FM 中,如何更改模型的架构?
当我使用 Framework Manager 创建数据模型时,我指定了要使用的架构,例如 XYZ_PAX(每个开发人员都有自己的架构)。但是,当我们将包裹运送给客户时,需要使用产品的标准架构 XYX
。
我将模型推送到 Cognos 8.4 BI,但在 Framework Manager 中找不到任何可以更改架构的位置。
Framework Manager 中用于编辑属性的每个对话框都仅列出数据源而不是架构。我在 Cognos 下的数据源定义中找不到任何内容来表明它用于设置特定模式。
如何更改 Framework Manager 中的架构?我宁愿不必从头开始重建整个模型。
When I used Framework Manager to create a data model, I specified a schema to be used such as XYZ_PAX
(each developer gets their own schema). However, when we ship the package to customers, it will be required to use the standard schema for the product, XYX
.
I pushed the model out to Cognos 8.4 BI but I cannot find any place where the schema can be changed in Framework Manager.
Every dialog box in Framework Manager for editing properties simply lists the data source rather than the schema. And there's nothing I can find in the data source definition under Cognos to indicate that it is being used to set a specific schema.
How do I go about changing the schema in Framework Manager? I'd rather not have to rebuild the entire model from scratch.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
好的,事实证明架构规范包含在
model.xml
文件中。您只需使用您喜欢的编辑器打开此文件,然后将旧架构名称
XYZ_PAX
替换为您需要的任何名称,例如XYZ
。然后,在 Framework Manager 中打开 CPF 项目文件并重新发布。这会将更改后的模型推送到 Cognos 服务器。
然后创建的任何报告都将使用新模型,您可以在 Report Studio 中打开每个现有报告,它将自动使用新模型重新验证。请记住完成后保存报告设计。
Okay, it turns out that the schema specification is contained in the
model.xml
file.You can simply open this file with your favourite editor and replace the old schema name
XYZ_PAX
with whatever you need, such asXYZ
.Then you open the CPF project file in Framework Manager and republish. This will push the changed model out to the Cognos server.
Any reports then created will use the new model and you can open up each existing report in Report Studio and it will automatically revalidate with the new model. Just remember to save the report design when finished.
您是否考虑过在数据库中使用同义词?
Have you considered using synonyms in your database?