/
Unable to see Cashiering Cubes Tables
Unable to see Cashiering Cubes Tables
Description of Issue
Unable to see the Cashiering Cubes tables to be able to import data in Excel Analysis Services
Context
Tyler Cashiering
Cause
The Role Properties - Access for Cashiering Cubes doesn't have the correct settings
Resolution
- Connect to server where Cashiering was deployed
- Open SQL and for Server Type , choose Analysis Services
- Expand Databases > Expand the specific Cashiering environment database > Expand Roles > Right-click on Access > Select Properties
- Role Properties - Access window will open and then select Cubes page
- It should display the Cube Name, you will want the following settings:
- Access set to Read
- Local Cube/Drillthrough set to Drillthrough and Local
- Process checkbox checked
- Select OK
Additional Information