[Folder Structure in Jasper Server Library View]

Hi Carl,

How many reports will each user have? Using our latest Jaspersoft Server 5.5 will generate a custom homepage for each user with a list of the 10 recently used reports. (Each user will have a unique list).

 

[How to create domain with domain designer for a Neo4j data source]

Hi Justin,

Our Neo4j connector is not supported by domains. In order to develop reports for your Neo4j database, you will need to use iReport. As Neo4j was developed as a pilot, the way to create the report is not standard. Here is how you can do so.

1. Download iReport

• http://community.jaspersoft.com/project/ireport-designer

2. Create a report

• Create a new datasource and set JDBC DataSource field: org.neo4j.jdbc.Driver
• Set JDBC URL with the host and the default port: jdbc:neo4j://HOSTNAME:7474
• Leave username and password blank.
• Run iReport and add the Neo4j JDBC driver jar to the iReport classpath (tools -> options ->classpath).

3. Deploy the report to JasperReports Server

• Configure the report datasource to the JRS data source you created.

4. Run the report

Search for the report or browse to the report in the JasperReports Server repository.

[How to add support for a new database vendor?]

Hi Bob, 

My name is Assaf Broitman and I'm the product strategy manager for our alliances team. I will be happy to discuss collaboration between us. Please reach out to me in email: abroitman@jaspersoft.com where we initiate the discussion.

Thank you,

Assaf

[Japser Server AWS problem - Menus are not coming up in browsers]

Hi,

I apologize for the issues you are experiencing. As I couldn't reproduce the problem with our hourly offering, Can you please share the following information about your setup so I can dig a little deepr?

• Which AWS product is this? (Hourly, BYOL or self deployment)
• What is the instance size?
• Which user is used to log into the server?
• Were any changes to the permissions / rules made on the server?

Thank you,

Assaf

[Ad Hoc Dataset Row Limit is erroneously applied to timestamp filters]

Manny,

While I'm still waiting for a response on the row limit implementation. I did want to recommend one option that will resolve this issue.

As you are describing the need for report generation, you can use our Jaspersoft Studio Pro (Included with your AWS hourly license) which will allow you to build pixel perfect reports with extensive charting capabilities and advanced filters. You will then publish these reports to the server and they can be scheduled and shared with your users.

You can also use them as Topics which are canned queries loaded to memory in our ad-hoc desinger, only this time, they will be pre-filtered by your query.

Let me know if you need help getting your Jaspersoft Studio copy or have any follow up quesitons.

Thanks,

Assaf

[Ad Hoc Dataset Row Limit is erroneously applied to timestamp filters]

Hi Manny,

I'm part of our AWS team and I will follow up with our tehnical support to clarify this issue and see if we can work around the behavior you are experiencing.

Thank you,

Assaf

[New to Jaspersoft and Need help picking what software]

Thanks Paul.

 

Another important note. While Jaspersoft on AWS is the cheapest option for pay-as-you-go BI that is great for either development or production environments. For evaluation only, we do offer free ways to play with the software. Simply go here: https://www.jaspersoft.com/jaspersoft-business-intelligence-software-trial and you can find all the ways you can try out the software before committing on purchase, including our cloud AWS by the hour.

[Issues with Hive Connection in Jaspersoft Studio 5.5]

There are two options:

If this is for development, simply remove the authentication from your Hive database. Or if authentication is a requirement, please reach out to me at the email I provided above and I will give you the new beta connector.

 

Thanks,

Assaf

[Issues with Hive Connection in Jaspersoft Studio 5.5]

Hi Shree,

Thank you for reporting your issue. I'm happy to announce that our upcoming release of Jaspersoft Server will include authentication for the Hive datasource (among other exciting improvements). 

Please feel free to reach out to me directly if you are interested in getting access to the new beta Hive datasource at abroitman@jaspersoft.com

Thank you,

Assaf

[How JasperSoft can be used with AWS for monitoring/Reporting purpose.]

Hi,

 

The best way to answer your question is this. If you have the above data, stored in any of the many relational databases or big data stores like MongoDB, Hadoop Hive or Amazon Redshift, we can connect to it and report against it.

 

In this context, Amazon offers specific monitoring tools for their AWS echo system with their CloudWatch product. If what you are looking for is specifically monitoring your AWS servers, that will be the best tool to use. However, if you want to have a deeper analysis of historical trends of your servers and tie it to your application data, you can then pull the data from Amazon, store it, and use Jaspersoft to report against it.

 

Thanks,

Assaf

[How JasperSoft can be used with AWS for monitoring/Reporting purpose.]

Hi,

Jaspersoft for AWS is a full featured Jaspersoft Server Professional Edition in the cloud starting at under $1 an hour. With it, you will get access to our reporting, dashboarding and data exploration tools.

As we can connect to a wide range of databases including big data data stores such as Hive and MongoDB, you will be able to create reports and dashboards to track, explore and monitor your data.

If you have a more specific question, please let me know.

Thank you,

Assaf

[Connection refused in Jaspersoft Studio when connecting to Jaspersoft Server on AWS]

Hey Paul,

Just wanted to close this and make sure everyone has the answer. When connecting to JasperServer from iReport or Jaspersoft Studio, you do not need to specify a port. Simply use the full link to your Jasperserver login page.

Thanks,

Assaf

[Jasper 5.5 Installation problems]

Yes, this is most definitely possible.

To do so, you will need to export / import our repository. You can find the documentation of how to do it in our Jasper Reports Server Admin guide available for download from our support portal. (support.jaspersoft.com)

As an AWS customer, you get access to a free support package that includes access to the support portal and our premium documentation, if you signed up for support, you should have the credentials in the mail already.

 

Thanks,

Assaf

[Jaspersoft Studio Pro and iReports Pro]

Paul,

As an AWS customer, you are entitled for a license to our Jaspersoft Studio Pro edition. When you registered for your free support package, you should have received an email with your credentials to our support portal (support.jaspersoft.com).

You will be able to download JSS pro and get the license from there.

Thanks,

Assaf

[Connection refused in Jaspersoft Studio when connecting to Jaspersoft Server on AWS]

Hi Paul,

Can you please send me a screenshot of your conenction configuration here: abroitman@jaspersoft.com

I'm sure we can get it sorted out for you.

Thanks,

Assaf

[Exception occurred during AWS data source recovery: /public/FPS_DEMO. The vpc ID 'vpc-exxxxxxx' does not exist]

Hi,

Can you please confirm if you deployed your Jaspersoft for AWS using our cloud formation template or through 1-click / EC2 console?

[Jasper 5.5 Installation problems]

Hi,

As you observed, Jaspersoft community edition does not support Dashboards however, Jaspersoft does offer a low cost professional edition in the cloud starting at $1 an hour that includes support for dashboards, ad-hoc analysis and our new Jaspersoft Studio Pro.

See more details here: https://www.jaspersoft.com/cloud-analytics

Thanks,

Assaf

[Error 404 installing JasperServer on Ubuntu 12.0.4 - Amazon ec2]

What URL are you using to access the server, from the log it appears it is up and running fine.

Can you also confirm that your EC2 instance has a public IP accessible from the outside world on port 80?

Thanks,

Assaf

[Exception in ad hoc view with derived table]

Hi Kathleen and sorry for the delayed response.

Looking at the log, it seems there is an issue with the field is_new_user: "unable to resolve field ref for Id: is_new_visitor".

Can you please confirm the query of your derived table works from a regular SQL interface to your database?

Thanks,

Assaf

[Cassandra in Jasper ETL]

Hi,

Jasper ETL does not include the Big Data components of the full Talend suit. In order to get the Big Data connectors, the full Talend solution is needed: http://www.talend.com/products/big-data

[Documentation for input control on AWS server?]

Hi Steve,

You can find all documentations for Jaspersoft Server here: http://community.jaspersoft.com/documentation?version=9036 specifically, use the "JasperReports Server User Guide"

When creating reports from the server, your filters act as input controls to the end user. When you add a filter in your ad-hoc designer and save it as a new report (not just ad-hoc view). The new report, will have the filter you added as input controls.

Assaf

[Opening Server 5.5 - 2G dashboard in studio]

Hi,

Jaspersoft Studio (JSS) is the right tool. As you are an AWS customer, you are eligible to sign up for our free support package that includes access to the latest JSS release.

If you already signed up, you should have received a link to download. If not, you can get your free support package here: https://www.jaspersoft.com/store/aws-support . (Please note, you will be asked for your Amazon account ID and instance ID. If you do not know how to find these numbers, the easiest way to register for free support is by going to Jaspersoft AWS instance page - http://ec2-54-219-25-xxx.us-west-1.compute.amazonaws.com/jasperserver-pro/ . Delete the highlighted part, navigate to the page part and choose the "Get support" button that will auto discover your details).

Also, when trying to edit the report, please make sure you edit the actual report (14g.Performance Summary) and not the dashboard which is based on this report.

Thanks,

Assaf

[Creating a chart from a MongoDB document List]

Hi,

Does the query work when using iReport?

To work with our MongoDB connector you will need to use our query language, you can find more information here: http://community.jaspersoft.com/wiki/jaspersoft-mongodb-query-language

Thanks,

Assaf

[Creating a chart from a MongoDB document List]

Hi,

Does the query works when using iReport.

To work with our MongoDB connector you will need to use our query language, you can find more information here: http://community.jaspersoft.com/wiki/jaspersoft-mongodb-query-language

Thanks,

Assaf

[AWS Jaspersoft Performance]

Thank you for the extra details. I have a few follow up questions based on the above.

1. When using ad-hoc, are you using Topics or Domains? 
2. Can you please attach a screenshot of your ad-hoc cache after trying to run one of the reports which fail. (Go to manage -> server settings -> Ad-Hoc Cache -> Find your query). If you cannot add a screenshot, please share the results for the following:
   1. Query/Fetch
   2. Memory Used
   3. Rows (Click on the query to get this data point)
3. Please share the server logs for your query execution, to configure the server to track your execution do the following:
   1. As superuser, go to Manage/Server settings/Log settings, and set the following to DEBUG:
      • Ad Hoc cache activity (CachedData): Logs the lifetime of cached data sets
      • Ad Hoc AJAX requests (adhocAjaxRequests): Logs details about server requests for the Ad Hoc UI, including timings
   2. Run your ad-hoc report
   3. Search Jaspersoft server log for the events above (use name in parenthesis as the search term, i.e CachedData)
   4. Post the results

Thanks,

Assaf