Views Explorer - Invalid query, check your DataSet schema

swagner · 2021-08-13T16:01:08+00:00

There was an error rendering this rich post.

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'

Find more posts tagged with

Accepted answers

MarkSnodgrass

@swagner Just watched someone encounter the same error as you. They fixed it by removing the group by column and then adding it back. Renaming the column does seem to be problematic though.

All comments

MarkSnodgrass

@swagner Just watched someone encounter the same error as you. They fixed it by removing the group by column and then adding it back. Renaming the column does seem to be problematic though.

swagner

@MarkSnodgrass that worked! thank you sir!

swagner

WizardOz

I just encoutered this issue - I added a fitler today and saved the file. Then I wanted to remove the new fiter I jut setup. it showed first my filters became cal_col1 and cal_col 2 and asking me remove the references. I deleted the fitlers, tried to reset it up, but now it shows the above error and I could not do anything. Please help. This is urgent.

Thank you

swagner

@WizardOz probably worth contacting your CSM if this is an urgent problem. My experience so far with Dataset Views is that they are a bit temperamental and quirky. I'm also finding that there is a specific order in which you should do things. Doing any Group By steps last is something I try to do which has caused less errors.

WizardOz

Thank you @swagner . I also found that View Explorer is unreliable :( and causing problems to down stream users

swagner

@WizardOz what kind of issues are your users having? So far for me, once you get through the learning curve Dataset Views are a great tool. Opening up some great possibilities for my use case. Let me know if you'd like to have a call to discuss. Sometimes "customer to customer" is a good way to figure things out. Happy to help where I can.

GrantSmith

@WizardOz

Have you tried removing all of your groupings and filters and then reapplying them?