Cube is trying to create 'money' datatype
- Dominant language
- Rust
- Stars
- 20.8k
- Forks
- 2.1k
- Avg merge
- 1d 2h
- Merged PRs (30d)
- 181
Description
**Describe the bug**
Cube is trying to create Sales_Amount column with 'money' datatype on the Playground.
1. At first run, cube show working output
2. but when adding to preaggregation. It's shows an error.
below are preAggregations and Sales_Amount measure on Schema view
cubes:
- name: FactInternetSales
sql: SELECT * FROM dbo."FactInternetSales"
preAggregations:
- name: test2
measures:
- FactInternetSales.Sales_Amount
timeDimension: FactInternetSales.ship_date
granularity: year
- name: Sales_Amount
sql: '{CUBE}."SalesAmount"'
type: sum
**Expected behavior**
Sales_Amount column should be in numeric/sum type
**Data Source**
Azure SQL DB (AdventureWorks)
**Version:**
Stable (0.31.55) - cube cloud
Contributor guide
Assessment
This issue has not been assessed yet.