Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Limitations of Data Mart

Ties to the Eagle Data Model (Opportunity for Enterprise Reporting)

...

When you use Data Mart, you can use views to supplement your Eagle data. This practice can offer an opportunity to use the Data Mart schema as an integration point for enterprise information delivery. See “How to Move Non-OLAP Data to the Mart. The Eagle Portal Access SQL Query is used by clients to create queries and dashboards that source data from non-Eagle sources, and integrate those sources with their Eagle data. See the section Eagle Portal Administration for information.

...

  • Views against warehouse fields can be built, and field attributes built against those views.  These field attributes can underlie fields in Mart tables.  However, prior to V11.0 there is a step you must take to support view-based field attributes in Data Mart. 

  • Some warehouse tables are structured in ways that make OLAP processing impossible.  For these, a view may be created directly against the warehouse table data, and included in the Data Mart database.

  • Performance needs to be considered when using views as mentioned in the “Ties to the Eagle Data Model” section.

...

  • when using views

...

  • .

Use Cases Not Supported by Data Mart

...