muttou

i want to add serial column in crosstab report. kindly plz help. thanks

dear you can get all from my attachments where u may find the locations for xml schema etc..

Dear All, i need to get the JaspeETL professional training. can somebody suggest or have the sample/tutorial apart from the web demos on the site thanks for the information, Nasir

thanks for your reply i will wait for ur positive reply. best regards.

dear thanks for your reply with the resourceful information. kindly could u plz send me your attach file at this address muttou@hotmail.com i would be so thankful to you for this effort. you can upload the different types of files with this post. list can be found with the error message. actually i m BI professional by using the Oracle 10.2 Data warehouse tool but its too tough to map the source table to others.. so i found the Jasper ETL good enough for this purpose...i hope for the positive reply from you. more how can we make the time dimension table or real time data based on date and time can u give some example in Jasper ETL tool. thanks for reply..... Nasir

ah well thanks for your remarkable reply. more tell me if i need to apply the business logic during extraction and loading of data using MySqlinput or output ect.. more how can we apply the numeric operation during ETL operation.. thanks for your reply with logic solution.

use for similar type of your use parameter in both report with field type "param1". which i guess from ur query. use Integer.toString() or java.lang.Integer for casting the parameter. check both.......best regards...

here is attached i think [file name=index.txt size=36992]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/index.txt[/file]

can u give me ur another hotmail, yahoo and gmail addrss whr i could send u the complete project. thanks nasir

can u give me ur another hotmail, yahoo and gmail addrss whr i could send u the complete project. thanks nasir

here is the index.jsp file.......

Hi i need some basic help for extract and loading of data from the database servers but dont know the way that how to deal with that, can some body give me the basic help to control and handle the operation of the Jasper ETL software. thanks for the post reply n help.

JasperSoft And Noetix Launch Business Intelligence Solutions For Oracle E-Business Suite. Kindly tell where to find this product and when it complete version is coming into the market with the proper handling of reports and analysis via drag & drop facility.... thanks for ur relpy

Dear for making the Dash board u have to use 3 products 1-Mondrian for your Business Logic(xml schema) 2-JPivot for your front end OLAP components like drill drop table..etc and with WCI components. 3-Tomcat version 5x for running all these. u can take the help from jasper site or www.pentheaou.org site.... Note: to make the custom dashboard u hav to be a good in web development then u can make the dashboard.... thanks....

http://webapps.masoodtextile.com:8182/Warehouse/ you can make ur own like this if u want.........with best regards......

Hi does any body knows that how to change the default style of the charts to 3d bar in Jasper Analysis server when page opens ist time. thanks for the support.

HI first of all i want to say thanks to the Jasper Team who provide us this marvelous products (Jasper Reports & BI) for Business Intelligence.. i found this product extremely more attractive and powerful for BI Analysis and reporting as well as establishment of Data ware house using jasper ETL. here i m giving option to my all viewers to explore that product on our live production data. URL is http://webapps.masoodtextile.com:8182/Warehouse/ thanks for ur comments in this regards. Muhammad Nasir DM Business Analyst. Masood textile Mills ltd Faisalabad, Pakistan. 92300-7439721. muttou@hotmail.com ur feed back would be highly appreciated to make me more professional. thanks.

Thanks for ur reply.......1 more thing when ur Pro Release will be available..... thanks for ur comments

hi i m using the Jasper Server for Analysis Reports and Views.. Can some body tell me that how to bring the multiple Analysis Reports or View into the Single page which Jasper Server Produce for Presentation. or there may be the option added by jasper team in near future to make the more compact and enhanced analysis and views...thanks for the support.........Thanks in advance..... Nasir

hi i m trying to Add the View as Fact table in Cube definition by using Work Bench but it doesn't show me the Views. can u tell what is the reason behind this. when Work Bench new Version is coming.. more can i handle the Snow Flake schema model in Work bench. Thanks for the Support........ Nasir

Hi does any body knows that i want to make the Dash Board for Jasper & mondrian based schema analysis. can some body could help me. i have three libraries like jpivot, wcf and mondrain and core jsp programing can i make the custom made jsp Page and my own Dashboard which contain more than one Analysis reports. any help would be highly appreciated.. Thanks and best regards. Nasir

again thanks for the reply..but Dear i know that we can parametrized the Jasper Reports Query my actual problem is to know about MDX Query that uses in Drill Drop Analysis Reports which extract the results via Mondrian Schema and displayed via jpivot Component like an example below SELECT {[Measures].[Production], [Measures].[Reprocess],[Measures].[LotCount]} ON COLUMNS, {([TIME],[Methods],[Machines])} ON ROWS FROM [Dyeing] where [TIME].[2007].[Q1].[MAR] can i replace it with SELECT {[Measures].[Production], [Measures].[Reprocess],[Measures].[LotCount]} ON COLUMNS, {([TIME],[Methods],[Machines])} ON ROWS FROM [Dyeing] where [TIME].[request.getparameter("Year")].[Q1].[MAR] or String var = [TIME].[request.getParameter("Year")].[Q1].[MAR] SELECT {[Measures].[Production], [Measures].[Reprocess],[Measures].[LotCount]} ON COLUMNS, {([TIME],[Methods],[Machines])} ON ROWS FROM [Dyeing] where <%= var %> could it may be case.... i have seen the monderian examples (Basic interface for ad hoc queries equipped with the Jasper Analysis server)in this sample they passed the different MDX Queries as whole as single parameter like var = "SELECT {[Measures].[Production], [Measures].[Reprocess],[Measures].[LotCount]} ON COLUMNS, {([TIME],[Methods],[Machines])} ON ROWS FROM [Dyeing] where [TIME].[2007]"; and get the val of Parameter which is complete MDX. any way i will try my own to see the results either it can use or not as mentioned above. thanks for ur reply and support... hope for the good corresponding in future....Thanks Nasir.

Dear Sir thanks for ur reply with the sufficient instructions actually i want to clear the forum that its public & open source discussion forum so every person has rights to say all & my team is working on this products and started its production so definitely if we will get any sort of problem and query while using Jasper Product where we suppose to get the solution & even u don't have the professional documentation so my cool buddy if u can answer properly then we will pursue on Jasper product otherwise want to go to the Oracle Sibel BI Products and Top Management also want to implement. i was convening them to move on this product lets see whats happen... /////////////////////////////// now my actual Problem is that i m using the jasperreports and an mondrian datasource and getting the desired results on Page/Japer Analysis Reports now i want to make the Parameterized MDX query like on where command {[TIME].[2007]} replace {[TIME].[request.getParameter('YEAR')]} etc i think its better shape for ur understanding.. again thanks for ur advice.... Nasir

hi does any body know that can we make the parameterized MDX query at run time... Thanks for the reply and special thanks for the early reply........Nasir

hi i have some views in my schema so when i access these views on Work bench analysis then it doesn't comes there . can somebody tell that what is the reason behind this.. Thanks for the support from the community.. Nasir