on 05-12-2016 12:59 PM
Hi,
I am getting very less records than actual in backend in my webi report. Can someone help me with this?
Thanks
Neeshi
Hi,
Could you please check if you have set up row level security or have some limit on the no of rows retrieved from Universe level.
Also please check the no of rows at WEBI level on query properties.
Regards
Niraj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Neeshi,
On Niraj's note about Max row retrieval or Max retrieval time restriction options in the Universe parameters or Query properties, there is an easy to find if those options are activated. In the report, look at the right bottom corner, do you see an ! mark in a yellow triangle, which says Partial results, if yes, then one or both of those options has been set in the Universe parameters and/or Query properties, remove that restriction. It may also be Row level security setup in the Universe.
Try to create a simple report in the Webi and then, copy the SQL generated and run directly against the Database in SQL Query Analyzer or Aquadata or Toad or any other client tool and see what happens.
Thanks,
Mahboob Mohammed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.