Not sure how you'd go about it but instead of redirecting maybe you can replace the error 500 page with your own custom one?

You might need to put quotes around your values too. I have done something like this in the past but can't remember what/how so just throwing out ideas that may or may not work!

Can see a missing bracket there but assume it was just lost in copy/paste. What was the error?

You could put logic into a filter. Create a filter and then tick convert to SQL

Most browsers these days have an 'Inspect Element' or similar function these days if you right click on something. I often do this to see what is going on in regards to spacing etc. Is it just expanding your analyses (or sections/columns containing them) to fit the full page width? Can you try limiting the width of the…

Whenever I need to add leading 0s to something I always just prefix 0 to everything and then take the substring/right of the string e.g. here is an example in Excel. I don't know what the best method is for performance but I like the simplicity of this.

So the next question is.. has anyone got a study guide for Christian's interview catalog?

How about thinking about this a bit differently Assuming beginning time will always be less than end time and there will only ever be a beginning time and optionally an end time. Assuming column names are "ID", "TIMETYPE" and "TIME" Can you 1. select ID, Min(Time BY ID) AS "Start Time", Max(Time BY ID) AS "End Time" 2. and…

If you were really desperate (or like exploring) you could use a Narrative View to do it with an external javascript library such as D3. There are a few articles such as this one which talk about how to do it in OBIEE.