You are not logged in.
Pages: 1
Hello,
In dynamic list with pivot mode, when creating a parameter of type date or data source, I get the error message :
"Could not generate mondrian schema, Could not find parameter: 1"
Note that the base request can be executed without error :
select ....
...
from
.....
where
...
and "VBAP"."ERDAT" > ${start_date}
NB: the error still occurs when disabling the pivot mode
Offline
Hello,
According to another post about using parameter in Saiku reports : https://forum.reportserver.net/viewtopic.php?id=1307
It seems there is already the ticket RS-2973 logged to the dev team about this topic, isn't it ?
Offline
Hi FLU73,
I am not sure if the issue is the same, since RS-2973 is for adding support for Saiku reports. Pivot reports are based on dynamic lists and these should work.
Can you please try adding a simple text parameter to your query? E.g. select * from mytable where name= {param_name}
Does this work with your pivot report?
Regards,
Eduardo
Offline
Hi Eduardo,
Ok it's fixed, the problem was in the comments used behind the instructions, where there was the character '
Typically a french mistake ...
by example:
select "VBAK"."ERDAT" as ERDAT-- date de création dans l'entête de la commande
.....
from "VBAK"
Offline
Hi FLU73,
thanks for letting us know. I raised ticket RS-3260 for this (better handling of special characters in comments of sql query).
Regards,
Eduardo
Offline
Hi FLU73,
fyi,
ReportServer 3.0.6 will support parameters in Saiku Reports analogously as parameters in dynamic lists (https://reportserver.net/en/guides/admi … arameters/).
For example:
<SQL dialect='generic'>
select * from mytable
where myfield > ${myparameter}
</SQL>oder
<SQL dialect='generic'>
select * from mytable
where $X{IN, id, myparameter}
</SQL>Regards,
Eduardo
Offline
Pages: 1