List of Contributions

Jorge Moura

Contact Details

My Content

1 to 6 of 6 total
Posted By Jorge Moura Jun 10, 2021 4:24 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Thomas, Thanks for sharing your solution as well. In some cases the approach without parameter map is not possible. We had recent a project with many security levels (Sales force dimension) and we were able to use the approach without parameter map combining user roles that identify the level (Regional ...
Posted By Jorge Moura Jun 10, 2021 4:09 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Ian, We are dealing with duplication now manually removing that. The main concern for us before this post was to not know what was causing the duplication and if it is fixed in later versions. Thanks a lot for the information. Parameter map gap is not an issue for us. We use to avoid it even in FM. ...
Posted By Jorge Moura Jun 9, 2021 9:32 AM
Found In Egroup: Cognos Analytics
\ view thread
​Hi Thomas, good morning. Let me share with you how we are using macros to apply general security in Data Module. 1) We use to create user roles with some business key inside the role name. In one of our projects for instance we use Brazilian city code like below: prefeitura-3305802_teresopolis is the ...
Posted By Jorge Moura Jun 8, 2021 6:00 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Ian, Today we took a more detail look to this issue and we found out that security entries are duplicated every time we reload metadata and your post confirmed our observations. As we use a single macro based on user roles to apply security to our secured tables (around 50 are secured) it will not ...
Posted By Jorge Moura Jun 8, 2021 5:51 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Thomas Today we found out that this problem occurs when the metadata is reloaded. We could see that filters are replicated in the SQL where clause as well. There is another reply in this discussion from Ian Henderson telling us that this is a bug of 11.1.2 fixed in 11.1.4. I think in your case if ...
Posted By Jorge Moura Jun 8, 2021 9:08 AM
Found In Egroup: Cognos Analytics
\ view thread
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 ...