Release 11i
Part Number A96138-01
 Contents |
 Index |
| Oracle Financial Analyzer User's Guide Release 11i Part Number A96138-01 |
|
In formulas, ACT-BUD variance means the positive variance is displayed when actual is greater than budget. Typically, if you are defining a revenue line item, you should select the calculation ACT-BUD so that a positive number is displayed if actual data is greater than budget data.
Button appearing on the Selector dialog box that enables you to add selected items to the Selected box.
The following aggregation types are supported:
A solution method in which the first two of every three iterations over a block of simultaneous equations are solved using the values from the previous iteration, and the results are tested for convergence and divergence. In every third iteration, the results are obtained not by solving the equations, but by making a next-guess calculation. This calculation uses the results of the previous three iterations. The results of the guesses are not tested for convergence and divergence, and the solution always continues to the next iteration.
A graph that emphasizes trends in data. While similar to a line graph, an area graph highlights the amount of change, not the rate of change.
A set of database objects that enables you to customize the layout of a report. An asymmetric combination joins the values of two dimensions so that you can juxtapose values in a way that lets you compare and contrast them.
A database object that links or relates the values of two dimensions. For example, you might define an attribute that relates the Sales District dimension to the Region dimension so that you can select data for sales districts according to region.
An option on the Graph, Report, and Worksheet menus. When you select this option, your report, graph, or worksheet is automatically redisplayed when you make changes to the format or data in the document.
A label that you can assign to the X-, Y-, or Y2-axis of a graph to provide information about the data represented by that axis.
A graph that compares one or more data series. Each data point is represented by a single bar. You can orient a bar graph either vertically or horizontally.
In formulas, BUD-ACT variance means a positive variance is displayed when budget is greater than actual. Typically, if you are defining an expense line item, you should select the calculation BUD-ACT so that a negative number is displayed if Actuals data is greater than budget data.
A button located to the left of the edit bar which, when chosen, clears all text from the bar.
A graph that compares data for two or more data series. Each data series is represented by bars of the same color. You can orient a clustered bar graph either vertically or horizontally.
The dimension from which you are selecting values. The current dimension is the dimension that you specified in the Dimension box of the Selector dialog box. Choices that you make and actions that you take in lower-level dialog boxes ultimately affect this dimension by selecting values from it to include in a document.
The object upon which the next specified action takes place. Generally, the current object is the most recently selected one. However, if you use a highlighter button to highlight a group of objects, such as data cells in a column, the first object in the group is the current object.
A graphical object that represents data in a graph. For example, the data markers in a bar graph are bars, while in a pie graph they are pie slices.
A graphical object that represents the point of intersection of multiple values in a graph.
If a database object belongs to a DBA library, it means that the object was created by an administrator and cannot be modified by a user.
Variables with a decimal data type contain decimal numbers with up to 15 significant digits.
If a dimension has the Defined by option set to DBA for hierarchies, models, or relationships, that dimension can be used only by an administrator in hierarchy, model, or relationship definitions.
If a dimension has the Defined by option set to EveryOne for hierarchies, models, or relationships, that dimension can be used by any user in hierarchy, model, or relationship definitions.
If a dimension has the Defined by option set to NoOne for hierarchies, models, or relationships, that dimension cannot be used in any hierarchy, model, or relationship definition.
A database object used to organize and index the data stored in a variable. Dimensions answer the following questions about data: "What?" "When?" and "Where?" For example, a variable called Units Sold might be associated with the dimensions Product, Month, and District. In this case, Units Sold describes the number of products sold during specific months within specific districts.
A text label that displays the name of the dimension associated with an element of a report, graph, or worksheet. For example, the data markers in a graph's legend contain dimension labels that show what data each data marker represents. Dimension labels can be short, which means that they display the object name of a dimension, or user-specified, which means that they display a label that you typed using the Dimension Labels option on the Graph, Report, or Worksheet menus.
A set of tiles in a graph, report, or worksheet.
Elements that make up a dimension. For example, the dimension values of a Product dimension might include Tents, Canoes, Rackets, and Sportswear.
You can print reports in either final quality or draft quality mode. Both modes print out all data included in your report. Final quality printouts reflect all formatting you have applied to the body of your report as well as any customized headers and footers you add to your report. Draft quality reports include customized headers and footers as well as row and column labels, but they do not reflect any customized formatting in the body of the report.
Because draft printouts use a default draft font and do not include customized formatting they can print faster than final quality printouts.
You cannot print drafts of graphs or worksheets.
Opens the Drill dialog box, which enables you to move up or down through the levels of aggregated data in a report, graph, or worksheet.
Icons on which you click to move up or down through the levels of aggregated data in a report, graph, or worksheet. There are two drill icons:
The following icon expands the list of related financial data items, enabling you to view more detailed levels of aggregated data.
The following icon collapses the list of related financial data items, enabling you to view higher levels of aggregated data.
The position in a report or worksheet along which a dimension or financial data item is located. The report edges correspond to the sides of a three-dimensional data slice.
An element of the document area that enables you to edit the text associated with components and options in graphs, reports, and worksheets.
A button that opens a Choice List dialog box, which provides a list of values from which you can make one or more selections.
A button located to the left of the edit bar which, when chosen, applies the text in the box to a selected graph, report, or worksheet option.
A database object that is made up of either a variable, or a variable and a formula. For example, a financial data item called "Actuals" would be a variable, while a financial data item called "Actuals Variance" would be made up of a variable (Actuals) and a formula that calculates a variance.
Represents a new series of data that is statistically based on an original series. Fitlines, also called trend lines, illustrate how original data series are changed by exponential, linear, or logarithmic calculations. A fitline answers the question, "What, mathematically, can we say about the original series?"
An object in which you can store documents such as reports and graphs. You can create a new folder and add documents to it by choosing the Maintain Folders option from the Tools menu.
Text that you can include at the bottom of a graph, report, or worksheet to annotate that document. Footnotes appear on your screen and on printouts of a document.
A button located to the left of the edit bar which, when chosen, invokes the Formula Tools dialog box. You can then use the formula tools to create a formula to be used in the current report.
A solution method in which equations in a simultaneous block are solved in each iteration over the block. The results are tested for convergence and divergence in each iteration.
The basic structural elements of a graph, such as the X- and Y-axes in line and bar graphs, or the pie slices in pie graphs.
Elements, such as a title or legend, that provide additional information about the data represented in a graph. Graph options can be displayed or hidden using commands on the Graph menu.
Lines that help to visually separate the data cells and labels in a report or worksheet, or that help to relate data markers and data points to axis tick labels in a graph.
A worksheet calculation method that enables you to augment or decrement the values of financial data items in a range of cells over a specified amount of time by a constant amount or by a percentage.
Small rectangular graphical objects that cause specific areas of a report or worksheet to become highlighted when you click on them. Highlighter buttons produce highlighted areas in the following ways:
Following is an illustration of the highlighter buttons.
A worksheet calculation method that enables you to augment or decrement the values of specific financial data items for specific time periods by a constant amount or by a percentage.
Variables with an integer data type contain whole numbers with values between -2.14 billion and +2.14 billion.
A graphical key that displays a graph's data markers and the dimension labels for the data that the markers represent.
An ownership designation associated with a database object, which specifies who created the object and, therefore, who is permitted to modify or delete it. Objects can have the following library designations:
A graph that depicts trends. Each data point is represented by a point on the graph. When the points are connected by lines, trends become visible.
Vertical and horizontal lines that you can display in a report, graph, or worksheet to visually separate data. Major gridlines visually segment the report, graph, or worksheet area into larger areas than do minor gridlines.
A relationship between one or more values of one base dimension with one or more values of a second base dimension. For example, if you have a Many-to-Many attribute definition where the first base dimension is Organization and the second base dimension is Line Item, then a single organization can be related to several line items, and a single line item can be related to several organizations.
Data that describes other data. An example of metadata is a variable that lists the names of levels in a hierarchy or that holds the number of decimal places to be used for displaying data. Client applications use metadata when displaying multidimensional data in graphs, reports, tables, and so on.
Vertical and horizontal lines that you can display in a report, graph, or worksheet to visually separate data. Minor gridlines visually segment the report, graph, or worksheet area into smaller areas than do major gridlines.
A set of interrelated equations for calculating data.
A relationship where one or more values of a base dimension are related to a single value of an aggregate dimension. For example, if you have a One-to-Many attribute definition where the base dimension is Organization and the aggregate dimension is Level, each organization can be related to only a single level.
If a database object belongs to an Oracle GL library, it means that the object was created by importing data from Oracle General Ledger. Users can add and move values that belong to Oracle GL libraries, but they cannot rename or delete them.
A graphical element that enables you to page through a graph, report, or worksheet.
Tip: To quickly page through an open report or worksheet, select the paging dimension by clicking on it and press ALT+PAGE UP or ALT+PAGE DOWN.
Personal databases are used to store objects, and on some types of workstations, financial data. Objects include dimensions, financial data items, attributes, and hierarchies, as well as documents such as reports, worksheets and graphs.
If a database object belongs to a personal library, it means that the object was created by the workstation user and can be modified.
Graphical lines that help you annotate a pie graph by connecting a pie slice label to a pie slice.
In reports, qualified data references (QDRs) are used to describe specific cells that are referenced by one or more dimensions. For example, a QDR can be used to reference the cell that represents the Total Assets line item for the year 1996 for the East organization.
Lets you redisplay a report, graph, or worksheet after you have modified it.
Button appearing on the Selector dialog box that enables you to remove selected items from the Selected box.
The basic structural elements of a report, such as its rows and columns.
Structural elements, such as titles or column headings, that organize the data represented in a report. Report options can be displayed or hidden using commands on the Report menu.
Graphical elements of a report or worksheet that enable you to view information that currently does not fit into the window display.
A set of tools that provide shortcut methods for selecting the values that you want to work with in a document.
The shared database contains financial data and objects that are shared by all users. Objects include dimensions, financial data items, attributes, and hierarchies, as well as documents such as reports, graphs, worksheets and data entry forms. Shared databases are maintained by administrators.
Variables with a shortdecimal data type contain decimal numbers with up to 7 significant digits.
Variables with a shortinteger data type contain whole numbers with values between -32768 and +32768.
A set of information used to calculate new values for financial data items. This information includes the variable for which new values are to be calculated, the model to be used in the calculation, the dimensions of the variable, and any hierarchies associated with the dimensions. When you run a solve definition, the model is solved for the variable referenced in the definition.
A worksheet calculation method that enables you to augment or decrement the values of descendants in a hierarchy by entering a value for a parent value in the hierarchy and modifying the descendants based on their relationship with the parent.
Variables with a text data type can contain multiple lines of alphanumeric text.
A dimension whose values can contain characters in both upper and lower case. The length of a text dimension's values is determined by the Width option on the Maintain Dimension dialog box.
A client is considered thick if the personal database and Express Server are installed on the PC and all processing takes place on the PC.
A client is considered thin if the personal database and Express Server are installed on the server and all processing occurs on the server.
Text or numbers, located along a graph's axes, that describe the data presented in a graph.
Short line segments, located on a graph's axes, that denote increments of data. Major tick marks indicate primary levels of gradation, while minor tick marks indicate secondary levels. When working with a bar, line, or scatter graph, you can choose to include major tick marks, minor tick marks, or both, to make the graph's data easier to interpret.
A graphical element of a report, graph, or worksheet that displays the name of a dimension whose data appears in that document.
A tile's location in a document indicates the position of the dimension it represents. For example:
Tiles contain a number in parentheses beside the dimension name. This number indicates how many values have been selected for the dimension.
You can manipulate the data in a document by dragging one or more tiles to new locations in the document. This action changes the position of the tiles' related dimensions.
A dimension whose values represent time periods. A time period can be a month, quarter, or year. The length of the Time dimension's values is determined by the Width option on the Maintain Dimension dialog box.
A database object that holds raw data. Data can be numerical, such as sales or expense data, or textual, such as descriptive labels for products.
The basic structural elements of a worksheet, such as its rows and columns.
Structural elements, such as titles or column headings, that provide additional information about the data represented in a worksheet. Worksheet options can be displayed or hidden using commands on the Worksheet menu.
A secondary vertical axis that can display:
|
 Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|
