Domain creation in Jaspersoft Server

Introduction

A Domain is a virtual view, created and stored in the server without modifying the data source. Through a Domain, users see columns that have been joined, filtered, and labeled for their business needs. Security policies limit the data values users can access through a Domain. Administrators define Domains, and users create reports based on Domains using either the Ad Hoc Editor or iReport.

Creating a Domain

1. Login into the Jasper server as an superuser and select Create > Domain.



2. Under choose data window , select the database ( For Example : Foodmart data source)



3. Next window you can see six option at the top of right hand side (Data Management, Joins, Pre-filters, Data Presentation, Security, Locales).
4. Click Data Management, select schema (For Example : public).



5. Select the tables which you want perform under public.



6. Click Join at the top of right hand side, In join window select the fields which you want to use to join two tables, the tables are present in left hand side.



7. Drag and drop the fields at main window and you can select the join type. We can create one or more joins inside the one tree (Jointree_2).



8. Next click Pre-Filters, select the required fields for filter and select the type of filter ( equals, is one of, etc.,) click ok.



9. Next click Data Presentation select the required fields which you want to display in the report , choose the Content type (Measure or Fields) and Summary calculation (Sum, Count, Min, Max, etc.,).






Make data easy with Helical Insight.
Helical Insight is the world’s best open source business intelligence tool.

Claim Your 30 Days Free Trail

10. Next click Locals > Add locale Bundles, select required language(US, French, German). Click ok.



11. Click save icon > Save Domain on top of left hand side , enter the Domain name and description in required field and select path to save the domain. Click Save button.

Thank You,
Nikhilesh
Helical IT Solutions Pvt Ltd

Best Open Source Business Intelligence Software Helical Insight is Here

A Business Intelligence Framework

Free
Download