(v23) 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
• Using a data cube to join tables

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
• 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

• 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