2 באוגוסט 2012
I read a very interesting book called "The Numerati" by Stephan Baker (in Hebrew "אשפי המספרים"). The book describes some of the real-world implementation ofBig Data. I enjoyed reading it and found it very interesting. Link to Amazon: http://www.amazon.com/The-Numerati-Stephen-Baker/dp/0618784608Link to the blog: http://thenumerati.net/I also saw recently a very interesting lecture at TED about the information collected by the cellular company and how much can they tellabout you (and me) just because they know where exactly you are every day andnight. Where is your home, how long you travel to work, how often you go tomovies and how much time...
1 באוגוסט 2012
I hope you're enjoying the summer. Those of you who are in Israel on Aug 29th (the last Wed of the month, as usual) are welcome to join us at another very interesting BI User Group Session.
This time Ronen will talk about Excel 2013, focusing on its new BI capabilities and how can you do more with Excel.
Please register here: http://biug32.eventbrite.com/
See you all
18 באפריל 2012
What are you waiting for?
9 באפריל 2012
I know this is a blog mainly about MS products. But recently I had to use MicroStrategy ( http://www.microstrategy.com/ ) at some of my customers. Apparently MicroStrategy offers full BI platform with many impressive capabilities.
The way I see it, Microsoft and MicroStrategy don't really compete. I love the SQL Server Relational engine, SSIS for ETL, SSAS or 2012 Tabular and Reporting Services. But, when a customer wants to query the SQL Server directly, well, in this case sometimes the SSRS is just not good enough.
Unfortunately, even the new PowerVIew is not a good answer. It requires installation...
Exam 71-461: Querying Microsoft SQL Server 2012
Exam 71-462: Administering Microsoft SQL Server 2012 Databases
Exam 71-463: Implementing a Data Warehouse with Microsoft SQL Server 2012
Exam 71-464: Developing Microsoft SQL Server 2012 Databases
Exam 71-465: Designing Database Solutions for Microsoft SQL Server 2012
Exam 71-466: Implementing Data Models and Reports with Microsoft SQL Server 2012
Exam 71-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012
For information about the certification paths, visit the SQL Server certification page.
2 באפריל 2012
As you know, while running a query which counts dimension members the Management Studio do not return how many rows were returned. (for ex. select * from AW.. where Color = ‘Red’ )
To solve this problem you can write a query like this:
WIth MEMBER aas
SELECT a on 0
WITH MEMBER aas
SELECT a on 0
Last weekend I was in London at SQLBits X. I lectured about SSAS 2012 Tabular Mode.
Tabular models are in-memory databases in Analysis Services which delivers fast access to tabular model objects and data by reporting client applications.In this session we'll understand the best practices of using this new technology. What exactly is it good for? When to use it and when NOT to? Does it replaces the good old MOLAP or should only be used on special scenarios?How to migrate my MOLAP cubes and applications to Tabular Mode?Security, administration other best practices if time permits.The session is based...
24 בפברואר 2012
Sometimes the result of a query depends on a parameter in a configuration file. Today, for example, I needed to write an SSRS report with a URL to another IIS. The dynamically generated URL should look like this http://devserver/folder1?CampainID=123 or http://prodserver/folder2?CampaignID=123 . The destination server name (DevServer or ProdServer) saved in an XML configuration file.
The XML file:
<?xml version="1.0" ?>
Obviously I could write .NET code in the RDL to retrieve data from the XML file. However, I used a simpler option using TSQL:
SELECT XMLSource.value('(Servers/Name)', 'VARCHAR(50)') as servername
cast(bulkcolumn as XML) as...
11 בפברואר 2012
While Analyzing cube (performances or data accuracy) I run many MDX queries. It is important to know whether the Measures in the query are calculated and if so, what is the MDX expression of the calculated measure.
Option one - open Management Studio (import the cube schema, if you can't find the source code) and look at the Calculation Tab.
A simpler option: run the following query
SELECT Measure_name, expression, Measuregroup_name, * FROM $system.mdschema_measures--where Measure_name = 'Growth in Customer Base'ORDER BY Measure_name
The SQL 2012 BOL now contains valuable information about DMV. Finally.
4 בפברואר 2012
The Problem: I needed to write a query using non unique member name. For ex. there are few cities called "Berlin". While using the name only one record retured.