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

My Head of Department cannot see Course and Class Marksheets

BySarah Hart

The following steps will need to be carried out/checked  In System Manager (Focus|System Manager) check that the Head of Department does not have two accounts. Please note, there are no System Manager defined permissions for Heads of Departments. These are all defined within the Courses. Add the Head of Department to the list of supervisors…

Backup Control Update

Byadmin

A fault was identified with the Scomis Backup Control utility which results in a SIMS .net database backup not functioning as expected.  The fault has been tracked to a database version name change as a result of the Capita SIMS upgrade. A update to Backup Control has been issued and is available for download using…

Troubleshooting KS5 16-18 Performance Tables Report

ByLiam Motevali

Students at End of KS5 Measure Detail All    % Male    % Female    % KS5 Cohort Information A levels Students at end of KS5 66 100.00 32 48.48 34 51.52 Number of A Level students at end of KS5 66 100.00 32 100.00 34 100.00 Number of A Level full time equivalent students…

Editing Academic structure

BySam Callard

If you need to make changes to an academic structure such as adding or removing a teacher training day you can do so by going through the following steps – Select Routines | School | Edit Academic Year to display the Create Academic Year wizard. You will not need to worry about defining the school…

EYFS- Key Stage- Changes to A code

ByHeidi Miller

The A code can no longer be used for EYFS pupil who are absent. The DFE has taken the decision that the EYFS profile must be completed in all instances unless: an exemption has been granted by the secretary of state for the setting or an individual child. In these cases only, an ‘A’ should be recorded for…