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 implementing role based access for PowerPivot. You can download the file from here.   Share your feedback’s and comment’s below

0

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 have a similar passion for Technology,Share my thoughts and learn from others experience.   As all of you might know,I am an Analytics Guy and always intrigued by numbers. This led me to understand my…

0

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 actions to reduce space usage in the server? One of the most oblivious to any data/dimensional modeler is the efficient way of minimizing the space used by the database on the disk. So how can…

1

Analyzing Aliens preference using Powerview

The day I watched Aliens, I was always fascinated about that topic. More than Aliens I was more interested in Crop Circles. Crop Circles in particular because it has a lot of fallacy ( As I believe in Aliens!) 🙂 and also due to the reason of its complexity and geometry involved in it. So, I took up a…

0

The Davinci code ( SQL Cryptology)

    Late night, Sitting under the A/C duct relaxing I could hear a grunted words from a near cubicle About a strange requirement which requested by a customer. Keeping my curiosity at bay I thought its not my business …   It dint stop there ! I could here a disappointed words from another…

0

Dynamic Dashboards in Performance point services 2010

For a long time  I wanted to share this  information with the report developers .Performance point services allows you to create dynamic dashboards which means you can connect a scorecard and a report and make each other interdependent. Below are the step by step guide Step 1.Create scorecard has “sales territory” in the rows .    …

1

Ranking within an hierarchy using DAX

  Hierarchy is one of the mostly wide functionalities in any model. So, the usual question will be how do you RANK a City across ALL the cities for sales or Country across all the Countries for sales .   Lets say I need to RANK the City for the Country which it belongs and…

2

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 my findings on how ALL and ALLExcept function behaves with contexts ! ALL(Table) will not apply for any of the contexts (Row,Query,Filter etc.)  ALLExcept (Table,Table[Column]) will apply the context only when Table[Column] is specified in any context…

0

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 feed icon shown in the ReportManager..As directed by my PM I said i will check it out and let you know..No commitments to client JLT is an advise to me by my PM . Here is how…

2

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 will make a BI developer like me like the Product even more.SSRS 2008 2008 (and later Version) Provides Globals! Render.FormatName which decides what can be achieved to the Data Region (Table, matrix, Chart, Gauge, etc…) when Rendered in different formats….

0