This article by Tomislav Piasevoli, author of MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook, discusses the common MDX tasks and one or more ways to solve them or deal with them appropriately. We'll cover basic principles and approaches such as how to skip an axis and prevent common errors, how to set the default member of a hierarchy, and how to format cell foreground and background colors based on the value in cells.
Specifically, we will cover:
- Skipping axis
- Handling division by zero errors
- Setting special format for negative, zero, and null values
- Applying conditional formatting on calculations
- Setting default member of a hierarchy in MDX script
In this article by Tomislav Piasevoli, author of MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook, we will take a look at some recipes on how to perform iteration. They deal with those cases when there's no other way but to iterate. However, some of the recipes also point out which calculation patterns we must recognize and thereby give up on using classic naïve iteration and use a better approach.
We will cover:
- Iterating on a set in order to reduce it
- Iterating on a set in order to create a new one
- Iterating on a set using recursion
In the previous article, BizTalk Application: Currency Exchange Rates, we took a look at the setup for sending data using AIF XML documents to AX. We can use the BizTalk adapter to retrieve data from Dynamics AX via this AIF module. This is done using the AIF Queue manager. Throughout Dynamics AX, there are Send electronically buttons that can allow you to push data into the AIF Queue with an Outbound direction. Similarly, asynchronous incoming messages have an Inbound direction parameter.
In this article by Carl Darski, author of Microsoft BizTalk 2010: Line of Business Systems Integration, we'll create a BizTalk application that retrieves messages from Dynamics AX 2009 via the AIF Queue.Read BizTalk Application: Dynamics AX Message Outflow in full
The best way to understand the behavior and setup required to use the Dynamics AX BizTalk adapter is to walk through a full example. A common requirement for many companies that use Dynamics AX is to populate the currency exchange rates. Typically, this needs to be daily when the closing rates are published. The Exchange Rates(General ledger | Setup Exchange rates) table in AX is not a shared table across companies, thus depending how your organization is set up; you may or may not need to populate the Exchange rate table using multiple companies with multiple rates.
In this article by Carl Darski, author of Microsoft BizTalk 2010: Line of Business Systems Integration, we'll create a BizTalk application to populate the exchange rates table.Read BizTalk Application: Currency Exchange Rates in full
In this article by Carl Darski, author of Microsoft BizTalk 2010: Line of Business Systems Integration, we'll discuss integrating with Microsoft Dynamics AX 2009 using the BizTalk Dynamics AX adapter. It will be a complete walkthrough for the configuration setup in the Dynamics AX 2009 Application Integration Framework (AIF)module and related set up for batch jobs.
We will specifically cover:
- What is Dynamics AX?
- Methods of integration with AX
- Installing the adapter and .NET Business Connector
- Configuring Dynamics AX 2009 Application Integration Framework for BizTalk Adapter
Business change is a constant necessity as a result of increased competition, improved technology, and shifts in consumer patterns. As a result, an enterprise will reorganize, acquire other businesses, create new applications, and downsize others. Throughout these changes, companies are faced with the challenge of efficiently provisioning their resources in response to their business priorities. To deliver data where it is needed, when it is needed, requires sophisticated information integration technologies.
This article by Jason Williamson, co-author of Oracle Information Integration, Migration, and Consolidation, discusses the basic concepts of information integration and reviews historical approaches to information integration. We will compare data-level integration with process and application integration. This will provide some solid examples for real world decisions, when trying to understand information integration and how this relates to your business and technical initiatives.Read Getting Started with Oracle Information Integration in full
With the new release of WebCenter, you have the ability to create rich enterprise portals without needing to code a lot. This article, by Yannick Ongena, author of Oracle WebCenter 11g PS3 Administration Cookbook, explains how to set up, create, and build such a portal application.
In this article, you will learn about:
- Preparing JDeveloper for WebCenter
- Creating a Webcenter portal
- Managing pages
- Changing the look and feel of your portal
- Editing pages using the composer
In early 2010, when you went to the Oracle Technology Network (OTN) website, it had just one link called Information Integration. This link led you to a simple web page that had information on Oracle-to-Oracle database-centric migration and integration tools such as SQL Loader, Data Pump, Oracle Streams, and Oracle Data Guard. The OTN website has been updated, but still lacks comprehensive coverage of the Oracle Information Integration stack. In this article by Tom Laszewski, co-author of Oracle Information Integration, Migration, and Consolidation, we will provide you with the relevant information, so that you can use the right Oracle Enterprise Information Integration (EII) or data migration product for your data migration, consolidation, and information integration projects.
This article covers the Oracle integration, migration, and consolidation products, tools and technologies in terms of the following taxonomies: data migration, physical federation, virtual federation. The focus of this article is to cover the great breadth and depth of Oracle products, not all the finer details.Read Oracle Tools and Products in full
Microsoft Data Protection Manager (DPM) 2010 is a backup and recovery solution which provides continuous data protection for Windows application and file servers to seamlessly integrated disk, tape, and cloud.
In this article by Steve Buchanan, author of Microsoft Data Protection Manager 2010, we will take a look at the existing as well as new features of DPM.Read The DPM Feature Set in full
In this article by Mike Pfeiffer, author of Microsoft Exchange Server 2010 Windows PowerShell Cookbook, you'll learn how to create Address Lists and Hierarchal Address Books. This article has immediately-usable task-based recipes for managing and maintaining your Microsoft Exchange 2010 environment with Windows PowerShell 2.0 and the Exchange Management Shell for some address list management that can be automated through the shell.
In this article, we will cover the following:
- Creating address lists
- Exporting address list membership to a CSV file
- Configuring hierarchical address books