Home » Archived » BIRT » Dataset that this chart uses has been changed. This chart can no longer be rendered.
| |
Re: Dataset that this chart uses has been changed. This chart can no longer be rendered. [message #1376554 is a reply to message #1375681] |
Fri, 23 May 2014 13:15 |
Marc Arbour Messages: 36 Registered: March 2014 |
Member |
|
|
It will not be possible to include a rptdesign with a sample database for the implications would be to much work just to export the tableS required.
The thing is I have a very complex query for the dataset, which is
with param as
( select ? p_ANFIN, ? p_per_fin, ? p_semaine_id, 1 p_dme, 1 p_dmo, '1,2,3,4,5,6' p_salle, ? niveau from dual)
--SELECT count(*) --f.*, t.*, s.*, sp.*
select f2.groupement_id, f2.groupement, f2.titre, f2.id_salle, f2.desc_salle, sum(f2.dmo) dmo_som, sum(f2.dme) dme_som, count(dmo) dmo_count, count(dme) dme_count
from (
SELECT f.dmo,
f.dme,
s.id_salle,
s.desc_salle,
case
when param.niveau = 1 then to_number(t.anfin_id)
when param.niveau = 2 then to_number(t.perfin_id)
when param.niveau = 3 then to_number(t.semaine_id)
else to_number(t.JOUR_SEMAINE) end groupement_id,
case
when param.niveau = 1 then t.anfin_desc_courte
when param.niveau = 2 then 'P'||to_char(t.perfin_id)
when param.niveau = 3 then to_char(t.semaine_id)
else t.jour_desc_courte end groupement,
case
when param.niveau = 1 then ''
when param.niveau = 2 then ANFIN_DESC
when param.niveau = 3 then PERFIN_DESC
else SEMAINE_ANFIN_DESC_COURTE end titre
FROM DIM_TEMPS t
left join FAIT_BLOC_OPERATOIRE f on ( t.id_jour = f.id_jour)
join (select s2.* from dim_salle_bo s2, param
where id_salle in (
select regexp_substr(param.p_salle,'[^,]+', 1, level) from dual
connect by regexp_substr(param.p_salle, '[^,]+', 1, level) is not null ) or param.p_salle is null
)s on ( f.id_salle = s.id_salle)
join param
on ((t.ANFIN_ID = to_char(param.p_anfin) or param.p_anfin is null )
and (t.PERFIN_ID = param.p_per_fin or param.p_per_fin is null )
and (t.SEMAINE_ID = param.p_semaine_id or param.p_semaine_id is null )
and (( f.flg_dmo = to_char(param.p_dmo) and f.flg_dmo = 1)
or f.flg_dme = to_char(param.p_dme) and f.flg_dme = 1)
) where t.id_jour <= ( SELECT max(dT_REF) FROM IS_BI_PROTO.DATE_REFERENCE_TMP)
) f2
group by f2.groupement_id, f2.groupement,f2.titre, f2.id_salle, f2.desc_salle
this creates me some columns I use for naming stuff in my report in a cross tab.
But the thing is that I have a graph based on another crosstab and as soon as I put some code with the expression builder to dynamically pass a parameter to my drill through, I receive this error message. As found here there are absolutely no explanation on this error message.
I hope it helps you help me.
Regards.
MArc
[Updated on: Fri, 23 May 2014 13:16] Report message to a moderator
|
|
| | | |
Goto Forum:
Current Time: Fri Mar 29 00:55:44 GMT 2024
Powered by FUDForum. Page generated in 0.02524 seconds
|