Category Archives: Business Intelligence

Cube Status – a new open source project for BI in SharePoint

I have released my Cube Status project (http://cubestatus.codeplex.com) to http://www.codeplex.com.

cubestatusscreenshot

This web part for SharePoint provides the possibility to visualize both the current status of a SQL Server Analysis Services (SSAS) cube or tabular model (BISM) and some of its metadata.

This web part can be used in BI portal type pages in SharePoint to show the current status of a cube used for reports and analysis. This means that there is no need to guess the update status or last process time etc. of a cube.

Both the source code and a .wsp solution file for deployment are available for download from the project page: http://cubestatus.codeplex.com

This project is described in more detail here

This project also works quite well together with the SQL Server Agent Job Status project found at http://jobstatus.codeplex.com and with more details here

Please, feel free to suggest updates and new features etc. either here on the blog or on CodePlex.

Update to Create Time Dimension App

This entry is part 2 of 3 in the series Create Time Dimension

I have published an update to the Create Time Dimension Application for Excel that includes a new Date Integer Id column (in the format 20130616 for June 16, 2013) and Dutch language support.

The update is made on the server so it is available for everyone right away, no update needed on the Excel/Client side.

Big thanks to Frederik Vandeputte (Web: http://www.vandeputte.org/ Twitter: https://twitter.com/frederikvdp) for suggesting the id column and helping with the Dutch translations.

ctd-dutch-ui

 

Screenshot: Updated app UI with the Dutch language choice

SharePoint 2013 and Office 2013 launch seminar at Microsoft

On May 17th (2013) we held a very successful seminar as part of the launch and roll out of the SharePoint 2013 and Office 2013 family. The event took place at Microsoft Sweden’s newly renovated office just north of Stockholm.

StefanAtMicrosoftSeminar17thMay2013

Photo by Björn Nylander

The event focused on the new capabilities for BI in SharePoint 2013, SQL Server 2012 and Office 2013 and looked at the possibilities of the platform from a strategic ROI point of view.

geoflow_demo

 

GeoFlow demo

The main part of the seminar was my presentation and demonstration of the Solver BI Framework that enables BI in SharePoint 2013 to live in a structured platform with plenty of information about report and system status, integrated news and much more. We also showcased the new GeoFlow 3D data visualization (download here) features of Excel 2013 that was very well received.

powerview_demo

 

Power View demo

More information on the Microsoft Business Intelligence start page here: http://www.microsoft.com/en-us/bi/default.aspx

If you are interested in the materials from the seminar or if you would like to see the seminar contents or demonstration, please contact me.

Unable to create folder in SharePoint 2013 library

1-aspx_debug_error

This error, “Sorry, something went wrong. The aspx_debug attribute on the page directive is not allowed in this page” occurs when trying to create a folder in some types of document libraries, such as the Report Document Library used for SQL Server Reporting Services report documents in SharePoint 2013.

The error comes from some bad /Upload.aspx files that are used by SharePoint 2013.

identifying the upload file for a Report Document Library gives us this standard file path:

C:\Program Files\Common Files\microsoft shared\Web Server Extensions\15\TEMPLATE\FEATURES\ReportsAndDataListTemplates\ReportDocumentLibrary\Upload.aspx

The standard contents:

3-upload_aspxfile

By updating the contents with something that makes more sense we can get the folder creation feature to work again:

workingfilecontents

Do note that all page directives needs to go, and we need to update the UIVersion property from 15 to 4 otherwise we just get new exciting errors.

Continue reading

Lönar sig en investering i Business Intelligence?

Den 17de maj pratar jag om och demonstrerar verksamhetsnyttan i en investering i Microsofts BI plattform under ett seminarie på Microsoft.

In English: On May 17th I will present and demonstrate the business value of an investment in the Microsoft BI platform.

Mer information på Solvers hemsida: http://sj.la/12JLaiH

Mer information på Microsofts CloudFacts-sida: http://sj.la/YTDYfG

Mer information:

Solver demonstrerar verksamhetsnyttig BI med Microsoft Office 2013 och Sharepoint 2013

Fråga: Hur får min personal tillgång till och möjlighet att förstå och analysera både företagets och sina personliga nyckeltal (KPI)
Svar: – Vi visar effektiva sätt att få tillgång till och analysera de viktigaste nyckeltalen genom intranätets BI-portal

Fråga: Som ansvarig för IT har jag tillstyrkt stora investeringar i avtal med Microsoft, hur drar jag nytta av dessa?
Svar: – Vi visar upp olika exempel hur dessa investeringar kan utvecklas till en verksamhetsanpassad informations- och BI-lösning med standardprodukter från Microsoft

Agenda:
– Kort om Solver
– Microsoft BI, en översikt
– Demonstrationer

Seminarieinformation
När? – Fredagen den 17 maj 8.00 – 10.00 (registrering och kaffe 08.00 – 08.30)
Var? – Microsoft, Finlandsgatan 36, Kista
Anmälan? – Maila din anmälan till bjorn.nylander@solver.se eller ring Björn Nylander på 08-24 88 00 för att boka ditt deltagande. O.S.A senast 10 maj. Seminariet är kostnadsfritt men begränsat till 40 deltagare.
Välkommen!