---
schema_version: "1"
id: 3737ae37036f8fd68c6cfd1242b749f7dac796ae54cdd7f7ba6813d4b4ea0e4f
title: System Columns in Datasets
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_system_columns.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_system_columns.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: eafefb169685bd86eb564ca7b53f8c8edfb7badf68db58dc74b2927354a35be4
description: System columns are dataset columns that don’t appear in the CRM Analytics user interface, such as lenses or Dashboard Designer. For example, to enable dataset security based on the Salesforce role hierarchy, the Flatten transformation generates columns that store the role hierarchy details. To prevent a CRM Analytics user from seeing and querying these columns, flag them as system columns.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# System Columns in Datasets

System columns are dataset columns that don’t appear in the CRM Analytics user interface, such as lenses or Dashboard Designer. For example, to enable dataset security based on the Salesforce role hierarchy, the Flatten transformation generates columns that store the role hierarchy details. To prevent a CRM Analytics user from seeing and querying these columns, flag them as system columns.