Handling Confidential Data

View previous topic View next topic Go down

Handling Confidential Data

Post  DilMustafa on Tue Mar 29, 2011 1:35 am

Col 1 Col 2 Col 3 Col 4
1 abcd 56.37 45
3 def 34.45 34
5 edk 23.45 34

I have a question about handling confidential data in Dimensional Model. Here in the above mentioned example RED is confidentential. Confidential data is at the table element level. There could be few elements is a row which could be confidential etc.
How this kind of scenerio would be handled by tools like BO in analysis? Your comments are much appreciated.

DilMustafa

Posts : 49
Join date : 2009-02-03
Location : Calgary, Canada

View user profile

Back to top Go down

Re: Handling Confidential Data

Post  ngalemmo on Tue Mar 29, 2011 9:21 am

The usual approach in BO is to use user security to restrict access to objects in the universe and/or apply filters to the data. You could also create different universes with different visibility into the database.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Handling Confidential Data

Post  John Simon on Tue Mar 29, 2011 11:09 pm

The question doesn't make sense to me.
I can understand that all credit card numbers would be stored, but masked or encrypted. But it doesn't make sense to me that some columns would be encrypted on some rows, and other columns on different rows.

Can you provide an example of this?

John Simon

Posts : 186
Join date : 2009-05-29
Location : Melbourne, Australia

View user profile http://jsimonbi.wordpress.com

Back to top Go down

Re: Handling Confidential Data

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum