-
Couldn't load subscription status.
- Fork 1.9k
Open
Description
Describe the bug
A clear and concise description of what the bug is.
Since this PR has been merged - querying in the BI tool to check counts results in an error rather than getting a count. With pushdown enabled - i wouldn't have anticipated this would be the expected flow if a count measure didn't exist.
If this is the expected outcome, then feel free to close!
cube(`Orders`, {
sql: `
select 1 as id, 100 as amount, 'new' status
UNION ALL
select 2 as id, 200 as amount, 'new' status
UNION ALL
select 3 as id, 300 as amount, 'processed' status
UNION ALL
select 4 as id, 500 as amount, 'processed' status
UNION ALL
select 5 as id, 600 as amount, 'shipped' status
`,
measures: {
count: {
type: `count`,
public: false
},
totalAmount: {
sql: `amount`,
type: `sum`,
},
toRemove: {
type: `count`,
},
},
dimensions: {
status: {
sql: `status`,
type: `string`,
},
},
});
view(`orders_view`, {
cubes: [
{
join_path: Orders,
prefix: true,
includes: `*`
},
}When doing a select count(*) on the orders_View it will error out..
Metadata
Metadata
Assignees
Labels
No labels