June 28, 2010 at 12:09 pm
Hi,
I guess this should be very basic question for those who are working on BIDS environment. I create a cube with dimensions using Fact table and dimension tables from SSMS and then deploy the project in SSAS environment for analysis purpose. Now I am not sure how to update the data in the cube
a) Do I need to delpoy cube and dimensions in SSAS every time when data will update in fact/dimension tables in SSMS? Or is there any other professional way to deal with this issue?
b) And then I need to create reports using SSRS which data source should I use to create the reports SSAS Cubes or SSMS fact/dimension tables?
Please advice.
Thanks.
June 29, 2010 at 1:27 am
You need only to deploy your cube when you made changes to the cube itself.
If the data in your relational database has changed, then you need to process the cube and its dimensions (first the dimensions, then the cube).
You can do this manually, or you can create a package in SSIS and use the Analysis Sercices Processing Task. Then schedule this package using a job in SQL Server Agent.
In SSRS, use the cube as a source, not your relational database, otherwise it wouldn't make much sense creating a cube, isn't it? 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 29, 2010 at 6:27 am
Great!! Make sense.
Any idea where/which directory SQL server use to physically store Cube data? And what which option do we use from SSAS to update the cube data?
Thanks so much!
June 29, 2010 at 3:55 pm
The data directories are impacted by the usual things (version of SSAS, whether you're using instance and whether you changed them from their defaults), but as an example, my local SSAS 2008 R2 instance data directory is
C:\Program Files\Microsoft SQL Server\MSAS10_50.SQL2K8R2\OLAP\Data
To process, when you've got the SSAS project open, in the Solution Explorer, you can right click on an object (e.g a dimension, or a cube or the entire DB) and select Process. It's also available from the menu's and the toolbars.
Steve.
June 30, 2010 at 8:24 pm
In addition you can also process the objects within SQL Server Management Studio once you are connected to your SSAS instance. During the process you can also save the processing as a script and then setup the XMLA script to be run through a SQL Server Agent job as well. As stated another option would be to set this up to run within SSIS using the SSAS processing task or use script components. You could also use PowerShell as well.
Take a look out here for some examples - http://ssas-info.com/analysis-services-scripts
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
June 3, 2012 at 12:12 am
I want to create a datamining application using visual studio and have lots of questions about it. im new to data mining so hope u'll help ... few questins are,
1) can you explain how to update the SSAS cube with SSIS ?
2) how to connect a visual studio application with SSAS ?
3) how can i applay my data mining queries to the cube ?
Thanks !!
June 3, 2012 at 1:09 pm
jayani0507 (6/3/2012)
I want to create a datamining application using visual studio and have lots of questions about it. im new to data mining so hope u'll help ... few questins are,1) can you explain how to update the SSAS cube with SSIS ?
2) how to connect a visual studio application with SSAS ?
3) how can i applay my data mining queries to the cube ?
Thanks !!
Why don't you start a new thread in the data mining forum instead of hijacking an existing one?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply