#1 2019-01-04 13:45:15

FLU73
Member
Registered: 2018-10-25
Posts: 38

Error with Parameter in dynamic list

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

#2 2019-01-07 08:59:36

FLU73
Member
Registered: 2018-10-25
Posts: 38

Re: Error with Parameter in dynamic list

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

#3 2019-01-07 13:33:58

eduardo
Administrator
Registered: 2016-11-01
Posts: 1,204
Website

Re: Error with Parameter in dynamic list

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

#4 2019-01-08 16:14:11

FLU73
Member
Registered: 2018-10-25
Posts: 38

Re: Error with Parameter in dynamic list

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

#5 2019-01-09 07:51:09

eduardo
Administrator
Registered: 2016-11-01
Posts: 1,204
Website

Re: Error with Parameter in dynamic list

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

#6 2019-02-08 18:35:57

eduardo
Administrator
Registered: 2016-11-01
Posts: 1,204
Website

Re: Error with Parameter in dynamic list

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

Board footer

Powered by FluxBB