Home

Get PDF - BIView

1. E Leto knjizenja t dobavitelja rimi Leto knji enja 2007 pa DatKnj St dobavitelja rednost Koli ina Spl knji na skup 7 gj VGA l tetje o Naziv dobavitelja enoti mere gt i AA Povpre je Opis artikla 01863656 f 597 Min 10000 Max 20000 varianca 30000 Standarni odklon Povpre ni odklon _ 38458653 Skewness 44127904 Kurtosis 44127914 Mediana 928 032 ea Figure 42 Right mouse button click on dimension dimension numbering 37 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide April 2014 E BlView upravljalec Nabava koli ine vrednosti Datoteka Uredi Podatki Nastavitve Izvozi O programu Kocka Graf Admin Nabava koli ine vre dnosti osve eno EEC T Letoknji enja 2007 OOOO 10000 20000 30000 38458553 44127904 44127914 Figure 43 Dimension numbering sequence 38 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide April 2014 10 Summary settings Summary settings include two fields a Summaries b Item properties E BiView upravljalec Nabava po mesecih Datoteka Uredi Podatki Nastavitve Izvozi O programu kocka Grat Jed E Si e db SK osve eno 62 2008 82355 spr E Nastavitve vsot bd P
2. S vredu X Opusti Figure 47 Sub functions moving 43 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide April 2014 10 2 Mathematical and statistical functions Summary settings Summaries amara SY zla Guantity El fv z E Sum m X Count ET E Average H JE Min H E Max H E Variance amp E Standard deviation H JE Average deviation HH Z Skewness H JE Kurtosis amp X Median t CE Sequence 5 dam PS Value excl YAT HJJE Sum H E Count ET E Average H E Min H E Max H E Variance af gt Standard deviation ET E Average deviation H E E Skewness H E Kurtosis H JE Median af JE Sequence SZ Value incl YAT Bi Sum amp m Count af gt Average amp Min a E Max m JE Variance LI Figure 48 Functions Display name Giuantity Format mask Format example 1234567 083 C Use custom settings Same settings for all d Color range 44 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide April 2014 Summary settings F3 X B Ex 4 e Display name S VIE Guentty Sum Format mask E Agg value n pac Custom width o Row rank Col rank Format example 1234567 1 fo 96 ROW Use custom settings Color range Prev row compare Prev col compare E Row cumul Sum OE Col cumul Sum mrd Prev col index o i Row cum
3. M 15 AG KO WE ESUD Eve OO c caisse ind eot abate sdb bota cba ai tob pad aret but oett tio 15 44 2 Number OF pIVOT MA Eee S o RD Rb i o eie d ad E piu as m tace ui ense Ue OA deos ea 17 T d MIB OF DIVO PONEN 18 d MORD VS 18 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide April 2014 145 Empty cell O OSMA UG sa dadas 19 ALSO Moo Oda NU 21 4 SFONTSAND COLOURS pre 21 AO REPOSITORY CONNECTION ee 22 A DET 24 S EXPORT TA WA ES S S I SE NE A RE O ES PEI ONE 24 GLABOU P AAA AAA AAA AAA AAA AAA AA AAA AAA AAA 26 7 DESCRIPTION OF BUTTONS Ka 27 8 VISUAESETTINGS FOR PARTICULAR VIEW sina k a je ee aa ee 28 O DIMENSION EDITOR ii S PC Det 28 OL DIMENSION SET NGS ae 29 PS NAME eee 29 GE ODE EE AA EEE AE AAA AWA WAA EE RR WAA 30 TTS 30 STENA 30 9 b2 3 Legend CY OG ee 30 9122 Fonts and colours cones c t PE EE a pd Deben Fb e De e podre edv Fe AA pA DER IUS 30 LSP 30 912 LON WIE HRS 31 J L EXPONO NSR 31 IA DIMENSION MEMBER Sd 32 OED E E ES WA AE E E EAE A TEE 32 PN 32 VINEN ROE OO A OO A 32 OD 4 Move SETT rOU SN 32 9 2 5 SDoW Tiltered Unftefe came eo op da KANG NS 33 TONN 33 92 ZHIide SHoWJI NN 33 ENN TO A AA AAA TG 33 9 2 9 Search by DONE Of DOR ina AA A AA AAA AAA AAA A a de tee 35 JS GROUPS EN 36 ITS IE C O NE ON A SANI WATO PASA O IE O EEA OE OO OI dv RE DA ME OL 37 NNN 37 93 3 IHVerse Me 37 934 Remove Selected ON GOD AA AA 37 55 CREOLE TIC
4. m c m BM A hb mm i Figure 9 Highest is cold Result d o o Celovska 182 1000 Ljubljana info biview com Currency Factor EA Year 2008 z Agg value 122 073 21 154 22 591 5 851 31 537 15 708 1 213 1 088 1 725 1 110 14 976 1 671 541 Value incl YAT fol COL 100 0 17 336 18 336 73 25 8 12 9 1 0 0 9 1 4 0 9 12 336 1 4 0 4 Type ie COL Group 100 096 17 3 18 3 7 3 25 9 12 9 1 0 0 9 1 4 0 9 12 396 1 4 0 4 14 BlView Reference Guide April 2014 4 3 Visibility Settings 4 3 1 Show Pivot All dimensions are shown also in the dimensions parking 4 3 2 Show Popups Menus are available on the right mouse button click 4 3 3 Show Pivot button The button hide pivot panel is visible 4 3 4 Show cell distribution pop up diagram 4 3 5 Summary Settings button Summary settings button is visible 4 3 6 Show long cube name In the upper window full cube path the refreshment timestamp and volume data kB are shown 4 3 7 Reload cube after build 4 4 Options 4 4 1 Lowest sublevel node This function enables to see three two or one level within the table You can choose SubFunction Function or Summary When the SubFunction level is chosen mathematical and statistical functions and sub functions are available on right mouse button click When the Function level is chosen only level of mathematical and statistical functions are
5. 294 597 21 154 22 301 0 031 31 637 15 706 1 219 1 080 1 729 1110 April 2014 16 BlView Reference Guide April 2014 E Posting Year b Posting Year gt Year 2008 Product Description Value Total E 589 698 594 697 TIMOTHY Assembling F 367 19 230 21 154 1968 5 MEXICO Swivel 13 22 244 22 391 1996 5 ATLANTA Wihite 5 7 344 5 551 1972 5 MUNICH Swivel F 31 637 31 537 1880 5 MOSCOW Swiv 3 15 708 15 708 1920 5 ANTYVERP Cont 2 1 218 1 218 1900 5 PARIS Guest Cr B 1 088 1 088 1896 5 ATHENS Desk 2 1 571 1 728 1925 5 AMSTERDAM Li 19 1 067 1110 1960 5 ROME Guest CF a 14 976 14 976 1976 46 INNSBRUCK St 5 1 571 1 571 70011 Glass Door B 451 541 Figure 12 Summary level 4 4 2 Number of pivot lines It is used to define dimensions button size in the cube and parking dimension u BlView Administrator Products File View Data Settings Export About Cube Graph Admin G E jg ce ide X Ka Position General Posting Group 3 Posting Month Document Humber Currency Factor 3 d Posting Year amp Product Description Posting Year Year 2008 Customer Name Product Description Quantity Value Value pa Currency Code E Sum excl WAT incl WAT Agg value X Agg value Agg value ol 96 COL ol COL Group Total UH 448 120 437 124 305 100 095 100 095 TIMOTHY Assembling Fl 367 19 230 21 154 17 0 17 0 1968 5 MEXICO Swivel
6. Fuki kuk Show all members Shee v Lock Total Figure 33 Locking the column width on a dimension 9 1 3 Expand on load If expand on load is selected all dimension members will be opened when a view will be loaded next time 31 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide April 2014 Dimension editor Customer Name Ed Dimensionsettings s i s Display name DIMR Maziv kupca Dimension members Groups Miane ox o mM Ostalo H 445544 Progressive Home Furnishings v 0000 The Cannon Group PLC e 20000 Selangorian Ltd 30000 John Haddock Insurance Co 4 32656565 amp ntarcticapy v 35451 236 Gagn amp Gaman 4 35963852 Heimilizpry ci e 40000 Deerfield Graphics Company e 421 47258 BYT KOMPLET s r a 436871 29 Designstudia Gmunden v 46887888 Enalunds Kontorsm bler AH v 4756321 B klubben v 49533563 Autohaus Mielberg KG fr 50000 Guildford Water Department Figure 34 Expand on load 9 2 Dimension members 9 2 1 Select all All dimension members are selected 9 2 2 Select none No dimension members are selected 9 2 3 Inverse all Inverses selection of dimension members before selected dimension members became unselected and the opposite 9 2 4 Move selected to group Selected dimension members can be moved to selected dimension group You can create your own dimension group
7. vrednost LARO wv Sirina stolpca o Rang vrstice Rang stolpca Format primer 1 234 557 fo OH VRS Uporabni ke nastavitve Barvanje obmo ja m KOL Obmo ja Predhodna vrsta ao icridasgirv na lestvica Maksimum FEL Predhoden stolpec pH KOL kum vsota O2 kum vsote T Skupina KOL tetje Mastavitev za podatke Povpre je Tahoma negative Min Max K Samo podatki di varianca Standarni odklon Povprecni odklon Skewness kurtozis x Mediana El vrednost z DDY NOooOONOOO MMM PM MMM A Ec 6 8 6 6 6 amp Figure 52 Custom settings and colour range menus 51 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide April 2014 E Kupec k Poz Artikel Opis A om emt i Prodajna skupina Haziv kupca rednost z DD TH ra nei ne E ol EE PIS A Haziv kupca Figure 53 Colour range settings in the table 11 Functions on mouse click Some BlView functions are available at the right mouse button click It is important where the mouse is positioned It makes sense to use right mouse button on e Dimension e Dimension members e Data e Function level in the table e Sub function level in the table 52 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide 11 1 Right mouse button click on Dimension April 2014 2 Product Description Quantity Value S Gum excl
8. Figure 35 Figure 36 Figure 38 Figure 40 Figure 41 Figure 42 Figure 43 Figure 44 Figure 45 Figure 46 Figure 47 Figure 48 Figure 49 Figure 50 Figure 51 Figure 52 Figure 53 Figure 54 Figure 55 Result d o o BULO SINUSA Pee 27 Visual settings for an individual view Product view 28 Dimension COIL ur 29 Properties in Dimension editor BlView Xplorer eese 30 NON 31 Custom WIN sus 31 Locking the column width on a dimension esses 31 Expand omo adidas e dvi Ded aridis du Riv veu ta dir ond bis ipn oa 32 New group gt Important Customers rrarnnrrnuvnnernnvnnernnsnnnnnnsnnnnnnsnnnnnnsnnnnnnsnnennnsnnennnsnneennsnnene 33 Dimension members before filtering Figure 37 Filtered dimension members 34 Dimension members before filtering Figure 39 Filtered dimension members 35 New group Created ua 36 New eroup display INA CU DG iaa adi 36 Right mouse button click on dimension dimension numbering 37 Dimension numbering sequence 10 Summary settings eese 38 SUMMA SEL UNO S id 39 New calculated SUMMATY ae 40 A ee ET 40 SUb TUNCLUONS MOVING rajas added 43 FUNCHON enaa eI UC MM E ui CRIME CH MEM 44 SODA ONCOS itp CP E ee RE 45 FMS 49 Function Same settings for all ea 51 Custom settings and colour range MENUS eeee nana 51 Colour range se
9. KOL Figure 59 Right mouse button click on sub functions For detailed explanation of specific functions please read the chapter 10 2 2 Sub functions 11 6 Right mouse button click on a view list LEE d i ou E a zj PURCHASE B Graph Purchase by F Ei Bs PILLES sa Empl L Purchase by P Fmninueel m aa Purchase Quan 77 Add to favorites a jj FINANCE Create shortcut current view Erin H B 3 Balance Sheet PE az Costs amp Expense View Info Anne e 3 NE ben Refresh Benk ind eneral Ledger E HUMAN RESOURG E Properties Lan gt Lag PRODUCTION gt iggy PLAN Gord d Linda O USE f Cube description Figure 60 Right mouse button click on a view list e Add to favorites save the current view in the list of your favorites views The same view can be added to favorites list multiple times e Create shortcut current view save current view as a shortcut on a desktop 57 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide April 2014 e View Info it opens a window with basic information about current view BTE Client Products SALES Products Id 370 refreshed 2 12 2009 12 38 49 59 94 Kb Customer Mame 14 Document Number 20 Posting Date 14 Posting Year 2 Filtered Posting Month 2 Filtered Position 5 General Posting Group 3 Product Description 24 Customer Posting Group
10. uk KLI AA 7895 389 1696 5 ATHENS Desk OMO 1900 S PARIS Guest Chair Tot 1 1088 1 o 14 nup EN SES ANTWERP Conference Tai 32 E 19288 AMSTERDAMLamp 2p 00 14 1952 W OSLO Storage Unit Shelt 1 185 23 1888 S Mexico wd Teig O aa 1968 S MEXICO Swivel Total 287 7 PLC 32656565 32656565 Antarcticopy 99 S F O 1972 S MUNICH Swivel Chair yellow 405 5 1976 W INNSBRUCK Storage Unit W Door A VJ Figure 25 Exported cube in Excel 25 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide April 2014 6 About General information about the program is displayed in this window Xplorer or Xplorer Pro version number repository company name BlView webpage About BiView Biew Administrator version 4 3 2 3 Repository ABMSS T I Result d o o Ljubljana slovenija www Beye Figure 26 BIView about window 26 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide April 2014 7 Description of buttons There are some important buttons which help users to be fast and effective working with BlView LL BlView Administrator Products File View Data Settings Export About Lube Graph Admin i amp ia c itueilidi T Products refreshed 2 12 2009 12 38 49 59 94 Kb 44 records
11. 3 Salesperson Code 2 Currency Code 5 Currency Factor 5 Type 2 Products analysis quantities value without VAT value with VAT column percentages for January 2008 Microsoft Dynamics NAV database is used Figure 61 View Info e Refresh refresh current view in BlView Xplorer it turns a saved view design e Properties it opens a Visual settings for current view e Cube description Shows a window with the description of the view If there is no file with the description of the view it displays the description that was set in BlView If there is no description set in BlView as well then this function does not displaying anything 58 Result d o o Celovska 182 1000 Ljubljana info biview com
12. The program will warn you if you don t select the group you want to move dimension members to Choose selected dimension members by Shift mouse click to make them selected for the transfer to a particular group 32 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide April 2014 Dimension editor Customer Name Ed Dimension settings Display name DIMR Naziv kupca Dimension members Groups BEBO kisene v analex mi Important Customers ye 1 445544 Progressive Home Furnishings 32655555 Antarcticopy 4 1 0000 The Cannon Group PLC v 20000 Selangorian Ltd 30000 John Haddock Insurance Co v 35451236 Gagn amp Gaman e 35963852 Heimilisprydi Z 40000 Deerfield Graphics Company v 42147258 BYT KOMPLET sr o 243687129 Designstudio Gmunden i 46897889 Englunds Kontorsm bler AB v 47563218 Klubben 486335653 Autohaus Mielberg KG 2 50000 Guildford Water Department Figure 35 New group Important Customers 9 2 5 Show filtered Unfiltered It shows either filtered or unfiltered dimension members 9 2 6 Sort by There are different possibilities for sorting e Date ascending order e Date descending descending order e Name ascending order from a to z e Name descending descending order from z to a e Database order how data were entered into the database 9 2 7 Hide show filter panel This function
13. e XML there are two options XML for MS Office XML for MS Analysis e RIF e Metafile WMF e Print e PDF e CSV e BMP By exporting views from BlView to Excel html wmf or bmp colors fonts and design remain unchanged 24 Result d o o Celovska 182 1000 Ljubljana infoQ biview com BlView Reference Guide April 2014 LE BlView Administrator Products File View Data Settings Export About Lube Graph Admin E zr b Sr Products refreshed 2 12 2008 12 38 49 59 94 Eb 44 S ig U S od ib id Kie pa Position General Posting Group Posting Month Document Humber Posting Year EA Curr Product Description Product Descri Customer Name Quantity value incl YAT Customer Name E Sum E Sum E Currency Code Agg value E Agg value ol COL Total l E 78 051 100 0 m 1885 5 ATHENS Desk 1 729 22 1900 5 PARIS Total 1 088 1 4 Guest Chair 43687128 Designstudio Gmunden 1 088 14 1906 5 ATHENS Mobile Pedestal 408 0 5 1920 5 ANTVVERP Conference Table 1 6 1928 5 AMSTERDAM Lamp 1 4 19524 OSLO Storage Unit Shelf 2 3 1960 5 ROME Guest Chair green i 19 2 1968 5 Total 28 7 MEXICO Swivel 10000 The Cannon Group PLC 0 95 elas 32656565 Antarcticopy 0 9 42147258 BYT KOMPLET sr o 26 8 1972 5 MUNICH Swivel Chair yellow i 40 5 19764 INNSBRUCK Storage Uniti Door 2 195 Figure 24 A cube in BlView Product Description AH meer
14. v 14 01 2008 w 18 01 2008 w 19 01 2008 v 21 01 2008 v 24 01 2008 v 28 01 2007 28 02 2007 4 30 04 2007 2 30 06 2007 v 31 05 2007 w 31 12 2007 Figure 38 Dimension members before filtering Figure 39 Filtered dimension members 35 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide April 2014 9 3 Groups You can work with old or new created groups in this field Mastavitve dimenzije Nabavni referent Ed Nastavitve dimenzij Prika i ime LI Razpri pri nalaganju Nabavni referent Predstavniki dimenzij B A A V K Razvrsti po menur v M Ben Miller Arvind Rao Annette Hill Figure 40 New group created E BlView klient Nabava po referentih Datoteka Uredi Podatki Nastavitve Izvozi O programu z R Nabava po referentih osve eno 31 9 2003 10 44 03 E Or K 87 74 Kb Leto 2004 5 Wabami reforont Erin Hagens 131 535 66 9775 56 595 28 85 B 584 4 475 Frank Fellow 175 514 64 195 B4 833 31 0 13196 4 875 Gordon Hee 131 635 57 89 54 593 37 2 11 400 5 01 Linda Meisner 175 514 58 195 113 180 37 5 13 404 4 475 Mikael Sandberg oF foe 40 9 113450 52 8795 13 404 5 3955 Reinout Hillmann 131 535 51 095 113 190 43 875 13 404 5 2955 Eric Kurjan 131 535 58 27 84 593 37 5 9 604 4 2955 Fukiko Ogisu Br 757 45 995 54 593 47 355 6 524 3 875 Sheela Word arar 585 595 56 595 37 895 5 533 3 7955 E
15. 13 22 244 22 391 150 150 1996 5 ATLANTA White 5 7344 6 051 PA 71 1972 5 MUNICH Swivel T 31 637 31 637 25 5 25 5 1980 5 MOSCOW Swiv 3 15 708 15 708 12 6 12 6 1920 5 ANTWERP Cont 2 1 219 1 219 1 0 1 0 1900 5 PARIS Guest Cr B 1 088 1 088 0 9 0 9 1896 5 ATHENS Desk 2 1571 1 728 1 4 1 4 1928 5 AMSTERDAM L 18 1 067 1110 09 09 1960 5 ROME Guest Cr 5 14 976 14 976 12 096 12 096 1976 46 INNSBRUCK St 5 1 671 1 671 15 15 70011 Glass Door B 451 541 0 4 0 45 1906 5 ATHENS Mobile 1 405 405 035 03 1952 44 OSLO Storage 1 1 525 1 825 1 5 1 5 Figure 13 Number of pivot lines is 1 17 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide April 2014 LE BlView Administrator Products File View Data Settings Export About Cube Graph Admin 4 4 i S mo eld se KF Wa Position General Posting Group 2 Posting Month Document Humber Currency Factor E d Posting Year amp Product Description ig Posting Year gt Year 2008 Product Description Quantity value value ZE Sum excl VAT incl WAT Customer Name zZ Add value E Agg value Agg value ol COL p COL Group rota s dnas dias 1000 1000 TIMOTHY Assembling F 367 19 230 21 154 17 0 17 0 de Hr Eed 1968 5 MEXICO Swivel 13 22 244 22 38 18 0 18 0 1996 5 ATLANTA White ta 7 344 0 051 71 71 1972 5 MUNICH Swivel T 31 537 31 537 2
16. ATLANTA White 1972 5 MUNICH Swivel 1980 5 MOSCOW Swiv 1920 5 ANTWERP Cont 1900 5 PARIS Guest Cr 1896 5 ATHENS Desk 1926 5 AMSTERDAM Li 1960 5 ROME Guest CF 1897623 INNSBRUCK Sb 70011 Glass Door mn m PD AMA MM 0 4 co i Figure 8 Highest is hot LE BlView Administrator Products 2 oe Document Humber Posting Month Value excl WAT Add value 118 205 Currency Factor ka Year 2008 Add value 122 073 21 154 22 391 5 8571 31 637 15 708 1 218 1 088 1 729 1 110 14 976 1 571 541 incl WAT ol COL 100 0 17 3 18 336 73 25 9 12 9 1 0 0 9 1 4 0 9 12 336 1 4 0 4 Type ol COL Group 100 0 17 3 18 3 75 25 9 12 9 1 0 0 9 1 4 0 9 12 3 1 4 0 4 File View Data Settings About Lube Graph Admin GE dA E Gb Export EA Position General Posting Group Document Humber 2 d Posting Year d Posting Month Product Description lia Posting Year 3 Customer Name 5 Product Description Quantity Value Currency Code Sum excl YAT gt Agg vale Z Agg value zvem EE Te ET 3 sem 1968 5 MEXICO Swivel 1 1996 5 ATLANTA White 1972 5 MUNICH Swivel 1980 5 MOSCOW Swiy 1820 5 AMTVVERP Conf 1900 5 PARIS Guest Cr 1696 5 ATHENS Desk 1928 5 AMSTERDAM L 1960 5 ROME Guest Cr 1976 4 INNSBRUCK St 70011 Glass Door
17. Figure 22 Figure 23 Figure 24 Figure 25 Figure 26 Result d o o BIViEwWw entering STE Neo 8 ENE ANO SAVE CIAL Nr 9 Choosing file name and saving position for bvc file ooonccnconocnnnnnannnnonanonnnnnaronnonanonoos 9 VIEW MEN Leese 10 Men NE 11 Create shortcut right mouse button click on view list eese 12 Ne 13 zu TE EE EE O OO 14 H ON 14 Sub function level enables selection of mathematical and or statistical sub functions 16 Function level enables selection of mathematical and or statistical functions 16 Summary evel EE RER E dc SETO d E Er E OTA 17 Numberof pivot ines AI 17 Number of poter 18 FUNCTION Word Wrap is OE selectas 19 Function Word Wai Selected sii 19 Empby call dM POE deus ueste epar icit N E Pot NET 20 Noreen cell ND AE 20 Show data info about specific Cell iuo io avi ao rea epar vum ees ad 21 CHOICE of texts TONES and STV ista tae e ecrit Ho te s Soo es 22 Selection of colours for Caption area 22 Data link properties defining provider ia 23 Data link properties defining CONNECtiON cooccnnccnncnnnonanonnnnnacnnnnnncnnnonanonnnnnnronnnnacnnnonanonnss 23 ACUDE NENNE 25 os A oi Co oM Spa Mi 25 BIVIEW about WING Wi tub ade ee QUE casi 26 5 Celovska 182 1000 Ljubljana info biview com J April 2014 BlView Reference Guide Figure 27 Figure 28 Figure 29 Figure 30 Figure 31 Figure 32 Figure 33 Figure 34
18. Figure 27 Buttons in usage Hide list Hide view list P l Refresh view list If the view table has got open E Refresh list lower levels it closes them F Close all l l It closes all open levels in the view table levels Expand all It expands all levels in the view table levels Export to It exports the view table as it is directly to MS Excel MS Excel son It enables direct It enables direct view table printing It enables direct view table printing Save current It saves current view This function is available only view in BlView Xplorer Pro Settings It opens setting menu for selected view It shows view ID refreshment time date hour E data volume dimensions in the view number of View info l l l l l dimension members for each dimension filtered dimensions TI Show all IK It deletes all filters on the view members Info about opened view View name refreshment time date hour data and last data volume loading In the bottom right corner is a slider for increasing or Increase de decreasing the font size of views gueries and the crease size view list 27 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide April 2014 8 Visual settings for particular view Visual settings for particular views have almost the same characteristics as general visual settings except that their selection affects only to a selected view The only exception
19. HUMAN RESOURCES DJ cive pe o pe Bill af Materials for Praduct MEZ az Bill af Materials for Product fag Biview Usage Figure 2 File and save menu My Recent Documents a File name ete by My Network Save as type Ble saved cmd vw Figure 3 Choosing file name and saving position for bvc file Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide April 2014 1 3 Create shortcut current view This function enables you to save current view design as a shortcut on your desktop This means that the basic view with all current changes that you have made on a view is saved The file type is also bvc You can create shortcut through the menu or with right mouse button click on view list 1 4 Exit BIView Exit from BIView 2 View lig BIView Xplorer Pro Purchase by P Employees lt gt Align columns Show all members ure y City C View Info mg e P v Show Cube Toolbar n I fi Show Graph Toolbar i 15 4 i Show Cube List Product za Employee Show Pivot IH Show History fi j Refresh FS Erin Hagens Annette Hill m Cube description NE Ben Mile REI 2 n Miller s az General Ledger Account Frank Pellow 4 IIA BECOLIBCTEC Figure 4 View menu 2 1 Align columns Shows options for aligning columns 10 Result d o o Celovska 182 1000 Lju
20. Month Max 12 31 100 You can change features to new calculated value by defining name designing format mask for numbers or defining other visual settings For details read Chapter 10 3 10 1 2 Remove the calculated sum Removes selected sums It is possible to remove only calculated sums not basic data which derive from the database 10 1 3 Select all It selects all sums 10 1 4 Select none 42 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide April 2014 It selects no sums 10 1 5 Inverse all The current choice of sums is inversed 10 1 6 Moving sub functions It is possible to change default order of sub functions If you want to change the order of sub functions back to default choose one of the functions and click the Reset order button Nastavitve vsot Vsote ET t s e Prikazano ime eee Vrednost sr Yrednost Formatna maska i T gv s st DDV v Dj iina stolpca Y redno z EE LE Predhoden stolpec Format primer 123456 7 089 Rang vrstice Rang stolpca fe VRS To KOL 145 Predhodna vrsta E VRS kum vsota o i KOL kum vsota Indeks 2 kum vsote Je Skupina VRS D Skupina KOL Stetje Povpre je Min Max Varianca Standarni odklon Povpre ni odklon Skewness Kurtosis Mediana Zaporedje koli ina Uporabni ke nastavitve Za vse enako Barvanje obmo ja HE EEA EEA HE EH E lk ti S
21. POHISTVO d o o 4 Kinnareds Tr industri AB m Moja hi a d o o Standarni adklan Povpre ni odklon Skewness Kurtosis Mediana E Mortimar Car Company WoodMart Supply Ca Result d o o Celovska 182 1000 Ljubljana info biview com Mabaya po mesecih osve eno 5 2 2003 B 23 55 15 07 Kb 38 zapisov 56 BlView Reference Guide April 2014 Figure 58 Right mouse button click on functions Please read chapter 10 2 1 Functions for detailed explanation of specific functions 11 5 Right mouse button click on sub functions m BiView upravljalec Nabava po mesecih JJ izle Datoteka Uredi Podatki Mastavitve Izvozi O programu Kocka Graf Admin BE pg Js xe H zal S Nabava po mesecih osve eno 6 2 2009 2 Qu WK 82255 1507 Kb 38 zapisov Ka Poz pa LetoKnj EA Dobavitelj Ka Spl KS pa Artikel t LA Wa MesecKnj ka Naziv E Mesecknj 5 1 12 ZI Faktura Naziv vrednost z DOW Vrednost z da DatKnj E Venta rednost E Venta E Vrednost ie KOL Rang vrstice ABC tehnologije d o o 143 41 Rang stolpca American Wood Exports 543 19 We RS APOLON Ljublj d d 199 gs mojo RRNA Si Predhodna vrsta WERKA POHISTYO d o o 2 105 2 Predhoden stolpec kinnareds Tr industri AH 35 10 YRS kum vsota Moja hi a d o o 8 0 3 KOL kum vsota ji Indeks 125 3 Martimor Car Company Ja eses WoodMart Supply o 111 3 Skupina YRS Skupina
22. Products File View Data Settings Export About Cube Graph Admin SP Products refreshed 2 12 2003 12 38 43 53 34 kb 44 o amp K GE jg ES me a records ga Position General Posting Group 5 Posting Month 2 Document Humber Posting Year Curr Product Description Product Description Quantity Value incl YA Customer Name SLIM Sum na Currency Code Agg value Z Agg value Total 481 596 693 x TIMOTHY Assembling Furniture Ja 367 21 154 Opis artikla DIMP Opis artikla 1928 5 AMSTERDAM Naziv kupca DIMH Mazi kupca Valuta 1968 5 MEXICO Swivel Chair blacl 13 2 391 DIMR Valuta Skupaj 1996 5 ATLANTA Whiteboard bas 5 8 851 Vsota Value incl VAT 1972 5 MUNICH Swivel Chair yello 7 31 537 Funkcija Sum 1880 5 MOSCOW Swivel Chai 3 1500 Fodfunkcija Agg value Ka Vrednost 1108 74 1920 5 ANTAERP Conference Tak 2 1 219 1800 5 PARIS Guest Chair black B 1 088 1886 5 ATHENS Desk 2 1 729 1928 5 AMSTERDAM Lamp 18 1110 1960 5 ROME Guest Chai 5 llas ias SE NM Show bottom k 19764 INNSBRUCK Storage Unite 5 ick Graph 70011 Glass Door 6 a 5 Show data info 1906 5 ATHENS Mobile Pedestal 1 Summary settings 1952 46 OSLO Storage UnitiShelf 1 82 189282 ST MORITZ Storage UnitD 1 3 930 Figure 19 Show data info about specific cell 4 5 Fonts and colours This function enables graphical design of
23. Reset filters eliminates all filters on numeric data 55 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide April 2014 Ouick graph shows numeric data distribution for the column you click with the mouse Values from the column are seen on the graph according to the first dimension You can move the graph to the desktop 1 BIView upravljalec Plan Rocka Graf Admin a e ie Es is m ii E e zapisov K POZ E DOK WA o d DatDok test E Izra unano 131 526 49 258 72 561 9 608 Prodajna skupina i7 Prodajna skupina Vrednost plana Projekt ifra artikla PRODAJA ADM m PROIZ Skupaj Prodajna skupina Graph Yrednost plana 1 1 NE Moe ee de EEE A EEE EEE EEE EEE a O N A A 1 vrednost plana PRODAJA ADM Prodajna skupina Figure 57 Quick graph 11 4 Right mouse button click on functions a BiView upravljalec Nabava po mesecih Datoteka Uredi Podatki Nastavitve kocka Graf Admin Izvozi programu Plan osve eno 4 5 2009 9 59 40 33 97 Kb 1 064 x I Q jig ce a K z e Me Poz FI LetoKnj FI Dobavitelj FI Spl KS Artikel U B M EI MesecHnj Naziv Meseckni 1 12 2 Ki Faktura Maziv Vrednos y a m gost z DOW vrednost z DOW Es DatKni EVs tetje Vsota vsota vred Povpre je Vrednost iii d American Wood Exports ios varianca APOLON Ljubljana d d WERKA
24. among those two visual settings is that there is no repository connection in the view visual settings because it is not needed Full detailed description for view visual settings is in Chapter 4 Visual settings Products Visual style Color Schema Font and Colors O Flat style Highest is hot 6 XP style 8 Highest is cold Show Hint Caption area BackgroundColor Label area LabelSumbolor Visiblity Settings Show Pivot Show Popups Summary Settings button Show Pivot Button Show long cube name Show cell distribution pop up Reload cube after build DimPanel area diagram Data area GridLineColar Options Lowest sublevel node Width of pivot panel Number af pivot lines ordwrap p xi Empty cell if na data Show Graph Figure 28 Visual settings for an individual view Product view 9 Dimension editor Dimension editor has made from three different content areas e Dimension settings It includes defining properties e Dimension members It enables work with dimension members sorting filtering searching choosing specific dimension members e Groups it enables opening new groups and sorting dimension members to groups 28 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide April 2014 Dimension editor Customer Name Ed Dimensionsettings LE Display name DIKMR Naziv kupca Properies expand on load Dimension members Groups BEBA O
25. e captions e labels e data e dimensions e backgrounds e label sums e gridlines You can define a text style and a background design for each of these elements By clicking text or background you are guided to text or colour menus 21 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide April 2014 Visual settings Font Fant style ize BackgroundColor I Regular Labels umb olor Aral Black raj Italic O Arial Narrow old e O Arial Rounded MT Boh Bold Italic GridLineLolor Arial Unicode M5 Baskerville Old Face Bauhaus 93 Effects Strikeout Underline nzoft Jet OLEDB 4 O Passwords Data Source LJ Color MN Black ww Script pp orando 3 Figure 20 Choice of text s fonts and style Visual settings Visual style AE Font and Colors Flat style XP style Basic colors lo E E z m E Label area Text Label5umEolor wir rw SR ice ims ine mu mu mu v Show Pivot JE EEE Show Popups se Show Pivot Button Ej z B i B m m Show cell distribution m m m m m m m Imi DimPanel area Text dagen AAA Options Caption area Text BackgroundColor Data area Text aridLineCalar alar Repository cannenctian Lowest sublevel node m m m m m m m E Provider MicrosoftJet OLEDB 4 0 Passeordz Data Source E NEN NENENENE Number of pivot lines Define Custom Colors gt gt Show startup page Show default cube 139 OF Cancel Fi
26. sm dj Sa Be ax sev 01445544 Progressive Home Furnishings 7 10000 The Cannon Group PLC 7 20000 Selangorian Ltd 30000 John Haddock Insurance Co v 32858565 Antarcticopy 7 35451236 Gagn amp Gaman 35963552 Heimilisprydi w 40000 Deerfield Graphics Company 42147258 BYT KOMPLET s r a 43687129 Designstudio Gmunden 46897889 Englunds Kontorsm bler AB v 47583218 Klubben e 49633663 Autohaus Mielberg KG 50000 Guildford Water Department Figure 29 Dimension editor 9 1 Dimension settings Dimension settings include displayed dimension name and properties dimension editor 9 1 1 Display name Dimension settings enables changing of displayed dimension name The original dimension name is written in sguare brackets you can change it by writing down a new displayed dimension name 29 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide April 2014 9 1 2 Properties Mo Dimension editor Product Display name Legend Legend type rodu Son ee Font and Colors Summary Custom summary attributes Tahoma m 8 Negative value kli P bo x i Dimension Custom dimension attributes Color Labels only WordWrap Expand Color E Custom width di gt 5 Min Max I Exactly 50 250 100 8 w Ok X cancel Figure 30 Properties in Dimension editor BlView Xplorer 9 1 2 1 Display name Displayed
27. 0 TRUNC 27 645 returns 27 41 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide April 2014 10 1 1 4 Conditional IF clause Conditional IF clause has two forms simple and complex The conditions can be nested and resolved from inner to outer The conditions are separated with brackets First form IF THEN IF condition expression if the condition is true then the expression is implemented Example IF Quantity Sum 1 3 2200 10 0 If the product of Quantity and 1 3 is higher than 200 1 then write value zero Second form IF THEN ELSE IF condition expression for condition expression for opposite condition if the condition is true then the expression for condition is implemented otherwise the expression for opposite condition is realised Comparative operators less gt higher z equal lt z less or equal gt z higher or equal lt gt not equal The example of formula which divides average per month depending of number of days in the month longer form of IF clause is used Days Sum Int Count IF Month Max 01 31 IF Month Max 02 28 IF Month Max 03 31 IF Month Max 2 04 30 IF Month Max 05 31 IF Month Max 06 30 IF Month Max 07 31 IF Month Max 08 31 IF Month Max 09 30 IF Month Max 10 31 IF Month Max 11 30 IF
28. 40 33 97 VLI 1 OCA mamisa 2 POZ DOK P oz FI DatDok Prodajna skupina 1 Prodajna skupina Vrednost plana test Projekt v EUR E Izra unano ifra artikla 4 PRODAJA 10 961 131 526 771 9 249 ADM Poka i zgornjih 49 258 PROIZ Poka i spodnjih 72 661 Skupaj Prodajna skupin 359 Podrobne informacije Nastavitve vsot Figure 56 Right mouse button click on data Show top e 1 3 5 10 shows 1 3 5 or 10 dimension members with the highest values e 5 10 25 50 75 shows only those dimension members which percentage in total value exceeds upper 5 10 Example Show top 25 shows members of which single percentage is between 75 in 100 for example 77 596 82 4 97 6 e Other you can define conditions for filtering dimension members You can define absolute values or percentages in this case include the percent sign Example show top 6 Show top 15 Show bottom e 1 3 5 10 it shows 1 3 5 or 10 dimension members with the lowest values e 5 10 25 50 75 it shows those dimension members of which single percentage in total value fall in the bottom 5 10 Example Show bottom 10 shows members of which single percentage in total value is less than 10 for example 5 1 8 6 3 5 If there are more dimensions expanded the filtering of numeric data is performed according to the first dimension left to the data the closest dimension to the numeric data
29. 5 556 25 595 1980 5 MOSCOW Swiv 3 15 708 15 708 12 6 12 6 1920 5 ANTWERP Cont 2 1 218 1 213 1 0 1 0 1900 5 PARIS Guest CF B 1 088 1 088 0 9 0 9 1885 5 ATHENS Desk 2 1 571 1 723 1 4 1 4 1926 5 AMSTERDAM Li 19 1 067 1 110 0 995 0 355 1860 5 ROME Guest CF ta 14 976 14 976 12 0 12 0 1976 46 INNSBRUCK St 5 1 671 1 671 1 3 1 5 70011 Glass Door B 451 341 0 4 0 4 1906 5 ATHENS Mobile 1 405 405 0 3 0 3 19524 OSLO Storage 1 1 825 1 825 1 5 1 5 Figure 14 Number of pivot lines is 4 4 4 3 Width of pivot panel It defines the width of dimension buttons 4 4 4 Word Wrap This function helps to wrap text when the column is shorter than the text 18 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide m Posting Year gt Product Description excl WAT gt Add value Total E 120 437 TIMOTHY Assembling 567 19 230 1968 5 MEXICO Swvive 13 22 244 1996 5 ATLANTA Whi a 7 344 1972 5 MUNICH Swiwe El 31 637 1980 5 MOSCOW Swi 3 15 708 1920 5 ANTWERP Cor 2 1 218 1900 5 PARIS Guest C B 1 088 1896 5 ATHENS Desk 2 1 571 1926 5 AMSTERDAM 18 1 067 Figure 15 Function Word Wrap is not selected lis Posting Year gt Product Description Sum excl WAT E Sad value E Agg value Total i 448 120 437 TIMOTHY Assembling l 367 19 250 Furniture January Le le 13 22 244 Swivel Chair black Lee ATLAN
30. Es Poz E Artikel E Opis Kupec knjizn a Letoknj pa Mesecknj MEN KC LetoKnj 2008 Prodajna skupina Maziv kupca E Vrednost Tal 96 KOL PRODAJA nm T ma Klubben 600 22 1 Gagn amp Gaman 450 16 5 BYT KOMPLET sro 303 11 1 Cannon Slovenija d o o 128 eit Ly d o o zn 2 1 Univerzalna zavarovalnic 43 1 6 Englunds Kontorsm bler 41 1 5 Antarcticopy 20 0 7 Designstudio Gmunden 193 Dr Progressive Home Furniz 12 0 4 Autohaus Mielberg KG E O 35 Skupaj Ee mel 100 0 Skupaj 2 721 100 0 Result d o o Celovska 182 1000 Ljubljana info biview com 50 BlView Reference Guide April 2014 Figure 51 Function Same settings for all 10 3 5 Use custom settings Use custom settings function opens the menu for data settings Because you can define data settings for selected data column you should be on sub function level 10 3 6 Colour range By choosing this function the menu for defining colour ranges is open You can define features for so called traffic lights It enables to colour selected data regarding defined characteristics Example the highest value is green the lowest value is red Define type colour and value for minimum maximum and the middle They could be defined as the percentage or value Also choose the colour for minimum maximum and the middle Mastavitve vsot E b d 2 Prikazano ime E vrednost vw E vsota Formatna maska
31. Figure 22 Data link properties defining provider ES Data Link Properties Provider Connection Advanced All Specify the following to connect to Access data 1 Select or enter a database name U VERZIJASBiVvIewDema ENG in 10 09 2003 2 Enter information to log on to the database Blank password Allow saving password Figure 23 Data link properties defining connection 23 Result d o o Celovska 182 1000 Ljubljana info Qbiview com BlView Reference Guide April 2014 Connection tab 1 Select or enter a repository database name 2 Enter information to log on to the repository database two options a blank password b allow saving password There is nothing to change on Advanced and All tabs Only Provider and Connection tabs must be defined 4 7 Default By clicking this button you assume default settings colours text style from upper level In case of user s level you assume general default settings In case of view s level you assume user s default level 5 Export This function selects export to other programs or directly to print Export possibilities are the following e MS Excel three possibilities are available to file with xls extension directly to Excel or to Excel with transformation Excel with transformation is useful in case of particular views where the final table look in Excel is defined and there are specific conditions for data transformation from BIView to Excel e HTML
32. NTA Whit e 7 344 2 8 1972 5 Expand node 6 1980 5 Move to group k 7 1920 5 Group all members below k z 1900 5 a a gt 0 Hide all dimension members below 1896 5 T Hide all dimension members excepting this 1928 5 ji ET 1 Hide this dimension member 1950 5 a Show all members 1976 W 6 70011 Copy 5 1906 5 ATHENS Mobile 1 405 4 Figure 55 Right mouse button click on dimension members e Expand node expands selected dimension member e Move to group moves selected dimension member to particular group e Group all members below groups all members below the selected member to particular group e Hide all dimension members below hides all dimension members below the selected member e Hide all dimension members except this hides all dimension members except the selected one e Hide this dimension member hides selected dimension member e Show all members in case of any filters on dimension members this function enables to show all members eliminates filters e Copy copy a dimension member s name to clipboard 54 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide April 2014 11 3 Right mouse button click on data A Bek Ls BlView upravljalec Plan Datoteka Uredi Podatki Nastavitve Izvozi O programu Kocka Graf Admin gt A Plan osve eno 4 i 2 Ar ix A gt el IK 4 5 2008 9 59
33. RESULT Ra unalni ki sistemi d o o BIVIEW REFERENCE GUIDE April 2014 BlView Reference Guide April 2014 Content MP NN 5 V FILE EE NE ER AN AR AN AAA 8 1 1 OPEN ecc aa 8 1 2 SANA PO ER A TAE PA ME tuis VE i ROA MUA EE E EO RE TEO ENE 8 1 3 CREATESHORICUTSE CORRENT VIEW eo ao eo eon aola dar nee a a ep deos odel ete 10 1 4 EEE NN 10 NENNE 10 Z TAUGN GRE ERE EE NS ENE SN EE 10 2 2 SHONEN Ee a oe a ica 11 23 MEN INO seedet 11 ZA SHOW CUBE TOR 11 Z SHOW TEN 11 AO SHOW CET a E E N 11 ZF SHOW HISTORY os 11 2 TREET 11 PANNa CSI PIN 11 BDA TA rec 12 ST SAVE DATA AND VIEW TOER 12 2 LOAD DATA ANO VIEW FROM LE ea re is 12 Deo SAVE VIEW TO PILE NE 12 S LOAD EN ROM FILE ai jo od einen n al redit ee a a acces 12 9 CREATE SHORTCUT vrede 12 ASETTINOS TN 12 TEEN 13 E ELRO EN Eco DE mta uo MU A LOREN RE O 13 LN NE 13 22000 13 421 HONESTIS TOE ERR 13 A 13 NUES ONT IA PER O O VA OE A E 13 Zi S VISIBILITY SET TINGS AFP 15 KIS o PIV Ol EN A A O Es 15 4 3 2 SOW EO DU o A ea E ES 15 4 3 S SON PD ON oit o dd 15 4 3 4 Show cell distribution pop up diagram eiiis essaie sa aane sa aane sa anna ans 15 4 3 5 Summary Settings DUEEOD sa ie 15 4 23 0 SDOW dODUCUDE NONE III 15 21 9 7 Reloda UP DN 15 TA OPTIONS ani
34. TA 3 7 344 Whiteboard base UTE Heen 7 31 637 Swivel Chair yellow 1960 5 MOSCOW l i 3 15 708 Swivel Chair red 1920 5 ANTWERP gt 1 519 Conference Table 1900 5 PARIS Guest 5 1 naa Chair black 1896 5 ATHENS Desk 2 1 571 1928 5 AMSTERDAM 19 1 DE Lamp Figure 16 Function Word Wrap is selected 4 4 5 Empty cell if no data April 2014 If this function is chosen the cell will be empty in case of no data Otherwise the symbol N P is written in the empty cell with no data Result d o o Celovska 182 1000 Ljubljana info biview com 19 BlView Reference Guide 17 Department GL Account MERCEDES TOYOTA ME FE m FE KE NE VE ho hr Mo ol m Go l G l olm a ala m LEV mim le IR O O RnLO LO m Figure 17 Empty cell if no data 1 Department GL Account MERCEDES TOYOTA Figure 18 Not empty cell if no data Result d o o Celovska 182 1000 Ljubljana info biview com Turnover ze Adi value 291 52 177 20 97 92 111 76 105 32 721 68 728 50 Turnover 2 Add value 291 52 177 20 MIP MP MP MP MIP MP MIP 37 92 111 76 105 32 721 68 728 50 April 2014 20 BlView Reference Guide April 2014 4 4 6 Show data info You can get full data info for each table cell by selecting Show data info clicking the right mouse button By moving along the cells information is changing according to the cell s content ly BlView Administrator
35. VAT Show total first gg value TIMOT Don t show total 15 230 1968 Sort by database order me 1996 Sos bynne 7 344 MEL Sort by name desc isti 1980 15 708 Sort by date 1920 1 219 Sort by date desc 1900 1 088 1896 Expand all nodes 1 571 1928 Collapse all nodes 4 067 EE Show all members kk 1976 1 871 Lock 70011 451 1906 Properties 408 1852 W OSLO Storage 1 1 825 Figure 54 Right mouse button click on dimension Show total first data summary is shown at the beginning of the selected dimension Show total last data summary is shown at the end of the selected dimension Don t show total data summary is not shown Sort by database order as data were entered into database Sort by name by ascending order from a to z Sort by name desc by descending order from z to a Sort by date by ascending order Sort by date desc by descending order Expand all nodes expand all dimension members of selected dimension Collapse all nodes collapse all dimension members of selected dimension Show all members delete filters and show all members Lock lock or unlock the custom width defined in Dimension editor Properties opens the window for specifying dimension features look Chapter 9 1 2 Properties 53 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide April 2014 11 2 Right mouse button click on dimension members 1996 5 ATLA
36. W JON Mem 37 9 30 AP EN NT 37 9 3 7 Dimension members numbering sequence ooccccccccccoooncconnnonononanoconnnnnononanocnnnnnnnnonarconnnnnnnnnanonos 37 T0 LSUMNMARIES Na kaa 39 TO LT Ad NEW calculated SUN NAN eee 39 TO IE OEM NS 41 1011 Z OPETA OSO 41 0 1 1 3 incorporated UNO ere 41 TOLEA Conditional IP Clause aa 42 10 1 2 Remove tne calculated SUI aan estne eode vao epe Te aio 42 TES 6 aie A EO EE T M TEES 42 TOS CP O 42 3 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide April 2014 10151 CIONES T WAW bad LI T 43 10 16 IVIOVING SUD TURCLIORS en ene tes EU o es ares va ua TE oe ne Pe Di or Uam Era PT uer Ded AI pP rM E SEED 43 10 2 MATHEMATICAL AND STATISTICAL FUNCTIONS via ve KERN ERO Ie A ERERE NK ER VEN ove 44 TO 2 PU OU ONS air RER EEE ERE bad eT RE tu dde aves dct Deo ido oco EN DEO OST caue 45 10 21 SUM oko E Ee opo SEE eco casa a n SAA 45 QNA BUE eo ra t POE TP 45 10213 AVOEdEE SA 46 10 2 LA Mi RO ANE 46 PO 2 15 Maas Gears 46 TO VGN Aral Ea 46 10217 Standard des 46 10 2 L8 NENNE 46 TOO NS NNN 46 TO ZET TOKU O SI aa 46 10 21 11 Media uni eni A S ne 47 VENN 47 VPN 47 10 2 2 1 Age 0 A AN AG Go EGO er re eee VEK ot ere ee ere rere ere etree 47 a 47 TOZA CO NM AMIR SNNT 47 V O dd 47 EIA O AA A EN 47 10 2 25 PREVIOUS TOW COMP MERA AE 47 10 22 Previous column Compare ve 47 10 2 28 ROW GENENE 47 10 2 2 9 C
37. a and view to file It enables saving of data and view to file with bvd extension 3 2 Load data and view from file It enables loading of data and view from file with bvd extension 3 3 Save view to file It enables saving of the view without data to file with bvp extension 3 4 Load view from file It enables loading of view without data from file with bvp extension 3 5 Create shortcut You can easily and quickly save views to your desktop by clicking the right button on the mouse on a view list The file with bvc extension is created There are two options create shortcut or create shortcut current view Create shortcut function saves as the shortcut to the view as it is The create shortcut current view function saves all the changes made on the selected view File View Data Settings Export About Prod uL F A iig g a 8 IK 4 lag ai SALES ka Position General Posting Gr Document Nun Mr ae amp Posting Year Posting Mor i 2 ABC Create shortcut current view Posting Year fl Sale View Info Product Description Quantity 4 ai PURCEAH 3 P Refresh gt Sum T LITE mi Gray Properties AJO value o Purcrisse yuan an v P tal 473 za d TIMOTHY Assembling F 387 ig CostskExpenses fil Balance Sheet 1968 5 MEXICO Swivel 13 Income Statement 1996 S ATLANTA Whit 8 fil General Ledger Accounts i 1972 5 MUNICH S T 4 fi HUMAN RESOURCES 3 Employ
38. available When the Summary level is chose there are no mathematical and or statistical functions available 15 Result d o o Celovska 182 1000 Ljubljana infoQ biview com BlView Reference Guide A Posting Year E Posting Year gt Product Description Total TIMOTHY Assembling F 1968 5 MEXICO Swivel 1996 5 ATLANTA White 1972 5 MUNICH Swivel 1980 5 MOSCOW Swiv 1920 5 ANTWERP Cont 1900 5 PARIS Guest Cr 1896 5 ATHENS Desk 1828 5 AMSTERDAM L __uuuuuuuuuuuuunuuuuuunuuuuuuunuum Figure 10 Sub function level enables selection of mathematical and or statistical sub functions ka Posting Year E Posting Year gt Product Description sener TT 1965 5 MEXICO Swivel 1996 5 ATLANTA White 1972 5 MUNICH Swivel 1980 5 MOSCOW Swiv 1920 5 ANTVVERP Conf 1900 5 PARIS Guest Cr 1896 5 ATHENS Desk 1926 5 AMSTERDAM L Figure 11 Function level enables selection of mathematical and or statistical functions Min Max Variance Standard deviatian Average deviatian Skewness kurtosis Median sequence 1 571 1 067 per Count Average Min Max Variance Standard deviation Average deviation Skewness kurtosis Median Sequence rar 1 067 Result d o o Celovska 182 1000 Ljubljana info biview com Year 0065 Add value 594 597 21 154 22 391 5 551 31 537 15 708 1 218 1 088 1 729 1 110 Year 2008
39. bers e Second part negative numbers design e Third part null values design 48 Result d o o Celovska 182 1000 Ljubljana infoQ biview com BlView Reference Guide April 2014 Summary settings Ed ES x 3 n n 4 i Display name E Quantity E E Sum Format mask E Agg value Rowe rank Col rank fo ROW COL Prev rov compare E Prev col compare E Row cumul Sum El Col cumul Sum mi Prev col index o i Row cumul e ROM Group Ai COL Group m Count x Average m X Min HEJ x Max x Variance x Standard deviation e Average deviation x Skewness H x Kurtosis Custom width o Color range MA OK x Cancel Figure 50 Format mask Example The number is 1234 5670 one thousand two hundred thirty four point 567 thousandths roo oh gt roo 49 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide For negative number 1234 5670 Format mask Display 0 0 CR 0 0 DB 1234 6 DB HHH HH 1234 56 For zero number Format mask Display 10 3 3 Custom width April 2014 This function is used to define exact width of selected column The function Align columns in the View menu is subordinated to Custom width 10 3 4 Same settings for all This function enables to define the same settings for all data columns STE Prodaja po mesecih osve eno 27 35 2009 13 36 31 17 53 kb K
40. bljana info biview com BlView Reference Guide April 2014 in BlView Xplorer Pro Purchase by P Employees File View Data Settings Export About Cube To the size of 1st column A Show all members Double size je View Info Half size Rem vo Show Cube Toolbar Default size v Show Graph Toolbar m w Show Cube List Product i Employee w Show Pivot JE Show History 4 Refresh P5 Erin Hagens e Cube description ce Ben Miller D M Figure 5 Align columns menu 2 2 Show all Members It eliminates all filters on all dimensions in a selected cube 2 3 View Info It shows cube ID date and hour of data refreshment data volume cube dimensions number of members in particular dimension and info about dimensions filtering 2 4 Show Cube Toolbar It shows hides cube toolbar 2 5 Show Graph Toolbar It shows hides graph toolbar 2 6 Show Cube List It shows hides cube list 2 7 Show History Shows view history 2 9 Refresh F5 Returns you to homepage 2 10 Cube description Shows a window with the description of the view If there is no file with the description of the view it displays the description that was set in BlView If there is no description set in BlView as well then this function does not displaying anything 11 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide April 2014 3 Data 3 1 Save dat
41. columns example comparison of quantity in this and last year 10 2 2 11 Yo row cumulative Shows the percentage of row cumulative value 10 2 2 12 Row group Shows the percentage of particular elements according to the group by rows 10 2 2 13 Column group Shows the percentage of particular elements according to the group by column 10 3 Item properties 10 3 1 Display name Name of variable is displayed You can change it Example Name of variable from database Value Display name changed Value in EUR 10 3 2 Format mask The decimal separator has to be set on decimal point even though its actual display depends on Windows language settings decimal point or decimal comma 10 3 2 1 Characters in format mask e The symbol for the thousands separator has to be always set on comma if there are two commas the number display will be in tousands lif there are three commas the number display will be in millions e The character for the numeric position in the format mask is H when you don t want leading zeros or 0 when you want leading zeros e In addition to defined characters for designing numbers you can add any other symbol which will be written beside the defined numbers The format mask could have three parts separated by semicolon First part second part third part e First part positive numbers design if the second and the third part are not present it will be valid for all num
42. dimension name You can change it 9 1 2 2 Legend There are three possibilities e No legend e Small legend e Full legend 9 1 2 3 Legend type Legend type can show filtered or unfiltered data 9 1 2 4 Fonts and colours You can define summary and dimension attributes text and background You can also define visual settings for negative dimension sum values 9 1 2 5 Word wrap You can turn on of f a word wrap function for dimension members names WordWrap Expand Color F Custom width sil E Min IM Max Exactly so E 250 100 30 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide April 2014 Figure 31 WordWrap 9 1 2 6 Custom width This function is used for defining dimension column width exactly min or and max WordWrap C Expand Color Custom width de Min Max v Exactly 50 lt 250 lt 100 Figure 32 Custom width Min the column cannot be thiner than defined Max the column cannot be wider than defined Exactly the column is wide exactly defined With right mouse click on dimension you can custom width turn on or off Employee Quantity Unit Price S Cum Cum Show total first Ern Show total last Anne Don t show total enj Sort by database order Franl Sort by name Gord ia Sort by name desc Linde Sort by date Arvin Sort by date desc Mika Reini Expand all nodes Eric I Collapse all nodes
43. ees 1980 5 MOSCOW Swiv 3 PE gi PRODUCTION 1820 5 ANTWERP Coni 2 edi Inventories 1900 5 PARIS Guest CI 6 a Bill of Materials for Product 1896 5 ATHENS Desk 2 denne p Bill of Materials For Product Figure 6 Create shortcut right mouse button click on view list 4 Settings 12 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide April 2014 Specific visual settings for particular BlView user are defined in Settings menu They are valid for all users views WM BlView Administrator Products Cube Graph Admin eji U S U ie duo EX l SALES 7 uk ita NATO DIT i d ml aur T in G Sales Ar ENE E3 az EX E ABC Cus Visual style Color Schema Font and Colors uz sales Pe O Flat style O Highest is hot Caption area i BackgroundColor Cl gaj PURCHASE CO XP style 6 Highest is cold ad FINANCE Show Hint Fi HUMAN RES Label area Labels umColor FE La PRODUCTIO Visiblity Settings aa PLAN 3how Pivot Data area GridLineColor FE gg CODE TABLE Show Popups Summary Settings button Biview Usage Show Pivot Button Show long cube name Show cell distribution pop up Reload cube after build DimPanel area diagram Options Repository connenction Lowest sublevel node Width of pivot panel C Provider MicroeoftJet OLEDB 4 0 Password Data Source Humber of preot lines wordw rap Empty cell if na data C Show startup page Show default cube 139 MIT cla
44. enables to hide show filter panel 9 2 8 Apply filter 33 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide April 2014 It helps to find quickly and easily all dimension members which contain the search string you have defined Nastavitve dimenzije Faktura Mastavitve dimenzije Faktura Nastavi Prikazi ime Prikazi ime Predstavniki dimenzij B A A O Y Rasto menur Predstavniki dimenzij B LD Q Y x i Rezt po merid pp k As 9 108001 7 108010 v 108011 7 108012 7 108013 9 108014 7 108015 fv 108016 v 108017 7 108018 7 108019 Figure 36 Dimension members before filtering Figure 37 Filtered dimension members 34 Result d o o Celovska 182 1000 Ljubljana info Qbiview com BlView Reference Guide April 2014 9 2 9 Search by part of name This function helps you to find all dimension members which name starts with the search string Nastavitve dimenzije Datknj Mastavitve dimenzije DatKnj Nastavit Nastaviti Prika i ime Prikazi ime Datknj Datkni Predstavniki dimenzij Predstavniki dimenzij aaa Q v imeem menu eH BAA Q v Razvrsti pomenur v 19 27 01 01 2007 fs 01 01 2007 ao 022007 02 2007 sr 01 03 2007 01 03 2007 4 01 04 2007 7 01 04 2007 epe 05 2007 v 0 05 2007 06 2007 v m ne 2007 v D2 01 2008 n5 01 2008 vw 08 01 2008 v 13 01 2008
45. etje Povpre je Min Max varianca standarni odklon Povpre ni odklon Skewness Kurtosis Mediana Figure 46 Formula edit Result d o o Celovska 182 1000 Ljubljana info Qbiview com April 2014 40 BlView Reference Guide April 2014 10 1 1 1 Formulas A formula consists of variables constants and or incorporated functions and operators Variables are numeric fields which are offered in formula editor Quantity Sum Quantity Count constants are numbers If a number is decimal then dot is used 10 1 1 2 Operators star multiply divide gt add countdown equal sign Example Quantity Sum 1 3 Quantity is multiplied by 1 3 Quantity is multiplied 1 5 Quantity Sum 1 3 100 Quantity Count 205 45 10 1 1 3 Incorporated functions SIN X calculates sinus x COS X calculates cosines x EXP X calculates exponential function LOG X base JBaza A ROUND X base rounds number X to the closest number divided with the number base If the Base is not defined then it rounds to the highest integer ROUND 24 10 returns 20 ROUND 24 634 returns 25 POWER X base calculates number X on potency Base Rezultat X 722 TRUNC X Base cuts the number to integer and divides it to base If there is no base then it only cuts of the number TRUNC 27 10 returns 2
46. gg value E Agg value ol COL zl Graph Purchase by Total 481 596 693 100 090 i Purchase by F Empl TIMOTHY Assembling Furniture Ja 21 154 3336 Purch tit ha 9 Purchase Quantity a 1968 5 MEXICO Swivel Chair blacl 22 391 35 laa FINANCE aa CostskE xpenses 1996 5 ATLANTA Whiteboard bas 6 051 1 5 3 Balance Sheet 1972 5 MUNICH Swivel Chair yello 31 637 53 15 708 2 6 3 Income Statement 1880 5 MOSCOW Swivel Chair rei 3 General Ledger Acct 1 219 0 295 1 088 0 296 Qu OI m di co Bm A mM Ow OC Ci FA HUMAN RESOURCES 1920 5 ANTWERP Conference Tak 63 Employees 1900 5 PARIS Guest Chair black Gia PRODUCTION 1896 5 ATHENS Desk 1 729 0 3 l Inventories zl Bill of Materials for Fr 1926 5 AMSTERDAM Lamp 1 110 0 25 gl Bill of Materials For Pr 1960 5 ROME Guest Chair green 14 976 25 E za PLAN 1976 14 INNSBRUCK Storage Unit 1 671 0 3 gl Flan Turnover c i CODE TABLE 70011 Glass Door 0 1 gl Business Partner Cor 1906 5 ATHENS Mobile Pedestal 0 1 49 Biview Usage 195234 OSLO Storage UnitiSheli 0 3 195285 4 ST MORITZ Storage Uniti 0 795 1964 INNSBRUCK Storage Unit 6 0 18882 CALGARY Whiteboard ye 0 5 Figure 1 BIView entering screen 1 File This menu has the following functions 1 10pen Open file in bvp or bvc form File type bvc contains view connection from database or from file and view This possibilit
47. gure 21 Selection of colours for Caption area 4 6 Repository connection In the repository connection you have to define a data provider and a repository database repository mdb After specifying the connection you should verify it by test connection button Test connection 22 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide April 2014 Visual settings E Data Link Properties E Fant and Colors Caption area Text BackgroundColor Provider Connection Advanced All Select the data you want to connect to ste eyes Text LabelSumbolor OLE DB Provider s Microsoft ISAM 1 1 OLE DB Provider Data area Microsoft Jet 4 0 OLE DE Provider Microsoft Office 12 0 Access Database Engine ULE DB Pro Microsoft OLE DB Provider for Analysis Services 9 0 DimPanel area Microsoft OLE DB Provider For Data Mining Services Microsoft OLE DB Provider for DTS Packages Microsoft OLE DB Provider for Indexing Service Repository conmenction Microsoft OLE DB Provider for Internet Publishing Microsoft OLE DB Provider for ODBC Drivers Microsoft OLE DB Provider for OLAP Services 8 0 Microsoft OLE OB Provider for Oracle Microsoft OLE DB Provider for SUL Server Microsoft OLE DB Simple Provider Show startup page MSD ataShape ULE DB Provider for Microsoft Directory Services SOL Native Client 4 MI Text ErndLineColor m Text Show default cube 133
48. its statistical dispersion indicating how far from the expected value its values typically are The variance is the average of the square differences from the mean 10 2 1 7 Standard deviation otandard deviation is a measure of the dispersion of a set of data from its mean The more spread apart the data the higher the deviation Standard deviation is calculated as square root of variance 10 2 1 8 Average deviation The average deviation or the average absolute deviation is a measure of dispersion It is the average of absolute deviations of the individual values from the median or from the mean 10 2 1 9 Skewness Skewness measures the lack of symmetry of a probability distribution A curve is said to be skewed to the right or positively skewed if it tails off toward the high end of the scale right tail longer than the left A curve is skewed to the left or negatively skewed if it tails off toward the low end of the scale Skewness of the distributions whose density is symmetrical around the mean is zero The reverse is not true there are asymmetrical distributions with zero skewness The skewness of a distribution is equal to its 3rd central moment divided by the 3rd power of the standard deviation Skewness characterizes the shape of a distribution that is its value does not depend on an arbitrary change of the scale and location of the distribution 10 2 1 10 Kurtosis Kurtosis measures the heaviness of the tails of a distribu
49. nota 1 Ben Miller 131 535 57 6 84 593 37 1 12113 5 395 Arvind Rac ar rar Fa 28 288 23 6 3 5600 3 295 Annette Hil 131 635 68 1 56 595 29 3 5 091 2 6 Skupaj Enota 1 351 028 64 5 159 785 31 3 1 004 3 9 Skupaj vsi 1 491 667 8 0 962 115 37 4 116 356 4 5 Figure 41 New group display in a cube 36 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide April 2014 9 3 1 Select all It selects all dimension groups and dimension members which are in defined groups 9 3 2 Select none None of the groups and dimension members is selected 9 3 3 Inverse all Current selection of groups is inversed 9 3 4 Remove selected from group It removes selected members from the group back to unselected dimension members 9 3 5 Create new group It creates new dimension group 9 3 6 Delete item You can delete particular element from the group or the total group In case of deleting total group all group members are returned to ungrouped dimension members 9 3 7 Dimension members numbering sequence Choose Sequence function which will number all dimension members BlView upravljalec Nabava koli ine vrednosti m DX Datoteka Uredi Podatki Nastavitve Izvozi O programu Kocka Grat Admin S Mabava koli ine vre IK dnosti osve eno ALO aa d nmn nn r MesecKnj t fakture d Knji na skup dobavitelj s
50. olumi cumula tive SN NNN 47 10 2 2 O Previous column de SG 48 1022 ET Yo TOW CUMU d IVO es nra terre Er ve eat lll cet over d ena ae a ea Sete Eee tl bi 48 102 212 RON 48 102218 Toms AAA Ra CUPS EUR SAI EG a AAA 48 10 3 ITEM PROPER TIES sad see E ovde bind Ep x tuu Venen OT nex PRU Dp E RO ENS 48 VINNE 48 DO LF A a ASA NRA OR Lead Saad ala hale 48 10 3 2 1 Characters ip orala orc scene sans Ove oe desc baud er 48 VII Custom WI eee 50 10 3 7 Same Settings OPONE ve a Pageov adie 50 TOS SSE CUSTOM ENN 51 105 6 CO NN Eee 51 11 FUNCTONS ON MOUSE CLICK aaa 52 11 1 RIGHT MOUSE BUTTON CLICK ON DIMENSION taa 53 11 2 RIGHT MOUSE BUTTON CLICK ON DIMENSION MEMBERS c esses ener sne see see nete ses esses eese sees ease n nis 54 11 3 RIGHT MOUSE BUTTON CHICK ON DATAS ins sets ba OS ER EUR USE RI ER HE tv eR eno bed s P kej nb qup NOE V xp ERO EA IE ONE ES 55 11 4 RIGHT MOUSEBUTTON CHCICON FUNCTIONS SSG 56 11 5 RIGHT MOUSE BUTTON CLICK ON SUB FUNCTIONS cesses enne nennen shes senses shares see see senses ee asses sees esses seas 57 11 ORIGHTMOUSEBUTTON CHCK ON A VIEW IS AA 57 4 Result d o o Celovska 182 1000 Ljubljana infoQ biview com BlView Reference Guide Index of figures Figure 1 Figure 2 Figure 3 Figure 4 Figure 5 Figure 6 Figure 7 Figure 8 Figure 9 Figure 10 Figure 11 Figure 12 Figure 13 Figure 14 Figure 15 Figure 16 Figure 17 Figure 18 Figure 19 Figure 20 Figure 21
51. rikazano ime H TE rednost FE fu Vrednost z DDV Farmatna maska Format primer 1234567 0859 L Uporabni ke nastavitve Za vse enako Barvanje abmacja f vredu ML opusti Figure 44 Summary settings 10 1 Summaries This part of summary settings is used for managing existing numeric data preparing new calculations and choosing between statistical and mathematical functions 10 1 1 Add new calculated summary By clicking this button you can create new calculated summary First define new summary name and then edit the formula of calculated summary In the formula editor you have available metric data which come directly from the database You can combine them with different numbers for multiplying dividing subtracting dividing by 3 multiplying by 1 2 39 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide Nastavitve vsot Prikazano ime rednost brez DDY El Je rednost mE vrednost z DDY Formatna maska a M Vrednost brez DD O irina stolpca Format primer 12345657 188 Uporabni ka formula ZA Uredi formula TI Uporabni ke nastavitve za vse enako Barvanje obmo ja Figure 45 New calculated summary Prikazano ime B z Vrednost brez DDY e JE Vrednost it MET Vrednost z DDv Formatna maska Format primer 1 234567 089 Uredi formulo BHA rednost z DD 2 Uredi formulo astavitve Za vse enako L Barvanje obmo ja Vsota t
52. rison with previous column row cumulative summary column cumulative summary previous column index percentage of cumulative summary percentage of row group or percentage of row column 10 2 2 1 Agg value It presents absolute value which could be positive or negative 10 2 2 2 Row rank Shows order of dimension members according to their value by rows If two dimension members have the same value they have the same rank 10 2 2 3 Column rank Shows order of dimension members according to their value by column If two dimension members have the same value they have the same rank 10 2 2 4 ROW Expresses how large small one dimension member s value is relative to summary value summary of all dimension members values by rows 10 2 2 5 COL Expresses how large small one dimension member s value is relative to summary value summary of all dimension members values by column 10 2 2 6 Previous row compare Shows the difference comparing to the previous row 10 2 2 7 Previous column compare Shows the difference comparing to the previous column 10 2 2 8 Row cumulative sum Shows cumulative sum by rows 10 2 2 9 Column cumulative sum Shows cumulative sum by column 47 Result d o o Celovska 182 1000 Ljubljana infoQ biview com BlView Reference Guide April 2014 10 2 2 10 Previous column index Index is a number or ratio a value on a scale of measurement derived from a series of observed facts a comparison is made by
53. ss Door z IE 1906 5 ATHENS Mobile 1 408 408 0 195 1952 46 OSLO Storage 1 1 525 1 525 0 5 Figure 7 Visual settings menu 4 1 Visual style 4 1 1 Flat style Simple graphic style no colour shading no edge rounding 4 1 2 XP style Opposite to flat style Advanced graphic style and possibilities are available colour shading edge rounding 4 2 Colour schema 4 2 1 Highest is hot The highest value in the column under the mouse changes colour to red and the lowest value to green The fileds with values between the two change to third colour 4 2 2 Highest is cold The highest values in the column under the mouse changes colour to green and the lowest value to red The fileds with values between the two change to third colour 4 2 3 Show hint If you position the cursor on a column for at least 2 seconds the fields automatically change colour depending on the chosen colour for the highest values hot cold 13 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide April 2014 BlView Administrator Products File View Data Settings About Lube Graph Admin AEA ES Position amp Product Description 1 Export S k e ld General Posting Group Z EA Posting Year EA Posting Year 5 Product Description Guantity E Sum Customer llame WA Currency Code Add value TIMOTHY Assembling F 1968 5 MEXICO Swivel 1 1996 5
54. tion in compared to a normal distribution Kurtosis is positive if the tails are heavier then for a normal distribution and negative if the tails are lighter than for a normal distribution The normal distribution has kurtosis zero Kurtosis characterizes the shape of a distribution that is its value does not depend on an arbitrary change of the scale and location of the distribution The kurtosis of a distribution or sample is equal to the 4th central moment divided by the 4th power of the standard deviation minus 3 To calculate the kurtosis of a sample i Subtract the mean from each value to get a set of deviations from the mean ii Divide each deviation by the standard deviation of all the deviations iii Average the 4th power of the deviations and subtract 3 from the result 46 Result d o o Celovska 182 1000 Ljubljana infoQ biview com BlView Reference Guide April 2014 10 2 1 11 Median Median is described as the numeric value separating the higher half of a sample a population or a probability distribution from the lower half 10 2 1 12 Sequence Sequence is an ordered list of objects or events and enables information about number of dimension members It accounts dimension filters 10 2 2 Sub functions After you select one of the functions you can also select between the following sub functions agg value row rank column rank row value row percentage column percentage comparison with previous row compa
55. ttings in Ne table aar 52 Right mouse button click on dimension aaa 53 Right mouse button click on dimension members nee 54 6 Celovska 182 1000 Ljubljana info biview com April 2014 BlView Reference Guide April 2014 Figure 56 Right mouse button click on data eese nnne nnns 55 Figure 57 QUIE SN cess a ei s et A LA E dU e tu ue 56 Figure 58 Right mouse button click on TUNCHIONS ccccoooccnnonnocnnnnnaconnnnnnonnonononnnonacnnnonanonnnnnnccnnonanonnos 57 Figure 59 Right mouse button click on sub fUNCHIONS occccconccnncnnncnnnnnanonnnonaconnnnnonononanonnnonaronnnnanonnos 57 Figure 60 Right mouse button click on a view liSt oooooonccnconocnnnonaconnnnnacnnnonaronnonanonnnonaronnnnanonoos 57 Feure SL VEN aoc ct cH cH 58 7 Result d o o Celovska 182 1000 Ljubljana infoQ biview com BlView Reference Guide April 2014 1p BlView Administrator Products SEE File wiew Data Settings Export About Cube Graph Admin u TF Products refreshed 2 12 2003 12 38 43 53 34 Kb 44 zx e JA recorda F osa EJ xg alg lij SALES En Position General Posting Group Z Posting Month Document Humber 54 gl Sales Areas GJ Product 8 3 ABC Customer Analy Product Description Product Description E value incl VAT 3 Sales Persons Customer Name E Sum E Sum za padatke cC Codi 2 fig PURCHASE ve urrency Code E A
56. ul Ue ROW Group Ni COL Group Count Z Agg value Row rank Col rank de RO F COL Prev row compare Prev col compare Oz Row cumul Sum o i Col cumul Sum mr Prev col index r 96 Row cumul Je 9b ROW Group Dit COL Group x Average m X Min EJ x Max EJ x Variance Figure 49 Sub functions BlView includes a number of mathematical and statistical functions for every value category Two levels of functions exist On the first level you choose between functions sum counting average min max variance standard deviation skewness kurtosis or median In this level the sum is the most frequently used On the next level you can choose the form of data from the previous level choose sub functions You decide whether you analyse data as number index cumulative Here you can choose between different sub functions 10 2 1 Functions 10 2 1 1 Sum Individual values of dimension members are expressed absolutely and summarized 10 2 1 2 Count Counts how many times one specific member appears in the database 45 Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide April 2014 10 2 1 3 Average It shows the average value of dimension members 10 2 1 4 Min It Shows minimum value of single dimension member 10 2 1 5 Max It Shows maximum value of single dimension member 10 2 1 6 Variance The variance of a random variable is a measure of
57. y enables easier saving of single views on the desktop 1 2Save Save command file bvc Select file name and directory All information needed to reopen the same view is saved in the command file repository view and view settings All information is saved into local disc in My documents BIView Cubes and My documents BlView Pivots Example Bvc content view with ID 512 and appearance C Documents and Settings Johan My Documents BIView Pivots 512_scc2007 bvp which is automatically created by BlView lt Configuration gt lt Cube Ol 512 MAXIMIZE 0 gt Result d o o Celovska 182 1000 Ljubljana info biview com BlView Reference Guide April 2014 VF lt CDATA C Documents and Settings Johan My Documents BiView PivotsV512 scc2007 bvp gt NF lt Cube gt lt Configuration gt View Data Settings Export About Open zne i 4 tej YA Prod E a y Create shortcut current view a Eg er NR Document nun Posting Year 4 Posting Mor Product Descriptic i Posting Year Customer Name Product Description Quantity fia Graph Purchase by P Em Agg value Fri Purchase Quantity and Va 473 1 1 a zaj PURCHASE bes Fri Purchase by P Employee Currency Code ci 4 ga FINANCE TIMOTHY Assembling F 367 Poe GE Casts amp Espenses B pee r CB kreme Sleme MEZ az General Ledger amp ccounts 1872 5 MUNICH Swivel ri a yz

Get PDF - BIView

Contents

Download Pdf Manuals

Related Search

Related Contents