Skip to main content

Comparison of Possible Widget Data Sources

Comparison of Possible Widget Data Sources

Pivot tables are the most common kind of data source for a widget on a dashboard. The system provides many other kinds of data sources. You can directly use any of the following items as data sources:

The following table compares these items:

Feature Pivot Tables KPIs Plugins Production Business Metrics
How definition is stored Folder item Class definition Class definition Class definition
Where defined Analyzer Studio Studio Studio
Data source options MDX query

  • MDX query

  • SQL query

  • Values returned by custom code

MDX query Values returned by custom code
Supports custom computation using lowest-level records? No No Yes No
Supports filtering? Yes Yes, depending on your implementation Yes, depending on your implementation No
Supports custom filtering (for example, provide user with only a subset of the members of a level)? No Yes, depending on your implementation Yes, depending on your implementation No
Supports listings? Yes Yes, depending on your implementation Yes No
Supports the Mini Analyzer? Yes No No No
Next sectionHigh-Level Summary of Options
Previous sectionItems That You Can Use in Calculated Members and Measures
FeedbackOpens in a new tab