Page History

Cubes (OLAP

...

Technology)

OLAP is an abbreviation for OnLine Online Analytical Processing. The user gets a convenient, intuitive model of data, organized in the form of multidimensional arrays — CUBES.

...

The reference is located in Options > OLAP Reports > Cubes and Reports.
Image RemovedImage Added

Hierarchically, the relationship can be represented as follows:

...

To form a cube, it is necessary to properly know the placement of data in the database tables.

The window for forming cube fields of cube fields forming is displayed below:

Image Added

The main properties of cubes that you should to pay attention to:

• Purpose
• Periodicity - the periodicity of cube generation
• Source type
• Timeout for Cubes building cubes timeout (in the properties of the report server properties).
  Image Added

Before viewing a report based on a cube, you need to cube-based report, recalculate the cube! Building a report after recalculating the cube Report building after cube recalculation is only possible if you have a license for the report server license and a Guardant key!

Report

...

Creation

Important

...

Notes

• in the query text, the use of group by / order by constructions is not allowed - — the query from the cube is stored saved in the SQL database as a view, grouping . Grouping and sorting are not allowed in views
• the request query must return at least one numeric field value (int, float) field - — this restriction is imposed by the cube engine in the manager station. The cube requires the presence of should have at least one fact and must count , so the totals must be calculated by the fact, it . It is impossible to count calculate the totals by a string field
• nested queries instead of specifying a table field are incorrectly processed when parsing a cube query, the . The solution is to collect data from tables via join and specify the necessary required fields from the general selection
• the GENERATEDPROPDATAS table stores the values of all extended properties for all DB entities. To restrict the entity type, you must include a reference link to the reference directory (OBJECTREFNO) and the property ID (RKTYPEIDENT) in the request.)

Creating

...

Cash Report

To create your own (customuser) cash report, perform do the following operations:

1. Create a new cube, in the property "Purpose" of which specify " specify For cash reports". Make sure that the cube property has "System Name" specified ( in its Purpose property. It is also necessary to specify  System Name — the value by which the band in the cube layout will find the desired cube);
2. Create a new document: reference "open Documents and Layouts", select the User reports document group "Custom reports", open the pop-up menu from it, select command "New document". Fill , right-click on it and select New document. Fill in the following document properties:   Name, Alternative name (optional), Status. On the Add your cube on the OLAP Cubes report document page, add your cube;tab
3. On the "Print templates" page of the document Printing Layouts tab, create a report templatelayout, then add the necessary required sections and fields to the report in the report template layout editor;
4. Add report template layout to a selected printing scheme in a corresponding directoryreference.

...

...

Image Added

Possible Errors

While configuring the cube properties, the following mistake may occur:

In this case, the recalculation filter should be disabled.

In the Filter Type property, Filter and Add Data should be set instead of Filter DataIt appeared after I set up the filter in the cube properties to recalculate the last two months.
I removed the filter-the error disappeared.

The value of the "Filter Type" property is set to "Filter Data", and it should be set to "Filter and Add Data".