Write and Edit Scripts
Write and edit Essbase scripts using enhanced script editing capabilities in the Redwood Interface.
Essbase now offers script editing capabilities in the calculation script, MDX script, and report script editors, as well as in the formula editor in the outline. You can use keyboard shortcuts to enable script editing functionality such as:
- Selecting and editing multiple lines at once
- Undo and redo
- Expand and collapse
- Find and replace
- Commenting the highlighted text
Essbase script editors also support code completion. Press the Tab key to select from the suggested list.
The following table lists the commonly used shortcuts for both, Mac and Windows systems:
| Action | For Mac | For Windows |
|---|---|---|
| Go to line | Ctrl + G | Ctrl + G |
| Delete line | Shift + Command + K | Ctrl + Shift + K |
| Select all occurrences of current word | Command + F2 | Ctrl + F2 |
| Insert cursor | Opt + Click | Alt + Click |
| Insert cursor above | Opt + Command + ↑ | Ctrl + Alt + ↑ |
| Insert cursor below | Opt + Command + ↓ | Ctrl + Alt + ↓ |
| Undo | Command + Z | Ctrl + Z |
| Redo | Command + Shift + Z | Ctrl + Shift + Z |
| Fold region (Collapse) | Opt + Command + [ | Ctrl + Shift + [ |
| Unfold region (Expand) | Opt + Command + ] | Ctrl + Shift + ] |
| Find | Command + F | Ctrl + F |
| Replace | Opt + Command + F | Ctrl + H |
| Toggle line comment | Command + / | Ctrl + / |