select distinct MONTH_NBR MONTH,sum(nvl(VALUE_NBR,0)) TOTVAL FROM
(
select c.time_id,c.VALUE_NBR VALUE_NBR
from tab1 a,tab2 c
where a.r_id=c.r_id
and (a.descr like '%Count')
) z, timedim b
WHERE
b.TIME_ID=z.TIME_ID(+)
GROUP BY MONTH_NBR
Output we're gettng for the above query ( Month_number - Value ):
(Basically we need to display over graph for all 12 months whether or not month have any value )
(....assume table of this )
1-0
2-0
3-54
4-65,
5-0,6-0,7-0,8-0,9-0,11-0,12-0
How can it be done in Business Objects? I could not find how the nested query can be defined in BO
while creating universe?? Your help is appreciated.
(
select c.time_id,c.VALUE_NBR VALUE_NBR
from tab1 a,tab2 c
where a.r_id=c.r_id
and (a.descr like '%Count')
) z, timedim b
WHERE
b.TIME_ID=z.TIME_ID(+)
GROUP BY MONTH_NBR
Output we're gettng for the above query ( Month_number - Value ):
(Basically we need to display over graph for all 12 months whether or not month have any value )
(....assume table of this )
1-0
2-0
3-54
4-65,
5-0,6-0,7-0,8-0,9-0,11-0,12-0
How can it be done in Business Objects? I could not find how the nested query can be defined in BO
while creating universe?? Your help is appreciated.