ReportPortal: Zero-footprint OLAP client for Microsoft Analysis Services

ReportPortal

All Forums

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:

UserName:

Password:

Anti-Spam Code:

Message:

* HTML is ON
* Forum Code is OFF

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
WildCard	Posted - 03/08/2017 : 07:18:49 Hi, how can I create a line chart in SQL reports that has for instance years on X-axis with a measure like 'number of orders' on Y-axis and separate lines for the members of a second dimension like suppliers? In OLAP reports I can do that by simply dragging the suppliers in the lines, the years in the columns and number of orders in the measures. But is there a way to achieve that in SQL reports?
1 L A T E S T R E P L I E S (Newest First)
admin	Posted - 03/08/2017 : 11:57:58 Which database do you use (SQL Server, Oracle, MySQL)? In SQL Server you can use the PIVOT function to transform the data from rows to columns: http://stackoverflow.com/questions/15745042/efficiently-convert-rows-to-columns-in-sql-server http://stackoverflow.com/questions/2421721/pivoting-on-a-column-without-knowing-the-entire-list-of-values You can also try using the ROLAP report.

ReportPortal