BEWARE: Here there be dragons!
In the world of Microsoft BI, one of the more painful configuration tasks is to get double-hop authentication working so that you can run SQL Server Analysis Services on a separate machine to your application/web server.
There is a very detailed article from Microsoft on what you need to do and how to configure your environment to allow for double-hop authentication… Continue reading
I was talking Paul Cavanagh-Downs, one of CALUMO’s awesome consulting team today. He showed me a web based CALUMO report he built in CALUMO that took about 1 second to display aggregated data. Paul changed the date, and some of the other 11 hierarchy members and the report still displayed in 1 second but with new data this time.
I say “Yeah, that’s pretty good. It looks nice too.”… Continue reading
We have just been implementing the ability for a user to use a CMEMBER with non-intrinsic properties in Microsoft SQL Server Analysis Services and found the following:
Use of .Properties should be avoided as much as possible. Filtering by member properties should be rewritten by using CrossJoin (or Exists). Lookups should be rewritten by using related attributes and .MemberValue. There are very few reasons to use .Properties.
First of trilogy of End User case studies, here is a short and potted history of deiverables at University of NSW.
CALUMO was invited by UNSW to assist them in reducing overheads and costs of their budgeting and reporting system.
Utilizing their existing technology and adding the CALUMO application layer, UNSW was able to provide effective management reporting across the University as well as a budget interface for… Continue reading
Third in a trilogy of End User stories in Education, here is a short history of Business Intelligence in action at University of Canberra.
With a multitude of spreadsheets and endless hours required to produce budgets and management reporting, University of Canberra went to market looking for a solution.
In a competitive process, CALUMO was selected to deliver management reporting, budgeting and forecasting. Once the University saw the… Continue reading
CALUMO Skylights open up a whole new way of integrating web content within Microsoft PowerPoint 2010 and Microsoft Word 2010 (and 2007). When combined with CALUMO reports, Skylights unite the power of corporate reporting with the presentation power of PowerPoint and printability or Word. Each Skylight acts as a window onto a report which can be presented or interacted with real time.
Here is a great example of how Dominic… Continue reading
I was busy modifying CALUMO’s data warehouse today. There was an existing field in a table in SQL Server that I need to make much larger. I changed the table then tried to process the SQL Server Analysis Services (SSAS) cube when I had this error:
Errors in the back-end database access module. The size specified for a binding was too small, resulting in one or more column values being… Continue reading