Category Archives: Uncategorized

How to Work With Dates in Cognos Insight

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 … Continue reading

Posted in Analytics, Business, Business Analytics, Business Intelligence, Cognos, Data Integration, IBM, OLAP, Reporting, Uncategorized | Tagged , , , , | Comments Off on How to Work With Dates in Cognos Insight

Joining Columns In Cognos Insight

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 … Continue reading

Posted in Business Intelligence, Cognos, IBM, MySQL, OLAP, Uncategorized | Tagged , , | Comments Off on Joining Columns In Cognos Insight

Raising the Bar with Mobile BI

(Enjoy a sneak peak of some dashboard screenshots as you read) In recent years, mobile device sales have outshined those of personal computers. One survey reported that 95 percent of employees purchased a mobile device with the intent to use … Continue reading

Posted in Business, Business Analytics, Business Intelligence, Productivity, Uncategorized | Tagged | Comments Off on Raising the Bar with Mobile BI

Changing Pentaho’s Default Email Server to a Gmail Account

Since we use gmail for our company email, we found it to be a bit trickier to enter the information through Enterprise Console unless you update your password.  To get around this, we edited the server\biserver-ee\pentaho-solutions\system\smtp-email\email_config.xml file as shown below.  … Continue reading

Posted in Uncategorized | Comments Off on Changing Pentaho’s Default Email Server to a Gmail Account

Installing and configuring phpCAS

Since CAS is capable of integrating applications made in many different languages, you may want to take the time to get everything you can authenticating through it.  Every different language needs a separate client though, which needs to be installed … Continue reading

Posted in Uncategorized | Tagged , | Comments Off on Installing and configuring phpCAS

PowerPivot and Production Processes

I am a strong advocate of Microsoft Excel and PowerPivot for the analysis and organization of information.  While it may seem odd to many, Microsoft should be applauded for the newest release of Excel and, in particular, the free add-on … Continue reading

Posted in Uncategorized | Comments Off on PowerPivot and Production Processes