I am constructing a WebI report on top of a Universe, and I have a peculiar problem when including on of the rows. Please refer the screenshot below and the description which follows for details:
As you can see, I have included 5 different attributes to form a WebI report. Now, I checked the number of rows using the "LineNumber()" function, and it was only 313 as shown in Screenshot 2. However, on using the "NumberOfRows()" function, I am getting a different number (substantially larger) as you can see in Screenshot 1. However, when I reconstruct the same query WITHOUT the LegalGroupCode attribute included, the numbers show up correctly (Shown in the screenshots below):
I DO NOT HAVE any restrictions on the number of rows which can be fetched. I am NOT USING ANY FILTERS. Also, a point to be noted is that when the same "LegalGroupCode" is used in combination with other attributes (those EXCEPT the 4 shown in Screenshot 4), I have no problems. The no.of rows as per the function and the number of lines calculated are the same.
For your reference, this Universe has been built on top of an SQL Database. Can anyone please help me identify what the issue here could be?
Thanks and Regards,