Thursday, August 22, 2013

Dimension Hierarchies and Categories

Dimension Hierarchies/Categories
When a user analyzes the measurements along a business dimension, the user usually would like to see the numbers first in summary and then at various levels of detail. What' the user does here is to traverse the hierarchical levels of a business dimension for getting the details at various levels. For example, the user first sees the total sales for the entire year. Then the user moves down to the level of quarters and looks at the sales by individual quarters. After this, the user moves down further to the level of individual months to look at monthly numbers. What we notice here is that the hierarchy of the time dimension consists of the levels of year, quarter, and month. The dimension hierarchies are the paths for drilling down or rolling up in our analysis. 

Within each major business dimension there are categories of data elements that can also be useful for analysis. In the time dimension, you may have a data element to indicate whether a particular day is a holiday. This data clement would enable you to analyze by holidays and see how sales on holidays compare with sales on other days. Similarly, in the product dimension, you may want to analyze by type of package. The package type is one such data clement within the product dimension. The holiday nag in the time dimension and the package type in the product dimension do not necessarily indicate hierarchical levels in these dimensions. Such data elements within the business dimension may he called categories. 

Hierarchies and categories are included in the information packages for each dimension. Let us go back to the two examples in the previous section and find out which hierarchical levels and categories must be included for the dimensions. Let us examine the product dimension. Let us examine product is the basic automobile. Therefore, we include the data elements relevant to product as hierarchies and categories. These would be model name, model year, package styling, product line, pi %.duct category, exterior color, interior color, and first model year. Looking at the other business dimensions for the auto sales analysis, we summarize the hierarchies and categories for each dimension as follows: 

Product:- Model name, model year, package styling, product line, product category, exterior color, interior color, first model year
Dealer:-  Dealer name, city, state, single brand nag, date first operation
Customer demographics:- Age, gender, income range, marital status, household sue, Veil IC Ics owned, home value, own or rent
Payment method:- ' Finance type, term in months, interest rate, agent
Time:- Date, month, quarter, year, day of week, day of month, season, holiday flag
Let us go back to the hotel occupancy analysis. We I' ' included three business dimensions. Let us list the possible hierarchies and category the three dimensions.
Hotel:- Hotel line, branch name, branch code, region, address, city, state, Zip Code, manager, construction year, renovation year
Room Type:- Room type, room size, number of bed, types of beds, maximum occupants, suite, refrigerator, kitchenette
Time:-  Date, day of month, day of week, month, quartet, year, holiday flag

Wednesday, August 21, 2013

Business Dimensions

Business Dimensions
As we have seen, business dimensions form the underlying basis of the new methodology for requirements definition. Data must be stored to provide for the business dimensions. The business dimensions and their hierarchical levels form the basis for all further phases. So we want to take a closer look at business dimensions. We should be able to identify business dimensions and their hierarchical levels. We must be able to choose the proper and optimal set of dimensions related to the measurements. 

We begin by examining the business dimensions for an automobile manufacturer. Let us say that the goal is to analyze sales. We want to build a data warehouse that will allow the user to analyze automobile sales in a number of ways. The first obvious dimension is the product dimension. Again for the automaker, analysis of sales must include analysis by breaking tlic sales down by dealers. Dealer, therefore, is another important dimension for analysis. As an automaker, you would want to know how your sales break down along customer demographics. 

You would want to know who is buying your automobiles and in what quantities. Customer demographics would be another useful business dimension for analysis. How do the customers pay for the automobiles? What effect does financing for the purchases have on the sales'? These questions can be answered by including the method of payment as another dimension for analysis. What about time as a business dimension? Almost every query or analysis involves the time element. In summary, we have come up with the following dimensions for the subject of sales for an automaker: product, dealer, customer demographic, method of payment, and time.. 

Let us take one more example. In this case, we want become up with an information package for a hotel chain. The subject in this case is hotel occupancy. We want to analyze occupancy of the rooms in the various branches of the hotel chain. We want to analyze the occupancy by individual hotels and by room types. So hotel and room type are critical business dimensions for the analysis. As in the other case, we also need to include the time dimension. In the hotel occupancy information package the dimensions included are hotel, room type, and time.


We will now introduce a novel idea for determining and recording information requirements for a data warehouse. This concept helps us to give a concrete form to the various insights, nebulous thoughts, and opinions expressed during the process of collecting requirements. The information packages, put together while collecting requirements are very useful or taking the development of the data 'warehouse to the next phases.

Requirements Not Fully Determinate. As we have discussed, the users arc unable to describe fully what they expect to see in the data warehouse. 'You are unable to get TA handle cm what pieces or in you want to keep in the data warehouse. You are unsure of the usage patterns. You cannot determine how each class of users will use the new system. So, when requirements cannot be fully determined. we need a new and innovative concept to gather and record the requirements. The traditional methods applicable to operational systems are not adequate in this contest we cannot start with the functions, screens and reports. We cannot begin with the data structures. We have noted that the users tend to think in terms of business dimensions and analyze measurements along such business dimensions. This is a significant observation and can form the very basis for gathering information.

The new methodology for determining requirements for a data warehouse system is based on business dimensions. It flows out of the need of the users to base their analysis on business dimensions. The new concept incorporates the basic measurements and the business dimensions along which the users analyze these basic measurements. Using the new methodology, you come up with the measurements and the relevant dimensions that must be captured and kept in the data warehouse. You come up with what is known as an information package for the specific subject.

Let us look at information package flu sales for a certain business. Figure 5-4 contains such an information package. The subject here is sales, the measured facts or the measurements that are of interest for analysis are shown in the bottom section of the package diagram. In this ease, the measurements are actual sales, forecast sales, and bud-get sales. The business dimensions along which these measurements arc to be analyzed are shown at the top of diagram as column headings. In our example, these dimensions arc lime, location, product, and demographic age group. Each of these business dimensions contains a hierarchy or levels. For example, the time dimension has the hierarchy going from year down to the level of individual day. The other intermediary levels in the time dimension could be quarter, month, and week. These levels or hierarchical components are shown in the information package diagram.

Your primary goal in the requirements definition phase is to compile information pack-ages for all the subjects for the data warehouse. Once you have firmed up the information packages. You'll be able to proceed to the other phases.

Essentitilly information packages enable you to:
  • Define the common subject areas
  • Design key business metrics
  • Decide how data must be presented
  • Determine how users will aggregate or roll up
  • Decide the data quantity for user analysis or query
  • Decide how data will be accessed 

Figure 5-4 An Information Package

  • Establish data granularity
  • Estimate data warehouse size
  • Determine the frequency for data refreshing
  • Ascertain how information must be packaged

Monday, June 17, 2013

70-342 Question 1

70-342 Question 1
You need to configure transport rules to meet the technical requirements for the PII data and the financial data. How should you configure the rules? To answer, disable the appropriate rule or rules in the answer area.



Microsoft 70-342 Exam

Microsoft 70-342 Exam
Microsoft Advanced Solutions of Microsoft Exchange Server 2013

The 70-342 practice exam is written and formatted by Certified Senior IT Professionals working in today's prospering companies and data centers all over the world! The 70-342 Practice Test covers all the exam topics and objectives and will prepare you for success quickly and efficiently. The 70-342 exam is very challenging, but with our 70-342 questions and answers practice exam, you can feel confident in obtaining your success on the 70-342 exam on your FIRST TRY!

Microsoft 70-342 Exam Features

- Detailed questions and answers for 70-342 exam
- Try a demo before buying any Microsoft exam
- 70-342 questions and answers, updated regularly
- Verified 70-342 answers by Experts and bear almost 100% accuracy
- 70-342 tested and verified before publishing
- 70-342 exam questions with exhibits
- 70-342 same questions as real exam with multiple choice options

Acquiring Microsoft certifications are becoming a huge task in the field of I.T. More over these exams like 70-342 exam are now continuously updating and accepting this challenge is itself a task. This 70-342 test is an important part of Microsoft certifications. We have the resources to prepare you for this. The 70-342 exam is essential and core part of Microsoft certifications and once you clear the exam you will be able to solve the real life problems yourself.Want to take advantage of the Real 70-342 Test and save time and money while developing your skills to pass your Microsoft 70-342 Exam? Let us help you climb that ladder of success and pass your 70-342 now!

Section 1: Sec One (1 to 9)
Details:Topic 1, Fabrikam, Inc
General Overview

Fabrikam, Inc., is a plastics manufacturer.
Fabrikam has an Exchange Server organization that contains only servers that have Exchange Server 2013 installed.

Physical Locations
Fabrikam has two main offices. The main offices are located in Tampa and Charlotte. The company has 8,000 users in each office.

Existing Environment

Active Directory Environment
Fabrikam has an Active Directory forest that contains one domain named Each office is configured as an Active Directory site. The network contains four subnets. The subnets are configured as shown in the following table.

All of the traffic from Subnet1 is routable to Subnet3. All of the traffic from Subnet2 is routable to Subnet4.All client computers are on Subnet1 and Subnet3 only. Subnet and subnet are assigned as the MAPI network. The network contains four domain controllers. The domain controllers are configured as shown in the following table.

Network Infrastructure

The network contains the following components:
- Two 10-gigabits per second WAN links that connect the Tampa office and the Charlotte office. The links have a latency of less than 15 ms.
- One IP-PBX that is located in the Tampa office. The IP-PBX can use only unencrypted communications.
- An Internet connection in the Tampa office and an Internet connection the Charlotte office.

Exchange Environment
The network contains six servers that have Exchange Server 2013 installed. The servers are configured as shown in the following table.

The Exchange Server environment has the following configurations:
- Two data loss prevention (DLP) policies named DLP_Finance and DLP_PII. DLP_Finance is based on a template named Financial Data - U.S. DLP_PII is based on a template named PII (U.S.).
- A mailbox database named UM that hosts only Unified Messaging (UM)- enabled mailboxes and nis replicated between the Mailbox servers in the Tampa office only.
- A database availability group (DAG) named DAG1 that contains EX2, EX3, EX5, and EX6. DAG1 is configured to use DHCP to obtain an IP address.
- A Send connector named Tampa SMTP that uses SMTP1 as a smart host. The cost of the Tampa SMTP connector is 10.
- Mailbox servers in the Tampa office that provide outbound SMTP services to the Internet.
- A UM dial plan named UMl.
- An SMTP relay device named SMTP2 in the Charlotte office.
- An SMTP relay device named SMTP1 in the Tampa office.
- No client access services are published to the Internet.


Exchange Server Issues
- The current Exchange Server environment has the following issues:
- Due to power failures, the Exchange servers unexpectedly fail, causing databases to fail over. During the database failovers, the preferred database is not activated, causing an unexpected distribution of active databases.

- An IRM template named No Print or Screenshot is deployed, but the template fails to prevent users from taking screenshots of email messages. Technical Requirements
You identify the following technical requirements:
- Assign a static IP address to DAG1.
- Block all personally identifiable information (PII) data and financial data without exception.
- Prevent the forwarding of email messages sent by users who have a value of Legal in their Department field.
- Ensure that the members of a group named HR1 can search all of the mailboxes for sensitive email content.
- Use Information Rights Management (IRM) to protect all of the voice mails left for the telephone number of the human resource (HR) department.
- Implement an archiving policy that moves all of the email messages from the mailbox folders to an Archive mailbox after 30 days and permanently deletes all of the email messages after 365 days.