(v24) Quick Start Reference- Managed Dashboards and Reports Data Stores

Quick Start Reference- Managed Dashboards and Reports Data Stores

This applies to: Managed Dashboards, Managed Reports

Data Cubes

• Data Cubes

• Design a Data Cube

• Create a New Data Cube

• Data Cubes - Blank

• Data Cubes - Manual Select

• Data Cube - Data Input

• Data Cube - Python Data Generator

• Data Cube - R Data Generator

• Edit a Data Cube

• Data Cube Data Storage Options

• Data Cube Storage Preparation and Use

• Refresh Data

• Using a Bridge Parameter

• Using Manual Select Placeholders

• Using TRACE Statements

• Writing Data Scripts with DundasScript

• Data CubesData Cubes

Working with Data

• Add a Relationship Between Tables
  

• Add a Slicer Comparison

• Adding Contextual Measures

• Automatic Joins and Hierarchies

• Create a Metric Set and Add a Filter

• Create a Ragged Hierarchy

• Create a Time Dimension

• Define Custom Hierarchy Sorting

• Define Custom Measure Sorting

• Displaying Top/Bottom Records

• Exclude Data Points from the Visualization

• Expand and Collapse Hierarchy Members

• Formatting Text

• Group Members During Analysis

• Handling Missing Data

• Handling Null Value in a State Indicator Column

• How To Create a Custom User Hierarchy

• Promoting an Auto-Generated Metric Set

• Set or Reset the Default Time Dimension

• Setting Up Data Input

• Set Up States on a Metric Set

• Slicers Versus Columns and Rows

• Use Metric Set Query Hints

• Using a Custom Total Calculation

Transforms

• Using Transforms

• Give a Friendly Name to a Transform

• Clustering predictions using R language analysis

• Display 'top N + other' Measures Using Data Cube Transforms

• Display 'top N + other' Measures Using Stored Procedure

• Filter Data Cube Using Complex Logical Expression

• Passing Parameter Value From Dashboard to Stored Procedure

• Passing Placeholder Value From Dashboard to Manual MDX Select

• Replace '(Empty String)' Text With Empty Value

• Re-Wire the Data Flow

Select Transforms

• Data Cube Select

• Data Input

• Manual Select

• MDX Select

• SQL Select

• Stored Procedure Select

• Tabular Select

Common Transforms

• Aggregate

• Calculated Element

• Data Conversion

• Filter

• Join

• Lookup

• Math

• String

• Union

Other

• Copy Element

• Flatten JSON

• Flatten XML

• Fusing

• Fuzzy Grouping

• Fuzzy Lookup

• Merge

• Null Replacement

• Percentage Sampling

• Pivot

• Install Python

• Python Analysis

• Python Data Generator

• Install and Configure R

• R Data Generator

• R Language Analysis

• Rank

• Record Sampling

• Remove Duplicates

• Sort

• Top/Bottom

• Transpose

• Unpivot

Output

• Process Result