www.sqlpass.org    Professional Association for SQL Server

Welcome to SQLCape!
We are based in the beautiful Western Cape, South Africa

 Next Meeting


Topic         Reporting Services - working with a SSAS Tabular data source
 
Despite the attention given to Self-Service BI, we still have to satisfy the needs of our general report consumers. For those of us that have worked our way through the world of MDX to build Reporting Services data sets from SSAS multi-dimensional databases, we are now faced with having to build reports using SSAS Tabular databases. It is not very complex, but it does help to get shown the DAX query patterns to produce SSRS datasets.
 
In this session we explore the anatomy of a DAX query. We briefly cover the basics, then tackle parameterised queries, multi-value parameters and cascading parameters.  Finally we will explore the world of dynamic DAX queries and how to make your code readable and maintainable.

 

When

 

Tuesday,11 March 2014

18:00 – 20:00 (Snacks & drinks will be provided from 17:30)

 

Where

    

Microsoft Cape Town Office, Golf Park 3, Engen House, Raapenberg Road, Mowbray, Cape Town

 

 

Speakers 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Toufiq Abrahams is the Principal Consultant and Trainer at Osmosis Consulting. He has a passion for BI and a penchant for Microsoft BI products, especially the new self-service BI capabilities.

 

 

We hope to see you there.

 

Regards

SQLCape Committee.

 

 

 

 

 

 

 

  

 

 

 

 

 

 

 

 

   
   
   
   
   

 

 

 

 EventDisplay
There are currently no upcoming meetings scheduled. Please check back for updates.
 EventArchive

You are almost there!

This archive module depends on EventDisplay module to display event detail. Please make sure you have at least one instance of EventDisplay added to a page first. Click Settings to start module configuration.

The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (SIGs) to webcasts and the annual PASS Community Summit � the largest gathering of SQL Server professionals in the world � PASS enables knowledge sharing, in-depth learning, access to the Microsoft SQL Server team, and the ability to influence the direction of SQL Server technologies. PASS was founded in 1999 by Microsoft and CA and continues to enjoy executive level endorsement from both organizations. As the number one user community for Microsoft SQL Server, Microsoft looks to the PASS community for valued feedback, input, and inspiration. PASS Mission Empower the global Microsoft SQL Server community to connect, share, learn and be inspired through networking, knowledge sharing, peer-based learning, and the ability to influence the direction of Microsoft SQL Server products and services.
 Sponsors

PASSChapterLogo100.jpg 

 

sql_micro_sm.gif 

sql_ca_sm.gif