Skip to Content
0
Dec 01, 2010 at 04:51 AM

selection on report problems

24 Views

Hi Experts

I have requirement on Sales report. In this Requirement structure will be show below

In Columns Sales as on 1st Sales as on 5th Sales as on 10th Sales as on 20th Sales as on 30th

In Rows

April-08

April-09

April-10

May-08

May-09

May-10

.

.

.

Feb-08

Feb-09

Feb-10

March-08

March-09

March-10

How can take selection on Sales as on 1st, 5th ,20th, 30th

In my sales cube have time characteristics is 0CALDAY 0CALMONTH 0CALWEEK 0FISCPER 0FISCYEAR, Suppose

i can take 0CALDAY, its possible for only takes date only, means its show on 01.10.2010, but its not

possible for my selection, why means my requirement needs every month on 1st 5th 10th 20th 30th . And also

In rows how can take selection for april-08 ,april-09,april-10 to mar-08,mar-09,mar-10

atleast we are not getting any ideas on these selections.

plz give me suggestions.

Regards

Sk BABU