Monthly Archives: May 2011

Game theory and Business Intelligence, no really

I followed a recent tweet from our Professional Services Manager recently linking to a blog here on game theory as it relates to social media activities.  It resonated with me immediately from a business perspective.

The synopsis of the blog (and I’m not doing it justice) is that the like of Twitter, World of Warcraft, Farmville etc are poster children for the practical application of Game Theory. … Continue reading

CALUMO for TM1 10.6 Release – TM1 9.5.2 and Office 2010 Support

CALUMO for TM1, the fastest web client for IBM Cognos TM1 has just been updated to version 10.6 has been released and available here.

Web ad-hoc browsing if faster, reports published from the web zoom so fast you sometime have to double check it updated! Here is the list of issues and features worked on.

Key
Summary

CALUMOTMI-205
Titles Dimension area hidden… Continue reading

IBM Cognos TM1 9.5.2 Release

IBM Cognos TM1 9.5.2 has been released.

The big, HUGE benefit of this release is it supports Microsoft Excel 2010. 

Microsoft Excel 2010 was released on April 15 2010 so we are very happy to have see IBM come to the party. 

If you want more information about IBM Cognos TM1 9.5.2, please email me wleitch@calumo.com.… Continue reading

Returning member properties of a dimension attribute

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:
.Properties
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.
http://sqlblog.com/blogs/mosha/archi…ices-2005.aspx

Best BI REPORTING Tool – BI is a tool

I couldn’t help but notice this thread.  Who couldn’t if you’re in the Business Intelligence Professionals group on LinkedIn. It is 9 months old and has over 600 comments. I have read all of the posts and it is fascinating!

The most interesting piece of information I found from peoples comments is BI is a tool.

I have implemented a little over 100 BI projects over the… Continue reading

BI In Education – University of NSW

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

BI in Education – Macquarie University

Second in the trilogy of End User stories in Education, here is a short history of Business Intelligence in action at Macquarie University.

Faced with an issue of 25,000 lines of SQL script to generate information for users – it was unmaintainable and unreliable.  CALUMO were engaged through winning a tender process to provide integrated Reporting.

The CALUMO solution, referred to as ForeSight provides financial and HR information… Continue reading

BI in Education – University of Canberra

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

Dynamic Security in SQL Server Analysis Services

I was talking to Steven Gibbs from UNSW the other day and he told me how he improved query time for users from a cold cache by a factor of 10. UNSW redesigned some cubes so they can use attribute hierarchies (moving away from parent child hierarchies). Everything is running smoothly until he came to incorporate dynamic security.  As Steve told me “it all goes pear-shaped”.

To understand the issue… Continue reading