NRS - FAQs

Printer-friendly version
NRS eReporting - FAQs

FAQs

This list of FAQs has been compiled to assist you with NRS eReports questions or difficulties. This list will continue to grow as we receive queries. As such, we welcome your feedback and additional questions at nrs@cihi.ca or via eQuery.


Q: When I hit the "Back" button on my browser, I get the message "Webpage has expired".

A: Once you have run a report in NRS eReports, clicking the "Back" arrow on your internet browser may cause this error. Click on the refresh icon at the top right of your screen, and click "Retry" when prompted. To avoid this problem, use the navigation links in the navigation toolbar ("trail-of-breadcrumbs") located at the top of the screen, underneath the CIHI logo and search box, to go back to the previous folder instead of using the Back button. Note that version 9 of MicroStrategy (implemented in Dec. 2009) contains a Back button that will permit you to return to the previous page without causing this error.


Q: I'm trying to export a report, but nothing is showing up.

A: Check the top of your screen for an error message. For security reasons, the download of the exported report may have been automatically blocked by your computer. To download the report, click on the message at the top of the screen and select "Download File". A File Download window will pop up, asking you to Open, Save or Cancel the operation.


Q: I don't currently have access to the NRS eReports, but feel that I should have access. How do I go about getting access?

A: If you feel that you should have access to the NRS eReports for the purposes of your job, have your facility coordinator contact us indicating that you should have access. At that point, we will add you to our list of designated users and will send an access code to you via your facility coordinator. Once you apply this access code within Client Services, we will begin a process to generate a username and password for you. When we send these to you, you will then be able to access the NRS eReports system.


Q: When I try to access the NRS eReports, I get an error message that says:
"An error has occurred on this page. Your request could not be processed. Please try again. If the problem persists, contact the Administrator. The History List for this Intelligence Server is full. To run a report, you must delete one or more messages from the History List on one of the projects running on this server."
What does this mean and how do I fix it?

A: This error occurs if you have access to more than one project in MicroStrategy (e.g., CCRS, Portal, and NRS). This message indicates that your NRS eReports History List is empty but that your collective History List (sum of all projects) is full (each person's History List permits a maximum of 50 reports across all projects). You need to go into one of your other projects where you have history list messages and delete some in order to free up some space for the NRS eReports project. This will then permit you to get into the NRS eReports environment. Once you have something added to your NRS eReports History List, you should no longer ever get this message.


Q: How often is the NRS eReports database updated?

A: Data is updated every quarter, approximately 2-3 weeks following the error correction deadline. Data for the current fiscal year will update accordingly, as will data for previous years, depending on the amount of "historical data" submitted in the most recent quarter.


Q: What is the difference between the "Length of Stay" indicator and the "Case Mix: Length of Stay" indicator? How do these compare to "Active Rehab Length of Stay" and "Patient Days, Count of Days"?

A: Length of Stay (LOS) appears in several reports. It excludes Service Interruption days and is calculated as follows:
         (Discharge Date - Admission Date) - (Service Interruption Days)

Case Mix, Length of Stay only appears in Case Mix reports and is calculated to include Service Interruption Days and Days Waiting for Discharge, as follows:
         (Discharge Date - Admission Date)

Active Rehab Length of Stay is the same as Length of Stay (LOS), except it also excludes Days Waiting for Discharge, as follows:
         (Discharge Date - Admission Date) - (Service Interruption Days) - (Days Waiting for Discharge)
More simply, it can be calculated as:
         (Date Ready for Discharge - Admission Date) - (Service Interruption Days)

Patient Days, Count of Days indicates the number of days that a client was in the rehabilitation bed in that particular reporting period (fiscal year or quarter), and includes days for both complete (i.e., those that have a discharge date during the reporting period) and incomplete (i.e., those that are still open at the end of the reporting period) episodes.
(Consult the NRS eReports Manual: User Guide and Report Interpretation Guidelines for more details about calculating this metric.)


Q: How do the new Patient Days eReports differ from the previous PDF Patient Days reports?

A: The eReport that provides Patient Days for the complete year uses the following methodology. Patients admitted and discharged within the selected fiscal year have their patient days calculated as the difference between the discharge date and the admission date. Patients admitted in the selected fiscal year and not discharged in the same fiscal year have their patient days calculated as the difference between the end of the selected fiscal year and the admission date. Patients admitted in a fiscal year prior to the selected fiscal year and discharged in the selected fiscal year have their patient days calculated as the difference between the start of the selected fiscal year and the discharge date. Patients admitted prior to the selected fiscal year and not discharged in the selected fiscal year have their patient days calculated as the difference between the end of the selected fiscal year and the beginning of the selected fiscal year.


Q: Why is the number of clients included in some RPGs different between the old PDF reports and the new eReports?

A: Based on the province's RPG methodology, an RPG should only be classified if admission motor function score and admission cognitive function score are calculated. Previously, an RPG like "3000 - Ventilator Dependent Respiratory Disorders", for example, was classified as long as the RCG was 17.51, regardless of whether admission cognitive and motor function scores were calculated. This has been changed in the new reports so that complete function scores are taken into account.


Q: When I print a report, it does not identify the time period (i.e., fiscal years). How can I make my report print with a time period showing?

A: There are a few different ways to print your report in such a way that the time period is displayed. When you click on the Print option, a Print window will appear. Here, you can click on the check box labeled "Print cover page with filter details", which will print the report details on a separate page. To include such details in the header or footer of the printed page, click on the "Edit Custom Settings" button, put your cursor in the header or footer box to which you want to add report details, and then click on one or more of the icons at the top of the screen to insert report name, filter details, page-by information, etc. (Placing your mouse over top of each icon will display the function of each icon.) Another method would be to Export the report as an Excel document, with the "Export filter details" box checked and print it from within Excel.


Q: When drilling, how do I drill for only one value under a data element? For example, if I was looking at Comparative Reports > Admission Profile > 3. Admission by Admission Class and my grid currently showed all fiscal years, but I only wanted to drill to fiscal quarters for 1 fiscal year. How would I do this?

A: In order to show only the quarters for one fiscal year, you would right-click on the fiscal year of interest and then select "Drill" and then select "Admission Fiscal Quarter". If, however you wanted to drill down into fiscal quarters for all of the available years, then you would right-click on the "Admission Fiscal Year" column header, select "Drill" and then select "Admission Fiscal Quarter".


Q: Can I drill up from fiscal quarter to fiscal year again?

A: Yes, you would follow the same process that you used to drill down in order to drill back up. For example, you could right-click on Admission Fiscal Quarter, select "Drill" and then select "Admission Fiscal Year".


Q: I created a report that showed several years of data. I then drilled down to the level of fiscal quarter for one specific year only. Now, when I drill back up to the level of fiscal year again, my report only contains that one particular year. Where are all of the other years that were originally showing in my report?

A: When you drill into a report, the NRS database is re-queried and a new report is created. If you only drilled into one particular year, rather than all years that were showing, the report is recreated with only that year's data, and the years that were previously showing are removed entirely. If you want to go back to your original report, try clicking on the "Back" button on your web browser. If this doesn't work, then you will have to re-create the report, using either the "Re-run report" or "Refresh" options from the "Data" pull-down menu.


Q: How do I move an attribute to the Page-by axis in order to filter my data?

A: Right-click on the attribute of interest and then select "Move", and then click "To Page-by Axis".


Q: How do I move an attribute from the Page by Axis back into my grid?

A: You could left-click on the attribute of interest and then drag it and drop it back into the grid or you could right-click on the attribute, select "Move", and either select "To Columns" or "To Rows", depending on where you would like to see the attribute in your grid.


Q: I have created a grid report and would like to create a graph using the data from this grid, but would only like to see certain data elements from the grid in the graph. How would I do this? For example, how could I graph percentages only and not count ("N") values? Or, how could I graph my report without the "Peer" results showing in the graph?

A: You can remove undesired elements from your report by right-clicking the element and then selecting "Remove from Grid". This will remove an entire attribute or metric, however, rather than specific "levels" of an attribute. That is, you cannot delete the "Peer" data from the "Facility Level" attribute, for example; you can only delete the entire attribute itself (which, in this case, will make your report quite useless). This method will work nicely for removing the count ("N") metric values from your report. But if you want to view a specific "level" of an attribute, you should move the attribute in question to the Page-by axis. In your example, you would right-click on the "Facility Level" header, select "Move", and then select "To Page-by Axis" (or click-and-drag "Facility Level" to the Page-by axis). Once this attribute is in the Page-by axis, you can select the "level" that you are interested in seeing and subsequently graphing.


Q: Is there an easier way to view all the fiscal years at the same time when looking at my grid, instead if having to use the drop-down menu in the Page-by axis?

A: Yes. Simply click and drag the Fiscal Year from the Page-by area into your grid and the grid will automatically be updated showing all the fiscal years at once. Alternatively, right-click on Fiscal Year in the Page-by axis, select "Move", and then select either "To Rows" or "To Columns".


Q: Will the eReports work with Internet Explorer v.8?

A: Currently, MicroStrategy does not certify Internet Explorer 8 browser (IE8). The reason behind this is due to the backend changes implemented in Internet Explorer 8 that are not directly compatible with the current version of MicroStrategy.

There is, however, a feature within Internet Explorer 8 called "compatibility view" which will allow any content in Internet Explorer 8 to be viewed as if it were running Internet Explorer 7. MicroStrategy Web should run fine under compatibility view mode in Internet Explorer 8.

There are several ways you can enable the compatibility view in Internet Explorer 8 and even predetermine which sites to be viewed in this mode exclusively.

You can find the quick button next to the address bar:


You can also view it via the Tool menu bar where you can activate/deactivate as well as change the settings with the "Compatibility view settings" option.


For more information on how "compatibility view" mode in Internet Explorer 8 works, there is the Microsoft IE8 features site:
http://www.microsoft.com/windows/internet-explorer/features/easier.aspx?tab=1

... as well as a how-to video:
http://www.microsoft.com/windows/internet-explorer/videos.aspx?mname=howto_compatibility

Any reported issues with MicroStrategy Web running under Internet Explorer 8 - compatibility view mode will be supported if the issue can be also reproduced when running on Internet Explorer 7.


Q: Is there a way, when I drill into an attribute, to keep the high-level headings while also showing the lower-level, more granular, headings? For example, when I drill to "RCG Subgroup", is there a way to keep the "RCG" column showing as well?

A: Yes. Select "Drill..." from the "Data" menu at the top of your Analytical Report. This will add a Drill section to the top of your report. This section provides a "Keep parent while drilling" checkbox. When checked, this box will permit you to see not only the more granular level of detail that you are drilling to, but will also keep the "higher" level that you are drilling from. This might help when drilling from "RCG" to "RCG Subgroup", as you've stated, but could also permit you drill on a "Facility Province" column while at the same time seeing "Facility Region" and/or "Facility" column.


Q: In one of my reports, I get a value of "-0.00". Why does this happen?

A: The reason for this odd-looking value is that it is being rounded to, in this case, two decimal places. The actual value, were you to increase the number of visible decimal places, would show as a very small negative number. If you would like to see this value, you can change the number of visible decimal places by right-clicking on the metric header and selecting "Advanced Formatting", clicking on the "Number" tab, and then selecting the number of decimal places you would like to see.

Use CIHI's accessibility request form to request CIHI documentation in an accessible format.