Book Image

Microsoft Dynamics AX 2009 Administration

By : Marco Carvalho , Marco Carvalho
Book Image

Microsoft Dynamics AX 2009 Administration

By: Marco Carvalho , Marco Carvalho

Overview of this book

Microsoft Dynamics AX 2009 is an advanced Enterprise Resource Planning system, essentially a comprehensive business management solution, designed for midsize and large organizations. Dynamics AX provides a centralized source for business data and enables you to consolidate and standardize your business processes, helping to improve productivity and provide visibility across your organization, for a variety of business needs.This book will enable you to successfully set up and configure Dynamics AX 2009 in your business with clear, practical, step-by-step demonstrations. You will learn how to plan and implement Dynamics AX 2009 efficiently, how to manage the Enterprise Portal, Role Centers, Kerberos Authentication, Workflow, Application Integration Framework (AIF), and much more! Each chapter of the book explores the different aspects of administring and configuring Dynamics AX 2009 to fit any company's needs.The book begins by introducing you to the important process of planning and implementing Dynamics AX 2009, providing the basic components to get you started with your Dynamics AX environment. It then dives deep into the installation of the multi component server of Dynamics AX and how to get it up and running efficiently, specifically the Base Server Components, Enterprise Portal, Role Centers, Kerberos Authentication, Workflow, and the Application Integration Framework (AIF).Other content includes the process of importing data into your Dynamics AX 2009 instance, common user administration functions, and Alerts and Notifications.Finally, the book considers how to enhance your Dynamics AX environment after it has been installed and it is being utilized, from tuning your system to work more efficiently to backing up and maintaining Dynamics AX to make sure you are prepared for worst-case scenarios, enabling you to keep Dynamics AX 2009 functioning at its best.By following the clear and practical steps found in the book, you will successfully master how to administer and configure Dynamics AX 2009 into your company.
Table of Contents (20 chapters)
Microsoft Dynamics AX 2009 Administration
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface

How to install Analysis Extensions on SQL Server Analysis Services 2008 and 2008 R2


The Dynamics AX 2009 installation program was designed to only install Analysis Extensions if SQL Server Analysis Services 2005 with SP2 is installed despite the fact that Analysis Extensions can work on SQL Server 2008 or SQL Server 2008 R2. To install Analysis Extensions on SQL Analysis Services 2008 or 2008 R2, you must first install it on SQL Analysis Services 2005. For example, you can temporarily install SQL Server Analysis Services 2005 on a test system. The entire process is outlined as follows:

  1. 1. Open SQL Server Management Studio.

  2. 2. Log in to an Analysis Services 2005 database that already has Analysis Extensions installed.

  3. 3. Select the Analysis Extensions database to copy to Analysis Services 2008/2008 R2. By default, this database is named Dynamics AX. Right-click and go to Script Database as | CREATE To | New Query Editor Window. You can also click on File—to automatically output contents to a file, or Clipboard—to automatically copy contents to the clipboard. This will create the XMLA definition of the Analysis Extensions database.

  4. 4. In the newly created query window of the XMLA definition for the Analysis Extensions database, select all the text and copy it or save it to a file. The goal is to save this definition, so that we may create the Analysis Extensions on Analysis Services 2008/2008 R2.

  5. 5. Now that the XMLA definition for Analysis Extensions database is saved, we can now log in to the Analysis Services 2008/2008 R2 database in the Management Studio.

  6. 6. In Analysis Services 2008/2008 R2, create a new database by right-clicking on the database folder and clicking on New Database....

  7. 7. In the New Database window, specify the appropriate parameters. It is recommended that Impersonation remain set to Default. When the required settings have been specified, click on the OK button to create the OLAP database.

  8. 8. Now that you have created a new OLAP database on the 2008/2008 R2 version of Analysis Services, create a new XMLA query.

  9. 9. In the query window, open or paste the XMLA definition, generated from step 4.

  10. 10. Execute the XMLA query by clicking on the Execute button or by pressing F5. The execution will create the Analysis Extension database. This process may take several minutes to complete.

  11. 11. Now, Analysis Extensions can work with Analysis Services 2008/2008 R2. The process may also be handy for migrating and backing up OLAP databases because the entire definition of an OLAP database can be defined as XMLA.