Understand the Differences Between Model Administration Tool and Semantic Modeler

Semantic Modeler offers most of the same functionality as Model Administration Tool with some exceptions. Before you migrate the semantic model, use this topic to understand some of the differences between Semantic Modeler and Model Administration Tool.

Functionality Differences

Item	Description
Initialization block deferred execution	In Semantic Modeler, when you create an initialization block, by default its deferred execution property is set to on. See Defer Session Variable Processing.
Allow Unmapped Table property	This field is included in Model Administration Tool logical table properties user interface, but isn't include in the Semantic Modeler logical table properties user interface. When you migrate a logical table source from Model Administration Tool or add a logical table source in Semantic Modeler, this property is internally set to on.

Terminology Differences

Model Administration Tool Term	Semantic Modeler Term
aggregation content	data aggregation
BI Server	Oracle Analytics query engine
Business Model and Mapping Layer	logical layer
common enterprise information model, RPD queries	semantic model
complex join	join expression
data model	semantic model
dynamic variable	global variable
execution precedence	dependencies
flat file	This term and concept not used in Semantic Modeler.
foreign keys	join
governed data model	semantic model
ignore (Query Limit field option)	inherit
logical dimensions	logical hierarchies
Logical Table Source (user interface elements and labels)	Sources tab (fact and dimension logical tables)
Logical Table Source dialog box's Content tab	Data Granularity section located on a logical table's Sources tab
metadata repository	semantic model
opaque view	SELECT statement
Oracle BI repository	repository
Presentation layer aliases	alternative names
query limit restrictions allow and disallow	available and unavailable
repository	semantic model
repository variable	semantic model variable
Row-wise initialization (Session Variable Initialization Block Variable Target field)	Query Returns field with Variable names and values selected
RPD	semantic model .rpd file
single join	join
Status Max Rows (Query Limits field)	Row Limit
Status Max Time (Query Limits field)	Max Time
translation	localization