SCOM (Systems Center Operations Manager) Cube and Data warehouse
What I have done is I have found that it is very handy having all our SCOM data in a data warehouse and then having it in a SSAS (SQL Server Analysis Services). Within the zip file which can be located here below it has all the details for the following: · SCOM Data Warehouse and OLAP Documentation.docx o This…
Data warehousing – Bringing down data twice but avoiding deleting on the data warehouse Fact Table
This is better explained with our example below. Example: · We had a situation where we were getting data down, but due to the nature of the data we were getting is we were missing data. · Also another note was the fact that we did not store the granular data, but aggregated the data, so due to this…
SSIS–Conditional Split based on Date
Below is a quick blog where I am using a conditional split based on your Date Column, so that you can then output your data to different tables or destination data flow tasks. I also found that there are bits and pieces of information as to how to use the Expressions within the Conditional Split. So this might help…
SSIS – Stopping an Error from Propagating to its Parent (Enabling an SSIS Package to continue when an error happens)
Due to our environment and packages we create, we have to enable the packages to continue even if it fails for some reason (Cannot connect to a Server for example) so that the rest of the data will be captured. In the past we configured the MaximumError count to be 100, but this is not ideal, because if another component…
SSIS – Fastest data flow task item for transferring data over the network
My goal was to find out which combination of data flow Source and Destinations would enable me to transfer data over a network as quickly and as efficiently as possible. · Below is what the outcome of the tests are · And then finally I have only detailed, based on the fastest data flow items how to configure the data…
SSIS & TSQL – Geo- location from IP Address to Country
Below are the details firstly from getting your Geo – location information from a table which has your IP Address to country information. And then getting your IP Address information from your source systems and quickly getting this to a Country so that you can see where the people are coming from. Geo – Location information There are a…
SSIS 2012 – Inserting data into a SQL Server Table from an MDX Query
The reason for this blog post, is I recently had a query if it was possible to get data returned from an MDX Query and then insert the data into a SQL Server Table. And the reason for putting it into SSIS was that we could schedule the job to run on a schedule. I have inserted pictures from my…
SharePoint – Power View URL Actions
This is related to using the PowerView reports in SQL Server 2012 using Analysis Services in the tabular mode. I thought it would be helpful to post some of the URL Actions that you can use with your PowerView Reports which will add more functionality to your reports and to your end users. So this will then enable you to…
SSIS – Process Cube with XMLA and Analysis Services DDL
Generating XMLA Script and data from Cube What I was looking to do, was to use XMLA and the Analysis Services Execute DDL Task in SSIS to dynamically process just a required partition that has already been created in SQL Server Analysis Services (SSAS). I found that doing this in SSIS was a quick and easy way in order to…