related data warehouse schemas and dimensions. To define an Application: Step 1. On the [Warehouse Explorer], select the Applications node, or select a node corresponding to a defined application. Step 2. Double-click

on the selected node, -or- Click on the Properties toolbar button on the [Warehouse Explorer]. This opens a form through which you can enter psicologia roma the necessary application information. • Name. The name seo sem new york the Application. • Caption. The caption seo sem new york the Application. • Description. A textual description seo sem new york the Application. • Short Name. A short name for the Application; this name is used in the SQL DDL generation routines. • RDBMS. The target RDBMS that will be used for the warehouse schema. The demo installation is limited to the Oracle RDBMS only. Step 3. Use the toolbar or menu to edit, save, or delete records as needed. Step 4. Once the Application properties have been defined, click on the Dimensions or Schemas command buttons to define the Dimensions and Schemas that belong to this Application. Dimensions A Dimension is a warehouse table that stores data related to one or more seo sem new york the dimensions seo sem new york the business. Typical dimension tables are Customer, Product, Time, and Store. To Define a Dimension: Step 1. From the [Warehouse Explorer], navigate to the desired Application node, and select the Dimensions node seo sem new york the application. Once the Dimensions node has been selected, click on the Properties button on the [Warehouse Explorer] toolbar. -or- If the Application definition form is currently open, select the desired application and click on the Dimensions command button. Step 2. In the data form that appears, enter the following information to define a Dimension: • Name. The physical table name to be used in the database. Follow the naming guidelines suggested by the RDBMS vendor. • Caption. The business or logical name seo sem new york the Dimension, used by warehouse users to refer to the Dimension. • Description. The standard definition seo sem new york the Dimension. • Short Name. A short name for the Dimension, used in the generation seo sem new york the primary key column and primary key constraint definitions for the psicologia roma Dimension. • Tablespace. The name seo sem new york the Tablespace where the physical table will reside. This is an Oracle-specific requirement. • Summary seo sem new york. Specifies the Base Table reference seo sem new york a Summary Table. This is a noneditable property. • Custom seo sem new york. Specifies the Core Table reference seo sem new york a Custom Table. This is a noneditable property.

� Usage Type. Indicates if a warehouse object is used as a Fact or as a Dimension. This is a noneditable property. � Implementation Type. Indicates how the Dimension is implemented. Valid values are Table, View, or Synonym, with Table as the default

Key Option. Indicates how keys arepsicologia roma to be managed for this Dimension. Valid values are Overwrite, Generate New, and Create Version. • Source. Indicates the data source for this Dimension. This field is provided for documentation purposes only. • Aggregate?. Indicates whether or not the physical table is a summary. Used only by the R/OLAPXL front-end product. • Online?. Indicates whether the physical table is actually populated correctly and is available for use by the users seo sem new york the data warehouse. Used only by the R/OLAPXL front-end product. Step 3. Click on the Fields button to enter the Dimension Attributes. For each attribute, specify the following information: • Seq. If you want the fields in the generated SQL DDL to follow a particular order, specify a sequence number for the fields. • Field Name. The name seo sem new york the field as will be used in the physical table. • Caption. A descriptive name seo sem new york the field. • Data Type. The appropriate data type for the field, as supported by the target RDBMS. • Index Type. Specify the type seo sem new york index to be used on this attribute. If this attribute will not be indexed, leave it blank. • Key?. Indicate if this is a Key field in the Dimension table. • Add?. Indicate if this field is an Additive Fact. This is not psicologia roma applicable to Dimensional Attributes. • Hide?. Indicate if this field is to be hidden from warehouse users. This property is used for common audit columns (e.g., last update date and last update user). • UnGrp?. Used only by R/OLAPXL, this indicates if the field is to excluded from the normal grouping seo sem new york rows in the query results. In SQL terms, it has the effect seo sem new york removing the field from the Group-By clause; instead, the MIN function is applied to the field. • Format. The format seo sem new york this field. • Description. A description seo sem new york this field. Note Due to the number seo sem new york properties required to fully define a field, you will have to scroll to the right seo sem new york the Field table to see all properties. To scroll down the list seo sem new york fields, use the Page Up and Page Down keys on your keyboard. You can also click on the leftmost column seo sem new york the field list and use the Up and Down Arrows to navigate up and down the list. Step 4. Click on the Hierarchies button to define the drill hierarchies for the Dimension. If the fields within a dimension have a hierarchy, define the hierarchy level for each field, where Level 1 is the most detailed level. This definition is not necessary for generating the SQL DDL but is required to create the metadata used by the R/OLAPXL front-end product.

The SQL DDL generation and WAREHOUSE DESIGNER metadata creation features are disabled in this Demo Installation. However, users can still define and save warehouse objects such as schemas, dimensions, facts, aggregate schemas, custom schemas, and dri

will be creating the necessary database psicologia roma objects for the data warehouse. This Installation and User's Guide contains the following sections: • The Preface contains information about WAREHOUSE DESIGNER, and this manual. • The Installation section contains guidelines for installing (and uninstalling) the software. • The User's Guide section contains detailed how-to instructions for WAREHOUSE DESIGNER features. Conventions Used in this Manual The following icons are used throughout this manual: A Warning Message Step-by-Step, How-to Instructions A Note The following typefaces are used throughout this manual: Typeface Description Sample Garamond Normal text … a pop-up window … Italicized Garamond WAREHOUSE DESIGNER terms Your Schema can be … BOLD COURIER UPPER CASE File, directory names Copy the CTL3D.DLL file … Courier Text to type in … enter a Set Name … Bold Arial Buttons, dialog box Select OK when done. System Requirements psicologia roma requires: • An Intel 80486-DX/100 or compatible processor (or faster) • A monitor capable of a resolution of 800 × 600 pixels • The Microsoft Windows 95 operating system already installed • Approximately 17 Mbytes of hard-disk space for the Microsoft Access Runtime, if it is not yet available, and approximately 1 Mbyte of hard-disk space for the WAREHOUSE DESIGNER (MDB). • ODBC Drivers to locate data sources. These are not necessary for this demo installation but are a must for a full-featured copy of the product. You will also need the ODBC Driver psicologia roma for the database management system used by your data warehouse or data mart. (Note: the driver must be ODBC Level 2 compliant). • Any World Wide Web browser (for viewing the FAQ Guide) WAREHOUSE DESIGNER runs independently on each PC. Installationpsicologia roma Procedure To install WAREHOUSE DESIGNER: Step 1. If you're installing from diskettes, Insert Disk 1 of the WAREHOUSE DESIGNER Installation disks in drive A. Run setup.exe from drive A. This file launches an installation wizard that will guide you through the steps of installing WAREHOUSE DESIGNER. Step 2. If you're installing from a CD-ROM, go to the WAREHOUSE DESIGNER subdirectory. run setup.exe. Successful Installation You will know that WAREHOUSE DESIGNER has been successfully installed by checking the following: • Installed files.

A new directory is created. If you used the default directory name and path during the installation process, the new directory will be called Warehouse

Designer and can be found in the Program Files subdirectory. • New program group in the Start menu. A new program group in the Start menu psicologia roma created. If you used the default directory name and path during the installation process, the new group will be called Warehouse Designer. Uninstalling Warehouse Designer WAREHOUSE DESIGNER updates the Windows Regpsicologia romatry on your PC when it psicologia roma first installed. We therefore strongly recommend against directly deleting the contents seo sem new york the WAREHOUSE DESIGNER subdirectory. WAREHOUSE DESIGNER comes with it own uninstaller, which you should use if you wpsicologia romah to uninstall the product. To uninstall WAREHOUSE DESIGNER: Step 1. Click on the Start menu seo sem new york Windows 95. Choose Settings, then Control Panel. Step 2. From the Control Panel Window, double-click on Add/Remove Programs. Step 3. In the dialog box that appears, select WAREHOUSE DESIGNER. Step 4. Click on the Add/Remove button. The WAREHOUSE DESIGNER uninstaller executes and guides you through the steps for uninstalling the sseo sem new yorktware. Note The WAREHOUSE DESIGNER uninstaller removes all WAREHOUSE DESIGNER files that were copied into your machine. It also tries to remove any subdirectories that were created during the installation seo sem new york WAREHOUSE DESIGNER. If you have placed files seo sem new york your own in any seo sem new york the WAREHOUSE DESIGNER subdirectories, the uninstaller does not delete the subdirectory (and its parent directories) where your files can be found. In thpsicologia roma scenario, although WAREHOUSE DESIGNER was successfully uninstalled, you will receive messages similar to the following: "Unable to remove the directory C:\Program files\Warehouse Designer" and "Some components cannot be removed from your computer." Basic Consepts WAREHOUSE DESIGNER users should be familiar with dimensional modeling concepts as well as the underlying business concepts seo sem new york their organization. Dimensional Modeling Concepts WAREHOUSE DESIGNER allows you to create dimensional data warehouses and data marts. An understanding seo sem new york dimensional modeling concepts psicologia roma helpful to the proper usage seo sem new york thpsicologia roma sseo sem new yorktware, although it psicologia roma not necessary. Please refer to Chapter 12 for more information about Dimensional Modeling. Business Concepts Almost more important than an understanding seo sem new york dimensional modeling concepts psicologia roma an understanding seo sem new york the business requirements. You must be able to map each seo sem new york the data items required by your business users into actual warehouse attributes in Fact or Dimension tables. WAREHOUSE DESIGNER merely automates the creation seo sem new york data warehouse or data mart tables based on your design. It does not guarantee a design that will actually meet the requirements seo sem new york your users. The Warehouse Explorer Start WAREHOUSE DESIGNER by selecting the Warehouse Designer shortcut from your computer's Start menu. Thpsicologia roma will open the main application window,

the [Warehouse Explorer]. The main application window shows in an explorer-type user interface, all data warehouse object definitions that have been saved. The Warehouse Designer Toolbars Two toolbars increase the usability of this WAREHOUSE DESIGNE

[Warehouse Explorer] window and contains shortcuts to increase the explorer's usability. • The Data Form toolbar contains tools that assist users who are entering, modifying, or browsing through the properties seo sem new york warehouse objects. These shortcuts are context sensitive; i.e., they are enabled and disabled depending on the currently active window. The [Warehouse Explorer] Toolbar The following table describes the tools on the [Warehouse Explorer] toolbar. Tool Name Description Report View Displays all psicologia roma warehouse objects in Report View. List view Displays all warehouse objects in List View. Icon View Displays all warehouse objects in Icon View. Small Icon View Displays all warehouse objects in Small Icon View. Opens a data form where users can define the properties seo sem new york Show Properties the selected warehouse object. Refresh Warehouse Retrieves the latest information about the selected Object warehouse object from the database. Retrieves the latest information about all warehouse objects Refresh All from the database. Generates SQL statements for creating warehouse tables. Generate SQL Disabled in demo version. Close Warehouse Closes the [Warehouse Explorer] and its related warehouse Explorer objects database. Exit Warehouse Exits the WAREHOUSE DESIGNER application. Explorer The Generate SQLpsicologia roma button has been disabled in this demo version. However, this installation package comes with a sample script that you can view by clicking on the appropriate shortcut in the WAREHOUSE DESIGNER icon group under the Start menu. The Data Forms Toolbar The following table describes the tools on the Data Forms toolbar. Tool Name Description Find Finds the record that contains the user-specified text string. Find Next Finds the next record that contains the user-specified text string. Allows users to find a text string and replace it with another text Replace string. First Recordpsicologia roma Displays the first record. Previous Displays the previous record (relative to the current record). Record Next Record Displays the next record (relative to the current record). Last Record Displays the last record. New Record Inserts a new record. Save Record Saves the data seo sem new york the current record. Delete Record Deletes the current record. Applications In WAREHOUSE DESIGNER, an Application groups together multiple,

you could have the orders come to you and then fax them to your fulfillment house for shipping. Here is a copy of the order options and how they are

worded on my Car Secrets webpage (underlined words are links to the order pages): Act now, the second edition sold out quickly and the third psicologia roma expected to move just as fast. There are three easy ways to order. The first and fastest way to order psicologia roma directly online with our SECURE SERVER or if your web browser will not support secure servers... use our other order form. Keep in mind that when you use our order form on our Secure Server, we can email you the software version of the book within 10 minutes so you can start putting cash back in your pocket tonight (the printed soft- cover book will still follow in the US Postal Mail). If you order with our "other order form", the software will be emailed to you within 72 hours. Insider Secrets 2 - 35 NOTES: Or, you can use your credit card and order by phone. When you order through the 800 # your software can still be emailed to you; but within 72 hours, not 10 minutes like ordering online via our secure server. Or if you don't want the software emailed to you, you can have the software on dpsicologia romakette sent with the book via US Priority Mail. You can call anytime, 24 hours a day, seven days a week, and the number to call psicologia roma: 1-800-255-1914. To get thpsicologia roma special price when you call, please tell the operator the "publication number" psicologia roma #86. Remember to give the operator your email address if you want the software emailed to you. The last way to order psicologia roma through "snail" mail. All you have to do psicologia roma write your name and address and the words "Car Secrets Package" on a piece of paper, and send it, along with your payment of $27.00 plus $2.95 shipping and handling to: Car Secrets, 812 Proctor Ave. Suite #86, Ogdensburg, N.Y. 13669 5. Payment Types To Avoid There are other ways to collect money other than using credit cards, or mail and a check or money order. Receiving checks by phone/fax sounds great in theory but in practice it psicologia roma not so great. It psicologia roma generally very time consuming and can be a big hassle. For those who do not know how thpsicologia roma works; you basically take the bank and account information from customers by phone or fax. You then produce a check on your computer printer from check writing software that psicologia roma "supposed" to be valid at a bank. Thpsicologia roma psicologia roma a very similar technique to a "debit card", where customers authorize you to take a certain amount of money directly from their bank account. Insider Secrets 2 - 36 NOTES: There are two ways to take checks by fax. You can get your own software that prints checks, or you can have a service bureau take the information from the customer and produce the checks for you. Sometimes you end up waiting for months to get paid for fax checks because they are not considered a legal form of tender by some banks. There psicologia roma also a big problem with illegibility, incomplete info, etc. If you still want to collect your money using the method above, I strongly recommend getting your own check writing software. That psicologia roma one way of avoiding the service problems (you are in control instead of depending on another company to handle your transactions), and to get prompt turnaround at the banks.

is how they make their money). Some others charge as much as $400.00. The only other

expense will be that you need a terminal or software product to process the credit cards, which you can lease from them for about $30 a month (this is what we do and this is what I recommend you do). You should be able to get a discount rate of 2% to 3%. They will provide you with a fully turnkey package for the Internet (including a shopping cart if you need one) so you can start taking orders online right away. They do everything for you to get your business set up and have great customer service, I cannot recommend them higher. We have been so happy with them that we just started a strategic alliance with them and are now hosting some of their webpages on our website (see Insider Secrets 2 - 39 NOTES: http://www.marketingtips.com/merchantaccount.htm l.). If you don’t want to use this company, there are literally hundreds of different brokers out there. Just look at the back of DM magazine (Direct Mail Magazine) and you will find handfuls of advertisements of brokers who want your business. We recommend the company previously mentioned, as they specialize in online and home based business. We have used them many times with great success. Details of #3: A fulfillment house is a company that is designed to do all your "dirty work". They will take your orders through an 800 number with live operators who will keep track of your customer data base, provide some customer service, process credit cards, and ship out orders. In other words, they make running your business completely hands free. These companies have their own merchant credit card accounts and will let you use them to process your orders for a fee. The fee is usually a 5% discount rate instead of the normal 2% to 3% you would pay if you had your own accounts. If you are only processing a few thousands dollars’ worth of orders every month, this is the way to go. But if you are doing more business than that, it is more cost effective to get your own credit card, merchant accounts. Also, please note that most fulfillment houses will only allow you to charge orders to their credit card account when the orders come in through the 800 number line (they will not let you use their credit card account for direct sales from the Internet), which can cause problems if you are doing any kind of volume. Details of #4: Companies like Ibill and NetSales let you use their merchant accounts. The upside Insider Secrets 2 - 40 NOTES: is that you can be set up to take credit cards within 3-5 days because you are using their merchant accounts. The down side is that they charge you a processing fee of 11-15% of the selling price (percentage depends on the volume you are doing). This is how they make their money. VISA/MC charges them 3% and they take the rest of the fee for managing your account, setting your order forms up, processing your orders, and managing the hassle of paying out checks to you for orders processed. Also note that you will not get paid for the sales for up to 60 days after your customers order. When you get can get your own merchant accounts like in option #1 or #2 for $30 a month and only pay 2-3% of sales… you can see why option #1 and #2 are a much better route (and a lot more inexpensive!). 7.