Report fields not showing correctly in Report Server

December 8, 2013

I’ve created a report quite a while back ago in SSRS for my client and deployed it to the report server. He used the report regularly (and I should know as much because I got requests for changes). Suddenly one day he sends me an email with a screen shot of the report with one of the fields showing a complete blank. I couldn’t understand why. I looked the report up in BIDS and the fields showed correctly. Looking at report on the server still showed me the field as blank. I was completely baffled. I decided to delete...
no comments

SQL Server 2014 Release Date

We’ve had a lecture the previous week with Mr. Roy Pasternak and Mr. Ofer Daliot from Microsoft Israel about the upcoming features for BI in SQL Server 2014 along with SharePoint 2013. One of the things Mr. Pasternak mentioned in his lecture was that SQL Server 2014 is suppose to be released on January 2014. Now I know there was already an SQL Server 2014 CTP2 but I’m used to having a release candidate (RC1) before the actual RTM. Still Mr. Daliot had also confirmed will be in the coming January so I guess that’s it.Mr. Pasternak had also...
no comments

It’s a new address for the Blog!

November 16, 2013

Hi everybody! Microsoft is migrating our platform to Wordpress and so the blog will have a new address! This means that you'll be visiting me and the blog at: Ella Maschiach's BI Blog Unfortunately enough, this also means that your feedburner account will no longer work.The new RSS account is: Please stay in touch with us!
no comments

How to shrink an Excel when connecting to a DB

November 12, 2013

A colleague in the IT department wanted to send his clients a report in Excel which was actually a pivot table on data from their DWH. He created the file easily enough. He defined on the Data tab in Excel a connection from SQL Server. He chose to connect to a specific table in the relevant DB. He could then edit the connection he created through the Data tab > connections > choosing the relevant connection and then properties and then edit the query on the Definition tab, through the Command Text box.   ...
no comments

SQL Server 2014 CTP2 Released

October 20, 2013

Last week, during his keynote session at PASS 2013, Mr. Quentin Clark announced the release of SQL Server 2014 CTP2. No new features were discussed which weren't mentioned in SQL Server 2014 CTP1, but it was definitely a more detailed show of power of Hekaton (in – memory OLTP) and the development towards the work in the cloud. Apart from watching the keynote, you can read the article about SQL Server 2014 CTP2 from the SQL Server Team and obviously – download it!
no comments

Tableau Public

August 11, 2013

I have recently been added to a team in the Municipality which is in charge of International relation with IT departments in other countries. The main goal is to hear what they did and talk about what we did, so we might exchange ideas and get some insight. The first Municipality I got to talk to was that of Firenze, and they mentioned mostly open source tools they were using. One of the main tools was Tableau Public. Now I’ve heard of Tableau before, but I only knew of their “regular” product which you need to pay for...

Excel 2013 GeoFlow \ Power Map – Pros and Cons

July 30, 2013

I finally got my hands on Excel 2013 and added to it Power Map (though if to be quite frank with you, it was still called GeoFlow when I did it). I admit I was very enthusiastic after seeing the post on the Excel blog. I would first have to say that visualization is RICH. It is every bit as exciting and beautiful as it looks in the different posts given about it. Seeing things evolve on the map over time really does make a whole lot of sense. You suddenly see  things. And yet,...

SQL Server 2014 CTP1 is coming

June 9, 2013

Just in case you haven't heard yet, SQL Server 2014 is already in the works. Release cycle for SQL Server has become one of 2 years lately and not 3 (SQL Server 2008, 2008 R2 and 2012) and this is no exception. SQL Server 2014 was first discussed in the last TechEd with a few sessions taking an overview of its main features:Hekaton - in memory built into the SQL Server engine for OLTP and data warehousing. Hekaton was already previewed in a few sessions in TechEd, mostly talking about the advantages it brings to OLTP.More accessibility to the cloud...

Problem Connecting from Panorama to PowerPivot

May 19, 2013

We installed Panorama Nova View Flash 6.2.5 and wanted to use it to connect to PowerPivot. While beginning the work, we couldn't connect to the PowerPivot files and would get an error message. My colleague Tomer Horev was in charge of SharePoint installation and also found the following solution. We understood what the problem was through the help of Panorama support. We tried to connect to the cube that's created for our PowerPivot file through the Management Studio. That meant connecting to the SSAS DB with the name of: http://servername/foldername/filename.xlsx ...