Thursday, 17 April 2014

Metadata is the key for efficient BI processing





The MicroStrategy BI architecture incorporates seven primary layers of metadata objects. Each layer represents a progressively higher level of abstraction from the physical data structures:
1.      Configuration Objects
Users, user groups, schedules, projects, and data source connections make up foundation of BI applications.
2.      Data Abstraction Objects
Logical tables, attributes, and facts translate physical data structures to the logical business model.
3.      Business Abstraction Objects
Metrics, hierarchies, custom groups, and transformations combine data abstraction objects into business definitions and organizational structures.
4.      Report Components
Templates, filters, auto styles and prompts are high level abstraction objects, and are part of the basic building blocks of a report definition.
5.      Reports and Documents
Report definitions are highly formatted enterprise reports that include cross-tabular grids and graphs as well as scorecards, dashboards, visual analyses and mobile apps. These reports track key performance indicators and business processes.
6.    Visual Analyses
A Visual Analysis object is a display of raw data as visualization. With a Visual Analysis object, business users can quickly spot outliers, identify patterns and discover data visually eliminating the need to sift through large columns and rows of data for insights.
7.Delivery Objects
Delivery objects define personalized information services that distribute reports to E-mail recipients, and to printers and folders. The abstractions defined by these metadata object layers enable quick and easy report creation, and distribution without the need for any programming. Objects are simply assembled directly from the metadata and resolved when the report is run. Since all MicroStrategy objects access the same metadata repository, any modifications to the metadata are automatically propagated to all objects and all reports.


0 comments:

Post a Comment