muttou

September 27, 2007

hi i m using the Jasper server for Jasper Analysis and i developed the Custom Dashboard which shows the different schema a analysis. can some body explains that what would be its performance and response time. thanks for the technical support .......... Nasir

September 27, 2007

Can some body knows that how to design the dashboards applications in Jasper using Tomcat server rather than to use the manual layout technique for layout designing.

September 26, 2007

Hi i need to know the Links or material regarding Jasper server & analysis Samples, Dashboard samples etc using tomcat web server.... Thanks for the support

September 26, 2007

hi i m using the Jasper server for my Analysis and found it well but i need to know that how Time dimension works and i have a TimeStamp data type in my table tell how i can map or make the time series on this columns for e.g

'01-JAN-07 10:23:00 am' make it levels like year = 2007 , and next level month = January etc... i used to format my field like to_char(Myfield, 'YYYY') for Year Level and to_char(Myfield, 'MM') for my Month level.. but give me the error message.....i need the urgent solution with the example shows the date data type columns and then makes the Time Dimension on that field or another way ,,,,, Thanks thanks a lot.

September 24, 2007

dear thanks for the reply with enough examples..... thanks.

September 24, 2007

dear thanks for the reply with enough examples..... thanks.

September 19, 2007

Hi i m making the cube useing the Work bench Analysis using the Monderian Scheema help on Foodmart database.

- 18 -

</Hierarchy>

</Dimension>

</Hierarchy>

</Dimension>

<Measure name="Unit Sales" column="unit_sales" aggregator="sum"

formatString="#,###"/>

<Measure name="Store Sales" column="store_sales" aggregator="sum"

formatString="#,###.##"/>

<CalculatedMember name="Profit" dimension="Measures" formula="[Measures].

[store Sales]-[Measures].[store Cost]">

</CalculatedMember>

</Cube>

</Schema>

and after write the query into the MDX Query in Work bench it gives me the error message like

Mondrian Error:Failed to parse query 'SELECT {[Measures].[unit Sales], [Measures].[store Sales]} ON COLUMNS,

{[Time].[1997].[Q1].descendants} ON ROWS

FROM [sales]

WHERE [Gender].[F]'

Mondrian Error:Error while parsing MDX statement 'SELECT {[Measures].[unit Sales], [Measures].[store Sales]} ON COLUMNS,

{[Time].[1997].[Q1].descendants} ON ROWS

FROM [sales]

WHERE [Gender].[F]'

Mondrian Error:MDX object '[Time].[1997].[Q1].[descendants]' not found in cube 'Sales'

thanks for solving my porblem and give me proper solution to aviod write MDX query and Schema ... more when add another database using ODBC it doesnt shows the Tables in Workbench and Penthao Cube Designer as well..... Thanks for the Support......Hope for the positive reply.......

Post edited by: muttou, at: 2007/09/19 13:06

September 18, 2007

Hi dear i need to know the difference and performance between the Jasper analysis & Server and Oracle DWH.. does any one can make the clear difference,,,, Thanks..

September 18, 2007

Exie wrote:

Dear Sebastian thanks for ur resourceful reply..actually i need to know that is there any way to draw the results without writing or understanding the syntax of MDX Query(Design the business Logic via Wizards) and can we make the whole schema and MDX through Wizards.....and then deploy to the Jasper Server... thanks again to solve my problem... i will wait for ur positive reply again.....Thanks...

... Have you tried the JasperAnalysis Workbench ? I found it was a good start to building your cube definiition. It's all GUI based and you can simply select your dimensions and whip up an OLAP schema really easily.

I cant help you with the MDX queries though, I just built mine manually.

Dear thanks for ur reply. i need to know more that hows Jasper works on Swing JFrame Applicaions and on Web portal is Jasper Analysis & Server can Handle the larger Enterprise Level Data. actually i m interested in Star layer Cashe hows its handle all the computed data and at first it will take long delay to pick up the transactional data based on time dimension etc.. thanks again for your positive reply... Nasir

September 14, 2007

csbac wrote:

no you can't.
ETL is for Export, Transform, Loading of data, not OLAP.
Seb.

dear thanks for ur reply about ETL working, could you please define 1 more thing that whats Loading of Data and where to use that feature. i mean to say that in Jasper Server Analysis reports is it export to PDF, Excel exports? and where to use the loading of data feature, thanks again for ur reply....hope for the positive reply. MUTTOU

Post edited by: muttou, at: 2007/09/14 10:57

September 14, 2007

Hi im new to Jasper ETL now does any body know that whats main functionality of Jasper ETL and can we draw the MDX and logical Schema model of our business system using jasper ETL.. I need the professional and summarized reply apart from the ETL documentation.... thanks for the reply and resource ful information.....

Post edited by: muttou, at: 2007/09/14 06:19

September 14, 2007

csbac wrote:

Hi!
The MDX query is not difficult to construct by hand, if you have the cube definition already.

To start, it is usually easiest to create a simle query only and work on it with the JPivot controls, e.g.,

Code:


select 
  {[Measures].[A Measure]} 
  	  ON COLUMNS,
  {([Dimension1].[All], [Dimension2].[All])} 
      ON ROWS
from [Cube]

when you have

- a cube called Cube

- a measure called "A Measure"

- two dimensions Dimension1 and Dimension2 with "All" as allMemberName.

The far more difficult stuff is to create the cube definition ... if this is your real problem, and you just put the wrong question, have a look at the Jasper Analysis Workbench.

Also, you should get the written documentation of JasperAnalysis, as this stuff is a bit too complicated to explain in a forum ...

Hope this helps,

Sebastian

Dear Sebastian thanks for ur resourceful reply..actually i need to know that is there any way to draw the results without writing or understanding the syntax of MDX Query(Design the business Logic via Wizards) and can we make the whole schema and MDX through Wizards.....and then deploy to the Jasper Server... thanks again to solve my problem... i will wait for ur positive reply again.....Thanks...

September 13, 2007

Dear Sebastian thanks for ur resourceful reply..actually i need to know that is there any way to draw the results without writing or understanding the syntax of MDX Query(Design the business Logic via Wizards) and can we make the whole schema and MDX through Wizards.....and then deploy to the Jasper Server... thanks again to solve my problem... i will wait for ur positive reply again.....Thanks...

September 12, 2007

Hi Dear does any body knows that how to generate the MDX Query and how i could make the OLAP reports like in Jasper Server Analysis Samples.. i need the urgent support.. thanks again.

September 12, 2007

Hi Dear does any body knows that how to generate the MDX Query and how i could make the OLAP reports like in Jasper Server Analysis Samples.. i need the urgent support.. thanks again.

May 31, 2007

Sir can u plz give me the copy of this book. if u dont mind........thanks for the support......

can email me at www.yahoo.com. thanks again

May 31, 2007

Sir can u plz give me the copy of this book. if u dont mind........thanks for the support......

can email me at www.yahoo.com

May 31, 2007

hi i m using the ireports 1.3.3 for jasper reports and using the line charts..its working well but can somebody tell me how to put the value on the series of each node of the line chart............using ireports 1.3.3. thanks for this solution.

January 26, 2007

Dear sir thanks for ur guide.........Sir i hav done all the efforts in this code but still there is exception... which is

/////////////////////////////////////////////

10 [main] ERROR digester.Digester - Digester.getParser:

org.xml.sax.SAXNotRecognizedException: http://apache.org/xml/features/validation/dynamic

at gnu.xml.aelfred2.JAXPFactory.setFeature(JAXPFactory.java:102)

at org.apache.commons.digester.parser.XercesParser.configureXerces(XercesParser.java:185)

at org.apache.commons.digester.parser.XercesParser.newSAXParser(XercesParser.java:138)

at org.apache.commons.digester.ParserFeatureSetterFactory.newSAXParser(ParserFeatureSetterFactory.java:71)

at org.apache.commons.digester.Digester.getParser(Digester.java:692)

at org.apache.commons.digester.Digester.getXMLReader(Digester.java:899)

at org.apache.commons.digester.Digester.parse(Digester.java:1647)

at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:238)

at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:225)

at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:213)

at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:167)

at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:151)

at awan.ReportDriver.runReport(ReportDriver.java:86)

at awan.ReportDriver.main(ReportDriver.java:112)

Could not create the report null

////////////////////////////////////////////////

i dont know y i m getting this exception..sir plz i think problem is in this statement..

JasperDesign jasperDesign = JRXmlLoader.load("D:/Nasir.jrxml");

/////////////////////////////////

also i hav studied the JRXmlLoader.load() class and its methods.....but still no solution..

i need the solution on urgent basis.. more can u run the same code correctly on ur machine.........

sir my OS is WinXP and JDK version is 1.6.0.......now plz help me out this.......thanks thanks................Nasir

January 25, 2007

dear thanks for ur code sample i copy paste the same sample code into my project i m using the Borland Jbuilder2005 and installed all the jars but i m getting this exception after running ur code samplee plz help me out this...........

/////////////////////////////////

0 [main] ERROR digester.Digester - Digester.getParser: