FROM - TO Dates passed from prompt into the Title of the WEBi report

[Former Member]

What is the right approach to pass two reporting period dates (FROM /TO) from user's input into the Title(Header) of the Universe based WEBi report, like "Tickets submitted from:MM-DD-YY to:MM-DD-YY"

Maybe this is trivial but it is easier to do in CR and I am not sure how to do it using Universe objects.

These are my first steps in building real production Universe.

Thanks in advance!

Alex

[amrsalem1983 · Accepted solution]

i dunn know if i understand you well, but it seems like you want to pass 2 dates (from, to) to some report and to have those 2 dates in the report title.

its too easy, first at the universe level you have to have a Date objects, which comes in the time dimension.

when you create a report usin Webi, just drag this Objects to the query filter and make the operator "between" and make both of them "prompt"

give two texts to the prompts lets say "From Date" and "To Date",,,, and run the report.

at the report design mode there is a function called "UserResponse"

in the report title text add this =userresponse("From Date")

you can modify the text as you require.

good luck

Amr

[Former Member · Accepted solution]

Thanks a lot, Amr!

I will try it later today.

Alex

[Former Member · Accepted solution]

Just today I had time to deal with this report. Everything worked perfect as you suggested.

Thanks again,

Alex