Would like to take a prompt

building reports desktopintelligence
1

Hello THere,
I am using Deski and I hope to take a prompt from one report and place it in the same report in a different location.

Better yet, is it easier to prompt for the data? To accept data from the user?

ANy hints on how? Thank you.

mardi (BOB member since 2008-08-18)

2

I didn’t get you ?

Do you want to copy the prompt cell value ? Explain clearly… ?

BO_Chief :us: (BOB member since 2004-06-06)

3

Hi,

I didn’t get you too.
A prompt is a condition entered in the query panel on a object.
It enables the user who will execute the report to filter the results he wants to obtain.
So if you want to understand how prompts are working, go in the Query panel , drag a dimension on your condition’s section and select “equal to” as operator and “prompt” as object.
You will directly understand how prompt works.

I hope it will help you.

Best Regards,
Cédric Paumard

DeskI & WebI Developer
BI Toolkit - Offices in UK and Holland
http://www.bitoolkit.com

[bitk]Cedric (BOB member since 2008-03-10)

4

If you have a prompt defined in a universe, you can drag it in many reports as you wish. If not, you can go for the one suggested by Cedric above.(Dragging a dimension for which you need the user to be prompted,selecting equal to operator, Type a new prompt as operand and then by typing the prompt text like “Please select …”)

Simply yes…and yes…

As suggested above…

Jansi :india: (BOB member since 2008-05-12)

5

thank you. what I should have said was, would like to take a value each day from one cell and transfer it to another location in the same report each day to be calculated. For example:

backlog value number of calls new backlog valueA

next day

new backlog valueA number of calls new backlog valueB

next day

new backlog valueB number of calls new backlog valueC

Now, I physically type whatever the new value is and place it in the backlog value space before the report runs again the next day. Is there a way to do this automatically? I schedule the report to execute each day at about 6AM. After the report runs, I receive the new backlog value and I manually put it in place where the program prompts; like you would file in a date prompt. Instead of a date, I put in a number. I was hoping for a way to automate it.

mardi (BOB member since 2008-08-18)