Rakesh Ramblings

All you need to know about Microsoft Business Intelligence !

Implementing Role Based Access for PowerPivot

This has been a very long week, and I have written a paper which will guide you step by step in...

Author: Rakesh M J Date: 05/17/2013

Analyzing LinkedIn Connections using Spatial Query!

Let me confess before I even start! I am an hardcore LinkedIn fan. I love to connect with people who...

Author: Rakesh M J Date: 05/16/2013

Sparse columns, An oblivious for any data/dimensional modeler !

Have you anytime been knocked on the head by the client on how can you as a data modeler taken...

Author: Rakesh M J Date: 05/10/2013

Analyzing Aliens preference using Powerview

The day I watched Aliens, I was always fascinated about that topic. More than Aliens I was more...

Author: Rakesh M J Date: 04/08/2013

The Davinci code ( SQL Cryptology)

Late night, Sitting under the A/C duct relaxing I could hear a grunted words from a near cubicle...

Author: Rakesh M J Date: 03/07/2013

Dynamic Dashboards in Performance point services 2010

For a long time I wanted to share this information with the report developers .Performance point...

Author: Rakesh M J Date: 01/30/2013

Whats up with ALL(Table) + ALLExcept + ALL(Table[Column])

I was Quizzed with Ranks in DAX and during my exploration few intresting things were found. Here are...

Author: Rakesh M J Date: 09/28/2012

To Hide Data Feed icon in Report Manager for Reporting services 2008 R2

Hi ,This is a Strange Requirement which my client asked me whether its achievable to Hide the Data...

Author: Rakesh M J Date: 09/20/2012

Reporting services 2008 (and later Version) gives more flexibility by adding few fine things which...

Author: Rakesh M J Date: 09/20/2012

How to Script Data from a Table ..?

Hi,Most of the time we need to script data of a table which holds configuration Values or Date...

Author: Rakesh M J Date: 09/20/2012

Asynchronous Output in SSIS

Hi Folks,I was supposed to do a Currency Currency Required for my Cubes.This Could have been...

Author: Rakesh M J Date: 09/20/2012

Intresting Question on MDX !

There was an Interesting MDX Query Which i cam through in MSDN Forum Posted by Piasevoli thought its...

Author: Rakesh M J Date: 09/20/2012

I was questioned by my client to display the Running Total at the Page Footer ,Initially thought it...

Author: Rakesh M J Date: 09/20/2012

What’s with the Error Count in SSIS ?

I was in for a surprise when one of my team-mate threw me a requirement in SSIS. Let me brief the...

Author: Rakesh M J Date: 09/20/2012

AND or OR in MDX !

Most of the time I encounter questions from MSDN users who often get confused with AND and OR...

Author: Rakesh M J Date: 09/20/2012

Here is My thought on using .dll to find the Current Month in an Easy Way ! Way of Finding Current...

Author: Rakesh M J Date: 09/20/2012

Load Cube Metadata Into SQL database

Howdy Folks !Hope this will be HelpfulWay of Finding Cube Meta Data Using SSIS Script TaskContext:...

Author: Rakesh M J Date: 09/20/2012