I have 2 SQL Select statements from an oracle db in a script.
I'd like to create a calcuated field based on values from each of the 2 seperate SQL scripts. I know how to do this as a calculated dimension, but I'd like to use it in multiple objects in the report, so would prefer to put it into the load or have as some sort of global calculated dimesion.
Finally sussed the problem. For some reason, the script didn't like the field name having an _ in it. I renamed the field to remove the _ and it worked!!
