On the Data Selection form, define the criteria that you want to apply to the data row, and click OK.Īt any time in the future, you can modify the data selection by selecting Define Data Selection from the Row menu. Set other properties that you want on other tabs, and click OK. To indent the text on the report, enter spaces in front of the text. This Description column can consist of multiple lines to accommodate as much text as required. The description appears on the report in the Description column of the Tabular section, on the Row List tab of the Tabular Section properties, and in the Description field of the Data Row Properties form. In the Description field, enter a meaningful description of the data. The name appears in the Name field on the Row List tab of the Tabular Section properties and on the Data Row Properties form. On the Data Row Properties form, enter the name of the data row in the Name field on the General tab. Open a tabular row section report in RDA. To again enable row optimization, set the variable to 1, or delete the row from the jde.ini file. As a troubleshooting measure, you can disable row optimization by adding this line to the UBE section of the jde.ini: The row optimization feature is enabled by default. You can also find the total number of optimized rows in the UBE log file, Tabular Optimization. The cover page also includes the total number of rows that are optimized, Number of Optimized Inclusion Rows, and the total number that are not, Number of Non Optimized Inclusion Rows. In the Optimized Row column of the cover page, the system prints a Y next to the rows that are optimized and an N next to the rows that are not. If you include a cover page with the report, you can review which rows the system is optimizing. The optimization accelerates report processing speed. The system optimizes rows with two or less logical expressions (nodes) that are joined by an AND operator. For example, you might want the system to automatically generate rows to create a balance sheet report that is based on the current month and the prior year's account balance. After the generation, you can insert rows that calculate account roll-up totals at various levels of detail. In tabular sections, the system automatically generates rows that define a chart of accounts for a business unit or represent the merging of accounts from several business units. Enables you to describe or label information in the tabular section, such as identification information for a group of rows. The total can include or exclude rows within the sum range that are themselves row calculations.Įnable you to create underlines to separate various rows in the report.Ĭontain only text. The calculation performs totaling for all numeric columns in a range of rows. For example, you can calculate the gross margin of the revenue and direct costs rows.ĭefine a special type of calculation. In addition, you can add a row that displays the direct costs (column) for another range of fields.ĭisplay amounts that are calculated from other rows. For example, you can have a data row that displays revenue (column) for a range of items. Data rows represent groups of data fields that are associated with the columnar amounts. You must define the rows and identify the data using the business view that is attached to the tabular section. Object subsidiary and object subsidiary type.įetch data from Oracle's JD Edwards EnterpriseOne tables. When a level break causes a change in one of these fields in a tabular section, the Description row automatically displays this information: The Row Description column has special capability for level breaks that are associated with the Subledger, Cost Object, and Object Subsidiary fields. If no trigger were attached to the company data dictionary field, the system would display the field value of 00001. This is because the company field has a trigger attached in data dictionary. For example, if you define company as a level break field and retrieve records for company 00001, the description of Financial Reporting Company appears in the Row Description column. Otherwise, the system prints the field value. If the level break fields that are included in the Description column have data dictionary triggers attached, the system prints the description of the field in the Row Description column. If you remove the Description column from the section layout, you can select it from the list of business view columns. The data in this column is based on the data sequencing fields that you define as level break fields. When you create tabular sections, the system automatically includes a Description column in the section layout. 8.2.1 Understanding Row Description Columns
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |