IBM Cognos Analytics – Conditional Notifications

IBM Cognos Analytics – Conditional Notifications

Bryan Scheck  Business Analytics Specialist  John Daniel Associates, Inc.  Bryan’s Profile Recently I was asked by a client to setup notifications for a daily report output. This is a routine request that can be addressed within the Cognos portal by creating and scheduling a job for the report. The unique challenge presented in my case however was that the client wanted results to be emailed […]

Read Me

How Cognos 10 tasks are performed in Cognos Analytics

How Cognos 10 tasks are performed in Cognos Analytics

Erin Dunmire Practice Director, Business Intelligence John Daniel Associates, Inc. Erin’s Profile This blog post covers some common tasks in Cognos 10 and details how they can be performed in Cognos Analytics. Access content Cognos 10 – The Public Folders tab provides access to shared content. The My Folders tab provides access to personal content. Cognos Analytics – The Team content button on the left-hand […]

Read Me

IBM Cognos Analytics – the Inside Scoop on the R5 Release!

IBM Cognos Analytics – the Inside Scoop on the R5 Release!

Susie Bann Business Analytics Specialist John Daniel Associates, Inc. Susie’s Profile After attending the World of Watson in Las Vegas at the end of October, here are a few of the highlights that can be anticipated in the IBM Cognos Analytics R5 release at the beginning of December. As you may or may not know, the upgrade from IBM Cognos BI to Cognos Analytics will […]

Read Me

Make Report Maintenance Easier by Implementing these BI Development Strategies

Bryan Scheck Business Analytics Specialist John Daniel Associates, Inc. Bryan’s Profile To “Get it done” and to “Get it done well” are two entirely different things.  Both have merit and are appropriate under specific conditions.  A mission critical output under a strict deadline must be prioritized to “get it done” to meet the objective.  Often this approach has delayed consequences that the urgency of the […]

Read Me

How to Create a List Report in Cognos Analytics

How to Create a List Report in Cognos Analytics

David Sakal Business Intelligence Specialist, IBM Cognos John Daniel Associates, Inc. It has arrived – IBM announced the release of Cognos Analytics V11, now available! The new features in this release support three main themes: an updated user experience, data discovery, and self-service BI. The new features in Cognos Analytics are aimed at competing products, like Qlik and Tableau, which have strong visualizations and an […]

Read Me

Configure Multiple Reports in One Report Specification

Configure Multiple Reports in One Report Specification

Erin Dunmire Practice Director, Business Intelligence John Daniel Associates, Inc. Erin’s Profile One report specification can contain different views of your data, essentially rendering different reports. But why would it make sense to set up one report spec to do this, you ask? This makes sense when the queries behind the pages share a lot of content, and it’s easiest to maintain that content in […]

Read Me

Relative Time Prompt Token Macro Technique

Relative Time Prompt Token Macro Technique

Alicia Scappe Business Analytics Specialist John Daniel Associates, Inc.  Alicia’s Profile Prompt token macros are used to pass the definition of a data item rather than a value. They are very efficient and useful for both relational and dimensional data sources and prove to be a friendly administrative and end user experience. You can use the relative time token for scheduling purposes as well as […]

Read Me

Manage Framework Manager Model Changes

Manage Framework Manager Model Changes

Bryan Scheck Business Analytics Specialist, Project Management, Reporting John Daniel Associates, Inc.  Bryan’s Profile Managing change is difficult in any aspect of life, whether changing jobs, moving cities or simply adapting to the fact that Panera has done away with your favorite Cuban Chicken Panini (bummer, right?). Addressing changes in business critical systems can range from mildly annoying to down right time consuming depending upon […]

Read Me

Use a Variable in a TM1 TI Process SQL Statement to Filter on Input from a User

Use a Variable in a TM1 TI Process SQL Statement to Filter on Input from a User

Erin Dunmire Business Analytics Specialist John Daniel Associates, Inc. Erin’s Profile Variables can be used in a variety of ways in Turbo Integrator processes. The use of variables can increase efficiency by making the administration of your TM1 model easier. Variables can also play a role in providing an end-user with the ability to perform administrative tasks similar to typical user input. Many times SQL […]

Read Me

TM1 Best Practices: The Power of Using Global Parameter Flags

TM1 Best Practices:  The Power of Using Global Parameter Flags

Alicia Scappe Business Analytics Specialist John Daniel Associates, Inc. Alicia’s Profile TM1 is a completely customizable solution for budgeting and forecasting. It is extremely robust and flexible, but with that comes complexity. Two of the biggest challenges my customers face are the amount of time it takes to prepare their budgets and forecasts, especially if they are responsible for rolling monthly forecasts, and how difficult […]

Read Me Leave comment

The Date Dimension – A MUST HAVE in all Reporting Environments

The Date Dimension – A MUST HAVE in all Reporting Environments

Bryan Townsend Business Analytics Specialist – Data Warehousing, Modeling John Daniel Associates, Inc. Bryan’s Profile As a report developer, how many times have you been stuck creating reports in a Business Intelligence environment without a date dimension? If your answer is only once, I can tell you from experience that even once is too many times. If you are consistently in that situation, then you […]

Read Me Leave comment

A Report Developer’s Guide to Sanity

A Report Developer’s Guide to Sanity

Bryan Scheck Business Analytics Specialist John Daniel Associates, Inc. Bryan’s Profile IBM Cognos Report Studio is a tremendously flexible and useful application for querying and presenting data in a multitude of forms. From crosstabs to graphs, details or summaries, sales reporting to financial statutory reporting, Report Studio is both powerful and versatile. Due to its expansive feature set and extensibility, every report developer will have […]

Read Me Leave comment