使用sql作业自动化多维数据集进程 [英] Automate cube process using sql jobs

问题描述

嗨朋友们，



我是SSIS的新手，不懂SSAS。我有一个自动化SSAS多维数据集的任务。



但我希望在完成工作的所有步骤之后处理多维数据集，以发布数据。



其他机器和作业中的多维数据集存在于其他机器上。即使我无法指向机器指向立方体。然后我想将其作为预定的工作处理。



如果我得到它将会很有帮助代码或工作步骤的任何示例。



提前致谢。

Hi friends,

I am very new to SSIS and don't know SSAS. and i have an task to automate SSAS cube.

But i want cube processing after all the steps of my job, to publish the data.

Cube present in other machine and job is on other machine. even i am unable to point machine for pointing to the cube.and then i want to process that as a scheduled job.

it would be great help if i will get any sample example of code or job step.

Thanks in advance.

推荐答案

请参考下文，可能很有用。



http：// msdn.microsoft.com/en-us/library/ms169712.aspx [ ^ ]



在SQL Server Analysis Services中创建第一个OLAP多维数据集 [ ^ ]



http://blog.sqlauthority.com/2011/ 09/22 / sql-server-learning-ssas-sql-server-analysis-services-online-in-6-hours-top-down-design-and-bottom-up-designing / [ ^ ]

Please refer below , may be useful.

http://msdn.microsoft.com/en-us/library/ms169712.aspx[^]

Create First OLAP Cube in SQL Server Analysis Services[^]

http://blog.sqlauthority.com/2011/09/22/sql-server-learning-ssas-sql-server-analysis-services-online-in-6-hours-top-down-designing-and-bottom-up-designing/[^]

这篇关于使用sql作业自动化多维数据集进程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！