Cognos Analytics

Hi Team !
 i have a requirement that User should see only their Bank Branch Data on Dashboard, i have done it with report , but unable to find a way to configure Dashboard as per User Login.
Thanks in advance.

------------------------------
Hashim Raza
------------------------------

Hi Hashim, 

We also have data for different Cognos users in the same tables and distinguish the data rows by a certain column (called database_user). The Framework Manager model uses Macros to assign different Cognos Data Sources to the Cognos users. The different Cognos Data Sources use different database users for the same database (= Catalog). For each FM query object we have a filter implemented like: [database_user] = {current_user} such that each Cognos user automatically filters only the data of its own database user in the end. It works fine for us. 

Could you please tell me the idea of your current solution for your reports? 

Regards

------------------------------
Philipp Hornung
------------------------------

Original Message:
Sent: Tue February 23, 2021 11:41 AM
From: Hashim Raza
Subject: Login User Based Access on Dash Board.

Hi Team !
 i have a requirement that User should see only their Bank Branch Data on Dashboard, i have done it with report , but unable to find a way to configure Dashboard as per User Login.
Thanks in advance.

------------------------------
Hashim Raza
------------------------------

HI Philipp
 i just Created a table with the column of Branch_Id and User Login ID, made a relationship with the report view, than used a [NAME] = #sq($account.defaultName)# in the main query, and its working fine for report.
let me try your suggested solution for the Dashboard.
Thanks.
​

------------------------------
Hashim Raza
------------------------------

Original Message:
Sent: Wed February 24, 2021 05:42 AM
From: Philipp Hornung
Subject: Login User Based Access on Dash Board.

Hi Hashim, 

We also have data for different Cognos users in the same tables and distinguish the data rows by a certain column (called database_user). The Framework Manager model uses Macros to assign different Cognos Data Sources to the Cognos users. The different Cognos Data Sources use different database users for the same database (= Catalog). For each FM query object we have a filter implemented like: [database_user] = {current_user} such that each Cognos user automatically filters only the data of its own database user in the end. It works fine for us. 

Could you please tell me the idea of your current solution for your reports? 

Regards

------------------------------
Philipp Hornung

Original Message:
Sent: Tue February 23, 2021 11:41 AM
From: Hashim Raza
Subject: Login User Based Access on Dash Board.

Hi Team !
 i have a requirement that User should see only their Bank Branch Data on Dashboard, i have done it with report , but unable to find a way to configure Dashboard as per User Login.
Thanks in advance.

------------------------------
Hashim Raza
------------------------------

Hi Hashim, 
your approach should also work in a Framework Manager model on which Dashboards could be based. (For Data Modules I'm not sure but I think the Session Parameters aren't available there.) But that brings me to the idea that - at least in the latest CA version - Report Queries can be turned to Data Sets which in turn can be used in Data Modules or in Dashboards directly. 
Best

------------------------------
Philipp Hornung
------------------------------

Original Message:
Sent: Wed February 24, 2021 10:53 AM
From: Hashim Raza
Subject: Login User Based Access on Dash Board.

HI Philipp
 i just Created a table with the column of Branch_Id and User Login ID, made a relationship with the report view, than used a [NAME] = #sq($account.defaultName)# in the main query, and its working fine for report.
let me try your suggested solution for the Dashboard.
Thanks.
​

------------------------------
Hashim Raza

Original Message:
Sent: Wed February 24, 2021 05:42 AM
From: Philipp Hornung
Subject: Login User Based Access on Dash Board.

Hi Hashim, 

We also have data for different Cognos users in the same tables and distinguish the data rows by a certain column (called database_user). The Framework Manager model uses Macros to assign different Cognos Data Sources to the Cognos users. The different Cognos Data Sources use different database users for the same database (= Catalog). For each FM query object we have a filter implemented like: [database_user] = {current_user} such that each Cognos user automatically filters only the data of its own database user in the end. It works fine for us. 

Could you please tell me the idea of your current solution for your reports? 

Regards

------------------------------
Philipp Hornung

Original Message:
Sent: Tue February 23, 2021 11:41 AM
From: Hashim Raza
Subject: Login User Based Access on Dash Board.

Hi Team !
 i have a requirement that User should see only their Bank Branch Data on Dashboard, i have done it with report , but unable to find a way to configure Dashboard as per User Login.
Thanks in advance.

------------------------------
Hashim Raza
------------------------------

Session parameters are also accessible in Data Modules and Dashboarding.
At the moment there is no UI to check/add/override any of these session parameters.
// Henk

------------------------------
HENK CAZEMIER
------------------------------

Original Message:
Sent: Wed February 24, 2021 11:59 AM
From: Philipp Hornung
Subject: Login User Based Access on Dash Board.

Hi Hashim, 
your approach should also work in a Framework Manager model on which Dashboards could be based. (For Data Modules I'm not sure but I think the Session Parameters aren't available there.) But that brings me to the idea that - at least in the latest CA version - Report Queries can be turned to Data Sets which in turn can be used in Data Modules or in Dashboards directly. 
Best

------------------------------
Philipp Hornung

Original Message:
Sent: Wed February 24, 2021 10:53 AM
From: Hashim Raza
Subject: Login User Based Access on Dash Board.

HI Philipp
 i just Created a table with the column of Branch_Id and User Login ID, made a relationship with the report view, than used a [NAME] = #sq($account.defaultName)# in the main query, and its working fine for report.
let me try your suggested solution for the Dashboard.
Thanks.
​

------------------------------
Hashim Raza

Original Message:
Sent: Wed February 24, 2021 05:42 AM
From: Philipp Hornung
Subject: Login User Based Access on Dash Board.

Hi Hashim, 

We also have data for different Cognos users in the same tables and distinguish the data rows by a certain column (called database_user). The Framework Manager model uses Macros to assign different Cognos Data Sources to the Cognos users. The different Cognos Data Sources use different database users for the same database (= Catalog). For each FM query object we have a filter implemented like: [database_user] = {current_user} such that each Cognos user automatically filters only the data of its own database user in the end. It works fine for us. 

Could you please tell me the idea of your current solution for your reports? 

Regards

------------------------------
Philipp Hornung

Original Message:
Sent: Tue February 23, 2021 11:41 AM
From: Hashim Raza
Subject: Login User Based Access on Dash Board.

Hi Team !
 i have a requirement that User should see only their Bank Branch Data on Dashboard, i have done it with report , but unable to find a way to configure Dashboard as per User Login.
Thanks in advance.

------------------------------
Hashim Raza
------------------------------

In my first post I forgot to add that we also have a FM Parameter Mapping in place that grougs the users (in your case by branch). This mapping is used in the mentioned Data Source Macros. So we don't need a Cognos Data Source for each user but only for the user groups.

------------------------------
Philipp Hornung
------------------------------

Original Message:
Sent: Wed February 24, 2021 05:42 AM
From: Philipp Hornung
Subject: Login User Based Access on Dash Board.

Hi Hashim, 

We also have data for different Cognos users in the same tables and distinguish the data rows by a certain column (called database_user). The Framework Manager model uses Macros to assign different Cognos Data Sources to the Cognos users. The different Cognos Data Sources use different database users for the same database (= Catalog). For each FM query object we have a filter implemented like: [database_user] = {current_user} such that each Cognos user automatically filters only the data of its own database user in the end. It works fine for us. 

Could you please tell me the idea of your current solution for your reports? 

Regards

------------------------------
Philipp Hornung

Original Message:
Sent: Tue February 23, 2021 11:41 AM
From: Hashim Raza
Subject: Login User Based Access on Dash Board.

Hi Team !
 i have a requirement that User should see only their Bank Branch Data on Dashboard, i have done it with report , but unable to find a way to configure Dashboard as per User Login.
Thanks in advance.

------------------------------
Hashim Raza
------------------------------

Dear,

From the Cognos Administration Panel, you can set the permission rights for the Dashboard to Cognos Users apparently.

------------------------------
Adnan Sheeraz
------------------------------

Original Message:
Sent: Thu February 25, 2021 04:39 AM
From: Philipp Hornung
Subject: Login User Based Access on Dash Board.

In my first post I forgot to add that we also have a FM Parameter Mapping in place that grougs the users (in your case by branch). This mapping is used in the mentioned Data Source Macros. So we don't need a Cognos Data Source for each user but only for the user groups.

------------------------------
Philipp Hornung

Original Message:
Sent: Wed February 24, 2021 05:42 AM
From: Philipp Hornung
Subject: Login User Based Access on Dash Board.

Hi Hashim, 

We also have data for different Cognos users in the same tables and distinguish the data rows by a certain column (called database_user). The Framework Manager model uses Macros to assign different Cognos Data Sources to the Cognos users. The different Cognos Data Sources use different database users for the same database (= Catalog). For each FM query object we have a filter implemented like: [database_user] = {current_user} such that each Cognos user automatically filters only the data of its own database user in the end. It works fine for us. 

Could you please tell me the idea of your current solution for your reports? 

Regards

------------------------------
Philipp Hornung

Original Message:
Sent: Tue February 23, 2021 11:41 AM
From: Hashim Raza
Subject: Login User Based Access on Dash Board.

Hi Team !
 i have a requirement that User should see only their Bank Branch Data on Dashboard, i have done it with report , but unable to find a way to configure Dashboard as per User Login.
Thanks in advance.

------------------------------
Hashim Raza
------------------------------

Hi, 
There are multiple ways to filter data by users. Dependend on the use case they are more or less useful or manageable. 
a. Separate Reports/Dashboards with shared Package/Data Module and fix report filters
b. Separate Reports/Dashboards with separate Packages/Data Modules
c. Shared Report/Dashboard with shared Package/Data Module and dynamic allocation of database users with according model filters
My initial suggestion goes the third way.

------------------------------
Philipp Hornung
------------------------------

Original Message:
Sent: Thu February 25, 2021 07:03 AM
From: Adnan Sheeraz
Subject: Login User Based Access on Dash Board.

Dear,

From the Cognos Administration Panel, you can set the permission rights for the Dashboard to Cognos Users apparently.

------------------------------
Adnan Sheeraz

Original Message:
Sent: Thu February 25, 2021 04:39 AM
From: Philipp Hornung
Subject: Login User Based Access on Dash Board.

In my first post I forgot to add that we also have a FM Parameter Mapping in place that grougs the users (in your case by branch). This mapping is used in the mentioned Data Source Macros. So we don't need a Cognos Data Source for each user but only for the user groups.

------------------------------
Philipp Hornung

Original Message:
Sent: Wed February 24, 2021 05:42 AM
From: Philipp Hornung
Subject: Login User Based Access on Dash Board.

Hi Hashim, 

We also have data for different Cognos users in the same tables and distinguish the data rows by a certain column (called database_user). The Framework Manager model uses Macros to assign different Cognos Data Sources to the Cognos users. The different Cognos Data Sources use different database users for the same database (= Catalog). For each FM query object we have a filter implemented like: [database_user] = {current_user} such that each Cognos user automatically filters only the data of its own database user in the end. It works fine for us. 

Could you please tell me the idea of your current solution for your reports? 

Regards

------------------------------
Philipp Hornung

Original Message:
Sent: Tue February 23, 2021 11:41 AM
From: Hashim Raza
Subject: Login User Based Access on Dash Board.

Hi Team !
 i have a requirement that User should see only their Bank Branch Data on Dashboard, i have done it with report , but unable to find a way to configure Dashboard as per User Login.
Thanks in advance.

------------------------------
Hashim Raza
------------------------------