tron79 Posted August 19, 2008 Share Posted August 19, 2008 Hi, Could somebody pelp me? I want to create olap cube. Which software I need to use. I had installed JasperServer 3.0 which include jasper analysis. I made same sample with mondrian connection and made schema, but I can not create cube.Regards Link to comment Share on other sites More sharing options...
swood Posted August 19, 2008 Share Posted August 19, 2008 It looks like you have done everything you need to use JasperAnalysis. When you say "create a cube", do you mean "create the cube database"?JasperAnalysis does not need to have an explicit cube creation step like Hyperion/Essbase or Cognos. ShermanJaspersoft Link to comment Share on other sites More sharing options...
tron79 Posted August 20, 2008 Author Share Posted August 20, 2008 Hi,I am new at JasperServer and Jasper Analysis. I think that I have to create the cube database.Regards,Nedelcho Link to comment Share on other sites More sharing options...
tron79 Posted August 21, 2008 Author Share Posted August 21, 2008 Nedelcho SlabakovWrote: Hi, I am new at JasperServer and Jasper Analysis. I think that I have to create the cube database. How can I do that? Regards, Nedelcho Link to comment Share on other sites More sharing options...
swood Posted August 22, 2008 Share Posted August 22, 2008 Where is the data you want to do analysis on? Have you tried creating a schema that uses your existing data?If you need to move your data from your existing data source and transform it into fact and dimension tables, you can use JasperETL which is based on Talend Open Studio. This tool creates transformation scripts visually, and you can test the scripts and deploy them to run at any time. ShermanJaspersoft Link to comment Share on other sites More sharing options...
tron79 Posted August 25, 2008 Author Share Posted August 25, 2008 Hi,My data base is real, I mean is working at the moment. Whem I created schema I used existing data base as file (for example myDB.sql , I used Navicat for MySQL). Is that correct? Regards,Nedelcho Link to comment Share on other sites More sharing options...
swood Posted August 25, 2008 Share Posted August 25, 2008 You have done all you need to do.Once you have created the schema and a Mondrian connection (schema + database connection), create an analysis view using the Mondrian connection (MDX query).JasperAnalysis uses the Mondrian OLAP engine. It caches query results in Java memory for speed. The only thing you need to do is to flush the cache when you want to see the impact of new data coming into the underlying database. There is a menu option for this. ShermanJaspersoft Link to comment Share on other sites More sharing options...
asifisyed Posted May 22, 2009 Share Posted May 22, 2009 I am new in using Jasperserver. I have some question while creating schema. I see the example SugarCRMSchema.xml file where It includes SugarCRMSchema.data file. Are these two files manually created? In the dat file I see some tags, Does this file cover all tags? In other words is there any documentation how to create xml and data file. For MDX query, same question , Do I have to write it manually or some software can generate it? Thanks in advance. Link to comment Share on other sites More sharing options...
kapil112307 Posted June 18, 2009 Share Posted June 18, 2009 hi can someone tell me how to make xml file from that olap cube.i have created olap cube in msexcel 2003 and i want to create a dyanmic dashboard Link to comment Share on other sites More sharing options...
kevinchristian Posted January 5, 2010 Share Posted January 5, 2010 Why do we need XML file for schema?? Why we need Modrian?? We have all our metadata stored into database so what is the reason to use Modrian connection and XML schema file? Link to comment Share on other sites More sharing options...
swood Posted January 7, 2010 Share Posted January 7, 2010 @asifisyed The SugarCRM.dat is a dump of an example database. You would need to provide your own datam, of course. The schema XML file can be created by hand, but it is best to use the Schema Workbench, which allows you to visually create the schema, validate the schema against the underlying database and run test MDX queries. There is a simple MDX query generator provided to get you started with queries that can be used in analysis views in the server. @kapil112307 Do you mean a Pivot Table in Excel? To get the OLAP result displayed in JasperAnalysis, you will need to load the data in Excel into a database, and then create a schema, OLAP connections and analysis views in the server. @kevinchristian The schema provides metadata that the OLAP engine uses to generate SQL statements that satisfy MDX query requests. ShermanJaspersoft Link to comment Share on other sites More sharing options...
shatad0101 Posted July 1, 2011 Share Posted July 1, 2011 HiI am new in this field and i want to create my first mdx query in jasperserver but i dont have any ideaabout cube,schema.Please anyboby suggest me how to make cube,schema all these thing.and i m using jasperserver 4.0.0.Should i install any software for olap cube. Post Edited by shatad0101 at 07/01/2011 11:44 Link to comment Share on other sites More sharing options...
shatad0101 Posted July 27, 2011 Share Posted July 27, 2011 Hi kevinchristian , I am new in ireport and jasper server can you guide me how to create my first olap report in jasper server.I dont know how to create cube and schema plz help me. Link to comment Share on other sites More sharing options...
oesina Posted October 7, 2011 Share Posted October 7, 2011 Hi shatad0101You need to download JasperAnalysis Workbench from the forge and define cube with at least a fact table with a measure and a dimension. http://sourceforge.net/projects/jasperserver/files/JasperServer/JasperServer%201.2.1/JasperAnalysis_workbench-1.0.zip/downloadMost information on Mondrian XML is provided on Pentaho website. MDX language is described in number of locations.Olga, JasperSoft Link to comment Share on other sites More sharing options...
oesina Posted December 5, 2011 Share Posted December 5, 2011 Hi Kevin,Schema modeling is used to map multi-dimensional databases with the underlying SQL database. Your database doesn't know how to group dimensions into hierarchies, which statistics to apply to measures etc. And schema defines all the joins for you, so you can operate with lists of dimensions and measures when you define reports with MDX or Graphical tools.Schema will also allow to support aggregate tables though that can be done by the viewer directly as well. Also schema allows to define Access Grant and apply dimension and hierarchy concept. Basically schema enables MDX to work with members, children, ancestor syntax. Check http://msdn.microsoft.com/en-us/library/aa216770%28v=sql.80%29.aspx Hope that helps,Olga Link to comment Share on other sites More sharing options...
shatad0101 Posted December 5, 2011 Share Posted December 5, 2011 thanks, for the help Link to comment Share on other sites More sharing options...
anilguptakgp Posted December 6, 2012 Share Posted December 6, 2012 I am unable to find jasper analysis workbench. Seems to be they stopped supporting it.... Can anyone suggest me on how to create mondrian cube reports for time series data? Say time hierachy as year/quarter/month/day. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now