Skip to Content
0
Nov 26, 2010 at 12:39 PM

report on selections problem

25 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

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