×
Siemens Industry Online Support
Siemens AG
Entry type: FAQ Entry ID: 105903240, Entry date: 12/08/2014
(1)
Rate

How do you create SIMATIC powerrate reports on a PC without WinCC being installed?

  • Entry
  • Associated product(s)

Description
Since it cannot always be ensured that a WinCC station (WinCC PC) is available for use by the company's energy officer, a means must be provided to create SIMATIC powerrate energy reports on a non-WinCC computer (Office PC).
This FAQ response only describes the settings required for the PCs of the "SIMATIC powerrate Report Tool" used for this.

Installation requirements
WinCC PC

  • Windows XP or Windows 7 Enterprise (32-bit)
  • WinCC V 7.x
  • powerrate 4.x

Office PC

  • Windows XP or Windows 7 Professional (64-bit)
  • Excel (2003/2007/2010)
  • WinCC Connectivity Client Pack
  • powerrate Reports 4.x
  • Automation License Manager
  • OPC Core Component

Note
If an "Error in getSQLData()" occurs in the reporting tool, check the installation of the "WinCC Connectivity Client Pack". CAC components might be missing (CCWinCCOLEDBProvider.dll) or not registered (CCTagCompressionPlugIn.dll, TABCTL.OCX).

Instructions
There are basically two different scenarios as described below.

Description for one workgroup

Settings for the WinCC PC
 

Firewall No special settings required
User rights Any user
Member of the groups Administrators, SIMATIC HMI, SIMATIC HMI Viewer (default settings)
Computer name Any, member of workgroup XYZ
DCOM settings Windows 7:   
No changes required

Windows XP:
see SIMATIC.NET documentation in Entry ID 77377601:

  • Section 4.7.4
    Accept all the settings for the SimaticNET
  • Section 4.7.5
    Settings for the server (OPCServer.WinCC):
    - in the Security tab set all three permissions to Customize
    - Add SIMATIC HMI group everywhere

Settings for the Office PC
 

Firewall Disable the firewall or enter the exception rule "Outgoing TCP and UDP", all ports, "PRE_Reports.exe" program or click "Confirm exception" when the Reporting Tool starts up for the first time and attempts to connect.
User rights Same user and password required as for the WinCC PC.
Member of the groups SIMATIC HMI, SIMATIC HMI Viewer
Computer name Any, member of workgroup XYZ
DCOM settings Windows 7:   
Network identification enabled, see SIMATIC.NET documentation in Entry ID 77377601. Section 4.7.1

Windows XP:
No change necessary

Description for one domain

Note

  • All the necessary installations must have been completed before inserting the user/computer in the domain.
  • All the settings described under "Description for one workgroup" must also be made in the domain.
    Below we describe the additional steps to be taken for operating PCs in a domain.
  1. Press the key combination <Windows> + <R> to open the "Run" dialog and there you enter "mmc". In the now open Microsoft Management Console you create "siemens" as Active Directory User in the domain.

    Note
    More information about the Microsoft Management Console and the required snap-in is available at the these links:

        Active Directory Management via MMC
        Installation of the Active Directory Schema snap-in

       
        Fig. 01

  1. On the Office PC you press the key combination <Windows> + <R> to open the "Run" dialog and there you enter "compmgmt.msc".
    Open the Properties dialog of the Group Policies for Administrators via this path: "Computer Administration > System > Local Users and Groups > Groups > Administrators".
    Include the Active Directory User "siemens" as member of the Administrator group of the Office PC.


    Fig. 02
     
  2. Open the Properties dialog of the Group Policies for Users via this path: "Computer Administration > System > Local Users and Groups > Groups > Users".
    Include the Active Directory User "siemens" as member of the User group of the Office PC.


    Fig. 03
  3. On the Office PC you open the Properties window of the "Siemens" folder in this path: "Computer > SYSTEM C: > Programs (x86)".
    Then, in the "Security" tab you use the "Edit" button to open the "Permissions for "Siemens"" window.
    Select the user "siemens" and enable "Full Control" with the "Permit" check box.
    Close the windows each with the "OK" button.


    Fig. 04
     
  4. Include the Active Directory User "siemens" as member of the following groups as described in Steps 2 and 3:
  • Administrator group
  • User group
  • SIMATIC HMI Group
  • SIMATIC HMI VIEWER
  1. On the WinCC PC you enable for the Active Directory User "siemens" Full Control for the WinCC project folder as described in Step 4.

Creation Environment
The screens in this FAQ response were created with Microsoft Windows 7.

Security Notes
Siemens offers products and solutions with industrial security functions which support the secure operation of plants, solutions, machines, devices and/or networks. They are important components in a comprehensive industrial security concept. The Siemens products and solutions continue to be developed under this aspect. Siemens recommends that you keep yourself regularly informed about product updates.
For the safe operation of Siemens products and solutions it is necessary to take appropriate security measures (cell protection concept, for example) and to integrate each component in an overall industrial security concept which is state of the art. This should also cover the third-party products used. Additional information about industrial security is available at:
http://www.siemens.com/industrialsecurity.
In order to keep yourself informed about product updates, we recommend subscribing to our product-specific newsletter. Additional information about this is available at
http://support.automation.siemens.com.

Additional Keywords
Energy management, Energy data management

Security information
In order to protect technical infrastructures, systems, machines and networks against cyber threats, it is necessary to implement – and continuously maintain – a holistic, state-of-the-art IT security concept. Siemens’ products and solutions constitute one element of such a concept. For more information about cyber security, please visit
http://www.siemens.com/industrialsecurity.