Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Handling Confidential Data

3 posters

Go down

Handling Confidential Data Empty Handling Confidential Data

Post  DilMustafa 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

Back to top Go down

Handling Confidential Data Empty Re: Handling Confidential Data

Post  ngalemmo 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.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Handling Confidential Data Empty Re: Handling Confidential Data

Post  John Simon 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

http://jsimonbi.wordpress.com

Back to top Go down

Handling Confidential Data Empty Re: Handling Confidential Data

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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