Business views provide report developers and end users with an easily understood business-oriented view of their data. They internally contain database connections and relationships between view elements that are required for creating reports but display data to end users in an easy to use flat structure. Business views shield end users from having to understand the underlying data structure, while enabling them to create complex reports containing multiple components.
All reports created from a business view automatically include all of the interactivity built into that business view. For example, they can include things like drill down, drill up so that end users are able to switch data from one group to another; they can allow end users to exchange the columns and rows of a crosstab, and to convert a chart to a crosstab and vice verse.
You can mash up multiple data resources from different connections into a single business view for more complex, deeper insights, including tables, views, synonyms, imported SQLs, imported APEs, stored procedures, queries and user defined data sources, and can create distributed joins to set up inter-relationships between the data resources. Data mashup makes it possible to integrate multiple separated application systems in your enterprise so as to get more comprehensive and objective data for decision making. Distributed joins extend this by letting you access multiple data resources as one virtual data resource. However mixed data resources cannot get the performance optimization as can single data resource by pushing down group query, while by using Logi JReport Server's in-memory cubes, better performance is guaranteed even with big data retrieval.
You can also create cached query result for a business view so as to retrieve data to reports from your machine instead of getting data from the database.
The following topics provide more information about business views:
Note: A Logi JReport Live license for Logi JReport Designer is required in order to use this feature. If you do not have the license, contact your Logi Analytics account manager to obtain it.
Please sign in to leave a comment.