Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try this expression
sum({ <Date_cre={">=$(=min(Date))<=$(=max(Date))"},Date=>} Sales)
Is this you have tried before?
Celambarasan
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
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