Reports Configuration
Ensure all Apps have been deployed.
ONLY START VisiCommander-MB-Microservice Service
The following steps are to be done directly on a browser outside App Environment Operating System
- Navigate to the Report URL set during Phase 3
- Login to the Report Portal
If customer requests for credentials, they automatically sign the Waiver of receiving no further support from MathCraft related to the Reports - Go to Admin by clicking on Settings on the top right
- Navigate to General from the left navigation panel
- Ensure the Site URL is set to http://localhost:5443
- Ensure the Anonymous Tracking is set to Disabled
- Ensure the Friendly Table and Field Names is set to Disabled
- Ensure the Enable Nested Queries is set to Enabled
- Navigate to Updates from the left navigation panel
- Ensure the Check for Updates is set to Disabled
- Navigate to Public Sharing from the left navigation panel
- Ensure the Enable Public Sharing is set to Disabled
- Navigate to Embedding in Other Applications from the left navigation panel
- Click the Regenerate Key button
- Copy the Secret Key into a Notepad window as we will need this later
- Navigate to Caching from the left navigation panel
- Ensure the Enable Caching is set to Disabled
- Navigate to Databases from the top navigation panel
- Click on VC under Name to modify the settings
- Ensure the Database Type is set to SQL Server
- Ensure the Name is set to VC
- Enter the Host Name to match your SQL Server Name where ViSi Commander database is deployed
- Enter the Port Number to match your SQL Server Port Number where ViSi Commander database is deployed
- Ensure the Database is set to VISICMDR
- Ensure the Database Instance is empty
- Ensure the Username is set to vc_mb_user
- Reenter the Password
- Ensure the "Use a Secure Connection (SSL)" is set to Disabled
- Ensure the "Use an SSH-Tunnel for Database Connections" is set to Disabled
- Ensure the "Automatically Run Queries when doing simple Filtering and Summarizing" is set to Enabled
- Ensure the "This is a large Database, so let me choose when Metabase Syncs and Scans" is set to Enabled
- Click on Save Changes
- Click on Sync Database Schema Now
- Wait for 10 minutes and then click Re-Scan Field Values Now
- On the App Environment Operating System, navigate to the visicmdr\configuration directory from the Application Root
- Launch the common.properties in edit mode using Notepad or Notepad++ (Notepad++ recommended)
- Go to line 15 and modify the metabase.url parameter by replacing ReportServerParam with the URL set during Phase 3
metabase.url=https://ReportServerParam
- Enter the metabase.secretKey copied in step 15 above
metabase.secretKey=
- Save the common.properties file