Hello Friends, Back with another video and this time on SSAS cube database backups using XMLA. Generally people prefer to use Wizard to take backups of databases but option using XMLA has more advantages over using Wizard. This is very interesting and useful option to know. So, why late .. just jump into the video .. Hope you too will try this guys !! Regards, Roopesh Valluru ...
Guys – In this post/video we are gonna discuss about the Flight Recorder and its use in SSAS. I feel most of us are not even aware of this (i came to know recently only) and hence adding this video to share my knowledge which will help you guys. Hope this helps you guys !! Regards, Roopesh Valluru ...
Friends, In this Post/Video we are gonna discuss about HOW TO PROCESS MULTIPLE DIMENSIONS AT A TIME FROM SSMS. This might be a very simple topic but very useful one to know for SSAS developers. Let me add couple of points to those who love to READ than WATCHING video .. Connect to the Analysis services using SSMS as shown below. Select any dimension of the cube for which you want to process multiple dimensions as shown below. Select Object Explorer Details options from View menu. Once the details of the dimensions open then...
Guys – In this post/video we are gonna discuss about the steps to be followed to use different attribute in ORDERBY property of a dimension’s attribute. Problem – How to use Attribute Key in OrderBy property of ssas dimension’s attribute. Hope this helped you guys. Do post a comment if this helps you. Regards, Roopesh Valluru ...
Friends, This issue is very common when you are pulling data from Sharepoint list to load parameter values. In this post let us discuss the solution for the same. Step 1 : Create a report and Go to the Report Tab at the top. Step 2 : Go to the Report properties and then code and write the following code in it. Public Function RemoveDuplicates(parameter As string) As String Dim value as String Dim items As Object() = Split(parameter,”~”) System.Array.Sort(items) Dim k As Integer = 0 For i As Integer = 0 To items.Length –...
Friends, This post is very useful to those who wants to learn SSRS with MDX. I have covered almost all concepts and please do drop a message if you are happie with the tutorials. Video 1 - Video 2 - Video 3 - Video 4 - Video 5 - Video 6 - Video 7 - Video 8 - Video 9 - Video 10 - Video 11 - My Best Wishes !! Regards, Roopesh Babu V ...
Friends, I am bringing together all the SSAS Videos. In this post we are gonna discuss about all the SSAS topics in details. Hope you will enjoy the journey through SSAS in detail. My best Wishes !! Video 1 Video 2 Video 3 Video 4 Video 5 Video 6 Video 7 Video 8 Video 9 Video 10 Video 11 Video 12 Video 13 Video 14 Video 15 Regards, Roopesh Babu V ...
Friends, I dunno how many of you guys are aware of the property IsBig in SSIS Aggregate Transformation. If you are aware of it then just skip this post else worth reading this. As you all aware that using aggregate we can calculate SUM,AVG,COUNT and COUNT DISTINCT of a column or columns. In some cases the return value will be soo big like more than 4 billion and to handle those kind of outputs we need this IsBig Property. This can be set on output columns to invoke special handling of big or high-precision numbers. If a column value may...
Friends, You might have seen the properties “Keys Scale” and “Number of Keys” in SSIS Aggregate transformation. What is the difference and in which scenario we use these properties ? Like to know, then continue .. The above two properties are given to improve the performance of the transformation. For the columns with GROUP BY operation in the transformation, we set these TWO properties. Both deals about the number of groups that are expected to result from a Group by operation. For example, if I used Color column...
Merge Join Transformation is one of the useful tool in SSIS to join two sources. The Merge Join transformation provides an output that is generated by joining two sorted datasets using a FULL, LEFT, or INNER join. Let us see how it works. You can configure the Merge Join transformation in the following ways: • Specify the join as FULL, LEFT, or INNER join. • Specify the columns the join uses. • Specify whether the transformation handles null values as equal to other nulls. NOTE: If null values are not treated as equal values, the...
The Import Column transformation reads data from files and adds the data to columns in a data flow. Using this transformation, a package can add text and images stored in separate files to a data flow. For example, a data flow that loads data into a table that stores product information can include the Import Column transformation to import customer reviews of each product from files and add the reviews to the data flow. A column in the transformation input contains the names of files that hold the data. Each row in the dataset can specify...
RowCount Transformation : The RowCount transformation provides a way to track how many rows are flowing through a particular path. You can use this information in logs as diagnostic information or for sending in an email as a notification of the work a package has completed. Counts the rows flowing through the data flow and writes the final count in a variable. Here we are gonna discuss an example on the same. In the Control Flow tab, add a variable named “RowCnt.” Ensure that the variable is package-scoped and of type Int32...
Friends, In this post we are gonna discuss about Character Map Transformation in SSIS 2008R2 with Example. Character map transformation is used to make changes to string type columns only. String functions can be applied using this transformation like upper case, lower case, byte reversal and so on. To understand in detail let’s take one data flow task and add character map transformation as per below screen print. In this transformation we have to select the column. Note: we can only use string type columns in this transformation. Here...