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