Skip to Content
0
Former Member
Mar 06, 2015 at 11:06 PM

Webi Group BY issue

16 Views

BO 4.1 SP.

IDT Universe.

I have a stand alone View from db in unx. Straight out objects mapping each fields (no complex objects).

Only have 1 measure object (sum on minutes).

In webi, created a simple report. Select all object from the view, create a filter between on start and end "Procedure Date".

when 4 objects is selected, for Jan 2015, Feb 2015 and March 2015, result is fine.

as soon as 5 objects is selected, it limits the result to 1 month, and only Jan 2015.

DATA is there for sure. if works fine for 1 month, and with 4 objects in select statement.

here is the query:

SELECT

Table__8."cr_prdate",

Table__8."crp_admit_date",

Table__8."cr_status",

Table__8."crp_proc_descr",

Table__8."fac_mnc",

Table__8."fac_descr",

Table__8."room_mnc",

Table__8."surg_service",

Table__8."surg_descr",

Table__8."surg_urn",

Table__8."surg_mnc",

Table__8."pc_descr",

Table__8."proc_descr",

Table__8."crp_acct_nbr",

Table__8."crp_last_name",

Table__8."crp_first_name",

Table__8."Location_Name",

Table__8."PtType",

Table__8."PtTypeDescr",

sum(Table__8."cr_proc_len_minutes")

FROM

"CN------------PROD"."INTEG----------DM.dbo"."S-----------NUTES" Table__8

WHERE

Table__8."cr_prdate" BETWEEN {d '2015-01-01'} AND {d '2015-03-05'}

GROUP BY

1,

2,

3,

4,

5,

6,

7,

8,

9,

10,

11,

12,

13,

14,

15,

16,

17,

18,

19