I would like to use new worksheet capability for my reports but I have very complex Oracle sql queries (db link, join between different schemas, timezone casting, partition, ..) and I think that is not so easy (or possible) to create the relative datamart and create the same query using QBE GUI.
My question is:
is it possible to use worksheet capability with a free hand sql (my custom sql), without create the datamart and use QBE GUI for query creation? for example using a custom datasurce from SpagoBI?
Your question is a very good point..
Now you can’t use a custom data source or dataset of SpagoBI as source of data for the worksheet.. But it should be a very useful feature and we’ve already started to move in that way.
Please contact us if you are interested to contribute for this extension..