OrangeScape Developer Community

A community for Application Developers on OrangeScape's Platform-as-a-Service

All Blog Posts (134)

BIRT Reports using Stored Procedure

We can also use Stored procedures in BIRT Reports instead of using select query/view.

Steps to be followed:

1.Create Datasource
2.Create Dataset. While creating Dataset, select the Dataset Type as SQL Select Query
3.In the Query call the procedure like this, Call Procedure_Name() In MYSQL database.
4.If you are using any parameter call procedure like this, Call Procedure_Name(?)

Rest will be same.

Added by Chandru on November 11, 2008 at 5:00pm — No Comments

How to make your theme as default theme ?

In liferay the theme is applied for every group we create , Currently dimension theme is applied by default,so we go to look and feel to change it to our application theme whenever we create a new group.

This step can be eliminated by making our application theme as default theme,

Steps to be followed:

Locate "Look and Feel" in ..\server\default\deploy\A-dimension-portal.ear\portal-ejb.jar\ :

Take notice of this line:… Continue

Added by Jothi on November 11, 2008 at 1:05pm — 2 Comments

Dates Table

I find that it can be advantageous to use a Dates table, especially when doing a lot of date calculations. Learn what a Dates table is and how to create one, and then try it out for yourself.

What is a Dates table?

A Dates table stores a range of dates. Dates tables are very common in a DateWarehouse as a dimension table. You can also use Dates tables in OLTP databases for lookups. When programmers use Dates tables, they don’t have to worry about using or designing… Continue

Added by Chandru on November 7, 2008 at 12:40pm — 1 Comment

How to install JDK in *nix and set the JAVA_HOME and PATH environment variables

The following is the procedure to install SUN JDK in *nix.

First go to sun's website and downloaded the .bin installation file. (not the rpm one). if you want to install jdk in a system wide accesible place like /usr/local from where all users can access then you will have to become super user before starting this procedure. you can either change to super user using su, or execute with sudo. To become super user, in terminal… Continue

Added by Anbarasan on October 29, 2008 at 10:00pm — 1 Comment

How to install Dimension Server in *nix

The installation of Dimension Server in *nix is same as that in windows, except the way we start off the installation.

when you double click the dimensionserver.jar file in windows the installer starts, but that is not the case in (some) *nix. In this case, to start the installer in *nix, goto the terminal, and type java -jar DimensionServer2.4.jar and press enter (if you have sun jdk), this will start the installer. If you have some other JDK installed, then please refer to… Continue

Added by Anbarasan on October 28, 2008 at 5:30pm — 3 Comments

BIRT Report -> Data Source & JNDI URL

Some times the Birt Reports which you create will work properly in the studio, but in server the report will not show any output. One of the reasons of this problems is because of giving the wrong JNDI URL.

In Birt when creating reports, you will be required to create a datasource. and you will find a entry in it asking for JNDI URL. This JNDI URL is a reference to the book mark which will be used by the report when executed on the server. The connection information which you are… Continue

Added by Anbarasan on October 28, 2008 at 1:30pm — No Comments

When to CODIFY

I have seen many people creating CODIFICATION by default for master models and also in WF / Transaction Models like Emp0034,TMC3426 . This is not required and can be avoided. Typically, CODIFICATION is required only when there is a need to communicate a CODE between the system that is being built and external evnironment like other systems or human beings. Simply put, I can say that CODIFICATION is required when there is a need for NATURAL KEY. When master data is accessed within the… Continue

Added by Pushpalatha on October 23, 2008 at 3:02pm — 1 Comment

Performance Monitoring of DimensioN server

Performance Monitoring in load testing environment or in Staging.

There are lot of performance monitoring tools which can be used with DimensioN. All these performance Monitoring tools takes lot of CPU and memory and hence cannot be used in production environment. These tools are ideally suited for load testing environment or in the staging.

One of the tools which doesn't cause too much overhead is "Managed Engine". Managed engine monitors various parameters… Continue

Added by Dinesh Varadharajan on October 21, 2008 at 2:49pm — No Comments

DBimport in MSSQL 2005 - Schema Issue

In MsSql 2005, if you are using the sa user, while doing dbimport you might run across errors of the following type.

"Ambiguous table name Address" or "The source DB Connection have access to multiple schemas. Restrict the

access to required schema for the user."

This is because of the way MsSql 2005 handles the schema, user and login. This can solved by adding the following to the connection string.

jdbc:… Continue

Added by Anbarasan on October 1, 2008 at 5:30pm — No Comments

Encoding Special Characters to use them in URLs

There may be certain scenarios where you will be using dynamic filters / drill down reports where the filter value has to be passed via url. Now if the data contains special character, it might create some problems. (especially the character "&"). To solve this problem, we will have to encode the special character in the data, before passing them via url.

This problem can be easily solved using javascript support in reports. For example, if you have value in column a as 'sample… Continue

Added by Anbarasan on October 1, 2008 at 4:00pm — 1 Comment

Performance improvement in file uploading

By default when you are uploading any files to the server (eg: through File Attachment or CSV Upload,..) the data will be sent as it is in the network. There is an option in the server where we can compress the data which we are uploading, so that we there is a significant improvement in the performance during upload process. This is called HTTP Compression.

Follow the steps to enable the compression

1. Open the file server.xml from the path… Continue

Added by adhi on September 19, 2008 at 4:36pm — No Comments

How to Convert Number to Words in Report

Scenario:Most of the times the user want to see the Values as a Words


Please Following the below steps to convert NumToWords:

1.In Report,select the table choose Bookmark for that particular table


2.Find the attached file named as "numtowords.txt" and Copy the

content and paste into the Bookmark file

3.Insert the Data and Open the Expression Builder and… Continue

Added by Sumathi Rajendran on September 17, 2008 at 7:00pm — 3 Comments

Using Hyperlinks for drilling down the details of a report statuswise or month(time)wise

Scenario: Most of the times users are interested in drilling down the details of a particular report statuswise (ex: Submitted, Approved) or timewise (Ex: Monthy, Yearly). The usual way we implement drill down in BIRT is by represent the specific parameter (status or time) as a 'listbox'. To improve the presentation, the same feature can also be represented as hyperlinks (ex: Current Month, Last Month, Current Year etc).

Please following the below steps for creating hyperlink instead… Continue

Added by Sumathi Rajendran on August 30, 2008 at 9:44pm — No Comments

Avoid port conflicts in Dimension

To avoid port conflicts, you will have to change the ports for the Dimension instance. Here is a list of what you'd have to do:

Please note : some of these recommended ports might conflict in your particular environment. In such cases, you might have to experiment until you get one that does not conflict. The Dimension server.log will tell you if there are any port conflicts. In Windows, you can use TCPView from Microsoft to inventory currently used ports. On Linux, you can… Continue

Added by Dinesh Varadharajan on August 19, 2008 at 8:48pm — No Comments

Monthly Archives








© 2018   Created by OrangeScape Technologies.   Powered by

Badges  |  Report an Issue  |  Terms of Service