Webi Properties SAMPLE result set option
I've a client requirement that Webi report should generate random number of rows while refresh on open.
i've got the info. that by enabling SAMPLE RESULT SET on webi properties it should work but unfortunately the option was disabled for me.
May i know how to enable this option?
Your expert suggestions are most welcome..
P.S:I've all the authorizations on Webi Application.
Screen shot attached
Amit Kumar replied
What is your backend data base?
Not all databases support fixed and random sampling. If they are not supported, the properties are disabled (in the Java Report Panel) or invisible (in Query - HTML). Sampling is not available at all in the HTML Report Panel.
This option is available in relational .unx, but not available in OLAP .unx or BEx queries.