Hi,
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.
Any ideas?
Thanks