The Form Tab serves as a "relational" interface for querying and modifying transaction-level details, much like Excel’s query function, but with the ability to write back. It also displays the unique ID within the table.
Note
The Olation Form Feature is enabled on the basis of customer licensing.
If your Olation Studio installation does not include Form capabilities,
reach PARIS Technologies for further
information.
Column Description:
Pre-Work When Using the Form Feature
Before the Form feature can be used, an ID column must already exist in the source fact table from where the source Cube is created from.
To add an ID column to the source fact table:
1. Go to SQL Server Management Studio.
2. In the Object Explorer, expand the correct database (e.g., USING_OLATION) and then expand Tables.
3. Locate and right-click on the correct factdata table (e.g., dbo.Factdata).
4. Select Design from the options.
5. In the tab that opens on the right, right-click on a dimension and select Insert Column from the options.
6. In the vacant field under Column Name, enter "ID".
7. Under Data Type, enter "int".
8. Uncheck Allow Nulls.
9. Click to select the new ID column, and under the Column Properties (bottom pane), go to Identity Specification and adjust the settings as follows:
10. Double-click on "No" along (Is Identity) to toggle to Yes. The related fields will then be automatically populated.
11. Save the changes.
12. If you right-click on dbo.Factdata and Select Top 1000 Rows from the options, you will now see an ID column.
13. Go to Olation Studio, right-click on the correct Cube, and select Reload Cube from the options.
14. Open the Cube Definition window by double-clicking on the particular Cube in the Database Explorer.
15. In the Settings tab, set all Form options in the Form section to True.
Note
To reiterate, Form is a licensed
feature, so the Form section will only appear in the Cube Settings
tab if your license includes access to it.
