Strategy ONE
Security Filter
lu_security_filter
The list of Security Filter objects and the corresponding descriptive information from the MicroStrategy metadata(s) being monitored by Platform Analytics. For more information about Security Filter Objects, see Restricting Access to Data: Security Filters.
|
Column |
Description |
Data-Type |
|---|---|---|
|
security_filter_id |
The auto-generated numeric ID of the Security Filter object. |
bigint(20) |
|
security_filter_guid |
The GUID of the Security Filter object. |
varchar(32) |
|
security_filter_name |
The name of the Security Filter object stored in the metadata. |
varchar(255) |
|
security_filter_desc |
The detailed description of the Security Filter object. |
varchar(512) |
|
creation_timestamp |
The UTC timestamp for when the Security Filter was first created. |
datetime |
|
modification_timestamp |
The latest UTC timestamp when the security filter was modified. The timestamp will continually update as the security filter is modified. |
datetime |
|
security_filter_status |
The current status of the security filter. A security filter can have a status of: Visible Deleted Hidden |
varchar(25) |
|
project_id |
The numeric ID of the project. Security Filters are stored at the level of project and metadata. |
int(11) |
|
metadata_id |
The numeric ID of the metadata. Security Filters are stored at the level of project and metadata. |
int(11) |
|
owner_id |
The numeric ID of the corresponding security filter object owner. This column is not mapped to an attribute in the schema. |
bigint(20) |
|
security_filter_location |
The navigation path to the Security Filter in the project. For example: Platform Analytics\Project Objects\MD Security Filters |
longtext |
|
folder_guid |
MicroStrategy internal use. |
varchar(32) |
|
transaction_timestamp |
MicroStrategy internal use. |
datetime |
|
security_filter_version |
Version ID of the Security Filter. |
varchar(32) |
fact_action_security_filter_view
This fact table tracks which security filters were applied on a particular execution. By joining this table with the fact_access_transaction_view table, the user can analyze which Security Filters were applied for each execution. The Security Filter Sequence represents order the security filter was applied, when multiple security filters are applied during an execution.
|
Column |
Description |
Data-Type |
|---|---|---|
|
parent_tran_id |
The auto-generated numeric Parent Action ID. This is a source column for the Parent Action attribute. |
bigint(20) |
|
security_filter_id |
The auto-generated numeric ID of the Security Filter object |
bigint(20) |
|
security_filter_sequence |
The source column for the Security Filter Sequence fact. Represents the sequence order a security filter was applied when multiple security filters are applied during an execution |
int(11) |