[SL-1634] [Feature] Support Dimension-only queries for SCD dimensions #1019
Labels
enhancement
New feature or request
linear
Low priority
Created by Linear-GitHub Sync
Metricflow
Created by Linear-GitHub Sync
Is this your first time submitting a feature request?
Describe the feature
One use case for the semantic layer is generating unaggregated data sets for operational reporting. Think of questions like how many support tickets has this company created? The expected output is an unaggregated list of tickets that an operations team might use to evaluate customer health. Dimension-only queries are supported in the semantic layer today but don't work with SCD-type dimensions. For example, take the following schema:
The expected output is auction name, order_date and order_id where the order name is based on the validity window of the dim_auction semantic model.
We could create the following semantic models to model this relationship:
Then create a query that shows us the acution name, order date and order id
mf query --group-by metric_time,order,auction__auction_name --explain
This query currently errors out, and we need to add a dummy metric in order for this to work for example adding a count of orders which will always return 1 since we're looking at the data set at the order_id level.
mf query --metrics orders --group-by metric_time,order,auction__auction_name --explain
Dimension-onlyDescribe alternatives you've considered
You can work around this by adding a dummy metric and hiding it from the final view in the BI tool. This works, but we should support this natively.
Who will this benefit?
No response
Are you interested in contributing this feature?
No response
Anything else?
No response
From SyncLinear.com | SL-1634
The text was updated successfully, but these errors were encountered: