Creating Domains

Test Case:

Extra Credit:

Verify warnings when changes to existing domain have not been saved when you choose to create a new Domain File

Creating Connection(s)

Test Case:

Extra Credit:

Add/remove Tables
1. Drag and Drop from Physical Tables in tree
  1. within tree
  2. onto workspace
2. Verify all columns are included
3. Right-click add - test in tree and on the workspace
Add/remove Columns
1. All columns should be added when dragging a Physical table onto the workspace or onto a mode in the tree
2. Add/remove column inside the Business Tables Properties dialog
Create relationships
1. Multi-select two tables in the Graphical View tab, right-click and select Add relationship
2. Right-click on 'Relationships' in tree to add a new relationship
3. Verify the 'Guess Matching Fields' button - should automatically define join fields if it finds matching field names in the two selected tables
4. Extra Credit - test defining complex join

Adding Categories using the tree
1. right-click to add category
2. add columns from Business Tables using drag and drop
Use Category Editor to build new categories
1. Add/Delete Categories
2. Single and multi-select to add columns to specific categories
3. Adding a Business Tables and included columns by selecting table and arrowing it over
4. Delete columns

Test applying standard properties
1. Apply properties to physical tables/columns, business tables/columns, business view categories/columns
2. Validate that properties are being picked up by Web-based Ad Hoc Query and Reporting
Test property inheritance
1. Define properties on the Physical Tables/Columns, validate that these chain down to the Business tables/columns and Business View categoriess/columns
2. Define properties on the Business Tables/Columns, validate that these chain down to the Business View categories/columns
3. Test overriding inherited properties in the Business Tables/Columns and Business View categories/columns
Create Custom Properties

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

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
1. 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.
1. Also test that inherited security is being respected in WAQR

Create new Concepts using the concept editor (Toolbar or Tools menu)
Apply the concept to a Business Table Column
1. Verify that it is inherited in any Category Columns that use this Business Table
2. 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
1. Create a 'base' concept with a set of properties
2. Create a child concept of base and validate that it inherits the properties from base
3. Apply the concepts to your business view and validate that the concepts are applied in WAQR

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

After creating a model including a business view, use the Query Editor to query the business view
New, Save, and Open
1. Test saving saving a query (saved in MQL format)
2. Create a new Query
3. Open the query created in step one and verify that it still works

After defining your Metadata domain (including Connection, Model(s), and Business View), test publishing the model to the Pentaho Server (File menu)
1. User/Password are your Pentaho username and password - i.e. joe/password
2. Publish password is the publishing password defined in ..\pentaho-demo\pentaho-solutions\system\publisher_config.xml
3. Server URL - i.e. http://localhost:8080/pentaho
4. Solution - i.e. /samples/analysis
Verify that you can query the published model using WAQR
Test modifying and republishing the model and verify that the changes have been applied using WAQR

Export a model to XMI
Import the model providing it with a new name
Validate that the model can still be modified and queried using the Query Editor