Problem between the range

building semantic layer
1

Hi

I created a universe which contains Time Period, it has year, quarter and month objects(( just pulled database column for all). The values in the table for month are ‘02’, quarter are ‘Q2’ and year are ‘2004’…

I want to generate a report between the prompt Mar’2003 and Feb ’ 2004 data. i want to get the data between this period like montly data. How should I approach this report. Should I have to create the object in designer itself or in the report ,can I do the prompt. if so please give me an example.

Regards, Amr

amr007 (BOB member since 2004-06-25)

2

Your best bet would be to prompt the user for Month Number (1, 2,…, 12) and not Month Name (January, February,…, December).

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

3

I’ve seen cases where people format such data as “Year_Month” in the format YYYYMM to make both the “between” and the sorting work more easily and intuitively. Otherwise, you could follow the advice I just gave Ravi about looking for Steve Krandel’s Smart Calendar in his 2003 Conference presentation on Empowering End Users Through Smart Universe Design.

Anita Craig :us: (BOB member since 2002-06-17)

4

You may also want to take a look at this thread, we’ve just maintained a discussion on a similar topic and there are some examples there.

mprost

mprost (BOB member since 2003-05-29)