BIRT 221 INSTALLATION

BIRT 221 INSTALLATION AND CONFIGURATION

This document provides details on Installation and configuring BIRT Report Designer 221 for the Base Services 7.1.1.5 and future Releases.

Prerequisites:

Before beginning install, make sure a copy of IBM JDK 1.5 (5.0) has been installed locally and BIRT 2.2.1 was used and supported within the MAXIMO V7 Releases.

                                                          JAVA INSTALLATION

Step 1: Accept the license agreement and click on next.

Step 2: Click on next.

Step 3: Installation in progress.

Step 4: Click on next.

Step5: Select the Browser and click on next.

Step 6: Click on finish.

BIRT INSTALLATION

Step 1: Run setup.exe.

Step 2: Select the installation language and click on ok.

Step 3: Click on next.

Step 4: Accept the license agreement and click on next.

Step 5: Select the installation folder and click on next.

Step 6: Review the installation and click on install.

 Step 7: Installation in progress.

 Step 8: Click on done to finish the installation.

BIRT CONFIGURATION

1. Copy com folder and mxreportdatasource.properties from “C:\IBM\SMP\maximo\reports\birt\scriptlibrary\classes.”

2. Create new classes folder to “C:\IBM\BIRTDesigner221\eclipse\plugins\org.eclipse.birt.report.viewer_2.2.1.v20070205-1728\birt\WEB-INF”

3. Paste com folder and mxreportdatasource.properties to “C:\IBM\BIRTDesigner221\eclipse\plugins\org.eclipse.birt.report.viewer_2.2.1.v20070205-1728\birt\WEB-INF\classes”.

4. Copy Opta.jar from “C:\IBM\SMP\maximo\applications\maximo\lib” as we are configuring for SQL server.

For Oracle=oraclethin.jar

For SQL Server=opta.jar

For DB2= db2jcc.jar and db2jcc_license_cu.jar

5. Paste Opta.jar to “C:\IBM\BIRTDesigner221\eclipse\plugins\org.eclipse.birt.report.viewer_2.2.1.v20070205-1728\birt\WEB-INF\lib”

6. Extract and copy the contents of Opta.jar.

7. Paste the contents of Opta.jar to “C:\IBM\BIRTDesigner221\eclipse\plugins\org.eclipse.birt.report.viewer_2.2.1.v20070205-1728\birt\WEB-INF\classes”.

8. Open maximo.properties from “C:\IBM\SMP\maximo\applications\maximo\properties”.

9. Make the changes in mxreportdatasource.properties refer by maximo.properties.

mxe.db.url=jdbc: inetdae7a: blank-62vrlsn3q.:1433?database=maxdb71&language= us_english&nowarnings =true&mars=false

mxe.db.driver=com.inet.tds.TdsDriver

mxe.db.user=maximo

mxe.db.password=maxadmin

mxe.db.schemaowner=dbo

10. Copy the mxreportdatasource.properties from “C:\IBM\BIRTDesigner221\eclipse\plugins\org.eclipse.birt.report.viewer_2.2.1.v20070205-1728\birt\WEB-INF\classes”.

11.  Paste mxreportdatasource.properties to “C:\IBM\SMP\maximo\reports\birt\scriptlibrary\classes”.

12. Create the shortcut of eclipse.exe on the desktop.

13. Open the properties of shortcut.exe by right click on that and change the target as “C:\IBM\BIRTDesigner221\eclipse\eclipse.exe -vm "C:\Program Files\Java\jdk1.5.0_07\bin\java.exe" –vmargs –Xmx512m”.

14. Path for the java.exe “C:\Program Files\Java\jdk1.5.0_07\bin\java.exe”.

15. Open the eclipse.exe and specify the workspace.

 16. Set the Resource folder for the Library Explorer from windowsàpreferences menu in eclipse to C:\IBM\SMP\maximo\reports\birt\libraries.

17. Set the Template folder to C:\IBM\SMP\maximo\reports\birt\templates.

18. Disable the Comment Template.

 A.  If not already open, from the menu, Select Window - Preferences.

B.  Remove the flag from the ‘Generate comment when creating a report design’ field if it is set.

19. First, create a project.  Click File, New Project.  Under Business Intelligence and Reporting Tools, select Report Project.  Click Next.

20. Enter a Project Name.  

a. Remove the flag in the ‘Use Default Location’ field.  

b. For the Location Field Value, browse to the location of your maximo V7 Report Source.    “C:\ibm\SMP\maximo\reports\birt\reports”.  

c. Click Finish.

21. Expand the folder and open any rptdesign file.

 Designing a Report in BIRT

1    1. Create a new project using the project creation wizard.

2    2. Provide the Name for your project and Provide the location of existing reports.

3    3. Now we can see the existing folders under navigator.

 4. Create Data Source --> Open the Data Explorer View. Right click on Data Sources and choose "New Data Source".

3    5. Create a Data Set:

    Open the Data Explorer View. Right click on Data Sets and choose "New Data Set"

6. Create a new report.

Fileànewàreport.

5    7. Select the type of report.

      8. Now you can edit the data set by right clicking on the data set and add required attributes to it.

Join Amulyam:

http://www.amulyam.in/signup.do?id=d322ff51-6d8c-421f-8e89-12d1f2268b80

Configuration of Attachments on AIX Environment

 Configuration of Attachments

Important Note:

i)                    It is case sensitive.

ii)                  Careful while giving forward and backward slashes i.e. / and \ respectively.

Following steps are required to configure the attachments.

1. Create a folder as represented in the below table.

Folder Name	Location
DOCLINKS	/doclinks
ATTACHMENTS	/doclinks /ATTACHMENTS

2. We have to edit httpd.conf file which is @ location

/WebSphere/HTTPServer/conf

i)                    Backup the httpd.conf file.

ii)                  Open the file with  text editor  and find the following context:

                        

              # This should be changed to whatever you set DocumentRoot to.

iii)                Change the value to /doclinks

        When you change the value it should look like

           <Directory /doclinks >

iv)                Find the context given below

                  #

                  # Document Root: The directory out of which you will serve your

                  # documents. By default, all requests are taken from this directory, but

                  # symbolic links and aliases may be used to point to other locations.

            #

           Change the value to   /doclinks

      When you change the value it should look like

    

            DocumentRoot "/DOCLINKS"

v)                  Save and Close the file.

vi)                Restart HTTP server. (Go to Services  and restart the service IBM HTTP server 6.1)

vii)              To verify whether it is configured correctly  make use of this steps

                a). Create a file test.txt   @ the location  /doclinks

                b). Open the browser and type the following url and press enter.

                    http://localhost/test.txt

                              You can see the contents of test.txt file.

3. Editing Default File Paths in the System Properties Application

i)                    To edit the paths you must have privileges. So login with “maxadmin” user.

ii)                  Go to System Configuration > Platform Configuration > System Properties.

iii)                Follow the table to complete the 3^rd step. Remember the Notes provided above. When you change the value it should look like as shown in the table.

Property	Value to be set
mxe.doclink.doctypes.defpath	/doclinks
mxe.doclink.path01	/doclinks = http://172.16.0.00/
mxe.doclink.doctypes.allowedFileExtensions	pdf,zip,txt,doc,docx,dwg,gif,jpg,csv,xls,xlsx,ppt,xml,xsl,bmp,html
mxe.doclink.doctypes.topLevelPaths	/doclinks
mxe.doclink.maxfilesize	10
mxe.doclink.multilang.aix.websphere	true

iv)                Restart the Application Server.

 4. Editing Default File Paths in Related Applications

i)                    Login to Application with user “maxadmin “.

ii)                  Open an application that has the Attached Documents action.

iii)                From the Select Action menu, select Attachments Library/Folders à Manage Folders.

iv)                Change the value as shown in the table.

Document Folder	Default file path
Attachments	/doclinks/ATTACHMENTS
Diagrams	/doclinks/DIAGRAMS
Images	/doclinks/IMAGES

v)                  Click ok.

vi)                Restart the Application Server.

Join Amulyam:

http://www.amulyam.in/signup.do?id=d322ff51-6d8c-421f-8e89-12d1f2268b80