trying to equate detail object and dimension object

[ksk2]

Hi All,

Pl take time to solve the below

iam having one userresponse which is checking the date condition and displying the result .

and once i get the result iam trying to equate userresponse (date) with another date field.

but BO is not allowing me to equate the fields coz when i call the userresponse in the cell or variable by default it is taking the field as detail object.

and my another date field is dimension..


e.g:

ename inv_date sal
__________________________

aa 10-jun-90 1000
bb 11-jun-90 2000
cc 12-jul-90 5000

and my date condition is on another field called eee_date

&quot;eee_Date <= prompt&quot;(here i will select 12-jul-2002)

so i will get all the three records.
and then iam trying to insert another column with

if userresponse date(eee_date) = inv_Date then 1000 else 0.

but bo is not allowing me to do this..

can any one help me.

thanks in advance.

ksk2

 

[blom0344]

hello ksk,

Try creating a report variable as a detail on the dimension inv_Date and check whether BO will then allow a comparison using the report variable instead of the dataprovider dimension. T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com