Author: Exforsys

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

Oracle Apps Concurrent Processing

Exforsys
Oracle Apps 11i Free Training : Concurrent Processing : This document talks about the concurrent processing in oracle applications. It will give the step-by-step procedure of creating concurrent programs in oracle applications. All types of concurrent programs are described in detail. Concurrent programs can be scheduled to run or manually run in oracle applications. In Oracle Applications, concurrent processing simultaneously executes programs running in the background with online operations to fully utilize your hardware capacity, hence the name ‘Concurrent Processing’. You can write a program (called a ”concurrent program”) that… Read More

Can I Really Get a Signing Bonus?

Exforsys
It never hurts to ask. During the technology boom in the late 90s, signing bonuses were commonplace as companies looked for ways to recruit top IT professionals from their competitors. Although the market is not nearly as strong as it was then, signing bonuses seem to be making a comeback. In many cases, all it takes to get one is to ask and to convince the hiring manager that a few extra bucks will be the catalyst that will convince you to take the job. It’s important to realize, however,… Read More

Targeting your Career and Your Audience

Exforsys
When writing a resume, professionals, especially those in the IT industry, tend to spend the most amount of time on the skills section. To be effective, however, a resume has to be much more than just a list of your abilities and accomplishments. As a matter of fact, one of the most often overlooked sections on the resume just might be the most important. Taking the time to write a resume that is targeted to your career, a particular position, and the audience that will be reading it, might slow… Read More

Looking for a Promotion: tips to make it happen.

Exforsys
In the current IT climate, promotions are no longer being given away based solely on merit and we often watch as those less qualified seem to pass us up on the corporate ladder. Whether it’s already happened to you or not, there are a few things you can do to create and execute a plan that you will get you moving again. When attempting to climb the ladder in the corporate environment, we can often become discouraged when passed over for promotions. The key to success, however, is to stay… Read More

Building Graphical Interface elements

Exforsys
Building graphical interface elements by using the System.Drawing namespace In this tutorial we will learn about Graphics Object, The Windows Forms Coordinate System, Drawing Text on a Form, Drawing Shapes and Working with images.     Understanding The Graphics Object Graphics handling in Visual Basic .NET is based on GDI+ (Graphics Device Interface). A graphics device interface allows you to display graphics on a screen or a printer without having to handle the details of a specific display device. All that you need to do is to make calls to… Read More

Event Handling In Visual Basic .NET

Exforsys
Introduction to Event Handling One of the most useful capabilities of the OOP Languages is their inbuilt ability to be aware of a large number of events like MouseOver, MouseClick, and so on so that we can write codes to react to any event that we are interested. This is made possible by the rich set of classes that have been built in the .NET Framework The events handling is very simple as we have seen in the previous example where buttonClicked event is handled by the following code: Private… Read More

Setting and Adding Properties to Windows Form

Exforsys
Setting and Adding Properties to a Windows Form In this tutorial we wil leran about Setting and Adding Properties to a Windows Form, Using the Visual Designer to set Windows Form Properties, Setting Windows Forms Properties programatically and Using Visual Inheritance along with the sample project and screen shots. Using the Visual Designer to set Windows Form Properties The properties of the Widows properties can be edited in the properties window visually. Both the inherited properties and also those added in the current class can be edited using the property… Read More

Application Class and Message Class

Exforsys
Using Application Class Visual Basic 2005 introduces a speedy way to access many important classes relating to the Computer on which the application is running, the user running it, the application itself, its forms and any associated web services. The best part of it all is that you can access it all using the new My object. The new My object has added features that help the programmer to gain access to some functionality that was really hard to achieve. My.Application Object contains information about running application, such as the… Read More

So you want to be a Software Tester?

Exforsys
So you want to be a Software Tester? Author: Carol My best friend is actually one of the best software testers I have ever met. When I began testing for her consultating company I sincerely thought I’d found the perfect job. I could stay at home and work independently. I received my projects, I completed them and I got paid. Alot. It seemed the perfect scenario until one day I realized that I just didn’t enjoy what I was doing. Testing was repetitious, often boring and I found myself dreading… Read More

5 Steps to a Great Cover Letter

Exforsys
5 Steps to a Great Cover Letter While most professionals spend hours and sometimes days or weeks mulling over just how to create the best resume, surprisingly enough, those same people more often than not, don’t even give a second thought to including a cover letter. With the IT market as competitive as it is today, most IT professionals are finding that they’ve got to do something to make their resumes stand out in the pack. A cover letter is an excellent place to start. If your cover letter isn’t… Read More

Exploring the Forms Designer generated code

Exforsys
VB.NET 2005 Free Training Exploring the Forms Designer generated code As you create a new project in the Visual Basic, the IDE generally automatically adds lots of lines of code on its own. Visual Basic 2005 comes with an option to skip over this behavior of the Visual Basic IDE. The default option comes with this behavior enabled. These codes are introduced with an aim that the user can continue to use the form without bothering about write codes to instantiate the form with a function new() and also the… Read More

Visual Studio Windows Forms Designer

Exforsys
Using The System.Windows.Forms.Form class System.Windows .Forms.Form class is the foundation class for all forms to be created. All the forms that are created in VB .NET are also inheriting from this base class. This class provides for all the facilities needed for the form. Additional functionality can be added by separate codes. In the .NET Framework, a number of new features have been added to the Form Class and the Controls. We shall see some of the new features quickly. For most detailed information is available in the Microsoft website.… Read More

Visual Studio.NET Namespaces

Exforsys
Visual Studio.NET Namespaces The .NET Framework class library has thousands of classes which are needed for developing and deploying solutions. In order to organize all those classes for ease of use .NET Framework uses namespaces. This Gives the Classes their own space and prevents conflicts between the various names in these classes. For instance if two classes contain a method Paint(), then to avoid conflicts in names we can place these classes in two different namespaces. Thus namespaces allow classes to be grouped in a consistent, hierarchical manner. The writing… Read More

Oracle Apps Table Registration API

Exforsys
Oracle Apps 11i Free Training : Table Registration API This chapter provides you with information you need to register tables to be used in Oracle Alerts and Flexfields with Oracle Applications. We will be learning about Procedures in the AD_DD Package, Procedure REGISTER_TABLE, Procedure REGISTER_COLUMN, Procedure DELETE_TABLE, Procedure DELETE_COLUMN and Example of Using the AD_DD Package. Introduction Though Oracle Applications comes with thousands of seeded database tables, there can be numerous applications in which one might be required to create a custom table to be used. In most of the… Read More

Oracle Certifications: Which ones do I need?

Exforsys
Oracle Certifications: Which ones do I need? If you’re currently working with Oracle products, odds are there is an Oracle certification out there for you. Although at one time, Oracle certifications were considered for database pros only, the certification programs offered by the "world’s largest enterprise software company" are evolving to keep up with IT trends. Like Microsoft, Oracle now offers certification programs in a wide range of IT positions. The recent Oracle merger with PeopleSoft has increased the offerings of this industry giant to include enterprise resource planning (ERC),… Read More

Technical Writing: It might just be the foot in the door you need

Exforsys
Technical Writing:It might just be the foot in the door you need For new computer science graduates or even tried and true professionals, the opportunities in IT seem to be few and far between. If you’re looking to break into the industry, need a foot in the door at a large corporation, or are possibly considering a career change, technical writing could be just what you’re looking for. Technical writing isn’t always fun but can lead to other opportunities within an organization and will definitely provide the opportunity to mingle… Read More

How to survive the technological trend to offshore outsourcing

Exforsys
If You Can’t Beat ‘Em, You Might have to Consider Joining Them How to survive the technological trend to offshore outsourcing Unfortunately for many professionals in the Technology industry, offshoring outsourcing IT work to India, Romania and other countries is on the rise. As corporations discover that they can get technical projects completed to their specifications for sometimes ridiculously low cost, odds are they’re not going to stop and consider the impact this trend will have on domestic workers. We’d be foolish to think that corporate America will actually forego… Read More

Do You Really Want to be an IT Consultant: The Pros and Cons of Being Your Own Boss

Exforsys
Do You Really Want to be an IT Consultant: The Pros and Cons of Being Your Own Boss At some point in every technical career, we come to a place where we start to visualize the glamourus world of independent IT contracting and consulting. We all know somebody who’s an IT consultant and as corporatations continue to downsize, our bosses fail to provide ideal working conditions and job security is no longer a given in any industry, more and more professionals are starting their own businesses as IT consultants or… Read More

Implementing Inheritance

Exforsys
Introduction and Implementing Inheritance The usefulness of inheritance is depnding on the choice of its usage. You can use inheritance if the derived class is a kind of base class but not has a relationship with the base class. Such a situation empowers you to reuse the code from the base class. It is also more useful if the hierarchy is very shallow. The developer can effect global changed to the derived class by changing the base class. Understanding Inheritance Inheritance is an important feature of any OOP Language. Let… Read More

Implementing Class Library Object

Exforsys
Implementing Class Library Object in VB.NET 2005 Class: Classical Object Oriented Concepts explain a class as a cookie cutter. A class allows you to create objects of the class. As a programmer you define a class with data fields, properties, methods and events. Then you can create objects based on that class that have state (fields, properties) and behavior (methods, events). A class can be considered as a specification of how the object of the class should look like and behave. An object of the class is nothing other than… Read More

Introducing VB.NET Windows Forms

Exforsys
Introducing VB.NET 2005 Windows Forms We will be learning in the next series of articles as part of VB.NET 2005 Free Training : Introducing Windows Forms in the following topics with code samples and screen shots. Introducing Windows Forms Designing Windows Application is simpler and less time consuming with Visual Basic 2005. A number of new facilities and enhancements have been made to assist the developer complete the project in time and with lesser number of errors. Windows Form is the cynosure of the Windows Application. Visual studio 2005 packs… Read More

Are You Really Listening: The Importance of Strong Communication Skills

Exforsys
Are You Really Listening The Importance of Strong Communication Skills for Advancement in the Technology Industry Let’s face it, when most people think of IT professionals, the image that comes to mind is the guy or girl with the glasses huddled behind a myriad of computer monitors, incapable of communicating with anyone other than their keyboard. In today’s competitive IT marketplace, this person also is exactly the type that no employer wants to bring on board and will, in fact, avoid at all costs. Strong communication skills are one of… Read More

Looking into the Crystal Ball: Technology and Trends in the IT Industry

Exforsys
Looking into the Crystal Ball: Technology and Trends in the IT Industry As the business world continues to evolve, outsourcing offshore hits all time highs, and technology continues to march on, many IT professionals are trying to peer into the future in an effect to identify trends in the IT industry and position themselves positively for the changes that are bound to come. To be honest, even with the saturation of IT professionals, the future shows some promise, as long as you’re ready and willing to adapt with the industry.… Read More

Get Microsoft Certified: Everyone else is!

Exforsys
Get Microsoft Certified:  Everyone else is! If you haven’t taken the time to earn your Microsoft certifications, you just may be severely limiting your opportunities in the IT industry. In the early 90’s there were only a handful of IT certifications available, in 2005 however, you’ll be hard pressed not to find one that fits your particular skill set. Although certifications are considered useless by some hard-core techies who don’t believe they need a one to prove their skill levels, the job market continues to remain competitive. The lack of… Read More

Caught in a Downsizing: Tips to help you regroup and head back into the IT market

Exforsys
In today’s economy and especially in the IT industry, it’s not at all unusual to meet professionals who are currently experiencing the frustration of seeking new employment after a downsizing or layoff. After the initial shock wears off, professionals in the IT market often find themselves attempting to negotiate in an arena many of them haven’t been in for years. In many cases, however, positive things can actually result from a layoff and once you get to a place in which you can appreciate them, it might not seem like… Read More

Too Much or Too Little: Common mistakes when presenting technical skills in an IT resume

Exforsys
When writing an IT resume, the most common mistake is presenting too much or too little information. More often than not techies tend to go heavy on the technical information, often leaving out key soft skills and other important data. When writing an IT resume, it’s extremely important that technical skills are presently clearly and concisely but even more important that the extent of your skills are quantifiable and you can show an employer how you use them. When adding a skill section to your resume, don’t exaggerate your level… Read More

Writing a Technological Resume: How to get noticed amid a plethora of other candidates

Exforsys
The technology industry is currently on the downswing when it come too available IT positions. The abundance of highly skilled and qualified candidates continues to increase, making it even more important that your first impression, your technological resume, makes an impact on a potential employer. Following are few tips that are guaranteed to land your technological resume on the top of the pile. When preparing to write your technological resume, the most important step is organizing the information you are going to provide, clearly and in a manner that will… Read More

Working with Oracle Listener

Exforsys
NOTE: "Working with Listener in Oracle" tutorial has been updated with Oracle 11g Version. This tutorial will teach you how to start, stop and check the status of the Oracle Listener through Enterprise Manager. Oracle Listener provides crucial information on database connection state. In case of any issue with the database connection, I would first check to see if the listener started properly or not. Hence it is important to be familiar with Listener functionality. Startup listener through Command Prompt Check listener status – The command to check the status… Read More

Oracle Apps Application Framework

Exforsys
Oracle Apps 11i Free Training : Application Framework: This document describes the steps of registering new application in oracle applications. It also talks about the standard directory structure within oracle application.Overview   Oracle Applications and custom applications that integrate with Oracle Applications rely on having their components arranged in a predictable structure. This includes particular directory structures where you place reports, forms, programs and other objects, as well as environment variables and application names that allow Oracle Application Object Library to find your application components. An application, such as Oracle… Read More

Differences between VB.NET 1.0 and VB.NET 2.0

Exforsys
VB.NET 2005 Free Training: Differences between VB.NET 1.0 and VB.NET 2.0: VB.NET 2005 comes with a number of enhancements. The IntelliSense Code snippets, the Windows Forms designer updates, IntelliSense filtering, debugger data tips, exception Assistant etc make the software a pleasure to work with. The language has been spruced up with generics, unsigned types, Operator overloading etc. The My Namespace is the most significant enhancement that provides a single reference to commonly used functionalities within the .NET framework. It includes classes like Application, Computer, Forms, Resources, Settings and Users. This… Read More

The .NET Framework Architecture Part 2

Exforsys
VB.NET 2005 Free Training : The .NET Framework Architecture Part 2. In this tutorial of The .NET Framework Architecture Part 2 we will learn about Just-In-Time (JIT) compilation, Assemblies, native assemblies, Global Assembly Cache (GAC) and Comparison of VB.NET, C#, and J#. Just-In-Time (JIT) compilation As stated above, the Just in time compiler is a facility that is invoked by the CLR to convert the IL into machine code. The .NET framework assemblies (*.dll or *.exe) files cannot be executed by the target processor unless it is converted into native… Read More

Automated Testing Best Practices

Exforsys
Automated Testing Best Practices: This article explains about many topics like The Case for Automated Testing,  Why Automate the Testing Process?, Using Testing Effectively, Reducing Testing Costs, Replicating testing across different platforms, Greater Application Coverage, Results Reporting, Understanding the Testing Process, Identifying Tests Requiring Automation and Task Automation and Test Set-Up.The Case for Automated Testing Today, rigorous application testing is a critical part of virtually all software development projects. As more organizations develop mission – critical systems to support their business activities, the need is greatly increased for testing methods that support… Read More

Single Node and Multi Node Installation Part 2

Exforsys
Oracle Apps 11i Free Training: Single Node and Multi Node Installation Part 2. In this part 2 tutorial we will continue with the installation steps about product license types, country-specific functionality, additional languages and internationalization (NLS) settings.Step 10. Select product license type On the Suite Selection screen, the wizard prompts you to indicate the type of licensing agreement you have purchased from Oracle Applications. It then presents the appropriate licensing screen. Completing a licensing screen does not constitute a license agreement. It simply registers your products as active. Rapid Install… Read More

Single Node and Multi Node Installation Part 1

Exforsys
Oracle Apps 11i Free Training: Single Node and Multi Node Installation Part 1. In this part 1 tutorial we will learn how to start with the Single Node and Multi Node Installation along with step by step instructions, screen shots and Frequently asked questions.Single-node and multi node installation In a single-node installation, the database, all product directories, all servers (concurrent processing, forms, and Web) are installed on a single node under one common APPL_TOP whereas in a multi-node installation, you install both application tier and database tier servers across two… Read More

The .NET Framework Architecture Part 1

Exforsys
This is the first tutorial as part of the Visual Basic .NET 2005 Training. In this tutorials we will be learning about the basics of The .NET Framework Architecture, The .NET vision, Common Language Runtime (CLR), .NET Framework Class Library and Microsoft Intermediate Language (MSIL). It’s very important to learn the basics before we actually start with the Programming. The .NET Vision The .NET framework is a software technology that is directed towards connecting information, people, systems and devices seamlessly. The high level of software integration that has been attempted… Read More

Database Checkpoints in WinRunner

Exforsys
Every application includes a database. The database is used to store the information. When an application is being tested, the database of that application should also be tested in order to assure that the values are entered into the database correctly.Database Checkpoints in WinRunner Every application includes a database. The database is used to store the information. When an application is being tested, the database of that application should also be tested in order to assure that the values are entered into the database correctly. In Winrunner, for checking databases,… Read More

Data Driven Tests using WinRunner

Exforsys
This article explains about Steps involved in creating data driven tests, Data Driver wizard features in WinRunner and adding Data to the Data Table.Data Driven Tests using WinRunner An application has to be tested with multiple sets of data. The automation test script written for one input can be used for number of inputs using data driven test in Winrunner. The test script has to be converted into the data driven test by creating a corresponding data table with the sets of data you want to test. Steps involved in creating data… Read More

Why Choose LoadRunner for Performance testing

Exforsys
This article start with brief introduction to Performance Testing, Why should you automate performance testing, What are the LoadRunner components, LoadRunner Terminology and Load Testing Process.Performance testing Introduction Performance Testing is the process by which software is tested and tuned with the intent of realizing the required performance. The performance testing part of performance engineering encompasses what’s commonly referred to as load, spike, and stress testing, as well as validating system performance. Performance can be classified into three main categories: • Speed — Does the application respond quickly enough for… Read More

Oracle Apps 11i – Using Rapid install and the Steps Before Apps Installation

Exforsys
This tutorial explains about using Rapid install to install Oracle Applications on any machine. With Rapid Install, you can perform these operations: Install a new, fully configured Oracle Applications system, including the latest certified Oracle Applications technology stack and all patches, mini-packs, family packs, and other updates available at the time of this release. Using Rapid Install Rapid install is used to install Oracle Applications on any machine. With Rapid Install, you can perform these operations: Install a new, fully configured Oracle Applications system, including the latest certified Oracle Applications… Read More

Oracle Apps 11i Installation – System Requirements

Exforsys
This tutorials explains about the System Requirements for Oracle Apps Installation. Please refer to Oracle Apps manuals for the specific and latest requirements for your Operating System.Oracle Apps 11i Installation – System Requirements CPU Requirements CPU requirements for running Oracle Applications depend on:  the number of concurrent users and their usage profiles the number of concurrent manager processes and the types of jobs that they are running  the load for activities other than Oracle Applications  the size of the database  desired response time Because there are different product combinations, different… Read More

Oracle Apps 11i : File System

Exforsys
An Oracle Applications Release 11i system utilizes components from many Oracle products. These product files are stored below a number of key top-level directories on the database and application server machines. Depending on how you chose to install Applications, these product directories may be located on a single machine (the simplest case) or on multiple machines (the most common type of deployment).Oracle Applications 11i File system An Oracle Applications Release 11i system utilizes components from many Oracle products. These product files are stored below a number of key top-level directories… Read More

Testing : Introduction to CMM

Exforsys
Quality software should reasonably be bug-free, delivered on time and within budget. It should meet the given requirements and/or expectations, and should be maintainable.  In order to produce error free and high quality software certain standards need to be followed. Software Quality: Quality software should reasonably be bug-free, delivered on time and within budget. It should meet the given requirements and/or expectations, and should be maintainable. In order to produce error free and high quality software certain standards need to be followed. Quality Standards ISO 9001: 2000 is Quality Management… Read More

Automated Testing Advantages, Disadvantages and Guidelines

Exforsys
This article start with brief Introduction to Automated Testing, Different methods in Automated Testing, Benefits of Automated Testing and the guidelines that Automated testers must follow to get the benefits of automation.Advantages of Automated Testing Introduction: "Automated Testing" is automating the manual testing process currently in use. This requires that a formalized "manual testing process", currently exists in the company or organization. Automation is the use of strategies, tools and artifacts that augment or reduce the need of manual or human involvement or interaction in unskilled, repetitive or redundant tasks.… Read More

VB.NET 2005 Free Training

Exforsys
VB.NET 2005 Free Training We are exited to let you know that we will be starting Visual Basic .NET 2005 Training. Please find the topics below which we will be covering during the course. This training is based on the latest Visual Basic .NET 2005 version. Visual Basic .NET 2005 Training 1. .NET Framework architecture The .NET Framework Architecture Part 1 The .NET Framework Architecture Part 2 Application Class and Message Class Implementing Class Library Object Visual Studio.NET Namespaces .NET Assemblies Differences between VB.NET 1.0 and VB.NET 2.0 2. Introducing… Read More

Oracle Apps 11i: Internationalization Support and Multiple Reporting Currencies

Exforsys
This tutorial explains about Languages and Character Sets on the Database Tier, Languages and Character Sets on the Application Tier, Character Sets on the Desktop Tier as part of the Internationalization Support and Multiple Reporting Currencies feature in Oracle Applications 11i.Internationalization Support The Oracle E-Business Suite is designed for ease of deployment in a single global instance that meets the complex requirements of a worldwide enterprise. Strong internationalization support is essential in meeting this requirement. Key internationalization features provided by Release 11i include support for a wide variety of languages… Read More

Testing Types

Exforsys
This article explains about different testing types Unit Test. System Test, Integration Test, Functional Test, Performance Test, Beta Test and Acceptance Test.Introduction: The development process involves various types of testing. Each test type addresses a specific testing requirement. The most common types of testing involved in the development process are: • Unit Test. • System Test • Integration Test • Functional Test • Performance Test • Beta Test • Acceptance Test. Unit Test The first test in the development process is the unit test. The source code is normally divided… Read More

WinRunner – TSL Functions

Exforsys
This article explains about Types of TSL Functions like Analog functions, Context Sensitive functions, Standard functions and Customization functions.WinRunner – TSL Functions Introduction: TSL stands for “Test Scripting Language”. The test scripts are written in Test Scripting Language in winrunner. TSL is an enhanced, C-like programming language designed for testing. The advantages of TSL are:     1. It is easy to use. 2. It is similar to other programming languages. So a person who is in touch with basic concepts of programming can write test scripts easily. 3. It… Read More

Life Cycle of Testing Process

Exforsys
This article explains about Differant steps in Life Cycle of Testing Process. in Each phase of the development process will have a specific input and a specific output. Once the project is confirmed to start, the phases of the development of project can be divided into the following phases: Software requirements phase. Software Design Implementation Testing Maintenance In the whole development process, testing consumes highest amount of time. But most of the developers oversee that and testing phase is generally neglected. As a consequence, erroneous software is released. The testing… Read More

Best Practices in Automated Testing

Exforsys
This article talks about many interesting things like what’s the Case for Automated Testing, Why Automate the Testing Process?, Using Testing Effectively, Reducing Testing Costs, Replicating testing across different platforms, Greater Application Coverage, Results Reporting, Understanding the Testing Process, Typical Testing Steps, Identifying Tests Requiring Automation, Task Automation and Test Set-Up and Who Should Be Testing?.The Case for Automated Testing Today, rigorous application testing is a critical part of virtually all software development projects. As more organizations develop mission – critical systems to support their business activities, the need is… Read More

Securing ASP.NET Applications with C#

Exforsys
Asp.net Security Overview: Security is one of the most important component of any application. Security is even more important when you are making a web application which is exposed to million of users. Asp.net provides classes and methods that ensure that the application is secure from outside attacks. In this article we will investigate the different types of authentication provided by Asp.net. Windows Authentication Windows Authentication mode provides the developer to authenticate a user based on Windows user accounts. This is the default authentication mode provided by Asp.net. You can… Read More

Configuring and Deploying ASP.NET Applications

Exforsys
Asp.net applications can be easily configured by using web.config files. You can store number of things in the configuration file. Let’s see some important stuff that can be stored in this file.Database Connections The most important thing to store in the web.config file is the database connection string. The reason of storing connection string in the web.config file makes sense since if later we ever want to change the location of our database we just have to change the connection string in the web.config file and thats it. This will… Read More

Oracle 10g Installation Guide on Windows 7

Exforsys
Oracle 10g Installation tutorial depicts step by step installation of Oracle 10g on Windows 7, 64bit (10204_vista_w2k8_x64_production_db) operating system. Installation on Windows 7 will return a operating system version compatibility error. However, there will not be any such issue during installation on older version of Windows operating system. It is important to note that this installation method is neither certified nor recommended by Oracle. If you are planning to install Oracle 10g for production purpose then please follow the Oracle specified installation guidelines and use only the correct and supported… Read More

Oracle Apps 11i : Getting started with Oracle Applications

Exforsys
This tutorial explains about Oracle Apps login, Choosing Responsibility, Choosing Function / Opening Form, Switch Responsibility, Query Form and Keyboard Shortcuts. This chapter would tell a user about the basics of login to the Oracle Applications instance. It would also demonstrate the basics of working with Oracle Applications. To understand the complete functionality of a particular responsibility please refer to the respective User Guide. Oracle Applications Login Before you connect to Oracle Applications you must know the URL of the Oracle Applications server you want to connect to. Clicking on… Read More

Caching in ASP.NET

Exforsys
This tutorial explains about The Importance of Caching, Declarative Page Output Caching, Programmatic Page Caching, Caching Page Fragments, Caching Data and Monitoring Performance. Introduction: Caching is one of the coolest features in Asp.net. Caching enables you to store the expensive data into Cache object and later retrieve it without doing expensive operations. A very common example where you want to use caching is datagrid paging. I am sure you all are familiar with datagrid paging which enables you to view the records in multiple pages. Each time you visit a… Read More

A Unit Ttesting Framework for the Oracle PL/SQL Language

Exforsys
The utPLSQL unit testing framework consists of several different elements: A set of tables to hold information about unit tests and test suites. A set of packages that allow you to run tests, build test packages and access information about tests you have run.  We learn best by following the examples of those who have gone before us. So you will find in this document sample test packages and different approaches to using utPLSQL to test your PL/SQL code like it has never been tested before! http://utplsql.sourceforge.net/Doc/examples.html How to Build… Read More

Usability Engineering – Usability Testing

Exforsys
Usability Engineering, an empirical science has quite a simple definition. It studies the human interaction and cognitive behavior of an individual with respect to performing as task. It could be as simple as a driving a vehicle or using a product. Users interaction in performing a task should be in sync with the workflow of the product. Usability Engineering as a science helps in achieving this goal. Usability for a Product A Product should be usable. It means that people can use a product easily and efficiently to accomplish their… Read More

Bluetooth Technology Models and Future

Exforsys
This article discusses about various Bluetooth Technology Models & Application in the market and Bluetooth in Future. Bluetooth Technology Models & Applications HomeRF like Bluetooth is a specification for connectivity and mobility in a home-like environment. HomeRF Working Group has developed a specification for wireless communications in the home called the Shared Wireless Access Protocol (SWAP). The Federal Aviation Administration (FAA) and other aviation regulatory bodies worldwide are currently reviewing the use of Bluetooth products on private and commercial aircraft. In the U.S. the FAA is the governing body to… Read More

Bluetooth Vs 802.11b Wireless LANs

Exforsys
This article discusses about the differences between Bluetooth and 802.11b Wireless LANs, Co-existence of Bluetooth & Wi-Fi and Advantages & Disadvantages. 1) Bluetooth has lower distance range (less than 30 feet) than 802.11b (up to 200 feet). Therefore, you would need many more access points to cover the same area of an office. Simple mathematics will show that you may need as many as 20-50 times the number of access points 2) Bluetooth has generally lower speed than that of 802.11b wireless LANs. 3) Bluetooth components (chips and radios) and device… Read More

MSAS – Browsing the Dependency Network

Exforsys
The predictive model of the decision tree helps users determine whether similar cases will have a similar behavior. The attributes of the tree can be examined for impact analysis by using the Dependency Network Browser. This can be opened by right clicking on a decision tree data mining model in the Analysis services explorer tree control.   The Dependency Network Browser window contains a slider on the left and a display window on the right. It contains a Close and help button at the bottom. When the slider is moved… Read More

MSAS – Building a Relational Decision Tree Model

Exforsys
Let us assume FoodMart wants the members with Golden Membership to be studied. It wants to focus on broadening the membership of the Gold Card. This can be done now using the Decision Tree Model. The Decision Tree model can be created from the relational data contained in the FoodMart 2000 Access database. 1. In the Analysis Manager tree pane right click the Mining model folder and select New mining model… 2. In the Wizard Welcome screen click Next to proceed. 3. In the Select the source type screen select… Read More

MSAS – Introduction to Data Mining

Exforsys
The process of probing into a set of information for descriptive and predictive purposes is called data mining. The purpose is to identify those trends and patterns which indicate the direction of effort to achieve desired outcomes. SQL Server 2000 and Analysis Services, has inbuilt powerful data mining capabilities including algorithms for Clustering and for Decision Trees.Before actually studying the data mining capabilities of Analysis Services, let us briefly look at some terminology generally used while discussing data mining. Understanding Terms used in Data Mining A case is the term… Read More

MSAS – Applying security to a Dimension

Exforsys
When roles are assigned for cubes the user has access or no access to the cube. When roles are assigned to a dimension, the user gains only partial access to parts of the cube. The simplest method of restricting access to a dimension is to prevent access to all levels except the top level of the dimension. In the Cube role dialog box all users were given complete access to the sales cube. Let us restrict the access of users by permitting them to see only values broken out by… Read More

Tutorial 65: MSAS – Managing Cube Roles

Exforsys
In the Analysis Manager console tree, expand the cubes folder and right click the Sales cube and click Manage roles The Cube Role Manager Dialog box appears. The dialog box shows all the users whose roles have been already assigned in the database. It also allows us to create a new role. On clicking the New button, new roles can be added to the Cube role dialog box. The create a cube role dialog box appears. Type in the name for the cube role and click Add button. The Add… Read More

MSAS – Understanding Database Roles

Exforsys
When a new database is created a default role is created for all OLAP Administrators to have access to the Analysis Manager. However, other users have to be given rights to access the database and its objects. Users can be given rights to Browse the cubes and objects but not to use Analysis Manager. If the user has to be given a right to use both the database objects and the Analysis Manager, specific rights have to be assigned. To assign database roles to users, right click the database and… Read More

Oracle Apps 11i: Advantages of Oracle E-Business Suite

Exforsys
Oracle ERP Suite is based on Oracle Apps framework. What that essentially means to the customers is that no matter which component of the suite you buy, you get the same look and feel.Advantages of Oracle E-Business Suite Oracle Database The biggest USP of Oracle ERP is that it is based on Oracle Database, which in itself is a market leader. So the Oracle ERP is best placed to take advantage of the advances in the database technology. The buzzword is "If it is in the database, you will get… Read More

Oracle Apps 11i: Overview of popular ERP Products

Exforsys
This tutorial explains about different ERP Products and how they are being used in the industry.Oracle E- Business Suite Oracle E-Business Suite is the industry’s only complete and integrated set of enterprise applications, working together seamlessly to streamline every area of your business—from sales, service, and marketing, through financials and human resources, to supply chain and manufacturing. Oracle E-Business Suite is your fastest path to high-quality enterprise intelligence, bringing your company a true 360-degree view of your finances, your customers, and your supply chains, so you can make faster, better… Read More

Managing State with ASP.NET and C#

Exforsys
Web Applications are disconnected in nature which means that there is no way for the browser to know who is using the application at present time. In classic Asp programming maintaining state was a headache for the developers. They had to write alot of code to maintain state. But Asp.net model provides easy state management. In this article we will see how we can persist state in multiple pages so the user is recognized by the browser.Preserving State in Web Applications There are number of ways that you can use… Read More

ERP Overview

Exforsys
ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief history of ERP, Why is it necessary, Market Leaders and the future of ERP. What is ERP? Enterprise Resource Planning or ERP is an industry term for integrated, multi-module application software packages that are designed to serve and support multiple business functions. An ERP system can include software for manufacturing, order entry, accounts receivable and payable, general ledger, purchasing, warehousing, transportation and human resources. Evolving out of the manufacturing industry, ERP implies the use of packaged software rather than proprietary… Read More

MSAS – Securing User Authentication

Exforsys
The enforcement of security defined by the roles must be preceded by user authentication. When the user connects to the Analysis server, the first thing that happens is authentication. The user login is validated and the user is given access to the data on the server in accordance with the roles. If authentication is unsuccessful, he will not be able to access the data on the server. End user security can be enforced at multiple levels. The levels are as under: 1. Server level : This controls whether an end… Read More

MSAS – Introducing Analysis Services Security

Exforsys
Security of data is of paramount importance to most industries and organizations. All organizations want to restrict access to data hierarchically or define role based access. Analysis Services provides for this need. The number of Administrators and users having access to Analysis services data can be restricted by setting the role definitions in Analysis manager. End users who have access to data through client applications can be restricted in various ways. Security levels can be set for various objects within the database such as cubes, dimensions and cells. The Microsoft… Read More

How Bluetooth Technology works?

Exforsys
This is the first article on the Bluetooth Technology by Nupur Mittal.  Bluetooth is a high-speed, low-power microwave wireless link technology, designed to connect phones, laptops, PDAs and other portable equipment together with little or no work by the user. Connective convenience Unlike infra-red, Bluetooth does not require line-of-sight positioning of connected units. The technology uses modifications of existing wireless LAN techniques but is most notable for its small size and low cost. The current prototype circuits are contained on a circuit board 0.9cm square, with a much smaller single… Read More

What is Bluetooth Technology

Exforsys
This is the first article on the Bluetooth Technology by Nupur Mittal. Blue tooth has been regarded as a new wave in the IT sector from the day of its origin. Blue tooth is continuing its success story. Toshiba introduced blue tooth in September 2000 to consumers for $ 199. The new technology is supported by SIG (Special Interest Group). SIG founded in 1998 consists of 2000 members who have access to the Blue tooth specifications (information needed to make a blue tooth product). The SIG works to promote the… Read More

MSAS – Writebacks

Exforsys
Dimensions can be modified so that the contents of the dimension changes. The impact of these changes can be viewed by end users browsing cubes. End user’s get an added analytical option due to this process.(This option is only available in the Enterprise Edition of Microsoft SQL Server 2000).Write-Enabled Dimensions Dimensions can be modified so that the contents of the dimension changes. The impact of these changes can be viewed by end users browsing cubes. End user’s get an added analytical option due to this process.(This option is only available… Read More

MSAS – Defining and Creating Drillthrough

Exforsys
Actions used by end users to select a single cube cell and retrieve a result set from the source data of the cell are known as Drillthrough actions. Drillthrough has to be enabled if administrators want to drillthrough in a Cube Browser and the Cube Editor data tab. The DrillThrough operations are extremely useful when the user wants to look at the underlying causes for some abnormally high or low outputs in specific fields. For example, let us say a store is doing extremely well and the sales in that… Read More

MSAS – Defining and Creating Auctions

Exforsys
This tutorial explains about defining Auctions, Creating Auctions, Creating Actions in Regular Cubes, Creating and Maintaining Actions in Virtual Cubes, Importing an Action into a Virtual Cube and Editing an Action in a Virtual Cube.Defining Actions End users can define certain operations to be performed or cubes or portions of a cube. These user defined operations are called Actions. The end user can use an action as a parameter for starting an application or for retrieving information. He can go beyond traditional analysis and initiate solutions to discovered problems and… Read More

ASP .NET Migration and Interoperability

Exforsys
Before Asp.net invasion there were many other programming languages and technologies on which the dynamic pages were made. In this tutorial I will explain how we can migrate our classic asp application to the modern asp.net application. Most of the components that were written was in visual basic 6 which communicated with the asp application using the COM components. Using COM Objects in Asp.net The Asp.net processor understands nearly all the syntax and all the objects that ASP itself supported. Let’s see how you can create a simple ADO Connection… Read More

MSAS – Creating and Maintaining Calculated Members in Virtual Cubes

Exforsys
Calculated members can be imported into virtual cubes from their component cubes. New calculated members also can be created directly into virtual cubes. The Calculated member Builder can be used to build the members or calculated members created in component cubes can be imported and then the same can be edited. The virtual cube editor is used to maintain the calculated members in virtual cubes. The Virtual cube Editor provides a single click access to Calculated Member Builder and the Import Calculated Members dialog box, which can be used to… Read More

MSAS – Building a Virtual Cube

Exforsys
In the above section we studied some of the reasons why we would want to create virtual cubes and how logical results can be obtained by making such cubes. We also saw that a virtual cube can be built quickly and easily by using the Virtual Cube Wizard.Building a Virtual Cube The Wizard takes the user through a series of steps that prompt him to specify the cubes, measures and dimensions to be used for building the virtual cube. The virtual cube then creates a combined view of the selected… Read More

MSAS – Understanding Virtual Cubes

Exforsys
This tutorial explains about Defining Virtual cubes, Benefits of using virtual cubes, Working with Virtual Cubes and Obtaining logical results.Defining Virtual cubes Virtual Cubes can be defined as a combination of multiple cubes into one logical cube. Virtual cubes resemble relational database views in so far as they combine other views and tables. A virtual cube is created by selecting measures and dimensions from a consolidated set of dimensions and measures underlying component cubes. End users will see the virtual cube as a single cube. Virtual cubes can also be… Read More

Functional Testing Tools

Exforsys
Here is the list of free Open Source Functional testing tools available.  If you know of any other , please send them over, so we can include them. Abbot Java GUI Test Framework http://abbot.sourceforge.net/ Description: The Abbot framework provides automated event generation and validation of Java GUI components, improving upon the very rudimentary functions provided by the java.awt.Robot class (A Better ‘Bot). The framework may be invoked directly from Java code or accessed without programming through the use of scripts. It is suitable for use both by developers for unit… Read More

SDLC : Software Development Life Cycle

Exforsys
This article explains about SDLC : Software Development Life Cycle  which is also known as Classic Life Cycle Model or Linear Sequential Model.   Author:  Madhavi Bade, QA Analyst.SDLC : Software Development Life Cycle The following are the actives of the SDLC   1) System engineering and modeling 2) Software require analysis 3) Systems analysis and design 4) Code generation 5) Testing 6) Development and Maintenance System Engineering and Modeling In this process we have to identify the projects requirement and main features proposed in the application. Here the development team visits the… Read More

MSAS – Introducing Solve Order

Exforsys
Before understanding what is solve order it is essential to understand the concept of Pass order. Solve order and pass order together determine the manner in which a cube is resolved in Analysis services.Pass order Every cube calculated as the result of a multidimensional Expression Query goes through a number of stages of calculations. Analysis server makes a complete pass of the calculations applicable for a stage and the stage is referred to as a calculation pass. The number of passes required to compute fully all the cells of a… Read More

MSAS – Implementing Calculations Using MDX Part 2

Exforsys
In this part 2 of  Implementing Calculations Using MDX, we will be learning about Renaming Calculated members, Creating Non Measure Calculated members, Using Functions in Calculated Members, Setting calculations at Member level and Setting a Calculation for a subcube or a selection of cells.Renaming Calculated members 1. In the Analysis Manager tree pane, under the database that contains the calculated member, expand the Cubes folder. 2. Right-click the cube that contains the calculated member, and then click Edit. 3. In the Cube Editor tree pane, right-click the calculated member, and then click Rename.… Read More

MSAS – Implementing Calculations Using MDX Part 1

Exforsys
In this tutorial we will be learning about Calculated members, Creating Calculated Members, Using Function Libraries to Build Calculated Members and Calculated Member Builder.Understanding Calculated members Calculated members are members of a dimension whose value is calculated at run time using Multidimensional expressions. The values of a calculated member may be derived from other member’s values. For instance Profit is determined by subtracting the value of member costs from value of member sales. This is unlike an input member whose value is directly loaded from the data base. The expressions for… Read More

MSAS – Merging Partitions

Exforsys
Cubes with multiple partitions can be extremely confusing. Users may like to organize the cubes into a cube with fewer partitions by merging some of the partitions together. The preconditions to the merger of cubes is that the Storage and aggregation design should be the same in the partitions being merged. To merge partitions with different storage designs, the partitions being merged must be edited to have the same storage design. The cubes must then be reprocessed before the merger is attempted. We will merge the Sales 97 partition back… Read More

MSAS – Introduction and Managing Partitions

Exforsys
The cube is a storage container that contains data and aggregations of data. Every cube must have at least one partition which must be stored in the Analysis server in which the cube is defined. Partitions are stored as separate files in the Partitions folder under the cube. If a cube contains multiple partitions, some of them can be stored in different physical locations. Partitions of a cube can also have different data sources. The aggregations of the data in the partitions can also be stored in different locations. The… Read More

MSAS – Troubleshooting Cube Processing

Exforsys
Microsoft SQL Server 2000 Analysis Services provides the user with many ways of tracking and solving errors. A large number of error logs built into the service help the user pinpoint the exact nature of errors and find solutions for them. Microsoft Tech Net also provides the user online support to troubleshoot problems. This requires paid membership. FAQs of different kinds are available for the reference of users. SQL Server Books Online FAQ SQL Server Enterprise Manager FAQ Administration Tools FAQ Failover Clustering FAQ Multiple Instance FAQ Programming FAQ Replication… Read More

MSAS – Processing Dimensions and Cubes

Exforsys
As stated earlier, maps are created when a dimension is processed. However, existing maps of a dimension are destroyed when it is processed and new maps are created. Consequently all cubes accessing the dimension will find it inaccessible and the cube will be invalid. The dimension will become accessible only when the cube is reprocessed.When cubes contain a large number of dimensions and some of the dimensions undergo a change, reprocessing a cube can become a daunting task. However, Analysis server has a solution to this problem. It is possible… Read More

MSAS – Introducing Dimension and Cube Processing

Exforsys
The Analysis server is like a black box. Everything that happens in the server is recorded, but the end user sees a multidimensional cube created out of the data in the data warehouse and has very little taste of what really goes on behind the scenes. In this section we will be examining this black box to understand how the Analysis server processes Dimensions and cubes. We will also learn how to optimize cube processing and how to troubleshoot cube processing.Processing Dimensions: Introduction Dimensions are building blocks on which the… Read More

Creating and consuming XML Web Services with C#

Exforsys
Introduction: We all talk about webservices, webservices can do this and webservices can do that. But when we are asked to make one, we hesitate. Maybe it’s because we never made a webservice before, and all the time playing with Webforms and Windows Forms or even Console Applications. By the way, I love Console applications. In this article, I will show you how to create a simple webservice that is consumed by a Console application client. Motivation of the XML Web Services Most of the people does not understand that… Read More

MSAS: Optimization Tuning Part 2

Exforsys
The SQL Server Query Analyzer is a feature rich Query Analyzer. The tool can provide a graphical representation of a query and helps the user mould queries into more efficient shapes. It also helps identify faulty queries. +To Tune the index created the user will have to open the SQL query analyzer and open a query or enter one. On the Query menu click on Index Tuning Wizard and follow the steps of the wizard. On the Specify workload screen select SQL Query Analyzer Selection and click Next. Select the… Read More

MSAS: Optimization Tuning Part 1

Exforsys
SQL Server 2000 Analysis services comes with certain features that optimize performance without the intervention of the Administrator. The Storage Engine is optimized by incorporating the following features;Record size and Data types should be kept as short as possible in the Fact tables and should only include fields for measures and indexed key columns. The Measure fields should use the smallest data type consistent with the measure data but the data type should be large enough to contain summarized values and prevent overflow when aggregations are calculated. Even saving two… Read More

MSAS: Usage-Based Optimization

Exforsys
This tutorial explains the usage of the Usage Based Optimization Wizard, The Server Cache , Query Usage and Manipulating the query log. Using the Usage Based Optimization Wizard. 1. When a set of queries have accumulated in the Usage log, the Usage based Optimization wizard can be pressed into service. 2. The task on hand is to select the Logged queries that should be applied and then design aggregations based on them 3. Let us assume that a user has browsed the sales cube and accumulated log entries by manipulating data. 4.… Read More

MSAS: Analysis Services Aggregations

Exforsys
Pre-calculated summaries of data that improve query response time are called aggregations. OLAP technology organizes data into the multidimensional structures of cubes. The dimensions and their hierarchies define the queries that can be asked of the cubes.Cells store the value at the intersection of dimension coordinates. Whenever a query is made on the data, the results have to be fetched from the various locations of cells on the multidimensional structure, affecting response time.  Aggregations consist of all the possible combinations of one level from each dimension in the cube. This… Read More

QuickTest Professional 8.0 CBT Tutorial and Evaluation Copy

Exforsys
Please find the step to get QuickTest Professional 8.0 CBT Step by Step Tutorial and Evaluation copy of the software. It takes couple of min to register and you get everything you need to learn and practice. The best part is comes with 1200 Page PDF Manual with kind of step by step instructions along with screen shots.Introduction to QuickTest Professional 8.0, Computer Based Training Register for free account, you will be able to download QuickTest CBT and Evaluation Copy software. QuickTest Professional is today’s answer for keeping pace with… Read More

MSAS: The Storage Design Wizard

Exforsys
The Storage Design Wizard helps the user set the storage options and design the aggregations for a cube. While choosing from the three available storage modes the user has to keep certain factors in mind. ROLAP stores aggregations in a relational database and hence it does not make sense to select ROLAP as a storage mode for cubes if the aim is to have speed of performance in analysis. Aggregations in Relational databases are slow and bulky and it defeats the very purpose of creating the aggregations. However, if the… Read More

MSAS: Analysis Server Cube Storage

Exforsys
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… Read More

MSAS: Defining Cube Properties

Exforsys
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… Read More