Day: April 7, 2005

Oracle 9i Packages

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

MSAS: Virtual Dimensions

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

MSAS: Introducing Member Properties

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

MSAS: Creating Custom Rollups

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

MSAS: Creating a Time Dimension

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