ReportServer Forum

Walter

Member

Registered: 2016-07-12

Pivot/Saiku with script datasources

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,

---

Walter

karolina

Member

Registered: 2014-08-09

Re: Pivot/Saiku with script datasources

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

Walter

Member

Registered: 2016-07-12

Re: Pivot/Saiku with script datasources

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.

---

Walter