Dealing with dates in Cognos can sometimes be a daunting task. Dates should be straightforward, but sometimes they take extra work to get what you want. Your data is designed to list the date of the transaction, but maybe you only care about data on a per week, per month, or per quarter basis. Obviously, […]
One of the benefits of Cognos insight is the ability to combine columns during the import process. This can help us when browsing the data through explore points. It is often beneficial to combine columns as it is easier to read, and not always necessary to sort by columns individually.
Anyone who has ever actually attempted it may have noticed that Pentaho Report Designer does not natively accept XMLA as a datasource. It is still possible, and this little guide will step you through how to do this. We used MSSQL 2008R2 with the standard Adventure Works example data loaded. We used the Pentaho BI […]
Overview This document shows how an Open Source Database like MySQL can be used with Microsoft’s popular Excel plugin PoweverPivot. Many clients enjoy the familiarity of Excel and ease of use that PowerPivot brings but the clients do not want to married with any one particular vendor in their Business Intelligence process. Consumers should have […]