Invalid Prompt Definition Error

building reports webintelligence
1

I have this dimension in my universe and it parses fine but when I add it to a Webi document I get an error. I have pasted the formula and error below. Any help would be great.

formula in the dimension;
dateadd(Month,-2,DateAdd(“D”, -1 * DatePart(“D”,@Prompt(‘Enter Value’,‘D’,‘Taskassignment_Request\Createddate’,mono,free))+ 1,@Prompt(‘Enter Value’,‘D’,’@Select(Taskassignment_Request\Createddate)’,mono,free)))

Error;
Invalid Prompt Definition.

Phreddyp :us: (BOB member since 2007-01-08)

2

Welcome to B:mrgreen:B.

Try this :
dateadd(Month,-2,DateAdd(“D”, -1 * DatePart(“D”,@Prompt(‘Enter Value’,‘D’,‘Taskassignment_Request\Createddate’,mono,free))+ 1,@Prompt(‘Enter Value’,‘D’,‘Taskassignment_Request\Createddate’,mono,free)))

I have removed @select in the second prompt. This may work.

Hope helful.

Regards,
Sukesh

sukrav :india: (BOB member since 2008-01-29)

3

That fixed it. Thank you very much.

Phreddyp :us: (BOB member since 2007-01-08)