Fast Cube 1.0 User manual
Contents
1. Measures Amount Current Value current value of the measure with wp name Amount plus the value of the wp variable 4 end Calculable Filters in Indicators It is possible to install filters for measures set by the script This filter is used if there is a need to calculate measures only in several selected rows of the source data set instead of all the rows The script is called for executing each row of the source data set before calculating the value of the measure for which the filter is set The executed script performs a consistency check to see if the row corresponds to the set criteria The returned value of the script Boolean type shows whether this value can be used for calculating the measure If Result False the value is ignored if Result True the value is accepted The following variables for getting access to the elements of the grid are available in the filter script list of fields SliceFields TfcSliceFields Please see the descriptions of this class and the script editor in the chapter Using the Fast Script formula tool Let us analyze the following example of a filter We need to calculate the client s advance payment A payment is considered an advance if the client s balance is negative it means that we need to sum up only the negative balances To do that we create an measure by the balance field called Saldo with the Sum aggregate function We create a filter for this measure use the val2. buttons located on both headers of the grid If you need to group the data by the value of a certain dimension you need to click the button of the corresponding dimension And vice versa to refine the data click the button These buttons are marked with the numbers 1 and 2 in the picture below 1 grouping button 2 refinement button Documents auto market Hinsurance agent Total Performing either one of the above mentioned operations causes changes in the structure of the grid header and the data region The next picture shows the way the grid looks after we choose to apply refinement to the GAT paragraph and grouping to the 2011 Fast Reports Inc FastCube Library Description 24 3 2 3 Documents paragraph HDocuments I registration certificate 1 000 00 1 00 Total 1 000 00 1 00 auto auto market 800 00 1 00 The Picture Refinement of GAI paragraph 3 00 The Picture Grouping of the Documents paragraph Apart from the above mentioned way of data refinement there is an option for complete refinement down to the source data 1 e displaying the values of the source table which made foundation for the given row of the grid This operation is performed by means of double clicking the corresponding cell in the data region of the grid This function is optional and depends on the developer s settings of grid For example while
3. in the previous example looks like this Consumption Sservice center air filter 400 00 1 00 0 00 1 700 00 1 00 700 00 550 00 1 00 320 00 50 00 10 00 1 079 00 1 00 150 00 1 00 0 00 1 970 00 1 00 320 00 Total 5 899 00 16 00 1 410 00 Data Rotation The grid layout may be changed easily by means of moving the dimensions between three regions the filter region the row dimensions region and the column dimensions region In the OLAP terms this operation is called rotation because it corresponds to rotating a multidimensional data array Indeed the operation of data rotation creates the opportunity for looking at the same information at a different angle To perform data rotation in the grid it is necessary to drag the corresponding dimension with the mouse from one region to the other While the mouse moves over the grid a special pointer shows where the dimension is going to go if the button mouse is released at that moment see the picture below 2011 Fast Reports Inc FastCube Library Description 26 CR LR D ll LT Measure Price moount Category 5e I Consumption service center 400 00 1 00 70 00 1 700 00 1 00 700 00 550 00 1 00 320 00 2 650 00 3 00 1 090 00 50 00 10 00 1 079 00 1 00 150 00 1 00 0 00 1 970 00 1 00 320 00 3 249 00 13 00 320 00 a aaah an Documents Gal registration certificate 1 000 00 1 00 The following picture shows how the grid looks after t
4. so now we have a chance to get all the necessary data displayed in a convenient form After the data was placed in the FastCube we received the following empty grid see Advanced demo paragraph True Examples Demography CS Sam O EM Move column fields here g Move measure fields here ii ii dr D Li P D _ li Service 4 gt If you click on the drop down List of Fields you will see the following set of fields System counter What can be done with this data Let us create several examples 2011 Fast Reports Inc Examples of Use 8 Example 1 Population by country Now let s drag the Country field to the row region the People field in the data region and place the measures field that is already located in the filters region into the columns region 4 fe E k Move column tielda here X Move measure fields here Move column fields here Move measure fields here Move row telda here Service 4 of As a result of the above mentioned manipulations we get the following grid 2011 Fast Reports Inc Fast Cube 1 0 User manual Move fiter fields here fe Fidis Measure v D cou e Amencar a Samoa 402 167 00 L Andorra 32 136 00 Angola 117 554 944 00 Antigua and Barbuda r20 420 00 Argentina 407 043 846 00 Armenta 33 255 474 00 Aruba roa 914 00 Service a ae It is
5. 059 00 269 667 391 00 285023 886 00 298 444 215 00 853 135 492 00 1 544 E44 275 00 1 909 556 632 00 1 968 395 010 00 5712597 917 00 Service dl of Since the resulting population size by year shows a sum and does not make any sense we Shall turn off their visibility This may be done through the contextual menu of the Year dimension f Es E 1996 w Show totals COUNTRY v RES Collapse dimension Expand dimension 58388 Russia United Kingdom United States E Change sort direction 145 311 Move items to page arez BO 618 663 00 59723 243 00 BOE 269 FEF 301 NN 296 093 AAA NN 298 After this operation the column Total by People is not visible in the grid any more and it looks like this 2011 Fast Reports Inc 13 Fast Cube 1 0 User manual Change of population on years see the Chart 4 AGE_GROUP F D E o 1 227 fb 44700 96 300 406 00 01 890 667 00 148 311 699 00 56 618 663 00 269 667 391 00 D Service 4 1 276 802 500 00 59 656 144 00 d 200 551 00 145 990 308 00 59 723 243 00 209 023 806 00 11356 2001 2006 CATA F PEOPLE PEOPLE 1 313 973 713 00 BO 876 136 00 De 422 299 00 142 069 454 00 BO 609 153 00 edo 444 215 00 1 958 395 070 00 al CE However this variation of the grid makes it hard to estimate the demographic situation in the countrie
6. 870 515 00 Bangladesh 146 691 993 00 142 069 494 00 Nigeria 131 496 864 00 127 463 611 00 Service A My Li Japar CEETTTTEETETTETEETTTEEETETTETEETEEEEETETTETEE If we turn on the percentage layout of the measure values we can also find out that the population of China constitutes 20 of the total global population and the population of Russia only 2 Example 2 The dynamics of changes in the population size over the years 2011 Fast Reports Inc Examples of Use 12 This example will be based on the grid received above To do this we need to move the Year dimension form the filters region to the columns region in front of the measures field and add the values 1996 and 2001 to the years filter As a result the data in the grid will display the population size from 1996 to 2006 with the 5 year interval Then we shall filter the country dimension in such a way that there should be only 6 countries left China France Germany Russia Great Britain and the USA Change of population on years see the Chart QG cour EEN 31996 2001 2006 Total by PEOPLE COUNTRY a F PEUPLE PEUPLE 1 229 fe 447 00 1 276 882 50000 1 313 9 3 1300 36918 623 660 00 5836840800 59658144 00 6087613600 178 922 688 00 81 890667 00 8228065100 9242229900 246 593 517 00 148 311 699 00 145 990 308 00 142069 494 00 46 371 501 00 United Kingdom Ae 618 663 00 59 23 243 00 60 609 153 00 178 951
7. Data marking contig Field ranges Price Ranges gt 1000 00 lt 100 00 Range config 1000 The measure for which the data highlighting rule is being set is selected from the drop down list Field ranges Below is a list of already existing ranges for various measures Ranges Each range is represented with a picture a cross in a square The background color of the square is the background color set for this range and the color of the cross is the text color Next to the picture there is a text describing the range of data for highlighting The range does not have to have the left and right borders If there is no left border the range 1s considered to be set from minus infinity to and including the value of the right border If there is no right border the range is considered to be set from and including the value of the left border to infinity If both borders are missing the range 1s 2011 Fast Reports Inc FastCube Library Description 30 considered to be set for the whole region of values of the measure To create a new range it is necessary to type the values of the left and right borders into the dialog fields choose the text and background colors by clicking on the corresponding button at that point the Color field changes its color to the one that was set and click the Add button to add the range To edit the existing range we need to select it on the li
8. Fast Reports Inc FastCube Library Description 28 3 2 6 The toolbar features the following commands 1 Set all the values as visible x Set all the values as invisible Invert object visibility w Apply changes and close list Cancel changes and close list Data Sorting All the data in the grid is displayed in strict sorted order irrespective of their original order in the source table The sorting order may be direct 1 e from smaller to bigger or reverse 1 e from bigger to smaller For numeric and temporary values the direct order coincides with their natural order The alphabetic order is used for string values Every dimension of the grid may have its own sorting order For example the rows referring to the Category dimension may have direct order and the ones included in the Seller dimensions a reverse one The default sorting order in a grid is direct for all dimensions The sorting order for a selected dimension may be changed in one of the two following ways 1 by double clicking on the dimension header 2 by selecting the corresponding option in the contextual menu of the dimension with a mouse click on header The dimension sorting order is marked with a special symbol it jaiii Category a OF Seller hn SES PE Back sorting F l am DE ON serv Ge sf CNY totals EGS Collapse dimension Expand dimension In Picture 1 number 1 refers to the symbol of s
9. User manual The main settings of the object are performed through its editor which is called by double clicking the object The cross view editor consists of a drop down list of the available cubes below and two tags with settings After the cube is selected the interactive cross view on the firs page becomes open for setup There is a detailed description of the cross view grid toolbar and the grid itself at the beginning of this manual Ei Cross tab Editor Cross tab structure Options Ea amp IG ae 2 Ey ie BS Wt SB Move Filter fields here Field list z D Consumption insurance agent Total Goods prey Owner Cube p Cubel The second tag contains a number of settings connected with the cross view layout 2011 Fast Reports Inc FastCube Library Description 44 Ei Cross tab Editor Cross tab structure Options Select style W Field names Auto size Default W Column header M Border around cells WW Row header D Print down then across MW Reprint headers on new page Cube E Cube1 Cancel At the top of the page there is a picture of the cross view representing its current view in the report In the drop down Select style menu it is possible to choose one of the six preset color schemes for the cross view display layout At the bottom of the page there are some elements for adjusting the graphic representation of the cross view Field names sho
10. calculable measures can be counted both by means of standard statistic functions and though calculating according to the formula of the calculable measure The FastScript package is used in the calculations 14 It is possible to install filters set by the script for measures A filter shows which values can be taken for calculating the measures The values of the original data set can be used in calculations The FastScript package is used for creating the script 15 Any level of detail on the axes may be folded completely or partially by means of folding the values by user s wish 16 It is possible to export a cube slice into Excel Word and HTML In export the scheme set by the user is retained One of the aspects retained is the settings for folded or unfolded values and levels Data highlighting creates the opportunity to highlight with different colors and styles the values of measures that fit in the boundaries set by the user 17 Text string field processing The type of a data field is defined though the TDataSet descendant All fields of standard types String Integer Float Date and Time may act as dimensions Only numeric fields and partially date fields maximum and minimum are allowed be included in the calculations Thus if the original field is a string then irrespective of the contents a string a textual representation of an integer or a date this field will be processed 2011 Fast Reports Inc F
11. from file lear the current data layout scheme LA save the data layout scheme to file a oad a previously saved data layout scheme from file 2011 Fast Reports Inc FastCube Library Description 38 export data into an external format The list of available external data export omats is opened through a drop down menu op up hints 1 in the grid display the information on the grid structure and the time elapsed for loading the data creating the headers and calculating the facts T m Saving the cube and the scheme differ in the volume of saved information The cube file contains a data array and the data layout scheme The scheme file does not include the data itself t only contains the data layout There can be several data layout schemes for one data cube 3 3 The Chart The data in the grid may be represented in the form of a cumulative 2D chart The TeeChart component is used in displaying the chart Depending on the settings one of the major dimensions of the rows columns is used to form the chart series and the opposite dimension 1 e vice versa the major dimension in the columns rows is used for getting the values in each of the series 2011 Fast Reports Inc 39 Fast Cube 1 0 User manual DM Price E Amount CL work price Consumption Documents Goods Category If the source grid does not contain row or column dimensions an internal representatio
12. it Also note that the values of the Country dimension are listed in the alphabetical order For our analysis it would be more convenient to list the countries by population in the decreasing order To do that we need to sort the data by the value of the measure Let us click on the grid on any data cell in the column which we are going to use for sorting the data and select the option Sort by active column in the Toolbar Las ow Sort by axis values EE 30 9930 713 00 3561 655 00 32 691 561 00 AMencan Samoa AY E34 00 11 992 807 00 Antigua and Barbuda bo 442 00 Sort by measure totals Sort by Focused column As a result the grid will display the data sorted by the value of the People measure population but in the ascending order 2011 Fast Reports Inc 11 Fast Cube 1 0 User manual 7 338 00 9 153 00 11 739 00 13 220 00 13 274 00 20 394 00 Turks and Caicos Islands 21 016 00 Service 4 To change the order for descending double click on the Country dimension you can do the same from the drop down dimension menu As a result we can see from the grid that China takes the first place by the size of population and Russia only the 8 one E ELF AGE GROUP COU Y F China India United States 1 313 973 713 00 1111 713 910 00 296 444 215 00 231 820 243 00 166 141 676 00 Indonesia Pakistan 164
13. several regions marked with different numbers on the following NO LA picture the grid header the filter dimensions region Dimensions included in this region can be used for filtering the data contained in the grid the dimension headers down Dimensions included in this region form the grid s vertical header the dimension headers across Dimensions included in this region form the grid s horizontal header the vertical header of the grid the horizontal header of the grid data region field list display region The fields necessary for processing can be taken from this region by means of a contextual menu service field The contextual menu of this region allows the user to perform various operations with the grid 3 2 1 Setting up the Grid Structure The grid structure may be created in several different ways l 2 3 In Structure With the use of a program By loading it from a cube or a scheme file Setup manually by the user this paragraph we are going to talk only about the manual setup of the grid 2011 Fast Reports Inc 21 Fast Cube 1 0 User manual In case there are no dimensions and measures in the grid they can be added by dragging from the contextual menu see picture into one of the following regions Move column fields here Move measure fields here Service 4 b Filters region This results in adding a dimension to the filters reg
14. virtual dimension it may take any position on any of the axes may be located in the filters region and its values may be filtered out 1 e some measures can be hidden 10 It is possible to perform the following statistic operations with the numeric fields of the measures Total Amount Minimal Maximum Average Product Dispersion Average Square Deviation 2011 Fast Reports Inc Introduction 4 See Dispersion See Average Square Deviation Count of Unique First value Last value List Of Unique Values 11 Only Minimal Maximum Count of Unique First value Last value and List Of Unique Values operations are allowed for the fields of the Date and Time type in the measures In the example Time and Attendance Record in the scheme Employees Arriving and Leaving Time the measures Arriving u Leaving are regarded accordingly as the Minimal and Maximum values of the time of passing though the access point A total for a group is also regarded as a Minimum value and a Maximum value 12 Count of Unique First value Last value and List Of Unique Values operations are allowed for the fields of other types 13 An measure may be calculable In this case the measure s value is calculated according to the script set by the user Values of other measures can be used in calculations Values of dimensions can be used in calculations Totals of
15. 4 50 54 90 94 GE _GROUR A chart makes it easy to answer the questions asked at the beginning 1 There are more boys born than girls 2 However beginning with the age of 40 44 there becomes more women than men If you are interested in this data and you would like to print it out switch to the grid page and click Preview in FR The FastReport window for report preview appears If you failed to repeat some of the examples you can open a ready made scheme from the Advanced chapter paragraph True Examples Demography 2011 Fast Reports Inc Chapter FastCube Library Description 17 Fast Cube 1 0 User manual 3 1 3 1 1 Data Converter At startup the field type is defined though the TDataSet descendant linked to a data source All fields of standard types text number logic date and time are supported The fields of other types BLOB Graphic Memo Array etc are not supported and are ignored at startup Only numeric fields and partially date fields maximum and minimum may be used as measures Thus if the original field is a string then irrespective of the contents a string a textual representation of a number or a date this field will be processed according to the rules for string fields and will not be included in the calculations There is a technique for changing the type that makes it possible to convert fields to the necessary type while the source data is being lo
16. Fast Cube 1 0 User manual Fast Cube 1 0 User manual Table of Contents I Chapter I Introduction 9 1 B sic Properes in ee ne an aa ENE a cl 2 Chapter Il Examples of Use 7 T EEXAMIDIS DeMOAD Ne a en 7 Chapter lli FastCube Library Description 17 1 DIa C ONVONOT nn eee am 17 Working WITH the CONVENOR sirrien EREA nan n EEE en esran tienne 17 2 WING GNO PR E E 19 Setting up the Grid Structure ssssssssssssssrennnnnnnnnnnnnnnnnnnneeeeeeneeneneneeeeeeresessssnsnsnnnnnennnneeeeeeeeeeeeeeenne 20 Data Refinement and Grouping nnnnrrrrrrrrssreeeneneeeeeeeneeeeeenennennnnnnnnnnnnnnnnnnseeneeneneeeeeeeeeeeeenenes 23 Apart from the values of dimensions nssssserrrennnnnrnereneeenennnnnnnenenenenennnnneneeeeeeeeenennnnnee 24 D S UE BA Oa OM PR PEER ENS otic A sees ceunsucensanevunssececedeuss SERRE PRES 25 D ES ANS a D nie ein 27 Data SORA ea e anne a de se cd retient 28 D OO mn ne anne ee ui 29 Using the Fast Script Formula TOO siviicsiiecistetcecccccctscescsscecsscsecnscnctanasnssncssssececdecescuucaacetessessessseestersesncsenstsnns 30 Calculable Filters in Indicators ssiscsiesccseconssasccnstececesseaeesonsoeseunesdeavandcncsxececeusranszuventoasocceancanceecnsemseaeesarnseneeenes 36 DA DORE a no ce ce 37 Te GHO OO ODA nan sn a ee ce 37 3 THE Char a as a 38 The Chart TOOIDAN nm sessesens sense ce ses sansca stene nes enoncnnesechesss denses ses ses essence 41 4 Worki
17. Index String TMeasure property Count Integer property RecordCount integer property Detail Value ARecordIndex Integer AFieldName String Variant procedure PrepareDetailInfo end Class Set of Dimensions TDimensions class published property Items AIndex Integer TDimension property ItemByCaption AIndex String TDimension property ItemByName AIndex String TDimension property Count Integer 2011 Fast Reports Inc FastCube Library Description 34 end Class Set of Fields TfcSliceFields class published property Items Index Integer TfcSliceField property FilterCount Index Integer Integer property ItemByCaption AIndex String TcSliceField property ItemByName AIndex String TcSliceField property Count end Below is a detailed description of the properties and methods of the above mentioned classes TMeasure Caption the caption of the measure FieldName the name of the measure field CurrentValue the current value of the measure CurrentCaption the caption of the current value ColOffsetValue Offset integer the value of the measure with an offset of elements in the columns from the current value RowOffsetValue Offset integer the value of the measure with an offset of elements in the rows from the current value ColOffsetValueWithDimValue ADimValue Variant the value of the measure for dimensio RowOffse
18. S trina 7 Shic l s No ha E dit Field Save To File Load From File OF Cancel Please note that the fields that are not ticked will not be loaded in the cube In cases when the field value can not be converted to the necessary type during startup the resulting field value is equaled to Null There is an option for saving the conversion scheme for further use the Save To File button It is possible to load a previously saved conversion scheme the Load From File file 3 2 The Grid The Grid is an interactive tool for representation and analytical processing of data There are multilevel headers in the left and top parts of the grid The headers are filled with the dimension values The central part of the grid displays the values of measures 2011 Fast Reports Inc FastCube Library Description 20 E Demo example re Move Filter fields here Measure o O vwlitem Price Amount wwork price Consumption 2 service Air Filter 400 00 1 00 70 00 a See 1 700 00 1 00 700 00 550 00 1 00 520 00 CE 2 650 00 3 00 1 090 00 50 00 10 00 C5 1 079 00 1 00 150 00 1 00 0 00 Transmission ail 1 970 00 1 00 320 00 Total 3 249 00 13 00 320 00 5 899 00 16 00 1 410 00 Documents SIGAr registration ee 1 000 00 1 00 1 000 00 1 00 SJauto market contract of 800 00 1 00 a NE E Service a a The grid consists of
19. S tring 30 ShipT a ddre No ShipT oCity String 15 ShipToCity No Ship oState FtS tring 20 ShipT oState No ShipT ip FtS tring 10 ShipT oip No ShipToCountry ftString 20 ShipToCountry No ShipT oFhone FtS tring 15 ShipT oPhone No MA Shiny lA fS trina Shiol Ho i Edit Field Save To File Load From File OF Cancel The list of fields of the original data set is displayed in the conversion editor To edit the field values it is necessary to select the field on the list and click the Edit Field button At this point the field editing form comes up Edit field i x Field name Empo Type ftinteger Gize 0 Caption EmpN 2 Use converter f Target type String X Target size fi T OF Cancel When the editing is completed the list of fields looks like this 2011 Fast Reports Inc 19 Fast Cube 1 0 User manual RTE field OI x _Field name Type Size Caption Usec Targettype Targetsize Order o ftFloat 0 Ordera Custo ftFloat Custa S5SaleD ate tD ateTime SaleD ate Mir a ftinteger Empa s String C ShipToContact String 20 ShipToContact No C ShipTodddr ftString 30 ShipT at ddr1 No C SHipTa ddre ftString 30 ShipT a ddr No L ShipToCity String 15 ShipT oCity No L ShipT oState FtS tring 20 ShipT oState No L ShipT ip FtS tring 10 ShipT oip No C ShieToCountry String 20 ShipToCountry No L ShipT oPhone FtS tring 15 ShipT oPhone No M ShiovlA ft
20. aded that is to transfer the fields into numeric or other types whenever necessary Working with the converter The data converter makes it possible to convert the source data into the necessary type This function is necessary in case the numeric data is stored in the string format To call the converter before loading the data it is necessary to set the option mdcoShowConvertor for TfcCube When the conversion option is on the editor is called before loading the source data The following parameters can be set in the editor for each field The measure of the necessity of loading you can avoid loading the fields that are not necessary for the analysis The displayed field name It is used whenever there is a need to set a name different from the original one The indication of the necessity of conversion In this case it is necessary to specify the target data type Allowed types String Integer Float Date and Time For the String type the string length should be specified additionally 2011 Fast Reports Inc FastCube Library Description 18 Fe Convert field 0 x Field name Type Size Caption Use c Targettype Targetsize Order o ftFloat 0 Ordera No Custo ftFloat 0 CustNo No SaleD ate tD ateTime SaleD ate No Ship ate tO ate T ime 0 ShipD ate Mo Empo ftinteger 0 Empa No ShipToContact ftString 20 ShipToContact No ShipT a ddr ftStrinig 30 Ship T addr No ShipTo ddrz H
21. alled schemes A scheme contains the following data on a cube slice settings location of the fields layer convolution visibility of conclusions sorting type and order data highlighting filters and some other settings Schemes can be created saved and loaded both by the end user working with the cube and with the program Schemes can be saved loaded either into a file or in another location for example a database by means of the stream tool Please note that a scheme does not store data Schemes are not associated with the given data set but during startup there must be a concordance of the field names in the data set and the loaded scheme Examples of several schemes for different cubes are given in the demo application 6 There is an option for saving the DATA of the cube in an external file or in some other location by means of steams Later the cube can again be loaded for analysis without connecting it to a database Thus for example we can save the data formed for the given dates and 2011 Fast Reports Inc Fast Cube 1 0 User manual afterwards restore this data really quickly Or we can send this data to our business partners bosses or colleagues from other departments The current settings are also stored in a cube 7 There is an option for filtering out the data by field values Entries containing the values specified by the user may be excluded from the data for analysis A filter ma
22. ast Cube 1 0 User manual according to the rules for string fields and will not be included in the calculations There is a technique for changing the type that makes it possible to convert fields to the necessary type while the source data is being loaded that is to transfer the fields into numeric or other types whenever necessary There is event OnGetFieldConv for tune of field converter 18 The data converter makes it possible to convert the source data into the necessary type This function is necessary in case the numeric data is stored in the string format When the conversion option is on the editor is called before loading the source data The following parameters can be set in the editor for each field 1 The indication of the necessity of loading you can avoid loading the fields that are not necessary for the analysis 1i The displayed field name It is used whenever there is a need to set a name different from the original one il The indication of the necessity of conversion In this case it is necessary to specify the target data type Allowed types String Integer Float Date and Time For the String type the string length should be specified additionally In cases when the field value can not be converted to the necessary type during startup the resulting field value is equaled to Null There is an option for saving the conversion scheme for further use There is an option for loading a previously sa
23. e measure s totals are calculated by the same formula as regular cells The formula is created and edited in the formula editor The editor is opened by clicking the Editor button in the dialog 2011 Fast Reports Inc FastCube Library Description 32 Formula Editor begin Variables Functions Classes 1 Measuresl irea CurrentValue lt gt 0 then Result Measures Population CurrentYal Result QO CJ Variables System variables fe Result fe Dimensions fe Measures fe SliceFields end The formula editor is a dialog with the following three parts 1 a toolbar 2 an editor with syntax highlighting and 3 a tree of variables functions and classes that are accessible for creating the calculations formulas The toolbar contains commands for checking and saving the formula and canceling the editing The text editor is used for editing the text of the formula The text of a formula is a Pascal program that is interpreted at the moment of calculating with the FastScript tools The body of the formula must return a value through assigning the value to the Result variable All the dimensions measures and fields of the grid can be used in creating a formula see below Apart from writing the text of the formula it is also necessary to set its calculation priority in the field Calculation order The following variables are available for getting access to the el
24. e only Russia in the Country dimension As a result of the above mentioned actions we get the following grid Female and man s structure in diff rent age tA v AAA Total by PEOPLE I D4 350586700 3706851 00 7216718 00 al 356855000 2376377400 7 322 324 00 5601 27500 52486700 11 426 142 00 5938 204 00 6036 309 00 11 974513 00 5 454 448 00 426 420 00 10990 969 00 5151 138 00 50937157 00 10 244 295 00 4700 486 00 4701 412 00 9401 897 00 5621 646 00 5371 305 00 10952 951 00 6399189000 577433200 1217251200 591056200 4976512700 10995 689 00 4992 794 00 3773697 00 9666 491 00 266049300 192459000 4495 083 00 47481300 293027000 7595 083 00 317555500 1621 404 00 4796 959 00 3236 414 00 1294 706 00 4531 120 00 167439100 39907300 2073 464 00 63972300 12074700 770530 00 31917600 4540100 364577 00 53 915 00 6 068 00 59 983 00 73271 679 00 6254951000 135921 199 00 Service 4 nu Just like in the previous example the absolute figures are less illustrative for analysis than a chart although for a paper report figures are still much more important so let us switch to the chart page 2011 Fast Reports Inc 15 Fast Cube 1 0 User manual j a 6 000 0004 5 500 000 5000 000 4 500 000 4 00 000 3 500 000 d 3 000 000 2 500 000 2 000 000 1 500 000 1 000 000 500 000 M Female D Male O 4 10 14 20 24 30 34 40 44 50 54 60 64 70 7
25. eDetailInfo Used to create list of detail records TDimensions Items AIndex Integer an array of dimensions with access by index ItemByCaption AIndex String an array of dimensions with access by caption ItemByName AIndex String an array of dimensions with access by name default property Count number of dimensions TfcSliceFields Items Index Integer an array of fields with access by index ItemByCaption AIndex String an array of fields with access by caption ItemByName AIndex String an array of fields with access by name default property FilterCount Index Integer the number of filtered values in the field Count number of fields Let us analyze the following example of calculating an measure Sum Price AMount WorkPrice l var Let us define the additional variable wp Variant 2A begin 3 wp Measures WorkLet us set the current value of the price CurrentValue measure with name Work price as the variable wp 2011 Fast Reports Inc FastCube Library Description 36 3 2 9 if VarType wp lt 1 then wp 0 If the value of wp is absent equal to Null or Empty then we set the value of wp O we are using this trick to avoid having to perform addition to the values of Null or Empty Result We define that the resulting value is Measures Price CurrentValue the current value of the measure with name Price multiplied by the
26. easy to see that the data in the grid is not real The reason is that in this condition the People measure sums up the values for all years Thus we need to specify the necessary year To do this we need to drag the Year field into the filters region When a field is added into the filters region in the grid there appears an element with the option of data filtering by means of a drop down list Let us click on the drop down list of the Year field E TEAR E AGE_GROUP g i0 aema or uss 075 00 mena 33 255 474 00 Service a aa As we see from the picture the grid contains the data for 10 years But we need to select only 2006 This can be done in several ways 1 By unticking every year we do not need one by one 1 e from 1996 to 2005 2 By unticking 2006 and then clicking the Invert selection button 3 By clicking the Deselect all button and then ticking 2006 2011 Fast Reports Inc Examples of Use 10 After all the manipulations with the Year dimension the grid looks like this FEAR AGE_GROUP RP due NN COU r PEOPLE 4 American Samoa AY 534 00 Andorra 69 883 00 Angola 11 992 807 00 Anguilla 13 220 00 Antigua and Barbuda be 442 00 Argentina 38 959 953 00 Amenia 2 976 372 00 Aruba FO 226 00 Service 4 fe L CR Please note that the changes in the Year are displayed in italics This means that a filter is applied to
27. ements of the grid list of dimensions Dimensions TDimensions list of measures Measures TMeasures list of fields SliceFields TfcSliceFields Classes available for creating a calculable measure Class measure TMeasure class published property Caption String property CurrentValue Variant property CurrentCaption String property FieldName String property ColOffsetValue Offset integer Variant property RowOffsetValue Offset integer Variant property ColOffsetValueWithDimValue ADimValue Variant Variant 2011 Fast Reports Inc 33 Fast Cube 1 0 User manual property RowOffsetValueWithDimValue ADimValue Variant Variant property Total ValueForDims ADimNames String Variant end Class Dimension TDimension class published property FieldName String property Caption String property CurrentValue Variant property CurrentCaption String end Class Field TfcSliceField class TPersistent published property FieldName String property Caption String read property CurrentValue Variant property CurrentCaption String property FilterCount Integer property Index Integer property IsMeasures Boolean property IsFiltered Boolean property CanAggregate Boolean end Class Set of measures TMeasures class published property Items AIndex Integer TMeasure property ItemByCaption AIndex String TMeasure property ItemByName A
28. he Item dimension is moved from the row dimensions region to the column dimensions region Field list Air Filter 4ntiFreeze Categ Seller SI Consumption service center 400 00 1 00 70 00 50 00 10 00 400 00 1 00 70 00 50 00 10 00 Documents insurance agent Total prey owner 400 00 1 00 70 00 a0 010 10 00 Also data rotation may be performed from a special dialog which displays all the fields of the grid 2011 Fast Reports Inc 27 Fast Cube 1 0 User manual 3 2 5 Move to grid E Let assign cube caption ES Amount Amount ES Category Category Hp ES Seller Seller Work price Work price Measures Measures wi gilli Columns Data Filtering Data filtering is performed by excluding certain dimension values from analysis Please note that it does not matter what region of the grid this dimension is located in the filter region the row dimensions region or the column dimensions region The values of dimensions may be filtered in the drop down list which is opened with a mouse click on the dimension filtering button Numbers in this picture represent the following items 1 dimension filtering button 2 drop down list of dimension values 3 drop down list toolbar Marked with a cross in the drop down list are the ones visible in the grid The dimension must include at least one visible value 2011
29. ion The row dimensions region This results in adding a dimension to the rows region 3 The column dimensions region This results in adding a dimension to the columns region 4 Data region At this point the dialog for creating an measure comes up N m Now let s assume that you added the Category and Item fields to the filters region and moved the Price field to the data region As a result of the above mentioned actions the Category and Item dimensions are added to the filters region and the measure setup dialog comes up In the dialog it is necessary to specify the aggregate function for the measure and the measure name and then click Add and OR 2011 Fast Reports Inc FastCube Library Description 22 MEUM Caicos lon O Wii Edit Measures Measures Caption Aggregate off Aggregate Display Calculat Filter M 440 00 D D mi i D iT cl wm mm Service 4 Thus your grid now looks like this A fe Category ikem kd EB Move column fields here Move measure fields here Move row telda here Service r Also please note that the number in brackets in the Measures dimension is now 1 instead of 0 This means that the number of measures defined for this grid is now equal to one The Measures dimension is in fact not a simple dimension Unlike all the others Measures co
30. n of a grid with row and column dimensions will be built inside the chart A button on the toolbar calls the chart data manager in which the internal representation of the grid may be edited If the source grid contains only one dimension it may be only the Measures dimension the number of the chart series will be equal to the number of grid measures with one value in them 1 Data source adjustment of the chart Grid Dimensions or list of measures can be chosen as the series list of the diagram Grid Dimensions or list of measures can be chosen as the categories list X axis of the diagram To set type of the source use next property property TypeChartData TfcTypeChartData TfeTypeChartData fcct_ByAxisAxis Categories and Series from dimensions Use for one measure fcct_ByAxisMeasures Categories from dimensions and Series from measures fcct_ByMeasuresAxis Categories from measures and Series from dimensions 2011 Fast Reports Inc FastCube Library Description 40 It is possible to specify detail depth count of levels when you are using dimensions of Grid as the series list and or categories list For the series list property SeriesFieldCount integer For the categories list property CategoriesFieldCount integer If depth 0 only TOTAL value is used If dimensions of the Grid are used for the series list and or categories list it is necessary to specify axis of the Grid c
31. ng with FastReport 4 0 Report Generator ss mnsssssmnrrerrmnnnerermnnnnnereennnnne 41 The ChOSS VIEW ODJEDE Sn aaa ON same 42 2011 Fast Reports Inc 2011 Fast Reports Inc Chapter Introduction Introduction 2 1 1 Basic Properties 1 FastCube is a set of components aimed at creating data analysis systems FastCube belongs to the Desktop OLAP class 2 Developers may build in FastCube in the form of a set of components into applications they create in the Delphi or Lazarus environments 3 FastCube consists of a data storage several slices and a grid The data storage contains the data that is loaded into the databases trough the descendants of TDataSet or through a file with a special format There is no need for preliminary sorting and grouping of the data source an SQL query or a table During startup the data is processed and the structure that is the most suitable for further analysis 1s created Slices receive the data from the storage and format the data in compliance with the cube settings We can create several slices with different structures which would be associated with one storage A grid is responsible for displaying the data formed by the slice and allows the user to manage the cube settings 4 Itis possible if necessary to create an alias for the fields that may be used further ON 5 There is an option for creating ready made cube templates Such templates are c
32. ntains measures and not elements of the row of the database table as its values This is done in order to make the adjustment of the grid layout more flexible In most cases this virtual dimension acts just like any other one While working with it we can filter the values while the visibility of measures is turned off sort the values this changes the order of measures and move it to any regions allowed to be included in dimensions The grid only displays data in case it contains at least one measure and the Measures dimension is located either in the region of row dimensions or the region of column dimensions 2011 Fast Reports Inc 23 Fast Cube 1 0 User manual For example if you drag the Category and Item dimensions into the row dimensions region and the Measures dimension into the column dimensions region the grid will look like this Move fiter fields here Cate rliltem rl Price 3 Consumption Air filter 400 00 50 00 1 700 00 1 079 00 Oil fiter 150 00 550 00 1 970 00 5 299 00 SDocuments contract of purchase 600 00 2 500 00 registration certificate 1 000 00 Total 4 300 00 Service 4 b 3 2 2 Data Refinement and Grouping The data displayed in the grid may be either refined or on the contrary grouped or folded excluding the values of the dimensions located below from processing These operations are performed with the help of the and
33. olumns or rows For series list property SeriesAxis TfcTypeAxis For categories list property CategoriesAxis TicTypeAxis TicTypeAxis ta_ColAxis ta_RowAxis If dimensions of the Grid are used for the series list and the categories list fcct_ByAxisAxis it is necessary to specify index of the measure property MeasureFiledIndex integer For the first visible measure MeasureFiledIndex 0 2 Additional features You can freeze do not change Chart on Slice change chart property Frozen Boolean or use appropriate button on the toolbar You can set properties of the data source of the diagram by code or in dialog use appropriate button on the toolbar If properties of the data source of the diagram are not correct TfcChart writes Chart properties are not correct 3 Restrictions It is impossible to use dimensions of the Grid as the series list and as the categories 2011 Fast Reports Inc 41 Fast Cube 1 0 User manual 3 3 1 3 4 list if Series Axis Categories AxI1s Detail depth count of levels should not be greater than count of grid axis levels Detail depth count of levels should not include Measures dimension Index of the measure MeasureFiledIndex must be smaller than count of visible measures 4 Print TfcChart in FastReport4 You can print Chart from the application form Use component TfrcChart Set properties property Chart TfcChart
34. orting direction and number 2 shows the settings line of the contextual menu for the dimension Apart from the sorting order it is also possible to set the sorting type separately for lines and columns There are three methods of data sorting 1 by dimension values the sorting is performed by the values of the fields located in the dimensions sorting method by default 2 by the totals of a fact data is sorted by the total values of a fact If there are several facts only the values of the fact associated with the selected cell are included in the sorting 2011 Fast Reports Inc 29 Fast Cube 1 0 User manual 3 2 7 3 by the current row column sorting is similar to the previous method but instead of the total values of the column row we use the values of the current row or column selected in the grid Both for row dimensions and for column dimensions the sorting method is selected through the toolbar or the contextual menu in the service region Data Highlighting It is possible to set special colors for measure values in the grid This may be necessary for highlighting the data located within a certain range or beyond its borders This tool is called data highlighting or highlighting exceptions To highlight data in the grid we need to define the range of data and then to set the cell background color and the text color These operations are performed in the following dialog
35. performing refinement of the 4 300 00 cell the following table of the source data will be opened z lamant Category Item Price Seller work price Documents contract of purchase 800 auto market Mull 2 Documents insurance 2500 insurance agent Mull 3 1 Documents registration certific 1000 GAI Mull from which it is obvious that the value of the cell 4300 800 2500 1000 Apart from the values of dimensions Apart from the values of dimensions total values may be displayed in the grid A total value is an aggregate value of the measure for a certain group of dimension values The total value of an measure is calculated by means of the same aggregate function that is used for the measure In the picture below the total values are marked with arrows 2011 Fast Reports Inc 25 Fast Cube 1 0 User manual 3 2 4 SI Consumption service center Air Filter 400 00 1 00 70 00 1 700 00 1 00 700 00 550 00 1 00 320 00 2 650 00 3 00 1 090 00 50 00 10 00 1 079 00 1 00 150 00 1 00 0 00 1 970 00 1 00 320 00 3 249 00 13 00 320 00 5 899 00 16 00 1 410 00 The layout for displaying the totals is adjusted in the Show totals contextual menu for the dimension Back soting Show totals Collapse dimension Expand dimension Alignment Mowe item sto page area After the Show totals option for the Item dimension is turned off the grid used
36. property Enabled Boolean Enable for selection property UserName String Name of the component In FastReport4 designer set TfrcChartView properties property FRCChart TfrcChart or property FRCChartName String The Chart Toolbar The chart toolbar features the following set of buttons l save chart layout settings to file En oad chart layout settings from file oy select the type of chart series jy frozen chart 3 Working with FastReport 4 0 Report Generator Building a report with the help of a grid is very similar to creating standard cumulative reports in the FastReport environment So we shall not repeat here the bulk of 2011 Fast Reports Inc FastCube Library Description 42 3 4 1 the FastReport manual which concerns cumulative reports but shall go directly to the practical part which deals with creating a grid based report Any grid uses a multidimensional data structure the cube as its data source A cube contains in its memory all the data in a format that is convenient for the grid This allows to minimize the time necessary for such operations as building and setting up a grid One cube may serve as a data source for an unlimited number of grids with different structures This is why two elements are required for building a report 1 a cube TfrcCube to be used as a data source for the grids 2 and a cross view TfrcCross View the object which represen
37. ry This setup includes the selection of font size style color etc background fill alignment etc All these settings may be done through the object inspector separately for each memo object which constitute the TfrcCrossView in FastReport designer These settings are similar to the setup of the TfrxCrossObject component from FastReport 2011 Fast Reports Inc
38. s A chart would be a much more illustrative tool in this case Let us go to the chart page 1 300 000 000 4 1 200 000 000 1 100 000 000 1 000 000 000 900 000 000 800 000 000 700 000 oog 600 000 O00 500 000 oon 400 000 000 300 000 000 200 000 000 100 000 000 r France r Germany Russia United Kingdom COUNTRY M i996 E 2001 O 2006 Such a chart gives a quick answer to the question as to in what countries the population has increased in and where it has decreased Thus the picture shows that in all the selected countries except Russia there was a population increase in 1996 2006 while Russian population decreased Example 3 Population by sex and age In this example we are going to try to answer the following questions 1 Children of what sex are born more often 2 Does this situation change from year to year 2011 Fast Reports Inc Examples of Use 14 In order to answer these questions we are going to perform the following operations with the grid 1 Place the Age_group dimension into the region of row dimensions 2 Then place the Year u Country dimensions into the filters 3 Add Sex which will have to be dragged out of the field list and the measures field to the region of dimensions 4 Exclude the values of 100 and 5 10 from the values of the Age_group dimension 5 Leave only 2006 in the Year dimension 6 Leav
39. st with a mouse click Its properties will be transferred into the edit region After making the changes the range must be replaced by clicking the Replace button To delete a range we need to select it and click the Delete button After completing all the settings for the ranges of data to be highlighted the changes must be saved by clicking the OK button or canceled with the Cancel button In the next example we see how the grid may look after the data highlighting ranges were set for two measures 400 00 1 00 70 00 1 700 00 1 00 700 00 550 00 1 00 2 650 00 3 00 1 090 00 50 00 10 00 1 079 00 1 00 150 00 1 00 0 00 1 970 00 1 00 320 00 3 249 00 13 00 320 00 5 899 00 16 00 1 410 00 3 2 8 Using the Fast Script Formula Tool To create a calculable measure we need to call the measures editor 2011 Fast Reports Inc 31 Fast Cube 1 0 User manual Edit Measures Measures Caption Area Population Fe yen KE M Edit Measure Measure Aggregate off Aggregate Ares Sum Population Sum Calculation Display 0 Calculat Filter een een meen Caption Calculation O Aggregate of field Aggregate mean Eag Calculation formula a eee Filter C Display Format Calculation order Editor A calculable measure may have both the Calculation aggregation type and any other type If the measure has the Calculation aggregation type th
40. tCol Width rOSS View There are several styles for setting the cell width and height while creating the report ssDefault the width and height of all the cells is equal respectively to DefaultCol Width and DefaultRowHeight ssBySlice the sizes of the external grid or the cross view built in the editor are used ssAutoCol Width automatic column width calculation Column width is chosen according to the values and the numbers used The width is set in such a way that it should be enough to accommodate all the data from the column ssAutoColWidthRestrict is also a tool for automatic width calculation but in this case the maximum width is limited by the value of MaxColWidth If this value is exceeded the height of the corresponding row increases 2011 Fast Reports Inc FastCube Library Description 46 ssAutoRowHeigh automatic row height calculation Row height is chosen according to the values and the fonts used in the table It is set in such a way that it should be enough to accommodate all the data from the row on condition that column width is set as DefaultCol Width ssByMemoSize by the size of the memo objects that constitute in the TfrcCross View component in FastReport designer Changing the size of the data in the memo objects is possible only if the AutoSizeStyle property is set as ssByMemoSize Individual settings of the print layout of the cross view may be performed if necessa
41. tValueWithDimValue ADimValue Variant the value of the measure for dimensi Total ValueForDims ADimNames String total value for dimensions ADimName TDimension Caption the caption of the dimension FieldName the name of the dimension field CurrentValue the current value of the dimension CurrentCaption the caption of the current value TfcSliceField Caption the field caption FieldName the name of the field CurrentValue the current value of the field available only in the script for the filter CurrentCaption the current value available only in the script for the filter FilterCount the number of filtered values Index the field s index on the list of fields IsMeasures shows 1f the field is an measure one 2011 Fast Reports Inc 39 Fast Cube 1 0 User manual IsFiltered shows if the values of the field are filtered CanAggregate shows if aggregation is possible for this field TMeasures Items AIndex Integer an array of measures with access by index ItemByCaption AIndex String an array of measures with access by caption ItemByName AIndex String an array of measures with access by name default property Count number of measures RecordCount count of detail records Detail Value ARecordIndex Integer AFieldName String value of field in detail record Prepar
42. ts the data in the form of a grid In order to build a grid based report we need to put the TfrcCube object on the data sheet from the FastCube section Then we should either connect a data set to this object through the object inspector or type in the name of a previously created cube file TfrcCube object basic properties Dataset a FastReport data selection At the moment only TfrxDBDataset are supported FileName the file name of a saved cube Active shows whether the cube is active or not If Active True then multidimensional data structures are created inside the cube These structures are filled up either with the values from the Dataset or with the data from the cube file If Active False the cube becomes inactive and its internal structures are not filled up with anything In order to build a cross view the cube report should be active To do it set the Active property as True Also You can use TfreGrid objects as sources for TfrcCrossView TfrcGrid allow link TfcGrid component from application form with TfrcCrossView And You can print any TfcGrid objects in application Use TfrcChartView to print Chart Use TfrcChart objects to link with Chart from application forms The Cross View Object The cube data output is performed with the help of a cross view object TfrcCross View Put the FastCube cross object on the report design page 2011 Fast Reports Inc 43 Fast Cube 1 0
43. ues of Saldo that are less than 0 l begin 2 ResultWe check the Saldo SlhiceFields Saldo Current Value lt 0 values 3 end 2011 Fast Reports Inc 37 Fast Cube 1 0 User manual As a result we get the measure value which reflects the clients advance payments The calculations filter may be used both with the measures based on standard aggregate functions and with calculable measures 3 2 10 Data Export The grid may be exported by means of a standard method into files of the following types HTML MS Excel MS Word In any of these three cases the file will really be created in the HTML format Also there is an option for exporting part of the data from the grid into the clipboard In order to do this we need to select the corresponding region in the grid with the mouse or the keyboard holding down Shift and moving the cursor and then copy the selected data into the clipboard by pushing a combination of buttons Ctrl C or Ctrl insert or through the drop down menu see the picture below ee 3 249 00 320 000 1 410 00 4 00 500 00 M Data marker 5 980 00 Alignment d 16 179 00 2 Display as d Select row Select column Select all Ctrl 4 4a Copy Ctrl C 3 2 11 The Grid Toolbar The grid toolbar provides access to the main functions realized in the grid The toolbar features the following set of buttons kek save the cube to file e load a previously saved cube
44. ved conversion scheme 19 All the cube settings may be adjusted both by means of a program and by the user 20 There is an option for prohibiting the user to make any changes in the scheme 21 The user can adjust the way of displaying the results separately for each level 22 Refinement There is an option for getting a list of records of the original set linked with a certain cell in the grid The list is displayed in the form of a table the data from this table may be exported into Excel Word and HTML 23 FastCube may be used both separately and together with the FastReport FastScrip and FastQueryBuilder packages FastReport may be used in creating reports containing data from FastCube tables FastScript is used in calculating calculable measures FastQueryBuilder may be used for creating SQL queries to a database for further analysis of the received data 2011 Fast Reports Inc Chapter Examples of Use Fast Cube 1 0 User manual 2 1 This chapter includes descriptions of some examples of use of FastCube All the examples may be seen in the demo program Advanced Example Demography Let us use the data on the demographic situation in different countries as an example of using a multidimensional table The source data from analysis was taken from the free service U S Census Bureau http www census gov ipc www idbprint html After some insignificant processing we loaded the data in the cube
45. w field dimension names Column header show column headers Row header show row headers Border around cells show border around the cells Print down then across if the cross view is bigger than a page it is printed first down and then across Reprint headers on new page repeat the headers on the new pages Auto size a tool for setting the cross view cells width and height see below Properties of the cross view object TfrcCross View connected with the information ube is the data source displaying different parts 2011 Fast Reports Inc 45 Fast Cube 1 0 User manual howNames howColumnHeade howRowHeader RepeatHeaders___ Boolean aintSizes DownThenAcross Boolean S GapX GapY___ Extended o KeepTogether __ Bo a NextCross_____ I freCrossView NextCrossGap Extended PO print size May have the following values ssDefault DefaultColWidth and DefaultRowHeight are used ssBySlice by the size of the live grid built in he editor ssAutoCol Width automatic width calculation ssAutoColWidthRestrict automatic width alculation limited by the value ssAutoRowHeigh automatic height calculation ssByMemoSize by the size of the memo objects built in the object MaxColWidth Extended he width limit when AutoSizeStyle SsSAutoColWidthRestrict DefaultRowHeight Extended niform values for graphic representation of the Defaul
46. y be set for any field loaded from the original set It is not allowed to apply the filter only to the fields taking part in the calculations measures 8 Field with type Date and Time from the database are automatically subdivided and the additional fields Year Quarter Month Weekday Day Week number Day Of Year Hour Minute Second are created These fields are sorted according to their logic not as rows That is the sort order for months is January February etc 9 measures There can be one or more measures For example Sum Total at Shipment Sum Total Amount of Debt Also it 1s possible to create several measures for one source field For example Amount of Goods Shipped Maximum Amount of Goods for Shipping Also it is possible to create a cube without measures which may be useful if for example there is a need to see only the list of Clients grouped by the managers working with them It is possible to manage the way and the order in which the created measures are displayed The measures can be created in different ways in advance in a scheme via a program by the user during their work with the cube measures may be placed both on the vertical and the horizontal axis Also measures may be placed on any level of the axis There is a special measures field for setting the position of the measures The measures field works like a
Download Pdf Manuals
Related Search