Hi Guys,
I have created a universe. This univesre is using a SP in SQL Server 2005. SP is having a IN parameter which is of date type. I am able to create a webi report using the universe. Every time I refresh the query it prompts me for the date. (This date is nothing but a IN parameter in SP).I want to captutre this value and want to show in the webi report. I tried the webi function UserResponse but no success. It compiles but does not show value when report is ran. I am using BO R3 webi rich cilent and SQL Server 2005.
Also, I want to know if there is any other way to do this.
Thanks & Regards
Manish