Display Timestamp for weekly monthly reports

building reports webintelligence
1

Hi,

I need to display the previous week or previous month in the report name.

It should be something like this say for previous week.
Sales_Revenue_Report- Week 05/17/2010 - 05/ 21/2010.

Reports are webi XI 3.1 and the output is stored either as .pdf or .xls format.
BO XI 3.1 and Oracle 10g

Thanks
Ram

Ram31 (BOB member since 2004-11-29)

2

How are you creating the date restriction in the query?
For the sake of my answer, I’ll assume you have a prompt that the user answers when running the report. let’s say the prompts are “from date” and “to date”.

your title can then be

="Sales_Revenue_Report- Week " + FormatDate(ToDate(UserResponse("from date");"MM/dd/yyyy HH:mm:ss");"MM/dd/yyyy") + "-" + FormatDate(ToDate(UserResponse("to date");"MM/dd/yyyy HH:mm:ss");"MM/dd/yyyy")

another option, is to use the date object on which you’re querying, and put miin([your date object]) and max([your date object]) in the title.

Once I have more information on how you’re restricting your dates, I can give you a more accurate answer.

-Ethan

ethan1701 :israel: (BOB member since 2004-05-05)

3

Hello Ethan,

Yes you are correct,we have From & To date as prompts in our webi reports. I shall try out

="Sales_Revenue_Report- Week " + FormatDate(ToDate(UserResponse("from date");"MM/dd/yyyy HH:mm:ss");"MM/dd/yyyy") + "-" + FormatDate(ToDate(UserResponse("to date");"MM/dd/yyyy HH:mm:ss");"MM/dd/yyyy")

Thanks for your help.
Ram

Ram31 (BOB member since 2004-11-29)

4

Ethan,

I tried:

="Sales Revenue " + FormatDate(ToDate(UserResponse("Enter Date (Start):");"MM/dd/yyyy HH:mm:ss");"MM/dd/yyyy") + "-" + FormatDate(ToDate(UserResponse("Enter Date (End):");"MM/dd/yyyy HH:mm:ss");"MM/dd/yyyy")

When I save the report in .pdf this is what I get

%3D%22Sales Revenue_%22_%2B_FormatDate%28ToDate%28UserResponse%28%22Enter_Date%28Start%29%3A[1]

Complete report name is not saved.

This is a webi report and these reports are scheduled reports. So the question is how do the date take effect?
Should we write a deski report with some java code and then when we save these scheduled reports in .pdf the from_date and to_date can be suffixed.
Please advice?

Thanks in Advance
Ram

Ram31 (BOB member since 2004-11-29)

5

Hi,

Can you try this

=“Sales_Revenue_Report- Week " + Replace(UserResponse(“from date”);“12:00:00 AM”;” “)+ “-” + Replace(UserResponse(“to date”);“12:00:00 AM”;” ")

Thanks,

Arun

aroonkaury (BOB member since 2007-06-08)

6

Ram, first of all, did you get the correct result in the Webi doc before converting to pdf? Or check the “Read Cell as” properties.

cyg (BOB member since 2004-06-14)

7

When you say correct results in webi before converting to .pdf, the webi report should display the name with the dates right? No I do not get the correct results in the webi reports.
“Read Cell as” properties-- can you please explain.

Thanks
Ram

Ram31 (BOB member since 2004-11-29)