As the name suggest the Data Exploration Bookmark Portlet displays a list of Data Explorations and the booksmarks saved within each exploration.  Users can click on a link to open the relevant Data Exploration/Bookmark.

View more about the Data Exploration Bookmark Portlet

 

 

Data Exploration Portlet

As the name suggest the Data Exploration Bookmark Portlet displays a list of Data Explorations and the booksmarks saved within each exploration.

• Interactive tree view
• Displays all data explorations
• Expand all option
• Open a bookmark in Web OLAP Viewer
• Complies with metadata security

View more about the Data Exploration Bookmark Portlet

 

 

Data integration server and studio makes building a Data Warehouse so much easier.  And with the tips we have found you can almost build one with your eyes closed.

View a list of SAS Data Integration Tips and Tricks 

You can code by hand or use Data Integration Studio.  If you agree with us that Data Integration Studio is the way to go here are some papers on how to get the best out of it.

View SAS Forum Papers about Data Integration

A department-specific data warehouse.
A) Independent – fed from legacy systems within the department
B) Dependent – fed from the enterprise data warehouse (preferred)

The process of finding hidden patterns and relationships in data. For instance, a consumer goods company may track 200 variables about each consumer. There are scores of possible relationships among the 200 variables. Data mining tools will identify the significant relationships.

Removing errors and inconsistencies from data being imported into a data warehouse.

The modification or alteration of data as it is being moved into the data warehouse.

A data type defines the type of data stored in a specific database column, such as date, numeric or character data. Significant differences in data types exist between different platforms’ databases.

A data warehouse is a subject oriented, integrated, non volatile, time variant collection of data. The data warehouse contains atomic level data and summarized data specifically structured for querying and reporting.

An enterprise-wide implementation that replicates data from the same publication table on different servers/platforms to a single subscription table. This implementation effectively consolidates data from multiple sources.

The logical and physical definition of a database structure.

A stamp added by an application that identifies a task or activity by the date and time it was initiated and/or completed. This can appear as part of a transaction log, message queue content in job logs.

A centralized database that has been partitioned according to a business or end-user defined subject area. Typically ownership is also moved to the owners of the subject area.

A remote data source tfgefwefeefw fwhat users can query/access via a central gateway that provides a logical view of corporate data in terms that users can understand. The gateway parses and distributes queries in real time to remote data sources and returns result sets back to users.

Software that supports exception reporting, stop light reporting, standard repository, data analysis and rule-based analysis. A database created for end-user ad-hoc query processing.

the technique of placing normalized data in a physical location that optimizes the performance of the system.