March 28, 2014
We had a book in Panorama NovaView which we had made about a year ago. The book had views that were all based on the same PowerPivot cube which was published to a SharePoint Server (so it was recognized as cube by the viewer). So, a year had passed and we needed to add to our book new views which would be based on a new PowerPivot cube. The data in both cubes was about workers in different units and the authorizations on the cubes were given so that every manger would see just the workers in his units....
March 3, 2014
A colleague of mine was working on a cube. The cube had a fact table that was also a dimension. It had 18 million rows of data. When my colleague tried to process the cube with that fact and dimension, he couldn’t. Both the full and the incremental process didn’t work. He got an error on processing the large dimension with a message of:
Exception calling "Process" with "1" argument(s): "File system error: A FileStore error from WriteFile occurred. Physical file: . Logical file: . .
Errors in the OLAP storage engine: An error occurred while the 'RN' attribute of the 'YYYYY'...
February 3, 2014
We’re starting a new project where we're collecting data, amongst others, from SharePoint lists from the Municipality’s site. Though the SharePoint developers recommended we import data through a web service, we found that SSIS has a component for SharePoint as a data source. We started off by downloading and installing the SSIS component for a SharePoint List Source from CodePlex as it does not come with the SSIS itself. We added the component to our SSIS through the Tools menu > Choose toolbox items and then chose the relevant components:
I needed to predefine for our DBA the tables we...
January 13, 2014
I’ve recently found something new to use in SSRS. Yes, 7 years of usage and I found something that was completely new to me. And then I discovered it existed since SSRS 2008 and I just hadn’t used it (oops!). I was a bit hesitant of posting about it, until I also heard a lecture about it in the last BI User Group meeting (and I recommend you go to meetings taking place around your neck of the woods). So now I feel very comfortable in telling you about referencing calculations in different parts of your report through the...
January 6, 2014
In the past few months, we've been hearing in the BI team about Smart Cities. We can define a Smart City (according to Wikipedia) as efficiency based on the intelligent management and integrated ICTs (information and communication technology), and active citizen participation.
The term was initially presented to us through a company offering us a POC of a dashboard in SharePoint. They talked with us on what another city in Israel had monitored and talked with us on what was being done, in a very larger scale in New York:
New York Open Data, APIs and Digital Roadmap
NYC Mayor’s Management Report
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...
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...
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!
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. ...
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!