Connect from SSRS 2008 R2 to Hadoop

February 16, 2015

A colleague of mine from another company had contacted me. He needed to connect from SSRS 2008 R2 to Hadoop in a version of Cloudera 5.2. Now I admit that working in the municipality I don't have any experience yet in working with the cloud, so it's hard giving advice without personal experience... So, I asked Google how to connect from SSRS 2008 R2 to Hadoop and got an answer from Microsoft that was actually sending me to look elsewhere: "The Microsoft SQL Server SQOOP Connector for Hadoop is now part of Apache SQOOP 1.4 and we are not providing a...
no comments

Report Builder in SQL Server 2014

February 9, 2015

If you've been reading this blog over time, you probably noticed quite a bit of my development was done with Report Builder. Yes, that's the report model shipped with SQL Server 2005. Though my team is currently working on SQL Server 2008 R2, we're only now starting to develop BI solutions with other tools. We're set for a bit of a headache with our Report Builder 1.0 in SQL Server 2014. Report Model has been one of a set of deprecated features on SQL Server 2012 (and obviously also on SQL Server 2014). SQL Server has released PowerView in SQL Server...

Different steps in BI projects

June 16, 2014

A project I just did for the municipality’s Sanitation Department made us rethink the different steps in BI projects in our team. Up till now, we would first have meetings with the customer and the operational system developer to learn what the client wants and what are the corresponding tables in the system.  We would then sit and write two documents – one for the customer detailing what we’re about to give him, and one for the BI developer detailing which tables should be extracted and how they should be manipulated. The client would have to wait two months (at...
no comments

Project Passau

June 13, 2014

We just had a Microsoft consultant come in and show us the latest innovation in SQL Server 2014 with Office 365. Though I saw most of it in demos given before, it was still stunning to see the abilities of Office 365 with SQL Server 2014. There was something new to see this time regarding Data Mining and Predictive Analytics in the cloud. This is the first time I saw Project Passau which demonstrated amazing abilities for easily predicting future trends. Microsoft has been offering Data Mining in various ways: through numerous versions of the Data Mining add in...
no comments

Imitating QlickView through Excel 2010

May 9, 2014

I have recently started a new project for the Sanitation department in the municipality. The Local Recycling and transfer station where the sanitation truck go to dump trash or recycle has a report system that is a QlickView over their operational system. Their power user saw reports being generated by QlickView and offered we see them as well. We showed him earlier what we can do with Panorama Nova View and SSRS but he didn’t buy it. Having seen what QlickView did for the recycling center, I can see why. Though we didn’t have QlickView to offer him as...
no comments

A user can’t see Panorama view on a new cube

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....
no comments

Errors in the OLAP Storage Engine for a large dimension

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'...
no comments

Preview SharePoint List Structure

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...
no comments

Referencing calculations in different parts of your report

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...
tags: ,
no comments

How to define a Smart City

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 NYC...
no comments