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
But 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 my not
getting any ideas on these selections.
plz give me suggestions.
Regards
Sk BABU
Edited by: Sk Babu999 on Nov 27, 2010 11:36 AM