Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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:...
Date: 09/20/2012