更新MicroStrategy中报告的表
我有一个MicroStrategy项目,该项目中的报告较早使用Teradata Connections和SQL。但是现在,要求将项目中的所有这些报告指向雪花数据库实例。 新的雪花数据库实例已经创建。我想知道这样做的方法。
- 我将将默认数据库实例更新为“项目配置”中的新雪花连接。
- 在“仓库目录”中更新数据库实例。
- 刷新仓库目录。
通过这些步骤,项目中的所有报告都会随SQL中的新数据库而更新,而表名称在Teradata和Snowflake之间相同? 还是我缺少其他步骤?
I have a MicroStrategy project where the reports in that project were earlier using Teradata connections and sql. But now the requirement is to point all these reports in the project to a snowflake database instance.
The new snowflake database instance is already created. I wanted to know the ways to do this.
- I will update the default database instance to the new snowflake connection in the 'Project Configuration'.
- Update the Database instance in the 'Warehouse Catalog'.
- Refresh the warehouse catalog.
With these steps will all the reports in the project get updated with the new database in the SQL with the table name being the same between Teradata and Snowflake?
Or is there any other step that I am missing?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
让我尝试回答它...
来源: https://community.microstrategy.com/s/article/kb44209-how-to-migrate-projects-from-one-nodabase-database-to-to-to-another othother?
Let me try to answer it...
Source: https://community.microstrategy.com/s/article/KB44209-How-to-migrate-projects-from-one-database-to-another-in?language=en_US