...
- Test adding a new, expression-based column to a Physical Table (Hint: look at how the Total column under the Order Details physical table was built
- Try all supported expression types: SUM, SUBTRACT, MULTIPLY, DIVIDE
- Verify that the new column can be used in your Model and associated Business View
Configure Security
- Test configuring the Security Service (Tools|Security...)
- Validate that the Test button returns a list of users and roles from your Pentaho BI Server
- Apply security to one of the columns in a Business View Category such that a particular column is visible to some users and not others
- Verify that security is being respected using WAQR
- Test security inheritance by applying security to column in your business table, then validate that this is inherited by any category columns in your business view.
- Also test that inherited security is being respected in WAQR
Using Concept(s)
- Create new Concepts using the concept editor (Toolbar or Tools menu)
- Apply the concept to a Business Table Column
- Verify that it is inherited in any Category Columns that use this Business Table
- Verify that the Concept is respected when creating a report against the Business view in WAQR
- Apply a concept at the Category Column Level and perform the same validation
- Test inheritance within Concepts
- Create a 'base' concept with a set of properties
- Create a child concept of base and validate that it inherits the properties from base
- Apply the concepts to your business view and validate that the concepts are applied in WAQR
Using Locale(s)
- Add a new local using the local editor (Tools on the file menu or the Locales toolbar button)
- Localize names and descriptions in your model that are used by WAQR (i.e. Category Column Names, Category Names, Model Descriptions, etc.)
- Change the locale in your browser and validate that the model properly respects the local settings in WAQR
Using Query Editor
Publishing Models
...