Author Topic: Security in Dynamic cubes  (Read 869 times)

Offline akshara_a

  • Full Member
  • ***
  • Join Date: Sep 2015
  • Posts: 17
  • Forum Citizenship: +0/-0
Security in Dynamic cubes
« on: 27 Oct 2016 02:11:22 pm »
Hi All,

I have a virtual cube with 2 base cubes. Both the base cubes have location dimension. Here is the structure of location dimension - Country > State > County. I have added a security filter which denies Country Canada to a set of people.
I published the cube and added people to the security view. They are not able to see the Country Canada.
When the user pulls Country and NetSales into the report in Analysis Studio, he sees Sales of all countries except Canada. Which is good.

Now I have another dimension called Product.

When the user pulls product and net sales into the report (without location anywhere in pictures), he sees total sales instead of Total sales excluding Canada region.

Can any one help me and explain me how to achieve this.

Thanks in Advance.

Offline stan.parker

  • Full Member
  • ***
  • Join Date: Oct 2016
  • Posts: 29
  • Forum Citizenship: +0/-0
Re: Security in Dynamic cubes
« Reply #1 on: 27 Oct 2016 02:40:04 pm »
When you added security did include it on the product dimension as well?

Offline akshara_a

  • Full Member
  • ***
  • Join Date: Sep 2015
  • Posts: 17
  • Forum Citizenship: +0/-0
Re: Security in Dynamic cubes
« Reply #2 on: 27 Oct 2016 02:54:38 pm »
No I haven't. How do I include it on Product dimension. There is no field on Product dimension specific to Country.

Moreover, I want the user not see Canadian Sales included in Net Sales when they just pull the NetSales measure irrespective on any dimension.

Offline bus_pass_man

  • Statesman
  • ******
  • Join Date: May 2008
  • Posts: 252
  • Forum Citizenship: +31/-0
Re: Security in Dynamic cubes
« Reply #3 on: 27 Oct 2016 07:06:34 pm »
"Cognos Dynamic Cubes security does not support visual totals, which means that the
summary values are not adjusted when some of the lower-level members are hidden (except
as described in 9.14.5, “Cognos Transformer Exclude option” on page 317). For example, if
measure values for cities in a country are returned along with the total for the country, the
value of that total does not change if some of the cities are hidden due to security restrictions"

Have you tried 9.14.5 Cognos Transformer Exclude option

 


       
Twittear