Conventions

In this book, you will find a number of styles of text that distinguish between different kinds of information. Here are some examples of these styles, and an explanation of their meaning.

Code words in text, database table names, folder names, filenames, file extensions, pathnames, dummy URLs, user input, and Twitter handles are shown as follows: "The name of the OLAP processing package is DynamicsGP_<warehouse_db>_OLAP_DB_<server name>_<analysis services database>, where <warehouse_db> is the name of the data warehouse database."

A block of code is set as follows:

UPDATE LastUpdated
SET [DateUpdated] = '01/01/1900',
  [LastRow] = 0, 
  [TempLastRow] = 0
WHERE TableName IN ('GLAccountMaster','GLTransactionsOpen','GLTransactionsHistory');

TRUNCATE TABLE GLAccountMaster;
TRUNCATE TABLE GLTransactions;

Any command-line input or output is written as follows:

=CUBEMEMBER("GP Financials Cube","[Accounts].[Acct No].[All].[000-1100-00]")
=CUBEMEMBER("GP Financials Cube","[Measures].[Amount - GL Trans]")

New terms and important words are shown in bold. Words that you see on the screen, in menus or dialog boxes for example, appear in the text like this: "The first three nodes—Date, Date by Month, and Quarter by Year—under the Master Date node are known as hierarchies."