last quarter

building reports desktopintelligence
1

Hi all,

I want to show me the report like that,

Comp name, Current year,Last year, Last month,Last quarter.

Whenever i refresh that report it shows the report based on system date.
How can i solve this one

Cheers

thangavelu :india: (BOB member since 2004-12-14)

2

Can you give more details
How you are calculating Last Quarter?

Rameshkumark (BOB member since 2002-08-29)

3

my current quarter is 2005 q2. I need previous quarter column which is based on current sys date.

thant means i want q1. in 2005.
2)Assume my sysdate is 02-02-2005. In this case my previous quarter is 2004-q4. how can i achieve this level

thanks,

thangavelu :india: (BOB member since 2004-12-14)

4

Assuming you are using Oracle how about using to_char(sysdate,ā€˜Qā€™)-1?

Rameshkumark (BOB member since 2002-08-29)

5

Ask your universe designer to implement a smart calendar table, you could then have such neat measure objects such as Revenue YTD, Revenue MTD, Revenue This Quarter, Revenue This Quarter of previous year, etc.

Andreas :de: (BOB member since 2002-06-20)

6

You might want to ask your Universe developer to Create a Filter called last quater on lines like this:

your
date.field between (addmonths(trunc(Q,sysdate),-3)) and
(trunc(Q,sysdate)-1).

You can customize this depending on what db you are on and what delay you might want to incorporate.
I am sure this should work.
let us know.

BOB_DW (BOB member since 2004-08-26)

7

Hi,

Iā€™m using Teradata, there is no trunc functions. How to solve this one.

cheers

thangavelu :india: (BOB member since 2004-12-14)

8

Check this post for Teradata date formatting.

holmes (BOB member since 2004-04-27)