Cubes (OLAP technology)
OLAP is an abbreviation for OnLine Analytical Processing. The user gets a convenient, intuitive model of data, organized in the form of multidimensional arrays — CUBES.
...
Before viewing a report based on a cube, you need to recalculate the cube! Building a report after recalculating the cube is only possible if you have a license for the report server 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 in the SQL database as a view, grouping and sorting are not allowed in views
- the request must return at least one numeric value (int, float) field - this restriction is imposed by the cube engine in the manager. The cube requires the presence of at least one fact and must count the totals by the fact, it is impossible to count the totals by a string field
- nested queries instead of specifying a table field are incorrectly processed when parsing a cube query, the solution is to collect data from tables via join and specify the necessary 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 to the reference directory (OBJECTREFNO) and the property ID (RKTYPEIDENT) in the request.)
Creating a Cash Report
To create your own (custom) cash report, perform the following operations:
...