1325
Chapter 58: Creating and Deploying BI Semantic Models
58
or no processing when the project is deployed. The default option allows Analysis Services
to determine the type of processing required.The Transactional Deployment Option specifi es whether deployment and processing should
be part of the same transaction. This means that if deployment succeeds but processing
fails, both operations will be rolled back. The default is False, meaning the operations are
not part of the same transaction.Query Mode specifi es the source from which query results are returned. The options
follow:■ (^) In-Memory: Query results are returned from cache only.
■ Direct Query: Query results are returned directly from the relational data source
only. Only a single relational data source is supported. For additional limitations
refer to http://msdn.microsoft.com/en-us/library/hh230898.aspx.
■ (^) In-Memory with Direct Query: Query results are returned from cache by default
unless otherwise specifi ed in the connection string from the client.
■ (^) Direct Query with In-Memory: Query results are returned from the relational data
source by default unless otherwise specifi ed in the connection string from the
client.
Deployment Server Options
The deployment server options specify target server and database properties. The deploy-
ment server options include:
■ Server: The target Analysis Services Tabular Mode instance name to deploy the
project to.
■ Edition: The SQL Server Edition of the Analysis Services Tabular Mode instance.
Options are Business Intelligence, Enterprise, Enterprise Core Licensing, Evaluation,
or Standard Edition.
■ (^) Database: The name of the in-memory column-store database that hosts the cube,
dimensions, and measures.
■ (^) Cube name: The name of the cube that integrates the data model and business
logic and to which users connect to do analysis.
DirectQuery Options
DirectQuery Options specify the credentials you need to use to connect to the rela-
tional data source when querying a model running in DirectQuery Mode. The Default
Impersonation Setting specifi es that the same credentials provided during the Data Import
Wizard will be used. The ImpersonateCurrentUser setting specifi es to use the credentials of
the user trying to establish the connection.
c58.indd 1325c58.indd 1325 7/31/2012 10:36:05 AM7/31/2012 10:36:05 AM
http://www.it-ebooks.info