Using Variable Offsets and Ranges. . . Because Version is not a range in this case, we will leave From Value selected. Note that step 6 was necessary because selection option variables cannot be combined with a hard-coded restriction in the same characteristic. Now that we have created the Actual selection, we can move on to the Plan selection. Because we will be filtering on Fiscal Year within the Key Figures structure, there's no need for a separate Fiscal Year drilldown.
For example, offsetting postings may occur within a cost center during the year. The new selection for prior year actual is now complete. . When the user expands this node, it will automatically be replaced by the Third Level A node. When the checkbox Structure as Group is checked, and zero suppression is enabled in the query properties, the structure will only be suppressed if all of the selections and formulas within the structure are zero. The Always Suppress option will never show a results row.
Right-click Cost Center and select Restrict. This concludes the properties available for the query as a whole. Because this new selection will be very similar to the existing Actual selection, we can take a shortcut by copying and pasting: right-click the Actual selection in the Key Figures structure, click Copy, then right-click the Actual selection again and click Paste. If you'd like a month-by-month running total, you would need to check the Cumulated checkbox and change the Calcu- 66 Summary: Query-Building Basics 3. Because you created this empty selection from scratch, you'll need to manually add the Amount key figure. The last section is a Preview of what the query will look like. Selection Option: Allows the user to enter any number of single values, ranges, logical operators greater than, less than, etc.
. Make sure Between is selected in the first dropdown box, and click the button next to the second dropdown box to open the Select Values screen for the From value of the range. . Other options include sorting by the values of the characteristic itself, or by an attribute of the characteristic. Das fachkundige Autorenteam beantwortet Ihnen zentrale Fragen, bspw.
You'll notice that the rows section of the report is much narrower in the hierarchical view, as the characteristics are nested within a single column. With a selection, the Constant Selection option is available. The Structures displayed in this pane are reusable query components consisting of a number of different selections; we will discuss structures in detail later. Choose whether to make the variable mandatory or optional. Our next exercise will involve removing our existing query-level fiscal year variable restriction and adding a line-level restriction into the Key Figures structure.
. Click once in the Description field after Plan, and hit enter to create a new line. . Let's set up a new selection in the Key Figures structure to show Actual data for the prior year, based on the fiscal year variable. The Web Application Designer Reference. .
Default Values: Set Now, Change Later. Selects a display hierarchy for the characteristic. A common use of text variables is to indicate which timeframe is being viewed when timeframe selections are dynamic. If the total for the year adds up to zero and Suppress Zeros is set to Active, that line of data may disappear from the query, depending on which characteristics are active drilldowns. Expand Key Figures in the InfoProvider pane on the left, and drag the Amount key figure to the Columns pane on the right.
Query Designer provides this functionality with the Free Characteristics, Rows, and Columns panes, as discussed earlier in this chapter. Grayed out if no display hierarchy is selected. Another useful setting involving text variables is the Offset Setting, found on the Replacement Path tab of the Change Variable screen. . . The display hierarchy assigned to the characteristic is often the same hierarchy used to set up the hard-coded restriction, but the two can be different if necessary. However, if Expand To was set to Cost Element, the Cost Center hierarchy would be again expanded to its default level, with Cost Element displayed as the next level.