如果我在开发服务器SSMS的分析服务中在整个数据库中创建改变的脚本,并在生产服务器SSMS上执行该脚本,而不是通过BIDS部署,那有什么不对吗?
否, 您实际上决不应该使用 BIDS 来进行测试。 BIDS 将总是覆盖目标服务器的管理设置( 安全和分割) 。
最佳选项是使用部署向导。 它允许您生成一个递增部署脚本, 以更新立方体和尺寸结构。 可以自定义角色和分区的处理方式。 它使用在 BIDS 中建立 SSAS 生成的 XML 输出文件作为输入文件, 您可以使用多种模式运行 :
如果您想要完全同步, 您可以使用“ 同步化数据库向导 ” 。 它几乎可以克隆一个数据库。 当目的地数据库已经存在时, 它会执行元数据同步和递增数据同步。 如果目的地数据库不存在, 则会完成完全部署和数据同步 。
我认为整个数据库脚本的主要缺点是所有东西都可以被重新处理。 此外,如果另一个团队或团队成员负责部署脚本,那么如果每一份更新都重建一切,那么审查和理解起来可能就困难得多。
我为红门工作, 我们最近推出一个免费工具, 名为 SSAS 比较( SSSA 比较), 帮助管理此方案。 它帮助您创建一个脚本, 包含您想要部署的更改
I have a many-to-many dimension in my cube (next to other regular dimensions). When I want to exclude fact rows in my row count measure, I usually do something like the following in MDX SELECT [...
我是SSAS的一个新奇,具有一些理论知识。
These are really hard to describe without going in-depth into the data structure, i ll try to keep it as short as possible while giving as much info as I can. I have a measure which is a monetary ...
I have a table with a list of contract line items in the form of CREATE TABLE contracts_lines ( contract_id integer, product_id integer, contract_line_start datetime, contract_line_end ...
Proficient with SQL but new to MDX, I am having trouble getting my head around this: I have a fact table that contains snapshots of account balances monthly. I need to roll up the balances as a semi-...
In a parent-child dimension in SSAS, the datamember is automatically named the same as the parent. E.g. Division X Risk Register Division X Risk Register Department A Risk Register Department B ...
I have the following query that gives me an extract (I am putting this into a CSV from my cube). I want to show the Total of all NRx in a column as the first column NRx and the rest of the NRx ...
First some background: I have the typical Date dimension (similar to the one in the Adventure Works cube) and an Account dimension. In my fact table I have daily transaction amounts for the accounts. ...
