BusinessObjects Board

Prompts

Hi
I have a question. My situation is

we have daily transactions for our business. can i display a prompt where we can select a single day or duration of days or default ( all days in a week)
where we can see the transactions for that corresponding day(s) ?
Can anyone please tell me how can we achieve this ?

Thanks
Harsha


reddyyvs (BOB member since 2004-08-24)

You’ll find directions to do that here in the Designer FAQ. :mrgreen:


MichaelWelter :vatican_city: (BOB member since 2002-08-08)

Hi
I don’t need cascading prompts.
I need all 3 prompts at one time…

user can give response any prompt he wants…

and the report should display according the user response.

can i achieve this?


reddyyvs (BOB member since 2004-08-24)

If I understand correctly, you want three prompts that show up at once, and, depending on the selection in the first and second prompt, you want the LOV for the third prompt to be filtered accordingly. Is that correct?

There’s no way to accomplish this, as the LOV is generated, not based on the values chosen in another prompt, but based on the LOV query created by the Designer.

So, the only way to accomplish this would be with VBA.


MichaelWelter :vatican_city: (BOB member since 2002-08-08)

Hi
No need of change of LOV’s.
we can have LOV file containing month, week, dates.
i want to keep 3 prompts
user can give response to any prompt …for the first prompts he can select date
for the second prompt, he has to select 2 dates…for the durations of dates.

for the third prompt, he has to select a week id …so that all days in that week will be displayed in the report

want to know whether we can achieve this ?

Thanks
venkata


reddyyvs (BOB member since 2004-08-24)

OK, I think I finally got it. You want all three prompts to be optional. User can fill in only 1 prompt and still get the data.

See this FAQ about how to get ALL included in your prompt options. Then, run your report, selecting ALL for all three prompts. Publish the report that way. Then, when a user runs the report, the prompts will still have ALL in them, and the users can change the one that they want, leaving ALL in the other two.


MichaelWelter :vatican_city: (BOB member since 2002-08-08)

I’m trying to implement the solution in the designer FAQ regarding allowing the user to enter * or ALL in a prompt. Below is a copy of my code. I’m getting a “Missing right parenthesis” error message and can’t figure out for the life of me why. Got any ideas? I’m working with designer 5.1.7 and Oracle 8.1

(@Select(Project\Employee Name) IN @Prompt('Select employee(s) or 
enter * for all employees','a','Project\Employee Name',multi,free) ) 
OR 
('*' in @Prompt('Select employee(s) or enter * for all employees','a','Project\Employee Name',multi,free))

Thanks,
Shelley

[added bbc CODE formatting for better readability - Andreas]


Shelley (BOB member since 2003-09-15)

Can you look at the real SQL code (the @Select being resolved) and post it?


Andreas :de: (BOB member since 2002-06-20)

This is the code behind the @Select:

TRIM(EMP_PROFILE.LAST_NAME)|| ', ’ || EMP_PROFILE.FIRST_NAME || ’ ’ || TRIM(EMP_PROFILE.MIDDLE_INITIAL)

Thanks!
Shelley


Shelley (BOB member since 2003-09-15)

Please, post the complete SQL code of your predefined condition.


Andreas :de: (BOB member since 2002-06-20)

I hope I’m including everything this time :oops:

Here is my object definition in designer:

(@Select(Project\Employee Name) IN @Prompt('Select employee(s) or 
enter * for all employees','a','Project\Employee Name',multi,free) ) OR 
('*' in @Prompt('Select employee(s) or enter * for all employees','a','Project\Employee Name',multi,free))

The actual definition of Project\Employee Name is:

TRIM(EMP_PROFILE.LAST_NAME)|| ', ' || EMP_PROFILE.FIRST_NAME || ' ' || TRIM(EMP_PROFILE.MIDDLE_INITIAL)

Is this what you were asking for? If not, please let me know how to find the additional information.

Thanks!
Shelley

[added bbc CODE formatting - Andreas]


Shelley (BOB member since 2003-09-15)

Open the properties for your object (the one where you use the @Prompt function) in Designer, in the Select box click the double arrow to the right, then check the box “Show object SQL”


Andreas :de: (BOB member since 2002-06-20)

aha … here it is:

(TRIM(EMP_PROFILE.LAST_NAME)|| ', ' || EMP_PROFILE.FIRST_NAME || ' ' || TRIM(EMP_PROFILE.MIDDLE_INITIAL) IN @Prompt('Select employee(s) or 
enter * for all employees','a','Project\Employee Name',multi,free) ) OR 
('*' in @Prompt('Select employee(s) or enter * for all employees','a','Project\Employee Name',multi,free))

Thanks!
Shelley


Shelley (BOB member since 2003-09-15)

Try:

   EMP_PROFILE.LAST_NAME IN @Prompt('TEST', 'a', , multi, free) 
OR 
   '*' IN @Prompt('TEST', 'a', , multi, free)

Andreas :de: (BOB member since 2002-06-20)

I get this error:

FROM keyword not found where expected


Shelley (BOB member since 2003-09-15)

This is sometimes caused by having reserved words “embedded” a field name. Can you try a different field temporarily (maybe NAME is a reserved word) and see if that parses?


Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

I still get the same error …


Shelley (BOB member since 2003-09-15)

Are you getting this error when trying to run a query in Business Objects Reporter? If so, please post the complete SQL code generated by Business Objects so we have something to go by :wink:

If you get this error when parsing the predefined condition on Designer you will have to do basic troubleshooting: Start with smaller code and add piece by piece to identfy which piece of code is causing the error.


Andreas :de: (BOB member since 2002-06-20)

No, I’m getting the error when I try to parse the code in Designer.


Shelley (BOB member since 2003-09-15)

OK:
What kind of object? Dimension, detail, measure or predefined condition?
What is the exact SQL code throwing this parsing error?
Is this SQL code part of SELECT or WHERE?


Andreas :de: (BOB member since 2002-06-20)