Ad Hoc Reporting: Lessons & Tricks with Dan Bulos

Ad Hoc Reporting: Lessons & Tricks with SSRS, SSAS, & MDX

Sometimes Self-Service BI Tools are not the right option for ad hoc reporting with cubes. There can be reasons of compliance and control. Multi-tenant BI applications have challenges with Self-Service BI tools. Also, sometimes Business Intelligence is just not intelligent about an application domain.

Creating a Reporting Services report that provides dynamic layout (PivotTable-like features ) has its challenges. On September 3rd, Business Intelligence expert Dan Bulos will look at a dynamic layout project and the techniques and tricks he used.

You'll learn about:

• Dynamic row & column layout

• On-The-Fly attribute reporting hierarchies (even across dimensions)

• Across dimensions other than measure (matrix reports are too slow)

• Dealing with numeric formatting (harder in an ad hoc environment)

• Adding a little more intelligence (% of total not useful for Gross Margin%)

• Dealing with multi-tenancy

http://photos3.meetupstatic.com/photos/event/8/0/9/7/600_441272919.jpeg

Dan Bulos is a highly-renowned BI consultant. He sits on the Microsoft BI Partner Advisory Council and has been a member since the council was founded 15 years ago. He's a recognized authority on analytical database technology and how to best use it to provide real-world solutions for business users. Dan has also consulted on new product features and directions to leading software vendors such as Microsoft, Oracle, Hyperion, and others. He's a featured speaker at Business Intelligence and Data Warehouse conferences across the U.S.