Page History

...

Adding Classification Category into Overall Dish Consumption

Anchor
CubeCreation CubeCreation

Creating

...

Cube

1. To create a new cube, it is convenient to use a copy of a preset one.
   Go to Options > OLAP Reports > Cubes and Reports. Go to the Sales branch and create a copy of a preset cube Total menu item sold cube.
   Image RemovedImage Added
2. Open the cube field editor by clicking three dots in the Cube Fields line on the Properties tab. 
   Go to Sales Element > Dish > Menu Item > Categories and select the required categories. Check the Code and Name boxes in the Main section of the category properties, and enter their system names in the Latin characters, for example CATEGCODE and CATEGNAME.
   Image Removed
   Image Added

Anchor
LayoutCreation LayoutCreation

Creating

...

Layout

1. To create a new report layout, let us use a copy of a preset one.
   Go to Options > Printing > Documents and Layouts. Open the Preset reports group and make a copy of the Menu items sold by categories Total menu items sold layout.
   Image RemovedImage Added
2. Name the copy and open the layout editor by double-clicking the created layout
   
3. This layout lacks information about dish categories. To 

This is how the layout's copy looks like (see Fig. 4):

Fig. 4 – Layout copy of Overall Dish Consumption

...

1. on dish categories.

...

1. To add it you need to change the cube's composition

...

1. according to the instruction above.

2. Anchor
   LayoutExport LayoutExport

   Export the layout by pressing the Export button

...

Fig. 5 – Exporting the existing layout

2.3 Drafting a user report

Create the Overall Dish Consumption_Categoriesin the User Reports section in the Settings > Print > Documents and Layouts menu. Create a new layout in the Print Layouts tab. Import the layout exported in Item 2.2 (see Fig. 6) in the Layout zone in the created layout's properties.

Fig. 6 – Importing the existing layout

...

1. .
   Image Added
   
   

Anchor
UserReportCreation UserReportCreation

Creating User Report

1. Go to Options > Printing > Documents and Layouts. In the User reports branch, create Total menu item sold_Categories classification.
   Image Added
2. On the Printing Layouts tab, create a new layout and open the Layout editor by double-clicking the Layout line
   Image Added
3. Import the exported layout
   Image Added
4. In order to change the layout, select the newly created cube in the 

...

1. DataSet Name band property and

...

1. choose the category code's system name CATEGCODE

...

1.  in the Grouping property.
   

Fig. 8 – Changing the layout's data source

Enter the classification code to be applied to the report in the existing formula in the Filter property (see the classification code in the respective classification's properties (see Fig. 9)).

Fig. 9 – Classification code

The cash register report is shown in Fig. 10

Fig. 10 – A drafted report

...

1. You may also need to edit the layout manually. For more information, see the articles on the Layout editor.
   Image Added
2. In the Filter property of the band, insert the required classification code. To find this code, go to Menu > Menu Classification, select the required classification and open the Properties tab.
   Image Added
3. In the Layout Editor, click OK to save the changes.

Adding Classification Category into Cash Balance Report

1. Create a copy of the System Balance

...

1. Report, Discounts,

...

1. Voids, Prepayments preset cubes
2. Enable the fields with the necessary categories (Calculated Fields > Sales Element > Dish > Menu Item > Categories > Category Name)

...

1. in cube copies' properties Cube Fields field.

...

1. Check the Code and Name

...

1.  boxes in the Main

...

1.  section of the category properties and

...

1. specify their system names

...

1. in the Latin

...

1. characters, for

...

1. example, CATEGCODE and CATEGNAME

...

1. .

...

1. Create a report layout

...

1. , according to the instructions above
2. Create a user report

...

1. according to the instructions above.