Before using the templates described in this chapter, make sure to have the following data ready (ask your Administrator or Luware representative): 

Provided Templates

Stratus Agent comes with a series of evaluation templates which will be sent to you on demand / during the onboarding process . The available report files and their contents are as follows: 

Report ContentPower BI Filename

Agent Report

Stratus_Agent_Agent_<Version>.pbix

Service Report

Stratus_Agent_Service_<Version>.pbix

Forecast Report

LUCS_Forecast_<Version>_Transform.pbix


The characteristics of each template are explained on the Service Template Details page. Also read our Introduction to Stratus Reporting if you are unfamiliar with this program.

Also please note the following remarks on report versions:

  • With Stratus Agent we introduce Versioning to our reports. Existing report templates can be moved to the next versions of Stratus Agent without any adjustments as long as you keep the versioning-number with the report. To achieve this we specified stored procedures in our database, distinguished by product version. These versions correlate between product version and report version.
  • The templates provided from Stratus Agent will remain persistent for you to use with future versions although without any new functionality. We will still deliver updated templates with each new Stratus Agent update, but you can continue to use your templates as needed and update whenever you want.
    (warning) Any manipulation of "version" parameters in your old report (e.g. to reflect a new product version) may result in errors being thrown. To avoid this, we always recommend upgrading to the newest reporting template instead.

Template Setup Steps

The following steps are required to connect the templates to the data source. Further steps below explain how to configure Power BI to specific needs (language, timezone). 

Database Connection via Power BI

By default in the Power BI you will see default data in either the Service or the Agent template. To customize this to your data, perform the following steps.

Adjust Parameters

  1. On the "Home" Tab, click the the "Edit Queries" Icon
    → A new pop-in opens

    Power BI - Configuring parameters


    Note that Fact & Dimension entries marked with (warning) are protected and should not be changed.

  2. On the Top Left "Parameters" section you can change/adjust the parameters as needed:
    1. Language = target language for data labels (e.g. "month" is called (January (eng) ←→  Januar (deu))
    2. Timezone = timezone to which timestamps in the report data are adjusted towards.
    3. MonthLimit = how many months back the report will pull data from, including the current (ongoing) month
    4. ServerName = on which Server Stratus Agent is located
    5. (tick) You get this name (full URL) from your Luware representative / support engineer. 
    6. DatabaseName = on which DataBase Stratus Agent is deployed 
      (tick) This name is depending on your database created when Azure Reporting Data access.
    7. Version = correlates with Facts and Dimensions and therefore the calculation in the reporting. (warning) Manual adjustments of the version may lead to different / mismatching facts and dimensions being requested and thus errors in your templates. 
      (lightbulb) In general you can go with the initially provided version that comes with the report template.

Connect to Data Source & Grant Permissions

(tick) Precondition:  As the remote data source requires verification, a O365 account with corresponding permissions is required. (info) Read chapter Azure Reporting Data access for details. 

  1. On the "Home" Tab, click the the "Data Source Settings" Icon
    → A new window opens which contains the data source entry specified from <your Servername / Database> parameters in step 1.

  2. Right click your entry and select "Edit Permissions"

    Power BI - Data source settings and permissions

    → A SQL Server Database Window opens

  3. Within the "SQL Server Database" window, select Microsoft Account > "Sign In
    → An Office 365 Login Window appears to authorize the access

  4. Provide O365 credentials which have the reporting access permissions. (info) Read chapter Azure Reporting Data access for details. 
  5. Close all open Data Source windows. The connection should now be established.

Data Refresh

  1. On the "Home" Tab, click the the "Refresh Preview" Icon
    → The database connection should now be established. (lightbulb) You might be re-asked for credentials as O365 login sessions can expire.

  2. Confirm any PopUps stating that you are connecting to the Facts and Dimensions with "Run
  3. You should now see an updated set of data and can start using the tabs and filters to your liking
    (info) Check the Service Template Details page for further info.

Source Data Refresh

(lightbulb) A data refresh is handled by Luware. By default your local Azure Reporting DB should be automatically refreshed every 15 min.

Timezone Configuration

(lightbulb) These settings are optional and can be customized by you

To configure the timezone, change "@Offset" in Power BI Desktop:
  1. Home Tab  → Select "Edit Queries"

    In the left "Queries" section: 

  2. Select > ServiceTask > Advanced Editor
    → The Advanced editor opens

  3. Change the "@offset" value to your required value


Language Configuration

(lightbulb) These settings are optional and can be customized by you

To configure the language in Power BI Desktop:
  1. Go to the the Home Tab > "Transform Data"
  2. Select "Edit Parameters" 
  3. Change Language to your desired option.
    (question) Language Parameter not present?
    Check that you have the latest BI Template or contact your Luware BI Support.