Creating a project in SpagoBI Studio

Creating a project in SpagoBI Studio

SpagoBI Studio is an eclipse based BIRT reporting software and creating a project in SpagoBI studio is very much easy and recommended too as all our reports / documents will be organized in better way

Let’s start creating a project in SpagoBI Studio:

  1. Start SpagoBI studio
  2. Click File > New and select Project.
  3. Search for Report Project under (Business Intelligence and Reporting Tools).
  4. Assign Spago Tutorial
  5. Now, you should be able to see SpagoBI Tutorial under Project Explorer.
  6. Click Yes, to open Report Design Perspective.

Project Creation

Thanks & Regards
Venkatanaveen Dasari™

Creating a folder under Functionalities Tree in SpagoBI Server

Creating a folder under Functionalities Tree in SpagoBI Server

In general Spago BI uses its own functionalities tree which allows to better organize documents / reports by grouping them in folders. Although in built Folders are provided to organize (Analytical documents, Custom Documents and Audit & monitoring under Functional Tree) but most of the cases we like to maintain our reports to be placed under different folder.

Based on Role-Based permissions these folders are visible to user. This structure can be created or modified only by the administrator.

Let’s start creating a folder under Functionalities Tree:

  1. Login as biadmin.
  2. From left menu, Select Functionalities Management under Profile tab.
  3. By clicking on a node of the functionalities Tree a set of possible actions is shown:
  4. While clicking on Functionalities insert option fill in Label, Name & Description (option) on Functionalities Detail page.
    • Insert
    • Detail
    • Erase
    • Move up/down
  5. Assign roles as preferred and Save the page

Work Flow

Thanks & Regards
Venkatanaveen Dasari™

Introduction to SpagoBI

Introduction to SpagoBI

 

SpagoBI allows to produce reports using structured information views (lists,tables, crosstabs, graphs) and it allows the multidimensional analysis through OLAP engines, which are more flexible and user-friendly, compared to structured reports

overall architecture is composed of five modules:

SpagoBI Server:

  • The main module, which provides all the BI capabilities, is the SpagoBI Server. This is the only mandatory module, the one that offers a web-based end-user environment to run all types of analysis.
  • This is the only place / server where all BI documents are stored and used by end users. The end-user GUI is entirely web based and can be accessed via a common web browser

 

SpagoBI Meta:

  • Is the module of SpagoBI suite specifically focused on technical metadata management, whereas business metadata are managed by SpagoBI Server.

 

SpagoBI Studio:

  • Developers use SpagoBI Studio (client application) to develop analytical documents using the business model, to get data and deploy documents into a remote SpagoBI Server.

 

SpagoBI SDK:

  • Mainly to authenticate the user, send or receive metamodels, analytical documents or data sets.
  • It is the standard development kit for java developers who need to integrate SpagoBI with their applications.
  • It is a collection of web services, tag libraries or APIs that allow to relate an external application to SpagoBI Server, allowing to use some SpagoBI documents and functionalities in this environment.

 

The integration layer that allows external tools and applications to interact with SpagoBI Server

SpagoBI Applications:

  • SpagoBI Applications are ready to use. Usually, they don’t include code.
    Some pre-built analytical models can be installed into SpagoBI Server and be immediately released for the end-user.

 

Spago BI offers many engines for reporting and analytical area, following are few:

JasperReport,BIRTReport, BO (displaying reports managed by Business Objects 6.5),
JPivot/Mondrian, JPalo/Mondrian, JPivot/XMLA Server.