Granting Query Security
To grant query security:
Select
Open the tree QUERY_TREE_PT.
Add the following records under the OLAP - Cube Manager Record node:
PSCUBTTRANS
PSCUBTSELLER
PSCUBTREGION
PSCUBTPRODUCT
PSCUBTACCOUNT
PSCUBTTRANSD_VW
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.