Hey guys, hope someone can help me out with this because I'm starting to tear my hair out over it.

I built a query for a report with the SAP BI Webi in a chrome bowser, and I needed to add some custom script. To do so I added the fields that I wanted to add custom filters on and set them to be prompts with descriptive names so that I would remember the custom SQL I used;

Then I opened the View Script and toggled it to Use custom and subbed in the following over the prompt;

dbo.Data.Date >= DateAdd(month, -2, DateAdd(day, -DAY(GetDate())+1, GetDate()))
AND dbo.Data.Date <= DateAdd(day, -DAY(GetDate()), GetDate())

This works and brings back the previous two months of data no matter when in the current month that I run the report.

I needed to implement this same logic in another report so I did the same steps as before, but when I click the validate script or save buttons, the application just spins and never completes the validation or save.

I've tried making the query from scratch a few times and it will not let me either.

Anyone got any ideas what I need to do to be able to write over the generated SQL with my own, I don't think anything about my permissions would have changed.