Cognitive Information

Business Intelligence Forecasting in SQL and Cognos
Published May 10, 2013 - No Comments
Note: This article is an update of a presentation given when I was at the University of Oklahoma’s Health Sciences Center. At that time, I was using Cognos version 7.3. This article is updated for Cognos 10 and SQL Server Analysis Server 2012. Revisiting this subject ten years late ...
read more
How to fix “Usage Based Optimizer” connection errors in SSAS 2012
Published April 30, 2013 - No Comments
The Usage-Based Optimizer can be a very powerful tool for calculating aggregations, when it works. When it doesn't work perfectly, then it can be frustrating to figure out. The devil is in the details. If you move data between environment, then you have even more details to find and fix.
read more
START by Jon Acuff
Published April 19, 2013 - No Comments
The best surprise of the day was the hour by Jon Acuff about his new book START, Punch Fear in the Face, Escape Average and Do Work that Matters. For about an hour Jon talked about the phases we go through in business.
read more

SSIS 2012 Parameters vs. Configurations

Published 12/10/2012 at 9:05 pm - No Comments

In this session, SQL Santa (Allen) will review configurations in SQL 2008R2. These options allowed dynamic configuration across environments. Next, we look at SSIS 2012 and the new dynamic options, including Parameters, Expressions and Variables. IWEBIX Webdesign

Measuring BI ROI begins with Business Analysts

Published 07/18/2012 at 5:51 pm - No Comments

Calculating ‘Payback Period’ or ‘Return on Investment’ (ROI) on business intelligence projects requires information at every project stage. On a recent project expansion required my team to provide information about cost savings for the project. This process was important not just for project approval, but also for validation after the project was built. If business [...]

Latest Articles

Latest Articles from the Blog

Business Intelligence Forecasting in SQL and CognosPublished 05/10/2013 at 2:46 pm
How to fix “Usage Based Optimizer” connection errors in SSAS 2012Published 04/30/2013 at 7:39 am
START by Jon AcuffPublished 04/19/2013 at 5:28 pm
Taking Flight!Published 04/10/2013 at 11:11 pm
Getting SQL data into SharePointPublished 04/10/2013 at 3:16 pm
SSIS 2012 Parameters vs. ConfigurationsPublished 12/10/2012 at 9:05 pm
What’s New in SQL Server Reporting Services (SSRS) 2012Published 12/04/2012 at 9:45 am
Syncronize Reports across SSRS ServersPublished 08/28/2012 at 9:43 am

Business Intelligence & Data Warehouse Consulting

Business Intelligence Forecasting in SQL and Cognos