Quick Start Reference - Managed Dashboards and Reports Data Stores Updated April 25, 2025 02:33 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 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 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 Related articles Data Cubes Visual Data Discovery Swagger API v25 Quick Start Reference - Connect to Managed Dashboards and Reports Data