Dynamic Sampling of query results

[Former Member]

Is there a way to implement dynamic sampling of expected result set in a way that we could invoke as a percentage of expected

results?

We are using Web Intelligence XIR3SP2.

[Former Member · Accepted solution]

Sampling is a built-in feature of XI 3.1. It occurs on the database server so the report server doesn't have to bear the load. If you build a query and then click the Properties tab on the top-left of the query panel, the properties includes a sample size.

[former_member207342 · Accepted solution]

Hi Dave,

where can i find more details on it. Have you written on this topic on your blog.

and kind of sampling algorithm is used in BO

Regards,

Kuldeep

[Former Member · Accepted solution]

I have tested Oracle only. Teradata has a "sample" command and I would hope that Web Intelligence would use that. The Oracle method involves the dbms_random package to assign each row a random number, then the query is sorted by that number and a limit is placed for the sample size.

I have not written about this on my blog yet, but it could be an interesting topic. Thanks for the suggestion.

[Former Member]

Less info, you have to elobarate the req.

Thank You!!