August 3, 2015 at 8:26 pm
Hi,
I've
1. Data Warehouse
2. OLAP CUBE in Analysis Services
My question is - If my Data Warehouse is changed (Having Append Data) - My OLAP Cube will have the Append Data?
It's possible, my OLAP Cube always having Append Data if my Data Warehouse is changed? If yes, please tell me how to do it without re-deploy and re-process my Analysis Services Project
Need answer
August 5, 2015 at 7:28 am
Qira (8/3/2015)
Hi,I've
1. Data Warehouse
2. OLAP CUBE in Analysis Services
My question is - If my Data Warehouse is changed (Having Append Data) - My OLAP Cube will have the Append Data?
It's possible, my OLAP Cube always having Append Data if my Data Warehouse is changed? If yes, please tell me how to do it without re-deploy and re-process my Analysis Services Project
Need answer
You will need to create a SQL Agent job to maintain the dimensions and facts so that any changes are processed.
gsc_dba
August 5, 2015 at 11:08 pm
Owh. Did you have any article to - Create SQL Agent to re-process the Cube in Visual Studio?
January 11, 2016 at 9:47 am
Qira (8/5/2015)
Owh. Did you have any article to - Create SQL Agent to re-process the Cube in Visual Studio?
https://msdn.microsoft.com/en-us/library/ff929186(v=sql.110).aspx
http://bidn.com/Blogs/userid/11/Use-SQL-Server-Agent-to-Process-Cube
gsc_dba
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply