ad-hoc reports switch datasource

[nandu_bc]

Hi All,

Please let me know if I can design ad-hoc reports (derived table,claculated fielda etc) such that the reports works across different datasource.

i.e, If I have created a ad-hoc report on mssql server , the same should also work if change the datasource to Oracle/db2/mysql.

Is this possible?

 

[nandu_bc]

Any help ?

Also adding ....

All databases will have same schema defined. Just swtiching the datasource in JS Domain should let report work across different DB's.

Help on this issue is much appreciated.

[nandu_bc]

Can we design domain such that , the ad-hoc reports works accross different Databases? if yes, plz furnish an example

[kcsekhar25]

I too have the same issue.

Is it possible to design domain suah that there are no hard coded sql queries and the domain can be used with multiple databases ?

regards

[kcsekhar25]

Hi,

CAn anyone please answer this question ? we want use profesional JS 4.1 for our reporting service.

 

regards,

 

Post Edited by kcsekhar25 at 07/06/2011 02:53

[nandu_bc]

Hi,

PLEASE REPLY AT LEAST "YES" or "NO"

 

I tried with simple queries  which work using applicationContext-semanticLayer.xml file. (simple functions)

But not for few complex queries.

am I  correct ?

[NandiniBC]

Not Possible using domain.

Consider custom datasource for your requirement.

 

-Sonata