We can also use Stored procedures in BIRT Reports instead of using select query/view.
Steps to be followed:
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 —
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\portal.properties :
Take notice of this line:… Continue
Added by Jothi on November 11, 2008 at 1:05pm —
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 —
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 —
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 —
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 —
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 —
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 —
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.
Added by Anbarasan on October 1, 2008 at 5:30pm —
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.
Added by Anbarasan on October 1, 2008 at 4:00pm —
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 —
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 —
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 —
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 —