I have created a simple dataset view that I would like to use in another dataset view... when I attempt to open it in views explorer I am getting the error message:
"Invalid query, check your DataSet schema"
Suggestions on how to trouble shoot?
The steps I followed to created the dataset view:
- Filter to exclude one value in a the 'Company' column (text)
- Add a custom column named "Attribute" with this as the entry 'Open AR' (text)
- Group on the two fields above, SUM 'Open Amount' column (decimal)
- Rename 'Open Amount' - 'Value
- Rename 'Company' - 'Business Unit'