gopika-lasitha.blogspot.com
Gopika's Blog: 8/1/14 - 9/1/14
http://gopika-lasitha.blogspot.com/2014_08_01_archive.html
Business Intelligence, Data Warehousing, OLAP Implementation, Reporting and many more. Thursday, August 28, 2014. Adding additional dimension attribute value in MDX query. Depending on the requirements, sometimes it is necessary to do some categorizations which does not included in the dimension data. In such scenarios we may have to add a dimension attribute which currently does not exists with the dimension data. We can do it in the MDX query as below. DimBranch].[Branch].[Dummy] AS. When I tried to co...
gopika-lasitha.blogspot.com
Gopika's Blog: Rank SSAS Cube data based on a filtered data set using MDX...
http://gopika-lasitha.blogspot.com/2015/02/rank-ssas-cube-data-based-on-filtered.html
Business Intelligence, Data Warehousing, OLAP Implementation, Reporting and many more. Friday, February 6, 2015. Rank SSAS Cube data based on a filtered data set using MDX. I explained how we can use MDX ranking in the below two posts. And Advanced MDX Ranking. To avoid this, we need to only use the filtered dimension members in the ranking calculation as well. The sample query is as below. In that, ranking needs to be done for the selected stores and the used parameter is paramStores. In SQL Server Anal...
gopika-lasitha.blogspot.com
Gopika's Blog: 5/1/14 - 6/1/14
http://gopika-lasitha.blogspot.com/2014_05_01_archive.html
Business Intelligence, Data Warehousing, OLAP Implementation, Reporting and many more. Wednesday, May 28, 2014. Importance of the Surrogate Key in Data Warehouse Design. In Data Warehousing, Surrogate Key is a unique identification key in a dimension table which is independent from the source. Normally it is an auto increment integer value. The purpose to have a surrogate key in a dimension table is to makes the relationship between dimension tables and fact tables independent from the source. To avoid t...
gopika-lasitha.blogspot.com
Gopika's Blog: Problems when trying to get changed records from...
http://gopika-lasitha.blogspot.com/2015/06/problems-when-trying-to-get-changed.html
Business Intelligence, Data Warehousing, OLAP Implementation, Reporting and many more. Tuesday, June 9, 2015. Problems when trying to get changed records from. The SSIS Package was configured to get only the net changes by applying the CDC processing mode as Net in the CDC Source. But when the SSIS package was executed, got the below error message. The issue was fixed by using the below steps. Right click on the CDC Source and select Properties. Labels: SQL Change Data Capture. View my complete profile.
gopika-lasitha.blogspot.com
Gopika's Blog: 7/1/14 - 8/1/14
http://gopika-lasitha.blogspot.com/2014_07_01_archive.html
Business Intelligence, Data Warehousing, OLAP Implementation, Reporting and many more. Thursday, July 10, 2014. Set the Visibility of a Dimension Hierarchy in SSAS. In some scenarios, you may need to set the visibility of a dimension hierarchy as hidden. Because that hierarchy may be used for some of the calculation and it is not good to show that to the user. In such a case, it can be done using the below steps. Open the Cube available in the BIDS. Right click on it and select Properties. Go to the Pkg ...
gopika-lasitha.blogspot.com
Gopika's Blog: 10/1/13 - 11/1/13
http://gopika-lasitha.blogspot.com/2013_10_01_archive.html
Business Intelligence, Data Warehousing, OLAP Implementation, Reporting and many more. Tuesday, October 15, 2013. Cube Optimization in SSAS. In a BI solutions, SSAS cube may contains billions of records. In such large volume of data, query processing will be crucial. End user wants to get the output without much delay and to cater that you need to optimize the query processing. Otherwise it may take minutes to get the query results. For cube optimization, two main approaches can be used. By using aggrega...
gopika-lasitha.blogspot.com
Gopika's Blog: 11/1/13 - 12/1/13
http://gopika-lasitha.blogspot.com/2013_11_01_archive.html
Business Intelligence, Data Warehousing, OLAP Implementation, Reporting and many more. Wednesday, November 20, 2013. Exclude Unknown member from the TopCount in MDX. While taking the Top or Bottom count using a MDX query or using a Named Set, we may need to exclude Unknown member. We can easily do it by using the FILTER function as below. FILTER([Item].[Item].[Item].Members,[Item].[Item].CurrentMember.MEMBER CAPTION 'Unknown'. SQL Server Analysis Services. Tuesday, November 19, 2013. We faced a situation...
gopika-lasitha.blogspot.com
Gopika's Blog: 6/1/15 - 7/1/15
http://gopika-lasitha.blogspot.com/2015_06_01_archive.html
Business Intelligence, Data Warehousing, OLAP Implementation, Reporting and many more. Tuesday, June 9, 2015. Problems when trying to get changed records from. The SSIS Package was configured to get only the net changes by applying the CDC processing mode as Net in the CDC Source. But when the SSIS package was executed, got the below error message. The issue was fixed by using the below steps. Right click on the CDC Source and select Properties. Labels: SQL Change Data Capture. Subscribe to: Posts (Atom).
gopika-lasitha.blogspot.com
Gopika's Blog: 3/1/14 - 4/1/14
http://gopika-lasitha.blogspot.com/2014_03_01_archive.html
Business Intelligence, Data Warehousing, OLAP Implementation, Reporting and many more. Thursday, March 20, 2014. Delete data using Partitions in SQL Server. In a previous post. I had explained how to partition SQL database tables. Actually we can use those partitions when we need to delete particular set of records from those large tables. Otherwise it will takes more time to delete those. To create a stored procedure to truncate partition data, I reused a script in this link. The added modifications are.
gopika-lasitha.blogspot.com
Gopika's Blog: 2/1/15 - 3/1/15
http://gopika-lasitha.blogspot.com/2015_02_01_archive.html
Business Intelligence, Data Warehousing, OLAP Implementation, Reporting and many more. Friday, February 6, 2015. Rank SSAS Cube data based on a filtered data set using MDX. I explained how we can use MDX ranking in the below two posts. And Advanced MDX Ranking. To avoid this, we need to only use the filtered dimension members in the ranking calculation as well. The sample query is as below. In that, ranking needs to be done for the selected stores and the used parameter is paramStores. In SQL Server Anal...