[Connecting jrxml report to XML/A connection]

chk this link: https://community.jaspersoft.com/documentation/jaspersoft-olap-user-guide/v550/creating-xmla-connection

[How to convert BO (Business Object) reports into Jasper-soft? Kindly help.]

Hi Hozawa,

 

can you please share the steps for adding Tabs as attached in the screen shot (in 5.5)

 

Thanks,

Sure

[Maps Pro]

Hi,

1. Is there any way to show legend as slider on the Map, as show in the link below

http://www.fusioncharts.com/explore/world-map-with-countries/

 

2. The markers seem to take the component (x,y) position (probably in pixels), is there any sample to gracefully show the markers along with Map data, something like i show numbers for all Entity and place marker for the top N entities.

Thanks,

Sure

[Where are the county codes/country codes documented?]

Hi Matt,

any pointers to get markers displayed on the Fusion Map (trying in JS 5.5), it looked strange to me, as the X,Y values were considered as coordinates rather than latitude or longitude.

thanks,

Suresh

[Drill down reports]

figured out what i was doing wrong!!! Thanks!! had to update the .js file mentioned in http://community.jaspersoft.com/wiki/creating-interactive-dashboards-using-javascript

[Drill down reports]

Hi,

'm trying to invoke this function from my report (5.5 pro) but getting hit by the below exceptions... can any one suggest the correct method to invoke the js function (in hyperlink --> Reference from a report)

TypeError: window.parent.replaceManyFrames is not a function

or TypeError: localContext.replaceManyFrames is not a function

 

Thanks,

Sure

[Exporters to DOC, OOXML, PPT, XLS and so on]

Code:

Recently, did wrote some code to allow exporting a report to PPTX format from Jasper Server,

all the files are written in Community version 4.2.1 



http://openbusinessanalytics.blogspot.com/2011/11/export-to-pptx-in-jasper-server.html



HTH

[Creating a Dashboard]

Use Hyperlinks to drill down (having a link to another report)

[JasperAnalysis Workbench 3.5.4 released]

Hello Mahi,

 

Let me try answering your questions

Could pls let me know how to implement drill-down on jasper report as we have developed few ireports and published into the jasper sever 2.1.

-- User Hyperlink functionality to drill-down feature. it woks in JS Studio and JServer.

i have a few queirs on jasper analysis.
Because we haven’t implemented/worked on jasper analysis

1) What is the workbench tool? -- GUI Tool which allows you to easily design your OLAP schema/Cube.
2) Can we do the drill-down in jasper server 2.1? - Yes use Hyperlinks
4) How to migrate jasper server 2.1 reports to jasper server pro 3.0. (Any separate tool for migration)- May you can try import/export command for this.

Hope this helps,
Sure

[XMLA-MDX reports on Jasper Server]

I'd set the property and copied the cincom-jr-xmla.jar and rex.jar ; but then the report never shows the result added to that i see warn messages on the tomcat console saying URL, Datasource and catalog are null....

[XMLA-MDX reports on Jasper Server]

Dear Lucian,

I have my Dashboards working in Jasper Studio (when using xmla-mdx) is there any eary way to deploy them on Jasper Server (i am using 2.0.1),

As an alternative i also able to deploy reports with modifications (using mdx as query language) on JS but have issues when I deploy the Dashboard. the issue is that the sub-reports are not getting displayed.

Any help is highly valuable for me.

Thanks,
Sure

[XMLA-MDX reports on Jasper Server]

Dear Lucian,

That report is working but has the query language as "mdx" and all my reports have query language as "xmla-mdx".

is there any work around for deploying "xmla-mdx" based reports?

Thanks,
Sure

[XMLA-MDX reports on Jasper Server]

Hi Lucian

Thanks for replying

I am not sure if I unerstand your question correctly; While in iReport i defined the connection to my xmla server and got the report working and in JS defined the XMLA connection and referenced it while adding the report unit.

hope this helps you to understand what i am doing.

Thanks,

Sure

[XMLA-MDX reports on Jasper Server]

Hi Lucian

Thanks for replying

I am not sure if I unerstand your question correctly; While in iReport i defined the connection to my xmla server and got the report working and in JS defined the XMLA connection and referenced it while adding the report unit.

hope this helps you to understand what i am doing.

Thanks,

Sure

[XMLA-MDX reports on Jasper Server]

Hi Lucian

Thanks for replying

I am not sure if I unerstand your question correctly; While in iReport i defined the connection to my xmla server and got the report working and in JS defined the XMLA connection and referenced it while adding the report unit.

hope this helps you to understand what i am doing.

Thanks,

Sure

[XMLA-MDX reports on Jasper Server]

Thanks Lucian,

I tried setting the property

net.sf.jasperreports.query.executer.factory.xmla-mdx=com.cincom.jasperreports.JRXmlaQueryExecuterFactory

The reports doesnt throw error upon execution but doesnt show result either. It displayed the following WARN Messages on Tomcat console

14:43:30,953  WARN JRXmlaQueryExecuter,http-8080-Processor22:62 - The supplied url is null.
14:43:30,969  WARN JRXmlaQueryExecuter,http-8080-Processor22:71 - The supplied datasource is null
14:43:30,969  WARN JRXmlaQueryExecuter,http-8080-Processor22:80 - The supplied catalog is null.

 

indicating that the XMLA  connection parameters are not being passed.

Any help is great!!

Thanks,
sure

 

[XMLA-MDX reports on Jasper Server]

Thanks Lucian,

I tried setting the property

net.sf.jasperreports.query.executer.factory.xmla-mdx=com.cincom.jasperreports.JRXmlaQueryExecuterFactory

The reports doesnt throw error upon execution but doesnt show result either. It displayed the following WARN Messages on Tomcat console

14:43:30,953  WARN JRXmlaQueryExecuter,http-8080-Processor22:62 - The supplied url is null.
14:43:30,969  WARN JRXmlaQueryExecuter,http-8080-Processor22:71 - The supplied datasource is null
14:43:30,969  WARN JRXmlaQueryExecuter,http-8080-Processor22:80 - The supplied catalog is null.

 

indicating that the XMLA  connection parameters are not being passed.

Any help is great!!

Thanks,
sure

 

[XMLA-MDX reports on Jasper Server]

Hello,

 

I am getting errors while trying to deplpoy my report (with query language as XMLA-MDX which runs fine on Jasper Studio) on Jasper Server. the error message is

No query executer factory class registered for xmla-mdx queries. Create a propery named net.sf.jasperreports.query.executer.factory.xmla-mdx

What changes I have to make to deploy the xmla-mdx based reports.

Looking for the kindest reply,

thanks,

Sure

 

[subreport with mdx query doesnt seem to work]

Hello,

 

I am trying to create a sample dashboard (using XMLA based connection and MDX Queries). The sub-report/child report independently works fine. But when i call it from the parent report (which has XMLA based connection and an MDX query) it just shows the data of the parent report, and the area of the sub-report is blank. nothing is shown. I am passing the parents reports Connection information to the sub-report.

 

My sample dashboards with SQL queries work fine.

 

Did any one try creating Sub reports that use MDX queries, if yes then please let me know how it was possible.

or is this a known issue?

 

Thanks,

Sure

[Not prompting for user/pass at logon]

Hi Lucian,
I copied the jar that you've attached to web-inf/lib folder and modified the applicationContext-security.xml
 

Code:

CONVERT_URL_TO_LOWERCASE_BEFORE_COMPARISON PATTERN_TYPE_APACHE_ANT /xmla=httpSessionContextIntegrationFilter, basicProcessingFilter, JIAuthenticationSynchronizer, anonymousProcessingFilter, basicAuthExceptionTranslationFilter, filterInvocationInterceptor /services [/code]

but was confused with the url http://.../jasperserver/...&j_username=..&j_password=..

could understand what to pass after /jasperserver/???
so that j_username and j_password are passed as parameters.

Waiting for you kindest reply,
Thanks,
Sure

[i18n in Analysis View]

Hi

 

I would like to know how to display schema object names in the selected locale in an analysis view.

 

Mondrian supports i18n, if we place variable names for schema object names in schema file, adding the property

mondrian.rolap.localePropFile

in mondrian.properties file, adding locale properties files, and using attributes dynLocale and dynResolver in a JPivot mondrianquery.

 

I would like to know how to achieve this in Jasper Analysis views.

Where do I set the JPivot attributes for setting locale for the MDX Query used in view.

 

Please clarify

[incorrect results with java.sql.Timestamp]

Hi,

 

I am trying to create a SQL report to display the record if they fall between the specified date&time range(ex: Nov 21, 2003 11 30 0 and Nov 21, 2003 14 30 0)

 

i m confused why the preceeding value is getting displayed in the report (ex: its displaying the record of Nov 21, 2003 11 18 ).

 

my DB is SQL Server, and the datatype that I am using is java.sql.Timestamp in iReport

 

Please help me on this.

 

Thanks, in advance

Sure.

[Hyperlink Reference Expression]

Hi,

 

I am trying to open a detailed report based upon the values clicked upon master report (field has hyperlink, the detail report is a parameterized report). I understand that to get this working i need to provide something in refrence Expression along with the parameter for my child report.

so what will be the hyperlink reference expression that opens a detailed report along with the parameter(value selected/hyperlinked).

This could be related to drill through. (i dont want to use subreports)

ex:- one reports shows product sales information. if i click the product name(which is hyperlinked to another report which is parameteriezed and accepts the product name to display the other product details) it should show the detailed report for the selected product.

I hope this example will help you to understand my problem.

 

Any help will be of high value.

 

Cheers!!!

Sure

[how does Jasper OLAP work?]

Hi Dreporter!!

 

As youve said that you are familiar with Jasper reports and wish to use OLAP reports you need to know few things

1. Mondrian is the OLAP engine

2. you can create connection to Mondrian OLAP thorugh jdbc or XMLA.

 

later can write queries (SQL and MDX)for your reports to access your OLAP Cube.

OLAP Cube is in XML format which contains the description of your star schema, dimensions and messures along with aggregates and calculated measures.

 

Your query hits the OLAP engine with has the definition to your OLAP data that helps to pull the information.

 

Hope this helps a bit.

Cheers!!

sure

[connecting to olap server with xml/ a]

Hi Jens Noering,

 

I need to look into your datasources.xml file. This file contains the

1. datasource information,

2. Catalog information (xml format). along with the DB info.

later the Catalog contains the cube information.

Could you please upload your "datasources.xml" file (you could find this in WEB-INF folder like "C:apache-tomcat-5.5.12webappsmondrianWEB-INF").

I am attaching my datasources.xml file, hope this helps

Cheers!!

Sure

[file name=datasources.xml size=1155]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/datasources.xml[/file]