Skip to Main Content
IBM Data and AI Ideas Portal for Customers


This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).


Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:


Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,


Post your ideas

Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

IBM Employees should enter Ideas at https://ideas.ibm.com


Status Not under consideration
Workspace Cognos Analytics
Components Cognos Cloud
Created by Guest
Created on Nov 18, 2021

Add Google BiqQuery Functions to Cognos Analytics

Hi IBM,

We are using Google BigQuery as one of the database sources to connect to Cognos Analytics on Cloud and using the packages to build reports and dashboards.

Currently, we have to manually type in the Google BigQuery functions in the Model, reports and it is impacting the performance of the reports because of query decomposition, local processing and possible performance issues.

If the functions are added to Cognos as a built-in function set then it is improve the performance of the reports which are using Google BigQuery datasources.

Please review this request to add the Google BigQuery as the vendor specific function set in IBM Cognos Analytics 11.0.13

Needed By Month
  • Guest
    Reply
    |
    Oct 14, 2022

    You can use any vendor function that returns data to Cognos in a data type that Cognos supports, even if it does not appear in the list of vendor specific functions in the expression editor UI.

  • Guest
    Reply
    |
    Oct 14, 2022

    Hi - we do support Google BigQuery functions today. If you are getting query decomposition and local processing (even after upgrading to a version of 11.1.4 or later) it would be helpful to diagnose if there are other reasons contributing to this.

  • Guest
    Reply
    |
    Feb 25, 2022

    Useful reply from Guest.

  • Guest
    Reply
    |
    Nov 25, 2021

    It is recommended to be using versions >= CA 11.1.4 when using Google Biguery.

    Those releases were updated to reflect improvements Google made to Bigquery. Older CA releases, such as 11.0.13 would not contain reflect those changes, which can result in decomposition where compensation was necessary at that time.

    Many of the built-in functions and aggregates in Cognos Analytics automatically are generated in SQL constructs passed to Bigquery etc.