The Cubes Tab
The Data Source tab
Azure Data Market
European Central Bank
Google Big Query
Microsoft Office Access
SQL Server Stored Procedure
Windows Event Log
Working With Data Sources
Sharing your data sources or cubes
Date & Time
Math & Trig
Installing Data Service
Configuring Network Security
Working with data sources dragged to the work area
In the upper right corner of a data source you will find the sigma/sum symbol (Σ) that toggles a table between fact and dimension state and the burger-menu (Ξ) with the following options:
Generates a preview of the first 100 rows in the table
Controls what dimensions and measures that are visible in the cube on a granular level.
The dialog allows you to control what measures and dimensions are made visible in the cube.
- Maximum value
- Minimum value
- Average of values
- Count of values
- Sums up values
Show in folders only
- Controls whether measures and dimensions will be structured in a folder within the Data Source SmartPad in TARGIT.
- Determines whether a field will be available as a dimension.
For numeric data types aggregation types like Max, Min, Avg, Cnt, Sum are automatically created as well as dimensions
For string data Cnt (counts) and dimensions are available.
Hide all fields
- Hides all measures and dimensions derived from the data source. This over rules settings configured in the cube visibility-dialog.
- Removes the table (data source) from the workspace
Courage to Act
© 2017 TARGIT. All Rights Reserved.