Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

...

  1. 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
  2. Try all supported expression types:  SUM, SUBTRACT, MULTIPLY, DIVIDE
  3. Verify that the new column can be used in your Model and associated Business View

Configure Security

  1. Test configuring the Security Service (Tools|Security...)
  2. Validate that the Test button returns a list of users and roles from your Pentaho BI Server
  3. 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
  4. 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

Using Concept(s)

  1. Create new Concepts using the concept editor (Toolbar or Tools menu)
  2. 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
  3. Apply a concept at the Category Column Level and perform the same validation
  4. 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

Using Locale(s) 

  1. Add a new local using the local editor (Tools on the file menu or the Locales toolbar button)
  2. Localize names and descriptions in your model that are used by WAQR (i.e. Category Column Names, Category Names, Model Descriptions, etc.)
  3. Change the locale in your browser and validate that the model properly respects the local settings in WAQR

Using Query Editor

  1. After creating a model including a business view, use the Query Editor to query the business view
  2. 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

Publishing Models

  1. 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
  2. Verify that you can query the published model using WAQR
  3. Test modifying and republishing the model and verify that the changes have been applied using WAQR

Importing/Exporting Domain Files 

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