Yearly Archives: 2012

Line chart + Bar chart in SSRS Report

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, “Language is the key for communication“. Having said that “Language” could be anything with a clear meaning of message/information to be delivered. Over the generations, we have one language which is never changed for communication among humans i.e. audio-visual communication. Developing charts for an organization for getting to know “how it’s team or organization is doing?” has been always a key requirement for managers or top-heads in organizations. But for developer it’s merely a representation of values in pretty charts. But every developer has to bear in mind that it’s always bonded with business meanings. And moreover, the … Continue reading →

Ways to execute SSIS package

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, There are lots of methods documented and available on internet. But if you think about the execution of anything you may find more options. Particularly for SSIS packages, there is a golden rule to be bear in mind when planning for executing ssis packages, i.e. you will need SSIS RunTime. Following is the excerpt from my previous post “http://bigator.com/2012/02/17/the-task-scr-get-task-start-time-cannot-run-on-this-edition-of-integration-services-it-requires-a-higher-level-edition-ssis-2005-dtexec-execution-result/”

Continue reading →

Dazzle your SSRS Report with SparkLines

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, “SparkLines” is a new feature introduced in SQL Server Reporting Services 2008 R2. Fast Facts about SparkLines: •    It is the simplest way to make your data/values intelligent by showing them in visual way. •    Because it’s a tiny-chart representation, makes report elegant, meaningful and non-messy. •    Report users can choose to dig in to values if they find SparkLines chart more appealing. (E.g. By seeing SparkLine chart, you can quickly determine  the fluctuation of values for the listed items rather than reading & analyzing values) •    It’s more suitable to use SparkLine rather than big charts if … Continue reading →

MDX Query Parameterization for displaying Last 12 month’s SSRS Report

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, While working with SSRS reports for displaying some financial data; many a times we have to display data for particular time-frame. Or most commonly – last 12 month’s data. I am talking about the case where you are pulling data from SSAS Cube using MDX queries. In this particular example, I need to display SSRS report for last 12 month’s data from SSAS Cube. So I need to provide 2 things: StartDate and EndDate. But as the default expected behavior of the Report requires EndDate to be today’s date so we have to dynamically configure today’s date in … Continue reading →

A Set of Boon Tools – SSAS DMVs in SQL Server 2012

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, As you must have heard or started using DMVs (Dynamic Management View) available in SQL Server to get information about local server operations and server health. But today I would like to focus specially on DMVs for monitoring SSAS (SQL Server Analysis Services) and dig-down to find out how powerful it can be. DMVs for SSAS are known as “Analysis Services Dynamic Management View“. We can query these views by simple T-SQL SELECT statement. When use these views, they exposes analysis services schema rowsets in form of table, hence information presented will become self-explanatory. Major benefits of using … Continue reading →

What do you need to know about – “Report Builder 3.0”

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, People who have been working with SSRS and Report Builder are well aware about the release of new “Report Builder 3.0“. I have summarized following introduction, features & facts about the product. General: If you already know or work with any previous versions of Report Builders then understanding “WHY” is no big deal. So here is a small introduction of new Report Builder 3.0 – This introduces additional visualizations including maps, sparklines, databars, and indicators which can help us producing fantastic reports (layouts based on requirements) so well that can be achieved with standard tables and charts. And … Continue reading →

What you need to know about – “PowerPivot”

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, Today i would like to talk about a booming technical feature by Microsoft i.e. “PowerPivot“. What is PowerPivot? PowerPivot (which is also known as Project “Gemini“) is Microsoft’s hottest business intelligence (BI) innovation. By integrating PowerPivot technology with Microsoft Excel, Excel has gradually becoming most wanted & preferred BI tool (client) in the world. PowerPivot is actually of 2 types: 1. Client Add-In for Excel 2010 i.e. “PowerPivot for Excel” (Applicable to Excel 2010) 2. Server component i.e. “PowerPivot for SharePoint” (Applicable to SharePoint 2010 Onwards)

Continue reading →

Search Country & Location Information based on IP Address

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, Once I ran into the situation where I have to find out the CityCountry name & location (Longitude, Longitude) based on the IP address. This was not difficult but rather not straight-forward as IP addresses are stored into database table as strings which is very obvious because there are no standard data type which supports IP address as value. Anyways, so in my database table there are 2 important columns regarding IP address details i.e. Start_IP_Address and End_IP_Address. And mind-well, a range of IP addresses belongs to a country. Currently my database table looks like following: (Below screenshot … Continue reading →

GodMode in Windows 7

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, If you have a Windows 7, then you can enable so-called “GodMode” to get access to most of the controls of operating system & other components. You simply have to create a folder name with following words. “GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}” (Please exclude ” – double quotes while naming it). Ta-Da. The folder icon will change to control panel icon and you will see the big list of items where you can easily search many controlling options just grouping by “Application” in details view. You can also collapse or expand all groups by right-click & selecting appropriate options. Though it seems … Continue reading →