SQL Saturday Sydney is back with lots of power packed sessions and a strong line up of speakers. I will be speaking on the topic “Crack open the AMO for SSAS Tabular” which will certainly help developers to programmatically manage and administer Analysis Services Tabular models.
Please find the agenda for the day (25th Oct, 2014) here.
Venue: University of Sydney
Looking forward to seeing you there.
Qlik launched their new product Qlik Sense Desktop that officially marks the launch of their next generation platform. The Qlik community and practitioners had been waiting for Qlik.Next for a while and the launch of Qlik Sense Desktop marks the beginning of a new era for Qlik embracers.
A few months ago, I blogged about using Microsoft Analysis Services Tabular Model as a data source for Qlikview. As a practitioner of SQL Server Analysis Services (SSAS) Tabular Model, I was curious to find out if there was a native connector for SSAS in Qlik Sense Desktop.
The following steps describe the process of loading data from SSAS Tabular Model using Qlik Sense Desktop. As a pre-requisite, please ensure you have the necessary OLEDB drivers for SSAS (MSOLAP) installed on your desktop.
Step 1: In the ‘Data Load Editor’, click on ‘Create New Connection‘ and select OLEDB from the list of connections.
Step 2: Select the provider for Analysis Services and enter the connection details to connect to the tabular model. Click Save once done.
Step 3: Once the connection is successfully saved, it appears in the Data Connections pane on the right.
Step 4: Though the metadata can be viewed using the select data option, the OLEDB provider for SSAS cannot programmatically generate DAX queries. To extract data from the Tabular Model connection created in the previous step, DAX queries should be written in the data load editor as below.
The verdict is that there are subtle differences in the interface but there is no native SSAS connector in Qlik Sense desktop yet. There are major enhancements in the visualisation side of things and I’m sure a lot of us will be talking about them in the coming days.
I encountered this unexpected bug while creating multiple partitions for a table in my SSAS Tabular model. While authoring the model in SSDT (Visual Studio 2010), I created two partitions for a given table to split the processing for a large dataset. After entering the query for the second partition, the validation check failed with the error “Object reference not set to an instance”.
There is a Microsoft Connect bug opened for this issue here.
You can also read more about this on the Technet thread here.
I am excited about speaking in my residential city of Sydney for SQL Saturday #224 on 25 May, 2013. I am extending the presentation I did for SQL Saturday #210 in Brisbane last month (Agile BI with SQL Server 2012 and TFS 2012). I am looking forward to seeing my mates from the Sydney BI community.
Please register if you haven’t done already.
The event will be held at:
Epping Boys High School (EBHS),
213 Vimiera Road
Eastwood, NSW, 2122
The schedule for the day is put up here.
I’m speaking at PASS SQL Saturday #210, Brisbane 2013. The event has an impressive line-up of topics and speakers and I am looking forward to be a part of it. I will be presenting on Agile BI with SQL Server 2012.
You can find the event schedule here.
I am sharing this video to demonstrate a simple mobile app that I built for an internal company challenge. This is a mobile app which is powered by force.com and uses most of its platform features. The UI is plain HTML5 with jQMobile.
Mobile app built for SMS Bluesky Challenge 2012