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
Ranking within an hierarchy using DAX
Hierarchy is one of the mostly wide functionalities in any model. So, the usual question will be how...
Author: Rakesh M J Date: 10/24/2012
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
Hide the Drill through Action URL Link when Exported to Excel
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
Reporting Services - Running Total at Page Footer
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
Dynamic Link Libraries to find current month in SSAS
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