Author Topic: Data Security in Cube?  (Read 10751 times)

Offline EarthDog

  • Community Leader
  • *****
  • Join Date: Mar 2010
  • Posts: 168
  • Forum Citizenship: +2/-0
Data Security in Cube?
« on: 25 Nov 2010 04:40:55 am »
Hi guys

I am relative new to Cognos (10 months) and i am know exploring the security possibilities.

ALthough Framework manager provides enough security options (Data Security,Pacjage Security and package security) i cant seem to find enough possibilities in Transformer models.

To explain myself:

I will be successfull in implementing our security model in FM packages. But i want to implement the same model in Transformer.

Is it possible to add lets say data security in Cubes WITHOUT having to create a seperate cube?

Example: I have a Sales Cube and i want some groups to be able to see everything but some Country specific managers to be able to see everything BUT for their OWN COUNTRY ONLY. Country is a filed in my main fact table. Can i add somewhere (like data security) in Transformer this requirement?

Sorry if this is a childish question...

p.s. mmm i see a similar post that says that it can be done through custom views, but i though that custom views can only filter members or measures as a whole....Some more manual reading i suppose
« Last Edit: 25 Nov 2010 04:43:19 am by EarthDog »
Cognos 10.2 / DW:MS SQL 2008 / ERP: JDEdwards 8.0

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,303
  • Forum Citizenship: +665/-10
  • Cognos Software Muppet
Re: Data Security in Cube?
« Reply #1 on: 25 Nov 2010 05:02:39 am »
Hi,

Yes, you can do this.  See the Transformer user guide, chapter 7.  There is a section on combining custom views with dimension views.

http://download.boulder.ibm.com/ibmdl/pub/software/data/cognos/documentation/docs/en/8.4.0/ug_cogtr.pdf

Regards,

MF.
Meep!

Offline EarthDog

  • Community Leader
  • *****
  • Join Date: Mar 2010
  • Posts: 168
  • Forum Citizenship: +2/-0
Re: Data Security in Cube?
« Reply #2 on: 25 Nov 2010 05:06:49 am »
YEap i just saw it ..thanks..

But why to use the combination.

Cant i use ONLY Custom views?

For example....

I have a group that needs to see only the member "GREECE" from dimension country. Cant i just make a custom view for this group and customize the dimension and Suppress every member except GREECE?

Cognos 10.2 / DW:MS SQL 2008 / ERP: JDEdwards 8.0

Offline dd926g

  • Associate
  • **
  • Join Date: Mar 2016
  • Posts: 2
  • Forum Citizenship: +0/-0
Re: Data Security in Cube?
« Reply #3 on: 26 Aug 2016 10:32:14 am »
Yes you can
Steps:
1. Open a model in Transformer and, from the Security menu, click Log On.
2. In the Logon dialog box, select the appropriate namespace from the drop-down list, and log
on as an authenticated user.
3. Open the Categories diagram for your model and click the Custom Views tab.
4. Right-click the Custom Views pane and click Create Custom View.
5. In the Custom view name box, type a name for the custom view.
6. If you are not logged on to the namespace from which you want to assign members, click Log
On, select the namespace from the drop-down list, and then log on as an authenticated user
for that namespace.
7. In the Custom View dialog box, click Assign Security, and then do the following:
User Guide 175
Chapter 7: Adding Security
● In the Select Users and Groups dialog box, click the appropriate namespace to expand the
available group and role entries.
Tip: To select individual users in the list, click the Show users in the list check box.
● From the Available entries list, select the security objects (roles, groups, and users) to be
assigned membership in the custom view and click the right-arrow button.
● When the entries you want appear in the Selected entries box, click OK twice.
The new custom view appears in the custom view list, the model dimensions appear in the
Dimensions list, and the measures appear in the Measures list.
8. To omit the dimension from the custom view, select the dimension and then click the Omit
button .
Tip: To reset a dimension to the parent or default view, select the dimension and then click the
Reset button .
9. To exclude a measure from the custom view, in the Measures list, clear the check box for that
measure.
10. In the Custom Views list, select the new custom view.
11. In the Dimensions list, select a dimension.
12. To create a custom view using the view operations Exclude, Cloak, Suppress, Apex, and Summarize:
● Click the Customize button .
● In the category viewer, right-click the categories and apply the view operations (Exclude,
Cloak, Suppress, Apex, and Summarize) until you achieve the desired effect.
For information about Transformer view operations, see"Customizing Cube Content with
Views" (p. 158).
Tip: To reset a dimension to the parent or default view, select the dimension and then click the
Reset button .
13. When you are finished applying view operations to the custom view, close the Categories diagram
and then, from the Custom Views list, drag the custom view that you want to associate to the
cube to the appropriate cube or cube group in the PowerCubes list.
14. Rebuild cube