sure919
-
Posts
47 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Downloads
Everything posted by sure919
-
chk this link: https://community.jaspersoft.com/documentation/jaspersoft-olap-user-guide/v550/creating-xmla-connection
-
Hi, is there any fix or recommended workaround for this, i have noticed this in 5.5 pro Thanks, Sure
-
How to convert BO (Business Object) reports into Jasper-soft? Kindly help.
sure919 replied to ram.orchha's topic in Products
Hi Hozawa, can you please share the steps for adding Tabs as attached in the screen shot (in 5.5) Thanks, Sure -
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
-
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
-
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
-
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
-
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
-
Use Hyperlinks to drill down (having a link to another report)
-
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
-
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....
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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.
-
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
-
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
