Cognos Analytics

Hello.
When I create a custom table (view) from a fact and dimension table needing to conduct an evaluation for a new fact table, I can no longer do a DISTINCT COUNT on ids if I join the new fact table back to my dimensions for report writing. 
error:
XQE-PLN-0385 Count distinct is not supported for queries that span multiple sources.

This worked fine in 11.1.5.

The query plan must have changed or the process.  How do I update or correct this?
Thanks.

------------------------------
Tom Rosenow
------------------------------

#CognosAnalyticswithWatson

Update, All field aggregation types work but Count Distinct if you use a Custom Table.

------------------------------
Tom Rosenow
------------------------------

Original Message:
Sent: Wed May 06, 2020 07:06 PM
From: Tom Rosenow
Subject: CA 11.1.6 Data Modules Custom Table unable to do a distinct count

Hello.
When I create a custom table (view) from a fact and dimension table needing to conduct an evaluation for a new fact table, I can no longer do a DISTINCT COUNT on ids if I join the new fact table back to my dimensions for report writing. 
error:
XQE-PLN-0385 Count distinct is not supported for queries that span multiple sources.

This worked fine in 11.1.5.

The query plan must have changed or the process.  How do I update or correct this?
Thanks.

------------------------------
Tom Rosenow
------------------------------

#CognosAnalyticswithWatson

I'm also having the same issue. Did you get this resolved in the end?

------------------------------
Duncan Stevens
------------------------------

Original Message:
Sent: Wed May 06, 2020 07:06 PM
From: Tom Rosenow
Subject: CA 11.1.6 Data Modules Custom Table unable to do a distinct count

Hello.
When I create a custom table (view) from a fact and dimension table needing to conduct an evaluation for a new fact table, I can no longer do a DISTINCT COUNT on ids if I join the new fact table back to my dimensions for report writing. 
error:
XQE-PLN-0385 Count distinct is not supported for queries that span multiple sources.

This worked fine in 11.1.5.

The query plan must have changed or the process.  How do I update or correct this?
Thanks.

------------------------------
Tom Rosenow
------------------------------

#CognosAnalyticswithWatson

​I have the same issue with SQL Tables created on 11.1.5 and installed the interim fix for 11.1.5 for it and stopped working my count distinct

------------------------------
Kleber Vieira
------------------------------

Original Message:
Sent: Wed May 06, 2020 07:06 PM
From: Tom Rosenow
Subject: CA 11.1.6 Data Modules Custom Table unable to do a distinct count

Hello.
When I create a custom table (view) from a fact and dimension table needing to conduct an evaluation for a new fact table, I can no longer do a DISTINCT COUNT on ids if I join the new fact table back to my dimensions for report writing. 
error:
XQE-PLN-0385 Count distinct is not supported for queries that span multiple sources.

This worked fine in 11.1.5.

The query plan must have changed or the process.  How do I update or correct this?
Thanks.

------------------------------
Tom Rosenow
------------------------------

#CognosAnalyticswithWatson

​I am having the same issue with SQL tables on data module.
Installed the interim fix for this version due to an audit table problem and ended up having this one now.
have recently deployed a nice dashboard containing this count information. however, can't move forward with the interim fix that resolve my audit issue and created another one.

------------------------------
Kleber Vieira
------------------------------

Original Message:
Sent: Wed May 06, 2020 07:06 PM
From: Tom Rosenow
Subject: CA 11.1.6 Data Modules Custom Table unable to do a distinct count

Hello.
When I create a custom table (view) from a fact and dimension table needing to conduct an evaluation for a new fact table, I can no longer do a DISTINCT COUNT on ids if I join the new fact table back to my dimensions for report writing. 
error:
XQE-PLN-0385 Count distinct is not supported for queries that span multiple sources.

This worked fine in 11.1.5.

The query plan must have changed or the process.  How do I update or correct this?
Thanks.

------------------------------
Tom Rosenow
------------------------------

#CognosAnalyticswithWatson

I have the same issue using sql tables objects within data module. have deployed 11.1.5 last weekend and found that the audit database wasn't been populated properly. Spoke to IBM and it was a bug then, they gave me an interin hot fix for 11.1.5 and fixed the audit issue but found that on my dashboard which the users created on 11.1.5 and promoted to production but now, facing this issue on my test environment, any idea so far how to fix it?​

------------------------------
Kleber Vieira
------------------------------

Original Message:
Sent: Wed May 06, 2020 07:06 PM
From: Tom Rosenow
Subject: CA 11.1.6 Data Modules Custom Table unable to do a distinct count

Hello.
When I create a custom table (view) from a fact and dimension table needing to conduct an evaluation for a new fact table, I can no longer do a DISTINCT COUNT on ids if I join the new fact table back to my dimensions for report writing. 
error:
XQE-PLN-0385 Count distinct is not supported for queries that span multiple sources.

This worked fine in 11.1.5.

The query plan must have changed or the process.  How do I update or correct this?
Thanks.

------------------------------
Tom Rosenow
------------------------------

#CognosAnalyticswithWatson

a have hire_key field which is text  example of a key 4517778-1 where i created a calculation count(distinct(hire_key)).

my situation is not a view, it is SQL table.
any suggestion would be great

------------------------------
Kleber Vieira
------------------------------

Original Message:
Sent: Tue June 02, 2020 03:25 AM
From: Kleber Vieira
Subject: CA 11.1.6 Data Modules Custom Table unable to do a distinct count

I have the same issue using sql tables objects within data module. have deployed 11.1.5 last weekend and found that the audit database wasn't been populated properly. Spoke to IBM and it was a bug then, they gave me an interin hot fix for 11.1.5 and fixed the audit issue but found that on my dashboard which the users created on 11.1.5 and promoted to production but now, facing this issue on my test environment, any idea so far how to fix it?​

------------------------------
Kleber Vieira

Original Message:
Sent: Wed May 06, 2020 07:06 PM
From: Tom Rosenow
Subject: CA 11.1.6 Data Modules Custom Table unable to do a distinct count

Hello.
When I create a custom table (view) from a fact and dimension table needing to conduct an evaluation for a new fact table, I can no longer do a DISTINCT COUNT on ids if I join the new fact table back to my dimensions for report writing. 
error:
XQE-PLN-0385 Count distinct is not supported for queries that span multiple sources.

This worked fine in 11.1.5.

The query plan must have changed or the process.  How do I update or correct this?
Thanks.

------------------------------
Tom Rosenow
------------------------------

#CognosAnalyticswithWatson

creating the count distinct itself is not a problem, the problem is when i join the fact that contain the count calculation to a month columns from my date dimension, that is where the error comes up, whatever the template you use for it, crosstab or graph, the error is the same.


------------------------------
Kleber Vieira
------------------------------

Original Message:
Sent: Tue June 02, 2020 07:34 PM
From: Kleber Vieira
Subject: CA 11.1.6 Data Modules Custom Table unable to do a distinct count

a have hire_key field which is text  example of a key 4517778-1 where i created a calculation count(distinct(hire_key)).

my situation is not a view, it is SQL table.
any suggestion would be great

------------------------------
Kleber Vieira

Original Message:
Sent: Tue June 02, 2020 03:25 AM
From: Kleber Vieira
Subject: CA 11.1.6 Data Modules Custom Table unable to do a distinct count

I have the same issue using sql tables objects within data module. have deployed 11.1.5 last weekend and found that the audit database wasn't been populated properly. Spoke to IBM and it was a bug then, they gave me an interin hot fix for 11.1.5 and fixed the audit issue but found that on my dashboard which the users created on 11.1.5 and promoted to production but now, facing this issue on my test environment, any idea so far how to fix it?​

------------------------------
Kleber Vieira

Original Message:
Sent: Wed May 06, 2020 07:06 PM
From: Tom Rosenow
Subject: CA 11.1.6 Data Modules Custom Table unable to do a distinct count

Hello.
When I create a custom table (view) from a fact and dimension table needing to conduct an evaluation for a new fact table, I can no longer do a DISTINCT COUNT on ids if I join the new fact table back to my dimensions for report writing. 
error:
XQE-PLN-0385 Count distinct is not supported for queries that span multiple sources.

This worked fine in 11.1.5.

The query plan must have changed or the process.  How do I update or correct this?
Thanks.

------------------------------
Tom Rosenow
------------------------------

#CognosAnalyticswithWatson

I've had the same problem​ in 11.1.6, and the only solution I've found was to do the count distinct in the report rather than in the data module.  I haven't tried doing it in a Dashboard calculation to see if I get the same benefit.

What I did was create a query with all the columns I need from the data module, including the column I wish to count.
I then dragged over a new query, and dragged my original query to the right of the new query (thus "feeding" query2 with query1's contents)
I then added all my columns from query1, and adjusted the default aggregate to count distinct on the column I was counting.

That eliminated the error -- I'm guessing because the query optimizer saw the count distinct happening after the subquery joined my disparate sources.

Have you opened a bug report with IBM on the issue?

Rich

------------------------------
Richard Chester
Director of Business Intelligence
LPA Software Solutions
------------------------------

Original Message:
Sent: Tue June 02, 2020 09:32 PM
From: Kleber Vieira
Subject: CA 11.1.6 Data Modules Custom Table unable to do a distinct count

creating the count distinct itself is not a problem, the problem is when i join the fact that contain the count calculation to a month columns from my date dimension, that is where the error comes up, whatever the template you use for it, crosstab or graph, the error is the same.


------------------------------
Kleber Vieira

Original Message:
Sent: Tue June 02, 2020 07:34 PM
From: Kleber Vieira
Subject: CA 11.1.6 Data Modules Custom Table unable to do a distinct count

a have hire_key field which is text  example of a key 4517778-1 where i created a calculation count(distinct(hire_key)).

my situation is not a view, it is SQL table.
any suggestion would be great

------------------------------
Kleber Vieira

Original Message:
Sent: Tue June 02, 2020 03:25 AM
From: Kleber Vieira
Subject: CA 11.1.6 Data Modules Custom Table unable to do a distinct count

I have the same issue using sql tables objects within data module. have deployed 11.1.5 last weekend and found that the audit database wasn't been populated properly. Spoke to IBM and it was a bug then, they gave me an interin hot fix for 11.1.5 and fixed the audit issue but found that on my dashboard which the users created on 11.1.5 and promoted to production but now, facing this issue on my test environment, any idea so far how to fix it?​

------------------------------
Kleber Vieira

Original Message:
Sent: Wed May 06, 2020 07:06 PM
From: Tom Rosenow
Subject: CA 11.1.6 Data Modules Custom Table unable to do a distinct count

Hello.
When I create a custom table (view) from a fact and dimension table needing to conduct an evaluation for a new fact table, I can no longer do a DISTINCT COUNT on ids if I join the new fact table back to my dimensions for report writing. 
error:
XQE-PLN-0385 Count distinct is not supported for queries that span multiple sources.

This worked fine in 11.1.5.

The query plan must have changed or the process.  How do I update or correct this?
Thanks.

------------------------------
Tom Rosenow
------------------------------

#CognosAnalyticswithWatson

Hi,

We are facing the same issue. Could you kindly share if you find any solution for the same.

Count distinct is not supported for queries that span multiple source

------------------------------
Balakrishna Adusumilli
------------------------------

Original Message:
Sent: Tue June 02, 2020 09:32 PM
From: Kleber Vieira
Subject: CA 11.1.6 Data Modules Custom Table unable to do a distinct count

creating the count distinct itself is not a problem, the problem is when i join the fact that contain the count calculation to a month columns from my date dimension, that is where the error comes up, whatever the template you use for it, crosstab or graph, the error is the same.


------------------------------
Kleber Vieira

Original Message:
Sent: Tue June 02, 2020 07:34 PM
From: Kleber Vieira
Subject: CA 11.1.6 Data Modules Custom Table unable to do a distinct count

a have hire_key field which is text  example of a key 4517778-1 where i created a calculation count(distinct(hire_key)).

my situation is not a view, it is SQL table.
any suggestion would be great

------------------------------
Kleber Vieira

Original Message:
Sent: Tue June 02, 2020 03:25 AM
From: Kleber Vieira
Subject: CA 11.1.6 Data Modules Custom Table unable to do a distinct count

I have the same issue using sql tables objects within data module. have deployed 11.1.5 last weekend and found that the audit database wasn't been populated properly. Spoke to IBM and it was a bug then, they gave me an interin hot fix for 11.1.5 and fixed the audit issue but found that on my dashboard which the users created on 11.1.5 and promoted to production but now, facing this issue on my test environment, any idea so far how to fix it?​

------------------------------
Kleber Vieira

Original Message:
Sent: Wed May 06, 2020 07:06 PM
From: Tom Rosenow
Subject: CA 11.1.6 Data Modules Custom Table unable to do a distinct count

Hello.
When I create a custom table (view) from a fact and dimension table needing to conduct an evaluation for a new fact table, I can no longer do a DISTINCT COUNT on ids if I join the new fact table back to my dimensions for report writing. 
error:
XQE-PLN-0385 Count distinct is not supported for queries that span multiple sources.

This worked fine in 11.1.5.

The query plan must have changed or the process.  How do I update or correct this?
Thanks.

------------------------------
Tom Rosenow
------------------------------

#CognosAnalyticswithWatson

Original Message:
Sent: 1/23/2021 10:20:00 AM
From: Balakrishna Adusumilli
Subject: RE: CA 11.1.6 Data Modules Custom Table unable to do a distinct count

Hi,

We are facing the same issue. Could you kindly share if you find any solution for the same.

Count distinct is not supported for queries that span multiple source

------------------------------
Balakrishna Adusumilli
------------------------------

Original Message:
Sent: Tue June 02, 2020 09:32 PM
From: Kleber Vieira
Subject: CA 11.1.6 Data Modules Custom Table unable to do a distinct count

creating the count distinct itself is not a problem, the problem is when i join the fact that contain the count calculation to a month columns from my date dimension, that is where the error comes up, whatever the template you use for it, crosstab or graph, the error is the same.


------------------------------
Kleber Vieira

Original Message:
Sent: Tue June 02, 2020 07:34 PM
From: Kleber Vieira
Subject: CA 11.1.6 Data Modules Custom Table unable to do a distinct count

a have hire_key field which is text  example of a key 4517778-1 where i created a calculation count(distinct(hire_key)).

my situation is not a view, it is SQL table.
any suggestion would be great

------------------------------
Kleber Vieira

Original Message:
Sent: Tue June 02, 2020 03:25 AM
From: Kleber Vieira
Subject: CA 11.1.6 Data Modules Custom Table unable to do a distinct count

I have the same issue using sql tables objects within data module. have deployed 11.1.5 last weekend and found that the audit database wasn't been populated properly. Spoke to IBM and it was a bug then, they gave me an interin hot fix for 11.1.5 and fixed the audit issue but found that on my dashboard which the users created on 11.1.5 and promoted to production but now, facing this issue on my test environment, any idea so far how to fix it?​

------------------------------
Kleber Vieira

Original Message:
Sent: Wed May 06, 2020 07:06 PM
From: Tom Rosenow
Subject: CA 11.1.6 Data Modules Custom Table unable to do a distinct count

Hello.
When I create a custom table (view) from a fact and dimension table needing to conduct an evaluation for a new fact table, I can no longer do a DISTINCT COUNT on ids if I join the new fact table back to my dimensions for report writing. 
error:
XQE-PLN-0385 Count distinct is not supported for queries that span multiple sources.

This worked fine in 11.1.5.

The query plan must have changed or the process.  How do I update or correct this?
Thanks.

------------------------------
Tom Rosenow
------------------------------

#CognosAnalyticswithWatson

We are experiencing the same issue in 11.1.7 FP1.

However, we have opened a case with IBM and they have identified that there is a defect here and are working to resolve it.

There is an APAR open so you might be able to receive updates on the future solution by subscribing:

https://www.ibm.com/support/pages/apar/PH32330

It is by no means a perfect solution especially if you have several tables all joined together but we have found that using Joined Views instead of Table Views resolve the issue in most if not all scenarios.

Hope this helps - data modules are a great feature of Cognos Analytics and IBM has been doing a great job working through issues with us so don't hesitate to open cases to get their support as well.

------------------------------
Joshua Milford
------------------------------

Original Message:
Sent: Tue June 02, 2020 09:32 PM
From: Kleber Vieira
Subject: CA 11.1.6 Data Modules Custom Table unable to do a distinct count

creating the count distinct itself is not a problem, the problem is when i join the fact that contain the count calculation to a month columns from my date dimension, that is where the error comes up, whatever the template you use for it, crosstab or graph, the error is the same.


------------------------------
Kleber Vieira

Original Message:
Sent: Tue June 02, 2020 07:34 PM
From: Kleber Vieira
Subject: CA 11.1.6 Data Modules Custom Table unable to do a distinct count

a have hire_key field which is text  example of a key 4517778-1 where i created a calculation count(distinct(hire_key)).

my situation is not a view, it is SQL table.
any suggestion would be great

------------------------------
Kleber Vieira

Original Message:
Sent: Tue June 02, 2020 03:25 AM
From: Kleber Vieira
Subject: CA 11.1.6 Data Modules Custom Table unable to do a distinct count

I have the same issue using sql tables objects within data module. have deployed 11.1.5 last weekend and found that the audit database wasn't been populated properly. Spoke to IBM and it was a bug then, they gave me an interin hot fix for 11.1.5 and fixed the audit issue but found that on my dashboard which the users created on 11.1.5 and promoted to production but now, facing this issue on my test environment, any idea so far how to fix it?​

------------------------------
Kleber Vieira

Original Message:
Sent: Wed May 06, 2020 07:06 PM
From: Tom Rosenow
Subject: CA 11.1.6 Data Modules Custom Table unable to do a distinct count

Hello.
When I create a custom table (view) from a fact and dimension table needing to conduct an evaluation for a new fact table, I can no longer do a DISTINCT COUNT on ids if I join the new fact table back to my dimensions for report writing. 
error:
XQE-PLN-0385 Count distinct is not supported for queries that span multiple sources.

This worked fine in 11.1.5.

The query plan must have changed or the process.  How do I update or correct this?
Thanks.

------------------------------
Tom Rosenow
------------------------------

#CognosAnalyticswithWatson

Please FYI, this issue was resolved in recently released CA 11.1.7 Interim Fix 3
https://www.ibm.com/support/pages/node/6350229

------------------------------
Ian Davidson
------------------------------

Original Message:
Sent: Wed May 06, 2020 07:06 PM
From: Tom Rosenow
Subject: CA 11.1.6 Data Modules Custom Table unable to do a distinct count

Hello.
When I create a custom table (view) from a fact and dimension table needing to conduct an evaluation for a new fact table, I can no longer do a DISTINCT COUNT on ids if I join the new fact table back to my dimensions for report writing. 
error:
XQE-PLN-0385 Count distinct is not supported for queries that span multiple sources.

This worked fine in 11.1.5.

The query plan must have changed or the process.  How do I update or correct this?
Thanks.

------------------------------
Tom Rosenow
------------------------------

#CognosAnalyticswithWatson

Please FYI, fix for this issue is available in CA 11.1.7 InterimFix 3 ( https://www.ibm.com/support/pages/node/6350229 ) 
The link includes main server installation zip file and optional supplementary tools zip file (e.g. Framework Manager).
To install these products please use main installer that can be downloaded from CA 11.1.7 FixPack2: IBM Cognos Analytics 11.1.7 Fix Pack 2

Hope that helps.

------------------------------
Ian Davidson
------------------------------

Original Message:
Sent: Wed May 06, 2020 07:06 PM
From: Tom Rosenow
Subject: CA 11.1.6 Data Modules Custom Table unable to do a distinct count

Hello.
When I create a custom table (view) from a fact and dimension table needing to conduct an evaluation for a new fact table, I can no longer do a DISTINCT COUNT on ids if I join the new fact table back to my dimensions for report writing. 
error:
XQE-PLN-0385 Count distinct is not supported for queries that span multiple sources.

This worked fine in 11.1.5.

The query plan must have changed or the process.  How do I update or correct this?
Thanks.

------------------------------
Tom Rosenow
------------------------------

#CognosAnalyticswithWatson

Hi Ian,

I installed the CA 11.1.7 Interim Fix 3 on top of CA 11.1.7, skipped installing the CA 11.1.7 FixPack2, and have the same issue/error ""Count distinct is not supported for queries that span multiple sources" against dashboards that created in CA11.1.4.

Questions?
1. Do I need to installed  the CA 11.1.7 FixPack2 on the top of CA 11.1.7 before installing the CA 11.1.7 Interim Fix 3?
2. If not, what do I need to check to know the fix is installed on my local correctly, such as any file name with version?
3. My upgrade process: 1) installed CA 11.1.7 in a different CM/App server (Windows Server), 2) made a backup of content store from the server (11.1.4) and restore it to the new server (11.1.7), and ran the dashboard and got the same error "Count distinct is not supported for queries that span multiple sources"
Then, installed the CA 11.1.7 Interim Fix 3 on top of CA11.1.7 and have the same error

4. My dashboards based on a data module that has a data server and an uploaded file (csv) and made JOIN

Any advice?

Regards,
Samuel






------------------------------
Samuel Lee
------------------------------

Original Message:
Sent: Tue January 26, 2021 02:40 PM
From: Ian Davidson
Subject: CA 11.1.6 Data Modules Custom Table unable to do a distinct count


Please FYI, fix for this issue is available in CA 11.1.7 InterimFix 3 ( https://www.ibm.com/support/pages/node/6350229 ) 
The link includes main server installation zip file and optional supplementary tools zip file (e.g. Framework Manager).
To install these products please use main installer that can be downloaded from CA 11.1.7 FixPack2: IBM Cognos Analytics 11.1.7 Fix Pack 2

Hope that helps.

------------------------------
Ian Davidson

Original Message:
Sent: Wed May 06, 2020 07:06 PM
From: Tom Rosenow
Subject: CA 11.1.6 Data Modules Custom Table unable to do a distinct count

Hello.
When I create a custom table (view) from a fact and dimension table needing to conduct an evaluation for a new fact table, I can no longer do a DISTINCT COUNT on ids if I join the new fact table back to my dimensions for report writing. 
error:
XQE-PLN-0385 Count distinct is not supported for queries that span multiple sources.

This worked fine in 11.1.5.

The query plan must have changed or the process.  How do I update or correct this?
Thanks.

------------------------------
Tom Rosenow
------------------------------

#CognosAnalyticswithWatson

We installed CA 11.1.7 Interim Fix 4 and the problem is still there. 

Is there any solution available or I should move the development to framework manager? 


------------------------------
Mauro Santos Otero
------------------------------

Original Message:
Sent: Wed February 24, 2021 06:35 PM
From: Samuel Lee
Subject: CA 11.1.6 Data Modules Custom Table unable to do a distinct count

Hi Ian,

I installed the CA 11.1.7 Interim Fix 3 on top of CA 11.1.7, skipped installing the CA 11.1.7 FixPack2, and have the same issue/error ""Count distinct is not supported for queries that span multiple sources" against dashboards that created in CA11.1.4.

Questions?
1. Do I need to installed  the CA 11.1.7 FixPack2 on the top of CA 11.1.7 before installing the CA 11.1.7 Interim Fix 3?
2. If not, what do I need to check to know the fix is installed on my local correctly, such as any file name with version?
3. My upgrade process: 1) installed CA 11.1.7 in a different CM/App server (Windows Server), 2) made a backup of content store from the server (11.1.4) and restore it to the new server (11.1.7), and ran the dashboard and got the same error "Count distinct is not supported for queries that span multiple sources"
Then, installed the CA 11.1.7 Interim Fix 3 on top of CA11.1.7 and have the same error

4. My dashboards based on a data module that has a data server and an uploaded file (csv) and made JOIN

Any advice?

Regards,
Samuel






------------------------------
Samuel Lee

Original Message:
Sent: Tue January 26, 2021 02:40 PM
From: Ian Davidson
Subject: CA 11.1.6 Data Modules Custom Table unable to do a distinct count


Please FYI, fix for this issue is available in CA 11.1.7 InterimFix 3 ( https://www.ibm.com/support/pages/node/6350229 ) 
The link includes main server installation zip file and optional supplementary tools zip file (e.g. Framework Manager).
To install these products please use main installer that can be downloaded from CA 11.1.7 FixPack2: IBM Cognos Analytics 11.1.7 Fix Pack 2

Hope that helps.

------------------------------
Ian Davidson

Original Message:
Sent: Wed May 06, 2020 07:06 PM
From: Tom Rosenow
Subject: CA 11.1.6 Data Modules Custom Table unable to do a distinct count

Hello.
When I create a custom table (view) from a fact and dimension table needing to conduct an evaluation for a new fact table, I can no longer do a DISTINCT COUNT on ids if I join the new fact table back to my dimensions for report writing. 
error:
XQE-PLN-0385 Count distinct is not supported for queries that span multiple sources.

This worked fine in 11.1.5.

The query plan must have changed or the process.  How do I update or correct this?
Thanks.

------------------------------
Tom Rosenow
------------------------------

#CognosAnalyticswithWatson