Jaspersoft BI Tools

iReport,Jaspersoft Design Studio,Jaspersoft Server, Schema Workbench,Analysis,Dashboards, Self Service BI, Domains,Topics,Ad-Hoc Reports, Jaspersoft ETL, Embedding BI,HTML-5 charts, Fusion Charts,JFree Charts,Drill down reports , Drill down Dashboards,Visualize.js, Performance Tuning, D3 Charts, Jaspersoft Customization

Tuesday, May 28, 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.