abc-techblog.blogspot.com
abc-techblog: July 2011
http://abc-techblog.blogspot.com/2011_07_01_archive.html
Monday, July 25, 2011. MDX: Replacing Null / Empty Values. In the result of an MDX query, you may get some empty or null values which you'd want to treat differently, such as considering them as 0s. For instance in Reporting Services, you might want to filter out any rows with 0 or empty values. In such cases, you can use the MDX function CoalesceEmpty. Which replaces an empty cell value with a given value. For instance:. WITH MEMBER [Measures].[NonEmpty Discount] AS. Very useful in certain scenarious.
abc-techblog.blogspot.com
abc-techblog: MDX: Replacing Null / Empty Values
http://abc-techblog.blogspot.com/2011/07/mdx-replacing-null-empty-values.html
Monday, July 25, 2011. MDX: Replacing Null / Empty Values. In the result of an MDX query, you may get some empty or null values which you'd want to treat differently, such as considering them as 0s. For instance in Reporting Services, you might want to filter out any rows with 0 or empty values. In such cases, you can use the MDX function CoalesceEmpty. Which replaces an empty cell value with a given value. For instance:. WITH MEMBER [Measures].[NonEmpty Discount] AS. Very useful in certain scenarious.
abc-techblog.blogspot.com
abc-techblog: May 2011
http://abc-techblog.blogspot.com/2011_05_01_archive.html
Saturday, May 7, 2011. Welcome to yet another tech blog. Since every IT geek has an IT blog, then why not have one too? Though part of the reason comes from motivation from a colleague. Otherwise I’m a fan of C# and game development, so things may be headed that way too. Links to this post. Subscribe to: Posts (Atom). Report builder 3.0. View my complete profile. Awesome Inc. template. Powered by Blogger.
abc-techblog.blogspot.com
abc-techblog: SSRS: Retrieving Member Properties in Reporting Services (with Analysis Services)
http://abc-techblog.blogspot.com/2011/10/ssrs-retrieving-member-properties-in.html
Monday, October 17, 2011. SSRS: Retrieving Member Properties in Reporting Services (with Analysis Services). In Reporting Services, it is unclear how, or if it is even possible to retrieve member properties when using an analysis services data source. Member properties refer to the extra information attributed to members apart from their names. For instance, in the AdventureWorksDW, the Customer dimension contains several member properties including Address, Gender and Phone. Screenshot 4 - Tooltip showi...
abc-techblog.blogspot.com
abc-techblog: February 2012
http://abc-techblog.blogspot.com/2012_02_01_archive.html
Tuesday, February 21, 2012. SSRS: World Maps for Reporting Services. The map visualization tool in Reporting Services 2008 R2 is a great feature that introduces multiple ways of visualizing data on a map. Some of the possibilities are:. Coloring countries based on some data. Showing bubbles or markers over countries that vary in color, shape or size based on data. Marking exact coordinates on the map based on geospatial data. Figure 2 - USA maps only. For Report Builder 3.0). If you have a Report...I fou...
abc-techblog.blogspot.com
abc-techblog: March 2012
http://abc-techblog.blogspot.com/2012_03_01_archive.html
Wednesday, March 28, 2012. SSRS: Dynamic zoom for maps in Reporting Services 2008 R2. The maps in reporting services miss one important feature: dynamic zoom. By this, I mean the ability for a user to zoom into the map while looking at the report and panning around to see the locations of interest. This is necessary for instance when you display the world map and wish to zoom into smaller countries or specific areas. Figure 1 - Starting map. The sample includes very few countries but that's okay. Figure ...
abc-techblog.blogspot.com
abc-techblog: SSRS: Dynamic zoom for maps in Reporting Services 2008 R2
http://abc-techblog.blogspot.com/2012/03/ssrs-dynamic-zoom-for-maps-in-reporting.html
Wednesday, March 28, 2012. SSRS: Dynamic zoom for maps in Reporting Services 2008 R2. The maps in reporting services miss one important feature: dynamic zoom. By this, I mean the ability for a user to zoom into the map while looking at the report and panning around to see the locations of interest. This is necessary for instance when you display the world map and wish to zoom into smaller countries or specific areas. Figure 1 - Starting map. The sample includes very few countries but that's okay. Figure ...
abc-techblog.blogspot.com
abc-techblog: SSRS: Hierarchies issue in report parameters with Analysis Services
http://abc-techblog.blogspot.com/2011/07/ssrs-hierarchies-issue-in-report.html
Friday, July 22, 2011. SSRS: Hierarchies issue in report parameters with Analysis Services. Reporting Services offers great support for Analysis Services (getting data from cubes). Admittedly however, you will sooner or later meet with several little annoyances that hinder report development, especially if you are not confident or have no knowledge in MDX. Screenshot 1 - Parameter. Screenshot 2 - Large dropdown list. So what can you do if you want only the countries? Screenshot 3 - Show Hidden Datasets.
abc-techblog.blogspot.com
abc-techblog: June 2011
http://abc-techblog.blogspot.com/2011_06_01_archive.html
Thursday, June 23, 2011. Microsoft SQL Server Reporting Services vs PerformancePoint Services. These 2 products aren't often compared with each other, and they are in fact different. However there are times where their capabilities overlap and reasons for using one instead of the other may be unclear, especially when using these tools together with Analysis Services. Since not much information on such aspects seem to be available on the internet, below is a basic list displaying some comparisons.
