I’m working on 6.5. In the report user wanted to pick all the values for a particular prompt. Can u someone tell me how to do that. I thought of selecting all the values from the List of Values available but i get spool space error.
Moderator comment: Please do not use Instant Message abbreviations on BOB, such as “u” for “you”. We are an international community, and spelling out the words will make BOB easier for everyone.
You should read Cindy Claytons FAQ. It’s not much more than creating a predefined condition. In the prompt you state that ‘’ gives the user all the results. In the SQL-code you make a where-clause with two branches (or-statement) : one branch where the user inserts the values he/she wants, and one with '’, which results in all the results.
pseudocode :
@prompt = ‘user input’
or
‘*’ in @prompt
The FAQ is very clear, so you should give it a go.
Since your Database is teradata, i am asking you some questions that might be helpful to get rid of your problem.
Does your universe use views instead of table ?
If yes then ask your DBA to optimize the views since it might have been long time since he/she optimized it.
What is the spool size of your userid ?
If you don’t know the answer then go ask your DBA about Spool size of your userid.
how much spool space it takes to run BO SQL ?
If you don’t know then ask your DBA.
Once you know the answers of above questions, it will be lot more easier for you to follow the guiderline provided by other members, otherwise you will end up spooling out every time you make some changes to the SQL.