on 11-05-2015 10:14 PM
Create a prompt that prompts the user to enter either [Post Date] or [Service Date].
The user MUST choose one or the other but not both.
WebI
SAP BusinessObjects BI Platform 4.1 Support Pack 4
Version: 14.1.4.1327
Has anyone been able to make something like this work?
Hello Jennifer,
You can create a simple variable like :
if (UserResponse("prompt_1") <> "" and UserResponse("prompt_2") <> "" ) then 1 .
Then filter the body of the report with your variable value not equal to 1.
Put a table at the header of the report, with the formula : hide when variable not equal to 1. And write a notification message at one of its cell to notify users that they should enter only 1 prompt value.
So basically, if they enter both prompt values they will see a blank page and an alert message at the header, else they will see the report itself. Though in both cases, background queries will run so users would have to wait a while even though they would see only a reminder message.
Regards,
Onur
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I think I have an answer for you. It is moderately complex and certainly not without its drawbacks, but I believe it will achieve your objective.
There are five basic steps...
In my example I am going to use a universe of mine that has accounts and look at their open and closed dates which will correlate to your Post Date and Service Date dimensions. The attached document has related screen shots.
This is not a perfect solution, but I hope you can make it work or it give you an idea of something else to try.
Noel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
72 | |
11 | |
10 | |
7 | |
6 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.