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

Friday, 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

Monday, 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

Monday, 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

Monday, 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

Monday, 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

Report fields not showing correctly in Report Server

Sunday, 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

How to shrink an Excel when connecting to a DB

Tuesday, 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

Sunday, 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

Sunday, 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...
3 comments