Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Subscribe

We created a new Web intelligence document base on a universe we created using designer and the SQL generated from the web intelligence document retrieves much more data than the report. Are there limitations on how many rows are retrieved? I have the "limit size for result set" unchecked in designer.

0 Likes

Know the answer?

Help others by sharing your knowledge.

Answer

Need more details?

Request clarification before answering.

Show replies
Show replies
View Entire Topic
Former Member
‎2008 Oct 15 4:08 PM
0 Likes

Is there a limit on the number of rows returned on the query level?

Show replies
Show replies
Former Member
‎2008 Oct 15 4:11 PM
0 Likes

Max rows and max time are both enchecked at the query level

Former Member
‎2008 Oct 15 4:29 PM
0 Likes

How many rows are retuned via Webi? 


=NumberOfRows([Query 1])

Former Member
‎2008 Oct 15 4:48 PM
0 Likes

Where do I see the number of rows?

Former Member
‎2008 Oct 15 5:06 PM
0 Likes

Create a variable in the Report.

For example,


x=NumberOfRows([Query 1])

Where 

[Query 1]

is the name of the data provider. (The square brackets are required.)

x contains the number of rows.

Former Member
‎2008 Oct 15 5:37 PM
0 Likes

Is the data provider the Universe name that we are using to build the Webi doc?

Former Member
‎2008 Oct 15 5:39 PM
0 Likes

No. It's the query name.

Former Member
‎2008 Oct 15 5:47 PM
0 Likes

I get a WIS 10006 error when I try and insert a free standing formula cell with this:

=NumberOfRows([Drug Utilization-Test])

Former Member
‎2008 Oct 15 6:38 PM
0 Likes

You can't use more than one query (name) with this function. Try creating one variable for each query.

Former Member
‎2008 Oct 15 6:42 PM
0 Likes

create the variable in designer?

Former Member
‎2008 Oct 15 6:50 PM
0 Likes

The NumberOfRows() is a report level function.

If you have 2 queries called Drug Utilization and Test, create 2 variables which return the number of rows in each query.

i.e.


     x=NumberOfRows([Drug Utilization]) and
     y=NumberOfRows([Test])

That said, I believe Webi (appears to be) returning fewer rows because because of the way Webi aggregates data.

How many rows does an export to Excel give?

Former Member
‎2008 Oct 16 5:15 AM
0 Likes

Hi Graham ,

Drag and Drop a Column in the Report which is not a Measure should be a dimension and Hide that perticular Object from the report

This should repeat the number of Rows.

Regards

Prashant

Former Member
‎2008 Oct 16 3:40 PM
0 Likes

That didn't seem to make a difference

Former Member
‎2008 Oct 16 7:24 PM
0 Likes

It looks like we are only getting around 1000 lines, the SQL returns over 200,000 records.

Ask a Question