Handling Confidential Data
3 posters
Page 1 of 1
Handling Confidential Data
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.
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
Re: Handling Confidential Data
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.
Re: Handling Confidential Data
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?
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?
Similar topics
» Is it a best practice that Data warehouse follows the source system data type?
» difference between data mart and data warehouse at logical/physical level
» clickstream fact data coming in with different levels of dimensional geography data
» Tracking of historical data using SCD2 in a non-dimensional data model
» Reporting table data repository vs. Dimensional data store
» difference between data mart and data warehouse at logical/physical level
» clickstream fact data coming in with different levels of dimensional geography data
» Tracking of historical data using SCD2 in a non-dimensional data model
» Reporting table data repository vs. Dimensional data store
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|