Running month

building reports webintelligence
1

Hi All,

I have to develop a report which will be schduled 5th or 6 th of every month. The report should fetch the previous month data. i.e if the report is scheduled on 5th june the report should fetch May’s data. Also in the report i have to fetch rolling 13 months data.

I have used the Fiscal calendar tableand created objects for running month, Year . I have developed a condition for rolling 13 months by using runniong month.
I have developed my report by asking the running month in the prompt. If i select the running month then the report will fetch rolling 13 months data based on the running month.

But my requirement is i have to devlop a condition that automatically takes the previous month as running month and from that it should fetch 13 months.

Can somebody help in getting this issue resolved.

Regards
Vasanth

vasanth (BOB member since 2008-06-05)

2

HI,

I have same requirement for Quarters…

Please someone help out…

Thanks

BOCP (BOB member since 2007-07-02)

3

Hi,

What happend if you create an object like month = currentmonth()-1 and use this in the Report prompt just by selecting “Object” for operand instead of "Prompt/Constant/Values from list.

madhu kothamasu :us: (BOB member since 2007-07-31)