June 13, 2008 at 1:10 pm
1)
I am developing a solution wherein I use a SSIS package to ftp data from a location, process the data and load it into a DW. How can I automate the process so that once I deploy the SSIS package onto production, every time new data is loaded into the sourceDW the cubes are refreshed. Do I have to schedule the SSAS package to run or can it be triggered to do an update rather than a full refresh? I am thinking of using an automatic MOLAP as a storage option (but I don't know where to change that option). I would really appreciate if someone could direct me.
2)
As of now I have problems even testing the SSAS package. I am on a LAN and the server is on an administrated machine so I get an error saying I do not have permissions to create objects onto the server. Must I ask for database creation access or is it enough for some kind of a create objects access. The part I am not sure about is when I create a cube (thru the SSAS package) does it necessarily have to create a new database on the server or can it be a part of the same source DW.
June 15, 2008 at 1:50 pm
Hi,
SSAS is quite a big subject area. Take a look at some of the video tutorials on the following site. A wealth of information is available.
http://channel9.msdn.com/posts/ZachSkylesOwens/Business-Intelligence-09c-Using-the-Cube-Wizard/
Cheers,
John
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply