Drill Down and Data Analysis
Drill Down Input Form Data
Manual Data Entry Log
To access the manual data entry log:
- Select a cell that is available for manual input.
- Right-click the selected cell.
- Choose Manual data entry log from the context menu.
[!TODO] Screenshot required Original caption: Figure 6.51. Drill down section
The upper table displays the dimension elements that define the selected cell.
The lower table displays the log of changes made to the value.
Input Mode = Input Currency
If the input mode is equal to the input currency, this option opens the manual data entry log window in the following form:
[!TODO] Screenshot required Original caption: Figure 6.52. Data entry log report (original currency)
The first line in the upper table contains only one value in original currency (for example, rubles).
The lower table displays the log of changing the value in the original (input) currency.
Input Mode = Functional Currency
If the input mode is equal to the Functional currency, this option opens the manual data entry log window in the following form:
[!TODO] Screenshot required Original caption: Figure 6.53. Data entry log report (functional currency)
The first line in the upper table contains three fields:
| Field | Description |
|---|---|
| Original currency | Contains the value entered in the original currency (for example, RUB). |
| FX rate | FX rate input option is set in the Scenario card (for example, EUR/RUB). FX rate value is set in the Exchange rate menu section (for example, 95.5000). |
| Functional currency | Contains the value calculated into Functional currency (for example, EUR). |
The lower table displays the log of changing the value in the original (input) currency.
Drill Down Calculated Data
The system provides the ability to drill down each calculated item to trace how it was generated.
To access the drill down report:
- Select the calculated cell at the most detailed level.
- Right-click the selected cell.
- Select Detail (All forms) from the context menu.
[!TODO] Screenshot required Original caption: Figure 6.54. Drill down context menu section
Input Mode = Input Currency
If the input mode is equal to the input currency, this option opens the drill down report in the following form:
[!TODO] Screenshot required Original caption: Figure 6.55. Drill down report
Input Mode = Functional Currency
If the input mode is equal to the Functional currency, the drill down report can be read in the same way as the Manual Data Entry Log report.
Drill Down Imported Data
How To
- Open the relevant input form.
- Load the layout with actual data.
- Find the amount in the subtable that you want to check.
Please consider that only detailed data can be drilled down to the document numbers.