Syncing Power BI with hosted SIMS

If you are a hosted school and wish to use Power BI you will need to install a external connector on the same machine as the Power BI software. Please see more information on how to request an external connector here https://faq.scomis.org/kb12448/

When setting up the Excel Command Reporter utility, you must create a new SIMS user specific to the purpose, with the following permissions – Assessment Co-Ordinator, Personnel Officer, School Administrator, Senior Management Team, System Manager and Third Party Reporting.  Do not try to use your hosted credentials in the utility as they will not work.

When setting up the Excel Command Reporter utility, the name of the server and the name of the SIMS database will need to be entered; these details can be found in the connect.ini file, or, failing that, can be provided by the Scomis service desk.

The location of Command Reporter.exe and where to save the outputs of the reports will depend on the set up of the third party connector machine and the shared drives available.

 

 

 

 

How useful was this article?

Click on a star to rate it!

Average rating / 5. Vote count:

No votes so far! Be the first to rate this post.

Similar Posts

How to connect to an iPad to a Wireless Network

Byadmin

How to connect to an iPad to a Wi-Fi or Wireless Network   To connect your iPad to a wireless network : 1) Start the iPad. 2) Tap on the Settings icon… 3) Once in the settings application, you will be in the screen shown below, tap on the Wi-Fi category to get to the screen…

Homepage Group Configuration

ByViv

Homepage Groups enable schools to set a standard Homepage Configuration for staff groups. Only those with a role of Employee in SIMS can be added to a home page group. Go to Routines | Homepage | Homepage Group Configuration Clicking Search will display the embedded groups : Use the embedded groups by clicking on them…

Exams – Making Amendments

ByVerity.Ridge

Once an entries submission has been made, changes to these entries may need to be made. Changes to entries can be made in Examinations Organiser and then an amendment file can be created and sent to the exam board. Focus > Candidates > Internal > Select the Student On the Internal Candidate Details screen, select tab…

Summer 2024 – School Census Bulletin

BySarah Purnell

This FAQ lists the latest information regarding the School Census. It contains information on the latest filesets, patches and errors. To jump to the latest SIMS Census documentation and FAQ’s Click here. For Schools wanting the latest documentation for Census and using Arbor or Bromcom  Click here  to jump to the relevant section. Register for…

Locking and Unlocking Examinations Organiser Marksheets.

ByVerity.Ridge

Marksheets created in Examinations Organiser can be made read-only, enabling their data to still be viewed while preventing them from being edited. This would be particularly useful when working with entry marksheets, where the submission file has been sent to the examination board and you do not want any changes to be made to the…

Individual Report – Section with no results still showing the header.

Byjanet.demaine

The hide rows with no results is ticked. Remove report sections that contain no results is ticked. The report shows the header for a table with no results.   Please ensure that the section open and section closed tags are inserted at the beginning and end of each table, including the first table on the report….