Friends – One of the Very helpful property of SSAS is discussed in this video. The data folder needs to be moved to a new loaction in few cases and the same is discussed in this post. Enjoy !! Regards, Roopesh Valluru ...

Friends, In this post/video, we are gonna explore DATA folder and it’s uses in SSAS. Hope this will help you in understanding the concept MOLAP Storage Mode very clearly. Hope you understood the concepts Regards, Roopesh Valluru ...

Friends – If you wish to know How I delete huge SSAS cube databases, then jump into the below given video. Hope you liked it !! Regards, Roopesh Valluru ...

Friends - To copy ONLY Structure or Schema of Cube database to new server, we need solution file. But, without solution you can do it using the DB deployed to one server and XMLA. check out how. Hope you liked  it!! Regards, Roopesh Valluru ...

Friends - REPLAY option in Sql Server Profiler Trace is one of my favorite options. This options helps you to replicate load of once server to the another and check out how .. Hope you liked it !! Regards, Roopesh Valluru   ...

Friends – When you try to ProcessAdd of dimension from SSAS, you will not find any such option. Is it really available for us from SSMS or not ? Check it out here .. Hope you understood now Regards, Roopesh Valluru ...

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 ...

Posted on Apr 19 2014 - 10:00am by roopesh.valluru
Comments Off

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 ...

Posted on Mar 27 2014 - 3:27am by roopesh.valluru
Comments Off

Friends, This post explains about “How to implement OR condition in MDX”. This is a youtube video and if you are unable to see the same then youtube might be blocked in your company .. Here it goes .. Hope this helped you guys !! Best 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, I am bringing together all the MDX Videos in this post. In this post we are gonna discuss about all the MDX topics in details. Hope you will enjoy the journey through MDX in detail. My best Wishes !! Video 1 Video 2 Video 3 Video 4 Video 5 Video 6 Video 7 Regards, Roopesh Babu V ...

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...

Posted on Oct 19 2013 - 10:39am by roopesh.valluru
Comments Off

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...

Posted on Oct 19 2013 - 10:16am by roopesh.valluru
Comments Off

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...

The answer is NOTHING. It is of no use. the only property yu can set in Rowcount transformation is VariableName and if you try to select any column in input columns tab then it will throw error. So Beware and don’t touch the highlighting tabs in the below pic. Regards, Roopesh Babu V ...