IDT Retrieving 5000 rows

[Former Member]

Hello,

I have designed an IDT by using relational connection and published to Development environment.

But IDT retrieving 5000 rows only. In Query options Business layer, I have unchecked all the check boxs related to rows retrieval.

still IDT retrieving 5000 rows only.

Santhosh

[former_member4998]

Hi

Data is restricted/filtered at universe level and Webi level.

So check both the levels and un-check box and then save, export then check in the report.

If still able to see small amount of data Check any filters applied at Data foundation  and check any query filters applied at WebI level.

[CdnConnection]

Santhosh,

    Did you re-publish the Business Layer again?  It should pick-up the changes next time you refresh the query.

You can also try to force change with the Query by dragging additional objects.

Regards,

Ajay

[Former Member]

Thanks for the reply,

Even in Local also it's retrieving 5000 rows.