Pivot/Saiku with script datasources

ReportServer (EN)
1

Hi folks,
When I try to edit the pivot of a Dynamic List, I got this message.

Is there a way to use a script datasource to create Pivot and Saiku reports ?

Thanks in advance,

2

Hi,

Pivot and Saiku require a relational database as a datasource.

Obviously, you can use RS scripts to load data into a database if you don’t want to use other ETL tools.

karolina

3

Hi Karolina,
what I like about the script datasource is the ability to use the queries, filters and multi database support my application already have, through web services.

I will think about other solution, maybe replication.
Thank you very much.