PB dimension with differents date

[#1]

Hello,

i have a problem with a request from a client.

I expose the subject :

I ve some OW (orders works) which have a date of creation ( Date_cre), a date of start (Date_st) and a date of end (Date_end).

The Date_cre is relied on date of my calendar Date dimension.

I try to have one indicator by period and i don't succed :

1) the number of OW during a period (date)  which have a Date_st is on the period selected, and a date_crea(=date) wich dhould take all the values possible.

The problem with this request is that  i would like to have also the OW which has been creating before the period selected but it s a porblem besause i t s my dimension date=date_cre(ating).

So i build a table with period in dimension and i put this formular :

sum(${ <Date_cre={'>=$($min(Date))  <=$(=(max(Date))),

Date=

>

}

but  i doesn t work and i can't change the date_st as the new dimesion date.

i m not sure to be clear but if you have any idea to resolve this problem.

Thanks

Pierre

[CELAMBARASAN]

Hi,

     Try this expression

sum({ <Date_cre={">=$(=min(Date))<=$(=max(Date))"},Date=>} Sales)

Is this you have tried before?

Celambarasan

[#3]

hello Celambarasan,

thank for your answer but it doesn't work

the result of this expression is the same that i wrote before.

This expression doesn't give the OW or sales which have a Date_cre ( Date )  different of the Date concerned by the period.

Pierre

[#4]

hello,

is there any body who have a solution to resolve this probleme of dates with the set anlysis?

Maybe  do i change my script and create an other table?

thanks