Unable to see Cashiering Cubes Tables

Unable to see the Cashiering Cubes tables to be able to import data in Excel Analysis Services

Tyler Cashiering

The Role Properties - Access for Cashiering Cubes doesn't have the correct settings

• 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