anuradhamehra01

Thanks Matt for your inputs. But how would we implement this drill down. Can you please provide some sample reports or steps on how to build this drill down from 1 map to other and 1 chart to other. I had seen sample Map pro map example but that tell about simple Map creation not on how to link 2 maps or 2 charts. Would highly appreciate if I can get this information at the earliest. Thanks & Regards, Anuradha.

Thanks Matt. I had seen the sales by month report sample that come when we setup trial version of Jasper BI Suite v3.5 "\jasperserver-pro-3.5.1\samples\reports" The report seems to be somewhat dynamic and looks different from what can be seen on dashboard. PFA the .jrxml file which I found on above mentioned path and also the print screen of Supermart Demo Dashboard available on Jasper Server. the layout of .jrxml files looks different from the sales by month report seen on dashboard. Can you please guide me how hypelink has been created on the sales by month report so that when user click on April he is able to view the Analysis view for showing Apr Sales? I feel the sample jrxml file which I am referreing is different from what is displayed on dashbaord. Please assist. Thanks & Regards, Anuradha.

Hi, I am also facing the same error when I was trying to drill down the measures. Like I had build an analysis view with Country as row and on Column I have measures like Device_Usage,Device_Down etc. Now when I try to drill down country I am able to move down the hierarchy as Country -->>Region-->Store.... But when I click on the Measure values i.e Device_Usage at a particular country i get the same exception java.lang.NegativeArraySizeException " PFA the schema xml file.I had a look at the demo xmls also but I was not able to make out where I am making a mistake. Please let me know how can I solve this issue. Thanks & Regards Anuradha. Code: Post Edited by anuradhamehra01 at 10/26/2009 09:46 Post Edited by anuradhamehra01 at 10/26/2009 09:47

Hi, I had seen Jasper Reports3.6 which provides Maps and flash charts features, but from the website and the sample charts/maps it seems they are all static. Like for example for a client we are doing a POC for them using Jaspersoft BI Suite. Now the requirement is to build drill down capability in Maps and Charts. Like for example using Jaspersoft Reports or Jasper Analysis, can we create a map that shows say sales at country level -->> then when user clicks on a country it shows Sales at States level --> then user clicks on a State so its shows Sales at Store Level... Can we create this drill down capability in Jasper iReports or Jasper Analysis using Maps graphical representation? I know this forum is for Jasper iReport but i will raise the same query on Jasper Analysis also because I dont know which tool of Jasper will support this... Thanks & Regards Anuradha.

Hi, I had seen Jasper Reports3.6 which provides Maps and flash charts features, but from the website and the sample charts/maps it seems they are all static. Like for example for a client we are doing a POC for them using Jaspersoft BI Suite. Now the requirement is to build drill down capability in Maps and Charts. Like for example using Jaspersoft Reports or Jasper Analysis, can we create a map that shows say sales at country level -->> then when user clicks on a country it shows Sales at States level --> then user clicks on a State so its shows Sales at Store Level... Can we create this drill down capability in Jasper iReports or Jasper Analysis using Maps graphical representation? I know this forum is for Jasper iReport but i will raise the same query on Jasper Analysis also because I dont know which tool of Jasper will support this... Thanks & Regards Anuradha.

Hi Sherman, I am quiet new to this tool and not aware of how to pass parameter to Analysis Views in the URL. Can you please provide some inputs on how to pass parameter via Hyperlink to Analysis Views from iReport? Also please let me know specifically what is the paramter name used for passing the MDX query in URL itself. Thanks & Regards, Anuradha. Post Edited by anuradhamehra01 at 10/19/2009 12:39

Hi Matt, Actually on the Jasper Analysis forum, I found that Analysis Views are not supported in JasperServer's Dashboard Designer. But when I was looking at self running demo of Dashboard Builder available on Jasper Website, I found that when in Sales By Month Report , user clicks on APR month hyperlink a new window opens up with Analysis view displayed for that month. PFA the clips in word document, taken from the demo for more understanding So I wanted to know how it has been implemented in the demo. I was looking at the demo samples installed with Jasper trial version but I could not find the specific report which implements this logic on SuperMart Demo Dashboard- Sales By Month Report. Can you please tell us how Analysis view has been called with a hyperlink on iReport? Or let me know where I can locate the specific demo report to understand the logic behind it. Thanks & Regards, Anuradha.

Can we use Analysis Views created in Jasper Server on Dashboard Designer? I created an analysis view but It is not visible on Dashboard designer, so I am not able drag drop analysis view just like other iReports. Is it possible to use Analysis Views(which allows us design drill down reports) on Dashboard Designer of Jasper Server. Regards Anuradha.

Can we create a dashboard of analysis views created in Jasper Server? If yes then please let us know how do we do that.

Thanks Christina You are right, that we can create drill down reports in Jasper Server by creating Analysis Views. But we don't know how to intergrate or use these drill down reports of Jasper Server in Java. Actually the problem is we are trying to design a BI dashboard where in we need things like Menu on left side, scrolling alerts or some tickers on the BI dashboard page which I was not able to do with Jasper Server. So as a workaround we were thinking to use Java and build ticker and alert functionality and call Jasper iReports in Java. We are able to call normal Jasper iReports in Java. But in this workaround we are not able to build drill down functionality in Jasper iReports which is our major requirement. So can you or anybody please tell how to call Analysis views created in Jasper Server in Java code using Struts or anything. Thanks & Regards, Anuradha.

Building Drill Down report in Jasper iReport I created a cube in Jasper Analysis workbench. The XML of the same is of following structure: This has A cube - Home 2 dimensions - Device (with hierarchy levels country, region) and Time dimension with Hierarchy (level Year). The measure here is OFFCount. That tells number of devices which are off in a particular country in a particlular region in a particular year. *********************************************************************************************************************************** <Cube name="Home" cache="true" enabled="true"> <Table name="OFF_STATUS" schema="SCOTT"> </Table> <Dimension type="StandardDimension" foreignKey="DEVICE_ID" name="Device"> <Hierarchy hasAll="true" primaryKey="DEVICE_ID" primaryKeyTable="DEVICE"> <Table name="DEVICE" schema="SCOTT"> </Table> <Level name="Country" table="DEVICE" column="COUNTRY_NAME" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> </Level> <Level name="Region" table="DEVICE" column="REGION_NAME" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> </Level> </Hierarchy> </Dimension> <Dimension type="TimeDimension" foreignKey="TIME_ID" name="Time_By_Day"> <Hierarchy hasAll="true" primaryKey="TIME_ID" primaryKeyTable="TIME_BY_DAY"> <Table name="TIME_BY_DAY" schema="SCOTT"> </Table> <Level name="the_year" table="TIME_BY_DAY" column="THE_YEAR" type="String" uniqueMembers="false" levelType="TimeYears" hideMemberIf="Never"> </Level> </Hierarchy> </Dimension> <Measure name="Offcount" column="OFF_COUNT" datatype="Numeric" aggregator="sum" visible="true"> </Measure> </Cube> *********************************************************************************************************************************** Now I want to use this mondrian cube to build Drill Down report using MDX query in Jasper iReport. Say forexample a drill down report which look like *************************************************************************************************************************************** 1998 1999 ....... and so on all year +AllCountry <sum of off_count for year 1998 for all country> <sum of off_count for 1998 for all country> ..... and so on *************************************************************************************************************************************** basically yearwise off_count of devices across all country and when u click on all country it will allow you to drill down further to specific country and then to region I was able to create such Drill down report in Jasper Server by creating Analysis view on this XML schema. But I want to create it in Jasper iReport. In Jasper iReport I created an Mondrian OLAP connection using this schema xml file. I tried using this MondrianOLAP connection in a report in Jasper iReport but was not successful. I am very new to this , Can anybody please tell me some demo example of how to create a drill down report in Jasper iReport using MDX query on XMLschema (which has been generated from Jasper Analaysis Workbench). Thanks & Regards Anuradha. Post Edited by anuradhamehra01 at 10/14/2009 11:47

Jasper Reports vs Jasper iReport Hi I am very new to Jaspersoft and trying to evaluate Jasper Soft BI Suite for a client. I need to know what is the the difference between Jasper Report and Jasper iReport tool. Are these two different tool that come packaged in Jasper BI Suite or they are the same? Thanks & Regds, Anuradha.

Hi We have downloaded trial version of Jaspersoft Business Intelligence Suite from following link: "http://www.jaspersoft.com/downloads" But the trial version download only has Jasper Server Professional and iReports. Do we need to buy some development license to get all componets of BISuite. We also need to evaluate other components of BI Suite - JasperETL , JasperAnalysis Server and Jasper Analysis Workbench . Please let us know if there any developer license for evaluating all BISuite Components. If there is no license then please let us know from where we can download the complete BISuite with Components(Jasper iReports, Jasper Reports, Jasper Server Professional, JasperETL , JasperAnalysis Server and Jasper Analysis Workbench ) . Thanks & Regards Anuradha

Thanks alot Matt for the quick reply. Just one more query. As you have mentioned that the Jasper Analysis workbench is a separately downloadable tool used to design the JasperAnalysis schema file. So if we suggest client for JasperSoft BI Suite then alongwith BISuite client needs to buy the Workbench tool seperately for the OLAP schema development? Because in BI Suite I could not find Jasper Analysis workbench component. Thanks & Regards, Anuradha. Post Edited by anuradhamehra01 at 10/13/2009 05:19

JasperAnalysis Server vs Jasper AnalysisWorkbench 1. I need to know what is the difference between JasperAnalysis Server and Jasper AnalysisWorkbench. I am a bit confused whether these are two different tools or not. 2. Also We have downloaded trial version of Jaspersoft Business Intelligence Suite from following link "http://www.jaspersoft.com/downloads" But this trial version only has Jasper Server Professional and iReports. We also need to evaluate JasperAnalysis Server, Jasper Analysis Workbench and JasperETL . Please let us know from where we can download JasperAnalysis Server, Jasper Analysis Workbench and JasperETL for evaluation. Are these 3 part of licenced version of Jaspersoft Business Intelligence Suite or not? Can we get the trial version of these 3 tools? Early response would be highly appreciated. Thanks & Regards, Anuradha.