Cognos Analytics

Hi Jorge,
I also experienced this behavior in version 11.1.2.  I did not find a solution. Now we have upgraded to 11.2.0. When I open the datamodule I still see duplicates.
Be also aware that if multiple filters are applied, the filters used will have an AND condition.

------------------------------
Thomas van der Meer

Original Message:
Sent: Mon June 07, 2021 07:43 PM
From: Jorge Moura
Subject: Data security - Data Module

Hi Everyone,

We are implementing data security in Data Module. We are doing that at Data Source level by adding users roles and respective data filter for each role. 

But Cognos for some reason that we aren´t able to explain is duplicating the same Data Security entry several times. 

I would like to know if someone has experienced that behavior and what could be the solution.

Our version is 11.1.2 - zLinux (Main Frame).

Tks in advance.

Jorge Nelson

I would like to confirm my understanding about what actions you performed prior to your observation of the duplicated security filters.

There was a bug in 11.1.x, which was fixed in 11.1.4, in which the security filters would be duplicated if you reloaded the metadata of the schema.   There is a manual step of removing the duplicated security filters which needs to be performed.  Interestingly, if you cleared the schema's metadata and then reloaded the security filters would not be duplicated.  

I have not been able to find any other defect where the behaviour you are observing happens.   

Keep in mind that security filters are built into the metadata and reloading the metadata will cause the security filters to be removed.  There is a message to that effect when you try to do that.

Hi Jorge,
I also experienced this behavior in version 11.1.2.  I did not find a solution. Now we have upgraded to 11.2.0. When I open the datamodule I still see duplicates.
Be also aware that if multiple filters are applied, the filters used will have an AND condition.

------------------------------
Thomas van der Meer

Original Message:
Sent: Mon June 07, 2021 07:43 PM
From: Jorge Moura
Subject: Data security - Data Module

Hi Everyone,

We are implementing data security in Data Module. We are doing that at Data Source level by adding users roles and respective data filter for each role. 

But Cognos for some reason that we aren´t able to explain is duplicating the same Data Security entry several times. 

I would like to know if someone has experienced that behavior and what could be the solution.

Our version is 11.1.2 - zLinux (Main Frame).

Tks in advance.

Jorge Nelson

I would like to confirm my understanding about what actions you performed prior to your observation of the duplicated security filters.

There was a bug in 11.1.x, which was fixed in 11.1.4, in which the security filters would be duplicated if you reloaded the metadata of the schema.   There is a manual step of removing the duplicated security filters which needs to be performed.  Interestingly, if you cleared the schema's metadata and then reloaded the security filters would not be duplicated.  

I have not been able to find any other defect where the behaviour you are observing happens.   

Keep in mind that security filters are built into the metadata and reloading the metadata will cause the security filters to be removed.  There is a message to that effect when you try to do that.

Hi Jorge,
I also experienced this behavior in version 11.1.2.  I did not find a solution. Now we have upgraded to 11.2.0. When I open the datamodule I still see duplicates.
Be also aware that if multiple filters are applied, the filters used will have an AND condition.

------------------------------
Thomas van der Meer

Original Message:
Sent: Mon June 07, 2021 07:43 PM
From: Jorge Moura
Subject: Data security - Data Module

Hi Everyone,

We are implementing data security in Data Module. We are doing that at Data Source level by adding users roles and respective data filter for each role. 

But Cognos for some reason that we aren´t able to explain is duplicating the same Data Security entry several times. 

I would like to know if someone has experienced that behavior and what could be the solution.

Our version is 11.1.2 - zLinux (Main Frame).

Tks in advance.

Jorge Nelson

I would like to confirm my understanding about what actions you performed prior to your observation of the duplicated security filters.

There was a bug in 11.1.x, which was fixed in 11.1.4, in which the security filters would be duplicated if you reloaded the metadata of the schema.   There is a manual step of removing the duplicated security filters which needs to be performed.  Interestingly, if you cleared the schema's metadata and then reloaded the security filters would not be duplicated.  

I have not been able to find any other defect where the behaviour you are observing happens.   

Keep in mind that security filters are built into the metadata and reloading the metadata will cause the security filters to be removed.  There is a message to that effect when you try to do that.

Hi Jorge,
I also experienced this behavior in version 11.1.2.  I did not find a solution. Now we have upgraded to 11.2.0. When I open the datamodule I still see duplicates.
Be also aware that if multiple filters are applied, the filters used will have an AND condition.

------------------------------
Thomas van der Meer

Original Message:
Sent: Mon June 07, 2021 07:43 PM
From: Jorge Moura
Subject: Data security - Data Module

Hi Everyone,

We are implementing data security in Data Module. We are doing that at Data Source level by adding users roles and respective data filter for each role. 

But Cognos for some reason that we aren´t able to explain is duplicating the same Data Security entry several times. 

I would like to know if someone has experienced that behavior and what could be the solution.

Our version is 11.1.2 - zLinux (Main Frame).

Tks in advance.

Jorge Nelson

I would like to confirm my understanding about what actions you performed prior to your observation of the duplicated security filters.

There was a bug in 11.1.x, which was fixed in 11.1.4, in which the security filters would be duplicated if you reloaded the metadata of the schema.   There is a manual step of removing the duplicated security filters which needs to be performed.  Interestingly, if you cleared the schema's metadata and then reloaded the security filters would not be duplicated.  

I have not been able to find any other defect where the behaviour you are observing happens.   

Keep in mind that security filters are built into the metadata and reloading the metadata will cause the security filters to be removed.  There is a message to that effect when you try to do that.

Hi Jorge,
I also experienced this behavior in version 11.1.2.  I did not find a solution. Now we have upgraded to 11.2.0. When I open the datamodule I still see duplicates.
Be also aware that if multiple filters are applied, the filters used will have an AND condition.

------------------------------
Thomas van der Meer

Original Message:
Sent: Mon June 07, 2021 07:43 PM
From: Jorge Moura
Subject: Data security - Data Module

Hi Everyone,

We are implementing data security in Data Module. We are doing that at Data Source level by adding users roles and respective data filter for each role. 

But Cognos for some reason that we aren´t able to explain is duplicating the same Data Security entry several times. 

I would like to know if someone has experienced that behavior and what could be the solution.

Our version is 11.1.2 - zLinux (Main Frame).

Tks in advance.

Jorge Nelson

I would like to confirm my understanding about what actions you performed prior to your observation of the duplicated security filters.

There was a bug in 11.1.x, which was fixed in 11.1.4, in which the security filters would be duplicated if you reloaded the metadata of the schema.   There is a manual step of removing the duplicated security filters which needs to be performed.  Interestingly, if you cleared the schema's metadata and then reloaded the security filters would not be duplicated.  

I have not been able to find any other defect where the behaviour you are observing happens.   

Keep in mind that security filters are built into the metadata and reloading the metadata will cause the security filters to be removed.  There is a message to that effect when you try to do that.

Hi Jorge,
I also experienced this behavior in version 11.1.2.  I did not find a solution. Now we have upgraded to 11.2.0. When I open the datamodule I still see duplicates.
Be also aware that if multiple filters are applied, the filters used will have an AND condition.

------------------------------
Thomas van der Meer

Original Message:
Sent: Mon June 07, 2021 07:43 PM
From: Jorge Moura
Subject: Data security - Data Module

Hi Everyone,

We are implementing data security in Data Module. We are doing that at Data Source level by adding users roles and respective data filter for each role. 

But Cognos for some reason that we aren´t able to explain is duplicating the same Data Security entry several times. 

I would like to know if someone has experienced that behavior and what could be the solution.

Our version is 11.1.2 - zLinux (Main Frame).

Tks in advance.

Jorge Nelson

I would like to confirm my understanding about what actions you performed prior to your observation of the duplicated security filters.

There was a bug in 11.1.x, which was fixed in 11.1.4, in which the security filters would be duplicated if you reloaded the metadata of the schema.   There is a manual step of removing the duplicated security filters which needs to be performed.  Interestingly, if you cleared the schema's metadata and then reloaded the security filters would not be duplicated.  

I have not been able to find any other defect where the behaviour you are observing happens.   

Keep in mind that security filters are built into the metadata and reloading the metadata will cause the security filters to be removed.  There is a message to that effect when you try to do that.

Hi Jorge,
I also experienced this behavior in version 11.1.2.  I did not find a solution. Now we have upgraded to 11.2.0. When I open the datamodule I still see duplicates.
Be also aware that if multiple filters are applied, the filters used will have an AND condition.

------------------------------
Thomas van der Meer

Original Message:
Sent: Mon June 07, 2021 07:43 PM
From: Jorge Moura
Subject: Data security - Data Module

Hi Everyone,

We are implementing data security in Data Module. We are doing that at Data Source level by adding users roles and respective data filter for each role. 

But Cognos for some reason that we aren´t able to explain is duplicating the same Data Security entry several times. 

I would like to know if someone has experienced that behavior and what could be the solution.

Our version is 11.1.2 - zLinux (Main Frame).

Tks in advance.

Jorge Nelson

I would like to confirm my understanding about what actions you performed prior to your observation of the duplicated security filters.

There was a bug in 11.1.x, which was fixed in 11.1.4, in which the security filters would be duplicated if you reloaded the metadata of the schema.   There is a manual step of removing the duplicated security filters which needs to be performed.  Interestingly, if you cleared the schema's metadata and then reloaded the security filters would not be duplicated.  

I have not been able to find any other defect where the behaviour you are observing happens.   

Keep in mind that security filters are built into the metadata and reloading the metadata will cause the security filters to be removed.  There is a message to that effect when you try to do that.

Hi Jorge,
I also experienced this behavior in version 11.1.2.  I did not find a solution. Now we have upgraded to 11.2.0. When I open the datamodule I still see duplicates.
Be also aware that if multiple filters are applied, the filters used will have an AND condition.

------------------------------
Thomas van der Meer

Original Message:
Sent: Mon June 07, 2021 07:43 PM
From: Jorge Moura
Subject: Data security - Data Module

Hi Everyone,

We are implementing data security in Data Module. We are doing that at Data Source level by adding users roles and respective data filter for each role. 

But Cognos for some reason that we aren´t able to explain is duplicating the same Data Security entry several times. 

I would like to know if someone has experienced that behavior and what could be the solution.

Our version is 11.1.2 - zLinux (Main Frame).

Tks in advance.

Jorge Nelson

Hi Jorge,
I also experienced this behavior in version 11.1.2.  I did not find a solution. Now we have upgraded to 11.2.0. When I open the datamodule I still see duplicates.
Be also aware that if multiple filters are applied, the filters used will have an AND condition.

------------------------------
Thomas van der Meer

Original Message:
Sent: Mon June 07, 2021 07:43 PM
From: Jorge Moura
Subject: Data security - Data Module

Hi Everyone,

We are implementing data security in Data Module. We are doing that at Data Source level by adding users roles and respective data filter for each role. 

But Cognos for some reason that we aren´t able to explain is duplicating the same Data Security entry several times. 

I would like to know if someone has experienced that behavior and what could be the solution.

Our version is 11.1.2 - zLinux (Main Frame).

Tks in advance.

Jorge Nelson

Hi Jorge,
I also experienced this behavior in version 11.1.2.  I did not find a solution. Now we have upgraded to 11.2.0. When I open the datamodule I still see duplicates.
Be also aware that if multiple filters are applied, the filters used will have an AND condition.

------------------------------
Thomas van der Meer

Original Message:
Sent: Mon June 07, 2021 07:43 PM
From: Jorge Moura
Subject: Data security - Data Module

Hi Everyone,

We are implementing data security in Data Module. We are doing that at Data Source level by adding users roles and respective data filter for each role. 

But Cognos for some reason that we aren´t able to explain is duplicating the same Data Security entry several times. 

I would like to know if someone has experienced that behavior and what could be the solution.

Our version is 11.1.2 - zLinux (Main Frame).

Tks in advance.

Jorge Nelson

Hi Thomas & Jorge,
Data Modules do not allow you to define parameter maps at this time, but the need of that is quite a bit reduced with the introduction of the macro function queryValue
Assume that you used FM and created a parameter map  myMap based on query items,  key=[ns1].[qs1].[qi_k] and value=[ns1].[qs1].[qi_val]
The use would be something like  # sq ($myMap { 'key1' } ) #     say that would give 'val1'.
Using queryValue you could use  #   sq ( queryValue ('[ns1].[qs1].[qi_val]',  '[ns1].[qs1].[qi_k] = ' + sq('key1')) ) #
This works in Data Modules, here is an example with based on the gosales sample model:
#
sq(
queryValue(' PRODUCT_LINE.PRODUCT_LINE_NL',
' PRODUCT_LINE.PRODUCT_LINE_EN = ' + sq('Camping Equipment') )
)
#
That gives as output: Kampeerbenodigdheden

// Henk​​​

Hi Jorge,
I also experienced this behavior in version 11.1.2.  I did not find a solution. Now we have upgraded to 11.2.0. When I open the datamodule I still see duplicates.
Be also aware that if multiple filters are applied, the filters used will have an AND condition.

------------------------------
Thomas van der Meer

Original Message:
Sent: Mon June 07, 2021 07:43 PM
From: Jorge Moura
Subject: Data security - Data Module

Hi Everyone,

We are implementing data security in Data Module. We are doing that at Data Source level by adding users roles and respective data filter for each role. 

But Cognos for some reason that we aren´t able to explain is duplicating the same Data Security entry several times. 

I would like to know if someone has experienced that behavior and what could be the solution.

Our version is 11.1.2 - zLinux (Main Frame).

Tks in advance.

Jorge Nelson