Tuesday, 28 May 2013

Creating Domain in JasperServer

What are Domains ?

* A Domain is a metadata layer that provides a business view of the data accessed through a data source.
* A Domain presents the data in business terms appropriate to your audience, and can limit the access to
data based on the security permissions of the person running the report.
* A Domain defined in JasperReports Server can be used to create reports, Ad Hoc views, and Domain Topics.


Tutorial to create a domain :
---------------------------------
http://community.jaspersoft.com/wiki/creating-domain


What is metadata ?

* The term metadata refers to "data about data".
* Metadata is data about data.
* It is descriptive information about a particular data set, object, or resource, including how it is formatted, and when and by whom it was collected.
* Although metadata most commonly refers to web resources, it can be about either physical or electronic resources.
* It may be created automatically using software or entered by hand.

More Information about metadata.
-------------------------------------
https://en.wikipedia.org/wiki/Metadata


NOTE:
* We generally create database in SQL clients such as mySQL, SQL, postgreSQL and etc.
* For example :

Our database looks like :

sample database
table1
A
B
C
table2
D
E
F
G
table3
H
I
J
K
and etc where A, B, C,D,.... etc are fields in the respective tables.

* We can say metadata or Domain from the above sample database as follows.
table1
A
B
table2
F
G
i.e, which ever tables and the fields in the tables we want to use in reporting and/or in analysis we separate them as a mini database which is nothing but domain or metadata.

* While creating metadata we may use some conditions, joins, SQL operations, security things and etc.


1 comment:

  1. Hi Sadakar,
    I am trying to create domain on jasperreports-server-5.1 with datasource pointing to my application oracle tables. I am not able to expand tables which name contains underscore i.e. project_detail. It expands table project. Do you have any idea? Can you please help me?

    -Puneet

    ReplyDelete