Hi All,
I am facing problem with prompts in webi BI 4.0 (SP4).
I have a parent webi report in which I have 5 Inputcontrols. I am capturing selected values by using formula "=reportfilter([object name])" and passing the values through hyperlink to child webi report.
I have one custom hierarchy in the universe with FA->Cate->SubCate. For FA I have 20 values, for Cate I have near about 100 values and for SubCate I have near about 150 values.
My problem is when I pass values with all the selected input controls, the child report is opeing but with less number of rows. This is because SubCate values are not passing properly. For example SubCate having 100 values to pass, it is passing only first 10 values or so and rest of the values are ignored. I don't know why this is happening. Is there any limit regarding prompts and prompts values in BI 4.0. INLIST parameter is set to -1 in universe.
Please help me on this.
Thanks & Regards,
Ravi.