Logo

Navigation
 

Author Description

Avatar
Exforsys Editorial Team at Exforsys is a team of IT Consulting and Training team led by Chandra Vennapoosa.

Author Posts

MSAS: Analysis Server Cube Storage

Online Analytical Processing (OLAP) is essentially data presented as Cubes, dimensions, hierarchies and measures. Users can navigate a complex set of data intuitively using these objects. In this context, consistent response times for each view or slice of data become important. Therefore modes of storing and retrieving data became the key tenet of storage design. In the early days OLAP technology focused upon specialized, non-relational storage models as the only possible mode for OLAP. They called this technology Multidimensional OLAP(MOLAP). Later vendors discovered that the use of database structures(Star and snowflake schemas) helped in indexing, and storage of aggregates, and…
April 12, 2005 - - Comments:

MSAS: Defining Cube Properties

Each object in the properties pane of the Cube Editor has its own set of properties which can be used to modify the settings of the object.  The properties of a cube defined in the properties pane are as tabulated below.  In this section we shall use these properties to set the properties of our cubes. Aggregation Prefix: This is a prefix appended to aggregation name for the cube’s partitions, provided that the partition’s aggregation prefix begins with a plus sign (+). In this case, this property’s value is appended to the beginning of the partition’s aggregation prefix. If the…
April 9, 2005 - - Comments:

MSAS: Introduction and Working with Measures

The quantitative and numerical columns from a fact table of a cube are the measures of the cube. When the cube is processed the data in the measures get aggregated across the dimensions of the cube. These measures are of primary interest to the end user and are the central values that get analyzed in a cube.Introduction to Measures The quantitative and numerical columns from a fact table of a cube are the measures of the cube. When the cube is processed the data in the measures get aggregated across the dimensions of the cube. These measures are of primary…
April 9, 2005 - - Comments:

MSAS: Introduction and Working with Cubes

The main object in Online Analytical processing is the cube. A cube is defined as a subset of the data in the data warehouse, organized and summarized into multidimensional structure that consists of dimensions and measures. Introduction to Cubes The purpose of creating cubes is to provide an easy to use mechanism for data access and quick and uniform response time for queries. User interface controls are inbuilt into Analysis Services to enable end users to connect to the server for queries and manipulate the cube. Aggregations built into the cube at the time of creation of the cube, enable…
April 9, 2005 - - Comments:

Managing Data with ADO.NET DataSets and C#

This tutorial explains about The Role of DataSets in ADO.NET , Using DataSets in ASP.NET , Saving DataSets in Session State, Using DataTable Constraints, DataSet, DataRelations Using DataSets with DataAdapters to Modify Data and the Transactional Model in DataSets.   ASP.NET: Managing Data with ADO.NET DataSets and C#   Introduction In this article we will explore the DataSet, DataTable and DataRelations classes. Those who have worked with classic asp will be familiar with record sets. Record set was the individual rows that were retrieved from the database and than binded to the screen using html table or any other html…
April 8, 2005 - - Comments:

Oracle 9i Packages

This weeks tutorial explains about Oracle Packages, Developing Packages, Package Specification, Package Body; Overloading, Oracle Supplied Packages and Dbms_output. Oracle Packages A package is a group of procedures, functions, variables and SQL statements created as a single unit. It is used to store together related objects. A package has two parts, Package Specification or spec or package header and Package Body. Package Specification acts as an interface to the package. Declaration of types, variables, constants, exceptions, cursors and subprograms is done in Package specifications. Package specification does not contain any code. Package body is used to provide implementation for the…
April 7, 2005 - - Comments:

MSAS: Virtual Dimensions

A logical dimension created out of the columns of a physical dimension is a virtual dimension. The contents of a virtual dimension are member properties of the physical dimension or columns and tables of a physical dimension. For instance the Store name level of the Store dimension has a member property named Store Sqft. This member property identifies the area of the store in square feet. This member property can be used to create a virtual dimension and this can be added to any cube that contains the Store Dimension.The virtual dimension can be used like any other dimension by…
April 7, 2005 - - Comments:

MSAS: Introducing Member Properties

Member properties are attributes associated with members. They contain some additional information about a member but cannot be used to create a level in the dimension by themselves. For example each member of the Month level has an associated Boolean number property called Bonus month.If records the bonus given during the month, if any. Since the frequency of bonus is irregular, all months may not have Bonus awarded during the month. This attribute of the month therefore may be 0 or 1 and provides additional information about the month. It does not qualify to be a level by itself. The…
April 7, 2005 - - Comments:

MSAS: Creating Custom Rollups

To enable proper aggregation of values along a dimension each member of the dimension needs its own aggregation rule. These rules are provided by custom roll up. Custom rollup operators provide a simple way of controlling the process of rolling up a member to its parents values. Custom rollup operators assigned to a column during the process of creating a dimension. The rollup then, uses the contents of the column as custom rollup operator for each member and is used to evaluate the value of the member’s parents.Custom rollups are enabled when the Unary Operators property of the level is…
April 7, 2005 - - Comments:

MSAS: Creating a Time Dimension

Time dimensions are part and parcel of OLAP cubes. At the lowest level of detail a time dimension may contain a month, minute or even a second. At the most summarized level it may contain a year, a decade or a century. The repetitive nature of time encourages users to view data in terms of a time dimension. How much sales of x product occurred during the month of March or April in the year 2000 compared to the year 2001? This would be a query on a sales cube with a time dimension.A frequent issue that arises while dealing…
April 7, 2005 - - Comments:

MSAS: Understanding Hierarchies

A hierarchy defines the relative positions of members in a dimension. Hierarchies are sometimes represented as pyramidal structures. The members in this structure are arranged in an expansive order—from the most summarized to the most detailed. For instance in a geography dimension the country may the most summarized and the individual cities and localities may be the most detailed members of the hierarchy.Analysis Services supports three kinds of hierarchies. Balanced, unbalanced and ragged. A balanced hierarchy is a hierarchy in which all branches descend to the same level and each member’s logical parent is the level immediately above the member….
April 3, 2005 - - Comments:

MSAS: Dimension Storage Modes and Levels

Dimensions are stored in the Multidimensional OLAP or Relational OLAP. The storage mode determines the location and form of the dimensions data. While MOLAP stores data in a multidimensional structure on the Analysis server, ROLAP stores the data in the relational tables. The storage mode can be set using the Dimension or cube editor.When a Dimension’s storage mode is set to ROLAP the following settings have to be made to the levels in the dimension. The lowest level’s Member Keys Unique property is to be set to TRUE.The dimension must not contain member groups.If the dimension is a private one,…
April 3, 2005 - - Comments:

MSAS: Working with Levels and Hierarchies

Dimensions are defined as structural attributes of a cube made up of levels arranged in hierarchies. A level is a set of members of a dimension organized such that all members of the set are at an equal distance from the root of the hierarchy. A hierarchy is the set of members in a dimension and their positions relative to one another.Working with Levels and hierarchiesThe basic facts relating to levels was discussed in “Building Dimensions using Dimension Editor”. In this tutorial we will go a little deeper into how to work with levels and hierarchies. Before proceeding with the…
April 3, 2005 - - Comments:

MSAS: Working with Parent-Child Dimensions

Parent child dimensions when viewed from within a cube reveal some interesting features. We will add an private employee parent child dimension to the sales cube and study the features thereof.In the cube Editor right click the Dimensions folder and click New Dimension to launch the Dimension wizardSelect the parent child option and click Next. Select the Employee dimension table and click Next. Select the Employee_ID in the member key list, Supervisor_ID in the Parent Key List, and Full_Name in the Member Name list. Then click Next. Click Next to skip the Advanced options screen. Type Employee as the dimension…
March 31, 2005 - - Comments:

MSAS : Basics of Levels

A level is an element of a dimension hierarchy that describes the hierarchy from the highest level to the lowest level of data. Levels exist within dimensions and are based on columns in the dimension table or member properties in the dimension. They specify the contents and structure of the dimension’s hierarchy and determine the members that are included in the hierarchy and their positions relative to one another within the hierarchy.Levels get created when a dimension is created using the Dimension Wizard, Editor or the Cube Editor. The levels can then be maintained and their properties can be set….
March 31, 2005 - - Comments:

MSAS : Working with Standard Dimensions

Dimensions are created, based on dimension table columns, member properties, or from the structure of OLAP data mining models. When a dimension is defined, there are a number of possible approaches. Each approach produces a different dimension variety. Standard Dimensions are regular dimensions. They can be of two types. The standard star schema dimension and the standard snowflake dimension.Within the Dimension editor a new standard dimension can be created in two ways:-Using the Dimension Wizard or multiple dimension tablesOpen the Dimension editor and select <new> from the dimension drop down list box on the tool bar. The Editor displays the…
March 31, 2005 - - Comments:

MSAS : Shared vs Private Dimensions

This tutorial explains how to create Shared dimension using Dimension Editor , Private dimension using Dimension Editor and the differences between them.Creating Shared Dimension using Dimension Editor 1. In the Analysis Manager tree pane, expand the database in which you want to create the shared dimension.2. Right-click the Shared Dimensions folder, point to New Dimension, and then click Editor3. In the Choose a Dimension Table dialog box, expand a data source, click the dimension table for the dimension, and then click OK.Dimension Editor appears with the dimension table showing in the Schema tab.4. To add more tables to the dimension,…
March 31, 2005 - - Comments:

Understanding Dimension Basics

The next 6 tutorials explains Building Dimensions using Dimensions Editor. Dimensional modeling is the conceptualization and visualization of numerical data models as a set of measures that are derived from the common parameters used in a business. It summarizes and rearranges data and presents views of data to support data analysis. Dimensional modeling focuses on data such as counts, weights, balances and occurrences. Understanding Dimensions BasicsDimensional modeling is the conceptualization and visualization of numerical data models as a set of measures that are derived from the common parameters used in a business. It summarizes and rearranges data and presents views…
March 29, 2005 - - Comments:

Oracle 9i Database Triggers

This Weeks tutorial explains about Oracle Triggers, Building a Trigger, Trigger Execution, Trigger Restrictions and Testing Mutating Tables.Database Triggers A database triggers is stored PL/SQL program unit associated with a specific database table or view. The code in the trigger defines the action the database needs to perform whenever some database manipulation (INSERT, UPDATE, DELETE) takes place. Unlike the stored procedure and functions, which have to be called explicitly, the database triggers are fires (executed) or called implicitly whenever the table is affected by any of the above said DML operations. Till oracle 7.0 only 12 triggers could be associated…
March 28, 2005 - - Comments:

ASP.NET Using the DataList and Repeater, Datagrid Controls

In this tutorial of Week 6 we will be learning about Overview of List-Bound Controls, Creating a Repeater Control, Creating a DataList Control, Introduction to the DataGrid, Setting Up the DataGrid , Using Advanced DataGrid Features and Adding Advanced Features. Overview of List-Bound Controls As we have seen in the previous tutorials that Asp.net ships with many controls. We already discussed different types of buttons, validation controls and the calendar controls. But the most power of Asp.net comes with the Databound controls. Databound controls are those controls which can be binded to any data source. They are also known as…
March 26, 2005 - - Comments:

MSAS : Office 2000 OLAP Components

PivotTable component in Office 2000 is the PivotTable report feature. It allows the user select and cross tabulate numerical values in ways that are similar to the processes of a cube. The earlier versions of this report in Excel could only extract values from relational data sources. The version under reference can present data directly form an OLAP cube.There is another PivotTable in Office 2000 which is a PivotTable list feature. This is a part of the Office Web Components. This component has the same functionalities as the PivotTable report, but includes capabilities that aren’t available in Excel component. It…
March 25, 2005 - - Comments:

MSAS : Client Architecture

The PivotTable Service:The interfaces used by client applications to access OLAP data and data mining data on the server are provided by the PivotTable Service. The PivotTable service is a set of tools that enable the transfer of OLAP cubes to client applications from the OLAP server. Two programming interfaces for querying data are available to the developer from the PivotTable Services:–The OLE DB for OLAP and the ActiveX Data objects Multidimensional (ADO MD). Tools such as those available in VisualStudio.Net are harnessed to create applications that query multi dimensional data sources. The figure below illustrates the relationship scenario.Using the…
March 25, 2005 - - Comments:

MSAS : Cube Storage options

In the first tutorial of this series “Introduction to Data Warehousing and OLAP” we briefly touched upon storage options that are used in data warehousing. In the second chapter “ Introducing Analysis Manager Wizards” we learnt how to use the cube Storage wizard to set storage options for the cube we had created. In this section of the tutorial we will be going into a little more detail on the various kinds of storage options available in Analysis Services and will be touching on the pros and cons of the different storage modes. To recapitulate, a cube is a multidimensional…
March 23, 2005 - - Comments:

MSAS : Meta data Repository

Metadata is a description of data. It provides a consistent way to describe data structures. It is used to describe data as it is being transformed and gives a clear explanation of the meaning of different fields, measures, levels and dimensions. All releases of Microsoft development and data management tools support and allow access to the Repository. The storage of data about data in a central location has some advantages.Reusability: With the storage at a central location the data can be used and reused. Dependency tracking: the repository stores information about different objects and the relationships between stored objects. Hence…
March 23, 2005 - - Comments:

MSAS : Analysis services Tools for Extended Functionality

Analysis services provides various tools that can be programmatically used to extend its functionality. Analysis services supports OLE DB to meet the OLAP specific requirements and is also designed to meet the requirements for Data mining specifications. The Analysis services is made compatible with the ActiveX Data Objects(ADO) and its multidimensional counterpart ADO MD. User defined functions for creating Component Object Model(COM) libraries enable the Analysis services to extend its capabilities of using automation languages such as Microsoft Visual Basic or Microsoft Visual C++. These libraries can be registered and the functions can be used in calculated member definitions and…
March 23, 2005 - - Comments:

MSAS : The Wizards

The primary aim of Microsoft was to ease the process of building and using data warehouses. A large number of wizards, editors and tools have been built into the Analysis services to fulfill this objective. The wizards available for use are: The Cube wizard that helps the user build all the structures necessary to create an OLAP cube. It walks the user through the entire cube design and implementation process. The user can map the data sources, create dimensions and define measures using this wizard. The Cube Editor is useful in editing cube structures or in creating new cubes. The…
March 23, 2005 - - Comments:

Accessing Data with C#

This tutorial explains about Accessing Data with C# with an Overview of ADO.NET, Connecting to Data , Executing Commands , Working with Data and Choosing an ADO.NET Provider along with the Project files used in this.   ASP.NET: Accessing Data with C#  Introduction: When working with classic asp we had ADO, object model for communication with the database. Microsoft.NET has introduced ADO.NET components that lets the developer communicate with the database more efficiently and easily. In this article we will see how we can make use of the ADO.NET classes to perform different operations on the database. ADO. NET Classes:…
March 19, 2005 - - Comments:

SQL Unit Testing Tools

Please find the Open source SQL Unit Testing tools available. SQL Unit Testing Tools SPUnit SPUnit  Description: SPUnit is an application of the popular xUnit framework concept to enable unit testing of SQL Server stored procedures.  SPUnit is (loosely) based on the xUnit family of Unit Test Frameworks. It is intended for testing MS SQL Server stored procedures using actual stored procedures. The idea was to make it really painless to test the code in stored procedures, and facilitate test-first programming of stored procs. It is a port inspired by JUnit, a testing framework for Java, developed by Kent Beck…
March 18, 2005 - - Comments:

Microsoft .NET Unit testing Tools

Here are the few Microsoft .NET Unit testing Tools available. Most of them are opensource and free.Microsoft .NET Unit testing Tools csUnit http://www.csunit.org/ Description: csUnit is a unit testing framework for the Microsoft .NET Framework. It targets test driven development using C#, Visual Basic .NET, and managed C++. Requirement : csUnit has been tested using the Microsoft .NET framework 1.0 Service Pack 2 runtime on an Intel-compatible platform. Unit Testing with C# Tutorial How do I make use of the Assert class? How do I implement simple test cases for my class? How do I integrate csUnit with my code?…
March 18, 2005 - - Comments:

MSAS : The Analysis Manager and Analysis Server

Analysis services is the middle tier server component of the MS SQL 2000. It manages multidimensional OLAP cubes of data and ease of access to such data to end users. It also enables user to create data mining models from the data in the cubes or in the relational databases. The Analysis Manager and Analysis ServerThe Analysis Manager: The MS SQL Server 2000 Analysis services, includes the Analysis manager, which is a console application. This application provides user interface for accessing the Analysis servers and the meta data repositories associated with them. The Analysis Manager is represented as a folder…
March 18, 2005 - - Comments:

MSAS : The Data warehousing framework of SQL Server 2000 – Part 2

This is part 2 of  MSAS : The Data warehousing framework of SQL Server 2000.  It’s very important that you understand the concepts if you are really trying to get job in Data Warehousing field.MSAS : The Data warehousing framework of SQL Server 2000 – Part 2The Online Analytical Processing (OLAP) tools offered by Microsoft are impressive, considering the fact that Microsoft entered the OLAP market only in 1998. A review of the growth of Microsoft tools in this area, clearly indicates that they have grown from being a mere entrant to being a market leader in the field. What…
March 18, 2005 - - Comments:

SQL Server 2000: Using Views in SQL Server

This tutorial on Views in SQL Server covers the concept of views, Creating Simple View, deleting views and how to use them.Using Views in SQL ServerViews are nothing but saved SQL Statements, and are sometimes referred as “Virtual Tables”. Views cannot store data; rather they only refer to data present in tables. As the name implies, they are just used to view the contents of the tables by means of joins etc. They can be used to provide row- or column-level access to data, to wrap up complex joins, to perform complex aggregate queries, and to otherwise customize the display…
March 17, 2005 - - Comments:

MSAS : The Data warehousing framework of SQL Server 2000 – Part 1

The Data warehousing framework is a set of components and API’s that implement the data warehousing features of the SQL server 2000. The common interface of the server known as the Enterprise Manager can be used by various components to build and use the data warehouse or a data mart.The Data warehousing framework of SQL Server 2000The following illustration details the Microsoft SQL Server 2000 data warehousing overview.The relational database engine of the SQL server is a modern, highly scalable and reliable engine for storing data. The database stores data in tables and each table represents objects that are of…
March 15, 2005 - - Comments:

MSAS : Microsoft Data Warehousing Overview

This tutorial explains various functions available and the tools available for building and managing data warehouses. MSAS : Microsoft Data Warehousing OverviewModern day enterprises believe that mission critical decisions should be information based. Vast information repositories and historical data available with them need to be analyzed and emerging patterns examined before any decisions are taken. Data warehousing and business intelligence solutions were looked upon as means of achieving this purpose. This need triggered off a proliferation of data warehousing and business intelligence solutions in the market. Initially these solutions were scattered, disparate and focused on specific areas of Data warehousing such…
March 15, 2005 - - Comments:

Oracle 9i Procedures and Functions

This tutorial covers Developing Procedures and Functions, Creating a Procedure, Executing a Procedure, Creating a Function, Executing a Function, Passing Parameters – IN Parameters, OUT Parameters, IN OUT Parameters, Purity of a User-Defined Function and Positional and Named Notations. Oracle 9i : Procedures and Functions PL/SQL subprograms A subprogram is a named block of PL/SQL. There are two types of subprograms in PL/SQL namely Procedures and Functions. Every subprogram will have a declarative part, an executable part or body, and an exception handling part, which is optional. Declarative part contains variable declarations. Body of a subprogram contains executable statements of…
March 13, 2005 - - Comments:

SQL Server 2000: Using System and Extended Stored Procedures

This tutorial covers how to use System Stored Procedures which are stored in master and msdb databases and normally begin with ‘sp_’ and Extended Stored Procedures normally begin with ‘xp_’.Using System Stored Procedures Whenever you add a database, add a login, create a table or modify any object, the changes reflect in the system tables. System tables are used by the SQL server’s for its own reference but we can also view their contents. But the information stored in them is somewhat in binary or unreadable format, therefore Microsoft has given us System stored procedures (almost 650) to read or…
March 13, 2005 - - Comments:

SQL Server 2000: Securing Your Stored Procedure

This tutorial explains how to secure your stored procedures if you ever need to.  Procedures resides on the database server in open fashion. It means that every body can easily access and view its code. Securing Your Stored ProcedureStored Procedures resides on the database server in open fashion. It means that every body can easily access and view its code. They are present in “syscomments” system table in each database and completely accessible. In order to secure it, we can encrypt them by using “WITH ENCRYPTION” keyword. Remember that encrypting stored procedures is a single step process and you can’t…
March 13, 2005 - - Comments:

SQL Server 2000: Creating Stored Procedure with Input and Output Parameters

This tutorial explains how to create and use Stored Procedures with Input Parameters and output parameters along with the screen shots and sample code. Creating Stored Procedure with Input ParametersInput Parameters in Stored Procedures are placeholders for data that the user needs to send. Technically, input parameters are memory variables because they are stored in memory. For creating Stored Procedure with Input Parameters, just change the above code to look like CREATE PROCEDURE Show_Customer @City varchar(50) AS SELECT FirstName, LastName FROM Customer WHERE Location=@City ORDER BY FirstName Here the placeholder i.e. Input parameter is @City variable. It accepts the value,…
March 12, 2005 - - Comments:

SQL Server 2000:Creating and Using Stored Procedures

This tutorial series covers the basic concepts of Stored Procedures in SQL Server and hot create and execute a simple stored procedure.Using Stored ProceduresSome of the most important concerns to a database user are speed and efficiency. Faster data retrieval provides applications to responds and behaves quickly. SQL Server provides “Stored Procedures” for faster and quick data access. Stored Procedures is a query that is stored in a database on SQL Server rather than being stored in the front-end code on users machine. You may think that storing queries in the form of Stored Procedures will be an overhead itself???…
March 12, 2005 - - Comments:

Using Rich Server Controls with C#

In the last article we saw some of the simple controls. Those included validation controls, TextBox, Label and other simple controls. Microsoft.net framework provides the developer with more advanced controls. Among those are the Calendar, AdRotator and the Xml Control. In this Tutorial we will see how we can make use of the rich controls provided by the framework.Using Rich Server Controls with C# Introduction: In the last article we saw some of the simple controls. Those included validation controls, TextBox, Label and other simple controls. Microsoft.net framework provides the developer with more advanced controls. Among those are the Calendar,…
March 12, 2005 - - Comments:

SQL Server 2000 Training Details

We are glad to let you know that we have started SQL Server 2000 training series. See the topics below which we will be providing the tutorials. Please let us know if there anything you would like to add to the topics.SQL Server 2000 Training1. Introduction to Microsoft SQL Server 2000 Overview of SQL Server 2000 | Components of SQL Server 2000 | Overview of SQL Server 2000 Architecture 2. Installing SQL Server 2000 Planning to Install SQL Server 2000 | Deciding SQL Server 2000 Setup Configuration Options | Running the SQL Server 2000 Setup Program | Using Default, Named,…
March 11, 2005 - - Comments:

MSAS : Browsing the Cube

This tutorial explains about the Cube Browser,  it’s a tool provided within the Analysis Services to display the results of the cube process without the need to add external software.Tutorial 16: MSAS : Browsing the CubeThe processed cube can now be analyzed. For the purpose of this tutorial we will use ‘slice and dice’ and drill down capabilities of the Cube Browser to browse the cube. The Cube Browser is a tool provided within the Analysis Services to display the results of the cube process without the need to add external software. It is a relatively useful data analysis tool that can…
March 10, 2005 - - Comments:

MSAS : Designing Storage and Processing the Cube

This tutorial covers the storage modes for the cube before it can be processed. The kind of storage selected will determine the query performance and enhance the cube efficiency.Tutorial 15: MSAS : Designing Storage and Processing the CubeWe have already discussed in detail the type of storage options that are available in OLAP. Analysis Services offers the end user all the different storage options of the OLAP. Multidimensional OLAP (MOLAP), Relational OLAP(ROLAP) and Hybrid OLAP(HOLAP) are available in Microsoft Analysis services. Now that the design of the cube has been completed the user will have to designate one of the…
March 10, 2005 - - Comments:

MSAS : Building the Cube Part #3

This is part 3 in MSAS : Building the Cube series, If you have not completed reading part 1 and 2 , please do so before continuing with this tutorial. Tutorial 14: MSAS : Building the Cube Part #3The next dimension that we need to create is the Time dimension. This is the most common dimension and inevitably forms a dimension of every cube. However, there are certain specific conditions that arise when we create the time dimension. In the Select Dimensions dialog box of the Cube Wizard we will chose time_by_day dimension table. The time dimension table is usually…
March 10, 2005 - - Comments:

MSAS : Building the Cube Part #2

This is part 2 in MSAS : Building the Cube series, If you have not completed reading part1, please do so before continuing with this tutorial.Tutorial 13: MSAS : Building the Cube Part #2Click ‘New Dimension…’ button to launch the Dimension Wizard. The welcome dialog box of the Dimension wizard appears. The Check box option is to be checked if we want to skip this screen in future. For the present we leave it as it is and click the Next button.The next requirement is to select the kind of schema we want for our cube. On clicking Next we are taken…
March 10, 2005 - - Comments:

MSAS : Building the Cube Part #1

This three part tutorial explains about cubes, Dimensions and how to create them using the wizards. You need to understand and learn how to create the cubes since it’s very critical step.Tutorial 12: MSAS : Building the Cube Part #1A cube is a multidimensional structure consisting of dimensions and measures. Therefore, we need to know what dimensions we intend to use and what measures will be captured. In short, we need to know what quantitative values we want to analyze or monitor from our database. Usually organizations capture actual measures such as revenues, sales in context of expenses, costs along…
March 9, 2005 - - Comments:

MSAS : Setting up the Database in Analysis Server

This tutorial explains Setting up the Database in Analysis Server and how to connect and test the connectivity.Setting up the Database in Analysis ServerThe first step in creating a cube is the setting up of the Database. Double click on the server and connect to it. Once the connection is established, the user can proceed to create the database. Right click on the server node and select ‘New Database’. On clicking on “New Database” a tiny window opens prompting the user to enter the name of the database and a description of it. The database has been named Sample and…
March 7, 2005 - - Comments:

MSAS : Preparing to Create the Cube

This tutorial explains the steps to create the cube and the preparation like settip the datasource.Preparing to Create the CubeA cube is the fundamental unit of data storage and retrieval in the Analysis Server. A cube can be created with either the Cube Wizard or the Cube Editor. The cube wizard provides very limited options as against the options available in the Cube Editor. In this section of the tutorial we propose to concentrate on the Cube Wizard and learn how to create a cube, process a cube and browse the results using the Wizard.Setting up the Data source NameEvery…
March 7, 2005 - - Comments:

MSAS : Introducing Analysis Manager Wizards

This tutorial covers brief introduction to Analysis Manager Wizards, how to start, Previewing and Defining terms which helps to understand the navigation along with the screen shots.Introducing Analysis Manager WizardsThe Analysis Manager is a console application in Microsoft SQL Server 2000. It provides an interface for accessing Analysis servers and their metadata repositories. The Analysis manager console can be used to administer servers, create databases, cubes, data mining objects, or for specifying storage options and optimizing query performance. The console also allows the user browse data sources, shared dimensions and security roles. It snaps into the Microsoft Management console, which…
March 7, 2005 - - Comments:

Oracle 9i PL/SQL Collections

This tutorial covers Defining and Using Collections – Declaring, Initializing, and Referencing PL/SQL Collections and Collection Methods – Using the Collection Methods. Oracle 9i: PL/SQL Collections Introduction Version 8.0 and higher versions of Oracle are referred to as ORDBMS (Object-Relational Database Management System). The traditional Oracle database management system is extended to include Object-Oriented Concepts and structures such as abstract data types, nested tables, varying arrays, object views and references. Abstract Datatypes Also called user-defined datatypes are those that consist one or more subtypes. Apart from using standard oracle datatypes they can also use other abstract datatypes. An abstract datatype…
March 6, 2005 - - Comments:

ASP .NET: Validating User Input with C#

This tutorial covers Validating User Input with C# covers Overview of ASP.NET Validation Controls , Using the Simple Validators , Using the Complex Validators and Summarizing Results with the Validation Summary Control. In this tutorial we will see the validation controls. The purpose of the validation controls is to validate the user input. Asp.net provides the developer with different types of validation controls. One most important point to note is that the validation is done on the client side as well as on the server side. You can always turn the validation on the client side off using the enable…
March 4, 2005 - - Comments:

Oracle 9i PL/SQL Control Structures

This tutorial teaches about how to structure flow of control through a PL/SQL program. The control structures of PL/SQL are simple yet powerful. Control structures in PL/SQL can be divided into selection or conditional, iterative and sequential. Control Structures This chapter teaches about how to structure flow of control through a PL/SQL program. The control structures of PL/SQL are simple yet powerful. Control structures in PL/SQL can be divided into selection or conditional, iterative and sequential. Conditional Control (Selection): This structure tests a condition, depending on the condition is true or false it decides the sequence of statements to be…
February 26, 2005 - - Comments:

ASP.NET Web Forms Controls

Working with Web Forms Controls and C# covers Introduction to Web Forms Controls, Simple Input Controls, HyperLinks and Button Controls and List Controls Introduction: In this tutorial we will introduce some of the most commonly used controls used in Asp.net web programming. We will see all the different types of controls and their behavior. I will not talk about complex, data bound or template controls in this tutorial since we are going to look at that in later tutorials. Web Form Controls: As in the previous tutorial I explained that there are three types of controls in Asp.net namely, HTML…
February 26, 2005 - - Comments:

Introduction to ASP.NET with C#

Introduction: In this tutorial we will introduce the new technology for building websites. This new technology is known as ASP.Net. ASP.Net allows the developer to build applications faster. This is achieved due to the fast that ASP.Net makes use of the rich class libraries provided by Microsoft. net framework. Topics Introduction Classic ASP ASP.Net Web Applications Use of Controls HTML Controls HTML Server Controls Web Server Controls Special Note Language Options Caching features Tools ASP.Net Web Services References Classic ASP: Asp, which is now more commonly known as Classic Asp was used extensively in 1990's. The idea of creating dynamic…
February 20, 2005 - - Comments:

ASP.NET with C# Training Course Outline

This article contains list of topics covered in ASP.NET with C# training series.ASP.NET with C# Training Course Outline Introduction to ASP.NET with C# A Review of Classic ASP ASP.NET Web Applications Rendering HTML with Server Controls Using ASP.NET to Deliver XML Web Services Working with Web Forms Controls and C# Introduction to Web Forms Controls Simple Input Controls HyperLinks Button Controls List Controls Validating User Input with C# Overview of ASP.NET Validation Controls Client-Side Validation Server-Side Validation Required Field Validator Summarizing Results with the ValidationSummary Control Using Rich Server Controls with C# Introduction to Rich Controls The Calendar Control The…
February 19, 2005 - - Comments:

ASP.NET with C# Training Launch

ASP.NET with C# training series is packed with skill enhancing, step-by-step tutorials to help you successfully build database-driven Web applications and Web services. ASP.NET with C# training provides Sample Code along with articles links from external sites (if any). Please use Discussion Board if you have any questions. ASP.NET Training Prerequisites At least one year of consistent object-oriented or object-based development experience in Java, C++, Visual Basic, or another modern object-oriented or object-based language and solid knowledge of HTML and should know SQL and relational databases. ASP.NET Features and Advantages ASP.NET is a compiled, .NET-based environment; you can code the…
February 19, 2005 - - Comments:

Building PL/SQL Blocks in Oracle 9i

This Week we will be learning about Creating PL/SQL Blocks which includes Declaration Section, Variables, Scope of Variables, Constants Records, Manipulating Data in PL/SQL and Using DML in PL/SQL . PL/SQL is a procedural extension for Oracle’s Structured Query Language. PL/SQL is not a separate language rather a technology. Mean to say that you will not have a separate place or prompt for executing your PL/SQL programs. PL/SQL technology is like an engine that executes PL/SQL blocks and subprograms. This engine can be started in Oracle server or in application development tools such as Oracle Forms, Oracle Reports etc. As…
February 16, 2005 - - Comments:

More Oracle 9i Database Objects

This week we will be learing about Sequences, Synonyms, Indexes, Views, Data Dictionary View, Controlling Database Objects, GRANT, REVOKE Roles and Privileges. COMMIT, ROLLBACK and SAVEPOINT SQL*PLUS has a facility to automatically commit all the work, without explicitly issuing the commit command i.e. SET AUTOCOMMIT ON — Enables autocommit feature. SET AUTOCOMMIT OFF — Is the default and disables the automatic committing Note: Certain actions automatically force a commit. DDL Commands CREATE, DROP, ALTER and DCL commands EXIT, GRANT, REVOKE, CONNECT, DISCONNECT, AUDIT and NOAUDIT are example for this. (i.e. the work done by these commands can not be taken…
February 14, 2005 - - Comments:

Oracle 9i Software Installation, SQL, PLSQL and SQL *Plus References

Before we actually start with the lessons, we need to install and setup Oracle on your pc to be able to practice. I would recommend all of you to install Oracle before you start with any of our lessons in the following weeks. Please use discussion board for any questions you might have in this Learning Series. That helps other users answering the same questions. Next week we will be starting with our first lesson. In the mean time please setup your pc with Oracle Software. Follow the link to download the appropriate version according to your operating system. Download…
October 25, 2004 - - Comments:

Introduction to Oracle 9i SQL, PLSQL, and SQL *Plus

We are excited to let you know that we are launching shortly The New Technology Learning Series. We will be starting with Oracle 9i: SQL, PLSQL, and SQL *Plus. Below is the course schedule by week. Please let us know if you have suggestions. Oracle 9i: SQL, PL SQL, and SQL *Plus Course Description: This course introduces students to data server technology, and explores the concepts of relational databases and the powerful SQL and PL/SQL programming languages. Students will learn and practice how to create and maintain database objects. You will also learn to store, retrieve, and manipulate data. Finally,…
October 24, 2004 - - Comments:

Benefits of Oracle Certification

Benefits of Oracle Certification Beyond OCA, by becoming an Oracle Certified Professional (OCP) you demonstrate your understanding of the full range of skills required by Oracle professionals in your chosen job role. An OCP is in high demand in today’s marketplace. The level of demand continues to grow with each new installation of Oracle technologies around the world. An OCP Certification raises your visibility and increases your access to the industry’s most challenging opportunities. The demand for professionals in the information technology (IT) industry is high, and the competition for jobs is intense. Individuals, experienced or new to the profession,…
August 27, 2004 - - Comments:

Technical Support Position Interview Questions

Please find Technical Support Position Interview Questions. If you have any from your experience please send them to us. We will update this article. These questions can be found in EFS Repository in PDF format. Technical Support Position Interview Questions (74 Questions) Programming 1) What is a stored procedure?2) What is a trigger? Novell (server)1) How do you see different Novell servers from a Console prompt?2) What is the autoexec.ncf?3) What is RIP/SAP?4) How do you bind the IPX protocol to a card? IP protocol? Novell(client) 1) What utility would you use if you were having problems with you NDStree?2)…
August 4, 2004 - - Comments:

Exforsys Services

Home Services Exforsys Services ERP Solutions Implementation Solutions Upgrade Solutions Support and Maintenance Solutions Custom Solutions Training and Mentoring Web Solutions Production Support Architecture Designing Independent Validation and Testing Services Infrastructure Management
November 30, -0001 - - Comments:

Exforsys Expertise

Home Expertise Exforsys Expertise SQL Server Database and BI SQL Server Administration SQL Server Database Support and Maintenance MS SQL Server QA/Testing Remote DBA Database Development Database Architecture Designing Microsoft Development expertise MS WinForms Development expertise MS ASP.NET, MVC & .NET Web Application Development MS Application Development expertise .NET System Designs C# .Net Development Microsoft Access Development expertise Mobile Development Android Apps Development Blackberry Apps Development iPhone Apps Development iPad Apps Development Windows Mobile Apps Development Mobile Web Apps Development Oracle and BI Oracle Business Intelligence Solution Business Intelligence & Data Warehousing Oracle Services Oracle Business Intelligence Workshop & Training…
November 30, -0001 - - Comments:

Expertise – SQL Server Database and BI

Home Expertise SQL Server Database and BI SQL Server Administration SQL Server Database Support and Maintenance MS SQL Server QA/Testing Remote DBA Database Development Database Architecture Designing
November 30, -0001 - - Comments:

Expertise – Oracle and BI

Home Expertise Oracle and BI Oracle Business Intelligence Solution Business Intelligence & Data Warehousing Oracle Services Oracle Business Intelligence Workshop & Training
November 30, -0001 - - Comments:

Expertise – Oracle RAC

Home Expertise Oracle RAC Oracle Real Application Clusters Consulting Oracle Real Application Clusters Support Oracle Remote DBA Support Oracle RAC Administration
November 30, -0001 - - Comments:

Exforsys e-Newsletter

ebook
 
© 2024. All Rights Reserved.IT Training and Consulting