Granting Query Security

To grant query security:

1. Select PeopleTools > Security > Query Security > Query Access Manager.

2. Open the tree QUERY_TREE_PT.

3. Add the following records under the OLAP - Cube Manager Record node:

   • PSCUBTTRANS

   • PSCUBTSELLER

   • PSCUBTREGION

   • PSCUBTPRODUCT

   • PSCUBTACCOUNT

   • PSCUBTTRANSD_VW

4. View the queries that were imported from the project.

   Note that:

   • Query CUBT_ACCOUNTS can be used to build a dimension structure.

   • Queries CUBT_TRANSACTIONS and CUBT_ALL_TRANSACTIONS can be used to populate the cube structure.

   • Query CUBT_TRANSDATES can be used to create a time dimension, and it displays all unique transaction dates from the transaction table.