Page History

...

When is Reports Server Needed?

1. A report reports server is needed when it is necessary to divide reports and references info into separate tasks.
2. A report reports server is required to generate reports (with prior re-calculation recalculation of cubes) and to view them in the manager station (the license is needed, connection to the internal SQL database is set up);

...

Reports server licensing procedure is identical to references server licensing procedure described in the article on the References server.

Briefly, the procedure is as follows:

• Open Settings Options - OLAP reports - Report Reporting servers reference; reference
• Select the server;

...

...

• Disconnect an external DB if there is a connection (Connection to external DB settings -> External Data Base Link — empty, Cubes data source - switch to re-calculation with file: DB UDB Source Type — switch to recalculation via disk file: UDB database (exchange via file);
• Save ;the changes
• Select the protection key in License Info - Protection key - Physical number field;in the License Information — Protection Key Actual Number field
• Generate license request (: right-click on report the reports server icon -> — Actions -> Generate license request);— Generate License Request
• Generate license for this request at l.ucs.ru siteon the licensing system site, and enter specify it to "License info -> License key" field;
• Save
• in the License Information — License Key field
• Save the chamges
• Configure the connection to an Configure connection to external DB if cube-based reports are required.

Launch

Launch report the reports server as follows:

• • Create a server in the manager station in
"Settings -
• • Options — OLAP reports
- Report
• • — Reporting servers
"
• • , assign a unique network ID to it,
e
• • f.
g
• • ex., REPSRV3001, change the status to Active, and save
;
• • the changes
  • License the server (see paragraph above); Otherwise, the connection
from
• • via the manager station will not be possible
;
• • In
"
• • the Synchronization
"
• • section,
make sure all checks re set
• • check all the boxes. Synchronization
should
• • must be turned on.
  • Create
clean
• • an empty base in Management Studio. Configure the connection to this DB using
instruction
• • instructions in the article on connection to MS SQL.

Specify the following parameters in repserv.ini, in the [Config] section:

Client = "REPSRV3001" ;

...

 reports server

...

 network IDRefServer = "RK7SRV3001" ; upper level server network ID (it can be both

...

 references server and

...

 reports server)

...

RefsBasePath = ".\BaseData\refsdata.udb" ; relative or absolute (recommended) path to

...

 reference DBCheckBasePath = ".\BaseData\check_db.udb" ; relative or absolute (recommended) path to

...

 receipt (cumulative)

...

 DBWorkModsFile = ".\BaseData\wmodules.udb" ; relative or absolute (recommended) path to working

...

 modules DBReceivedPath = ".\Received\" ; relative or absolute (recommended) path to

...

 directory with received

...

 closed shiftsErrorLog = "repsserv.stk" ; relative or absolute (recommended) path to

...

 log fileUseSql = 0 ; do not connect to external DB under SQL Server 2012 control

• Launch the server.
• Stop the server, change UseSql=1 parameter value in repserv.ini config file
• Launch the server.

Important: the The first launch should always be performed as an application (with the /desktop parameter). Also, make sure to perform the launch as administrator.

...

...

...

...

...

As well as references server, report reports server can be launched as a service. For this purpose, use the /install parameter.

Upon server lunch as a service (rkReportsServer.exe/desktop) the following icon will appear in the task bartray:Image Added

Repsserv.ini

...

Attention!

...

File Description

Before launching the reports server, uncheck the Read only box in its parent folder attributes (otherwise,

...

the reports server will not be able to create its database).

...

Also, make sure the full path to the folder with the RKREPORTSSERVER.EXE file contains no spaces, and the total number of path symbols does not exceed 200.

Copy Copy the repserv.ini file from  file from the RK7/BIN/WIN/ini folder folder if you have not done so yetthis before, and place it besides beside the RKREPORTSSERVER.EXE file file, i. e., into the RK7/BIN/WIN/ folder.

[CONFIG]

...

Client = "REPSRV3001" ;;

...

 the reports server network name, same as

...

 the corresponding reports server in the management station. See Manager station settings belowRefServer = "RK7SRV_3001" ;; the references server network name (or

...

 the upper reports server)

...

RefsBasePath = ".\BaseData\refsdata.udb" ;; a full path to

...

 the references base, do not confuse with rk7.

...

udbCheckBasePath = ".\BaseData\check_db.udb" ;; a full path to

...

 the receipt base, do not confuse with check.

...

udbWorkModsFile = ".\BaseData\wmodules.udb" ;; a full path to the working

...

 modules baseReceivedPath = ".\Received\" ;; a path to

...

 the data receiving folderErrorLog = "repsserv.stk" ;; a log file name (add the path if necessary). By default, the log file is saved in the same folder where RKREPORTSSERVER.

...

ErrorLogSize = 1048576 ;; error log size in bytes

OldRefsSyncMode = 0 ;; 1 - enable old synchronization mode necessary if PollEvents=1

PollEvents = 0 ;; enable periodic references server polling mode (in references server .ini file, fill EventCachePath= parameter), and set OldRefsSyncMode=1

RecalcAllCubesAt = 2015 ;; Time is specified without semicolon in "HHMM" format. Re-calculate all cubes that would be re-calculated by "re-calculate all cubes" item at manager station in 20:15. For versions 7.4.20.60 or higher.

CubesRecalc = 0 ;; disable cubes re-calculation, 1- enable cubes re-calculation, 2 - manual cubes re-calculation (For versions7.6.1.2 or higher!)

...

exe is placedErrorLogSize = 1048576 ;; an error log size in bytesOldRefsSyncMode = 0 ;; 1 - enable old synchronization mode, necessary if PollEvents=1PollEvents = 0 ;; enable periodic references server polling mode (in the references server .ini file, fill EventCachePath= parameter), and set OldRefsSyncMode=1RecalcAllCubesAt = 2015 ;; Time is specified without semicolon in HHMM format. Recalculate all cubes that would be recalculated by "recalculate all cubes" item at the manager station at 20:15. For versions 7.4.20.60 or higher.CubesRecalc = 0 ;; disable cubes recalculation, 1- enable cubes recalculation, 2 - only manual cubes recalculation (For versions7.6.1.2 or higher!)NoReports = 0 ;; disabling menu with manager station reports (For versions 7.6.1.2 or higher!)

...

ServPingTimeout = 5000 ;; 7.4.17.78 or

...

UseSql = 1 ;; 0 - if no connection to SQL, 1 - if connection to SQL is used

...

 higherUseSql = 1 ;; 0 - if there is no connection to SQL, 1 - if connection to SQL is usedLoadThreadsCount = 4 ;; load closed shifts data to the cumulative DB simultaneously, "4" - a number of files processed simultaneously (recommended in case of the big number of shift files being received simultaneously). Version shall be higher than 7.5.2.328!

...

cubesBuildTool = "bldcubex.exe" ;; Enable bldcubex.exe utility for cubes generation at PC with 2+ GB memory (For versions7.6.2 or higher!)

...

[NETKERN]

...

Protocols = tcpsoc.dll ;; protocols list (comma separated),

...

 make sure these DLL files are placed in the folder with the RKREPORTSSERVER.

...

exe file[TCPSOC]

...

PORT=

...

3639 ;; a port for the server

...

[TCPDNS]

...

RK7SRV_3001=subway.rkeeper.com:3648

...

;;REP_CENTR4=subway.rkeeper.com:3644

...

;;RK7SRV=subway.rkeeper.com:3639

...

[UPDATE]

...

NoUpdate=0

...

; scheduler. only for 7.5.2.502+

...

[SYNCCONF]

...

; Enable scheduled

...

 synchronizationRefsSyncMode=1

...

; synchronization time

...

 in CRON format 50 10 * * * is equivalent to "always at 10:50",

...

 45 13 * * * is equivalent to "always

...

 at 13:45".

...

Format is as follows:

...

* * * * *

...

| | | | |

...

| | | | +----- Days of week (range: 1-7)

...

| | | +------- Months (range: 1-12)

...

| | +--------- Days of month (range: 1-31)

...

| +----------- Hours (range: 0-23)

...

+------------- Minutes (range: 0-59)

...

SyncSchedule=50 10 * * * ; synchronize references at

...

 reports server loadingSyncOnReload=0

...

Reports Server Update

Right-click the icon to open report the reports server in a browser. Default Http HTTP port can be assigned set in the manager station by specifying a new port in report reports server properties (HTTP Server group -> HTTP Data Port group).

Upon report After the reports server launch, check its connection to the upper server.

Report The reports server update is identical to to the references server update.

Важно: Report server restart after update is mandatory.

...

Manager Station Connection to Reports Server

Use the following methods ways to connect the manager station to report the reports server:

1. Create a separate instance of the manager station with a new ini INI file and specify report the reports server network ID in the [REFEDIT] section therein.
   
   
   • Server= REPSRV3001 ;; Your

...

1. • reports server name
   • Client=MANST-%RANDOM% ;; the name of the manager station that will be connected to

...

1. • the reports server
     
     Therefore, there will be

...

1. • two icons for RK7MAN.exe on the desktop - one for connection to

...

1. • the reports server and references editing, another for connection to

...

1. • the reports server and reports viewing.
     
     
2. Launch the manager station again, leaving ini the INI file unchanged. When the logging window appears, press "Ctrl+Alt+S" on the keyboard and enter report the reports server ID in the poll that appears in the bottom left corner.

Manager The manager station will make necessary modifications in rk7man.ini, and you will have to select the server by pressing "Ctrl+Alt+S" at the next launch.

Cubes

...

Recalculation

Cubes are in Settings - placed in the Options — OLAP reports - — Cubes and reports referenceReports reference.

The status of a Status of cube and its data thereof can be checked in the cube properties, "Data processing" Processing section. Each cube has a list of report reports servers and cube re-calculation recalculation info (periodperiodicity, calculation time, last error, etc.).

You can re-calculate cube of interest recalculate a required cube manually (right-click - actions - re-calculate> Actions -> Recalculate).

Starting from version 7.06.04.041: if a server has over 2 GB of RAM, you can use a new utility for cubes construction – generation – bldcubex.exe. To do sothis, add the following settings to to repserv.ini::

[CONFIG]

...

cubesBuildTool = "bldcubex.exe"

and restart report the reports server. Then, you will have new a new rk7manex.exe manager station file. Use it for cube report generation.

It is desirable to create a new user (role) with "cubes and reports only" rights and hide all other elements in the manager station for this user (role). Then, create an icon for such a manager station with a name like "Reports".

Starting from version 7.4.20.60 or higher, all  all cubes that , that would be re-calculated recalculated by the "re-calculate recalculate all cubes" menu items item at the manager station,   can be re-calculated recalculated automatically at the specified time  by entering by inserting the following command in the INI file:

RecalcAllCubesAt = "2015" (Time is specified without semicolon "HHMM") 
The value is easy to check via the web interface.

Setup of

...

Reports Servers for Restaurant Chain

1. Example of report reports servers connection in chain restaurants

Big distribution networks restaurants chains (like SUBWAY, BURGERKINGBURGER KING) use quite extensive chains nets consisting of multilevel connection trees or report of reports servers with a central report reports server (numbering in hundreds sometimes). Since the data (meals, prices, composition) is the same within one chain, it is enough to make modifications in the manager station working with the upper-level server (references server), and the data synchronizes automatically with lower-level servers (intermediate), and then with local servers (in a restaurant).

...

Connection of report reports server to an external DB is required if reports generation and viewing is needed when the manager station is connected to this report reports server.Connection diagram is shown in the figure below.

Find the connection diagram below:

In this case, the servers that will be used to view reports and process data, are subject to licensing. No. The quantity of stations is means the number of different users that can generate reports at the same time.

...

...

...

Configuration example for the network of 2 restaurants and

...

a head office

...

Image Added

How it works:

Upon After the common shift closure being closed at POS the cash server 1 (midserver1) of restaurant #1, the shift data is processed at report the reports server 1 and report server at "the reports server of the head office".

The same is valid for the second restaurant. The closed common shift is processed by "a local " report reports server 2, and further in the head office.2.1.

Framework

• Head Office
• primary SQL base
• manager station
• references server (= primary report reports server)
• Restaurant 1
• report reports server 1
• local SQL base 1
• POS cash server 1 (midserver1)
• Restaurant 2
• POS cash server 2 (midserver2)
• local SQL base 2
• report reports server 2

...

SQL databases

• for Head office – ‘reports_HO’
• for restaurant 1 - ‘reports_rest1’
• for restaurant 2 - ‘reports_rest2’

...

Stations and devices

Create 2 restaurants and a POS cash server for each of them.
Image Added

2.4. External DB settings

Create 3 settings as described in the article on connection to MS SQL, and configure the connection to corresponding report reports servers (shall be created additionally). !

This shall result in 3 configurations:

...

for restaurant 2 (‘reports_rest2’ database).

2.5. Report reports server properties

Attention! Do not forget to acquire 3 licenses for 3 report reports servers.

2.6. Ini files

For report reports server 1:

[CONFIG]

Client = "repsrv_1"

...

Protocols = tcpsoc.dll

For report reports server 2:

[CONFIG]

Client = "repsrv_2"

...

Manager station connected to report reports server 1:

[REFEDIT]

Server=repsrv_1 //network name of report reports server 1

Client=rk7man_rep1

Manager station connected to report reports server 2:

[REFEDIT]

Server=repsrv_2 //network name of report reports server 2

Client=rk7man_rep2

...

Add 2 employee groups:
* for report reports server 1
* for report reports server 2

Configure their right in properties:
* give all rights to view reports
* manager restrictions --> Report reports servers à mark corresponding report reports server

Set the following in employee properties:
* general --- current restaurant
* general --- account --- login and password

Using valid SSL certificates for

...

reports server in the domain

Default certificate (for rk7.local) is in BaseData\httpKeys\ folder, default.pem file.
To use your own certificate, rename it (own certificate) to mylocal.pem, and place it into the same catalog, then restart report reports server.

Certificate properties:

...

Solution: Find cube corresponding to the report and re-calculate recalculate it!

1. In Windows 7 and higher OS, when report generation is attempted at manager station, "CubeDLL: Error reading Grid -> LICENSE_STR: Failed to set data for" error occurs. "CubeDLL:" error occurs in the course of viewing corresponding cube.
   

...

4 Connections limit exceeded

Reason - pre-installed report reports server is licensed in RK7, and you are trying to create one more report reports server

Solution - reset license data of extra report reports server, and create empty string "Setup of connection to external DB"

...