Home

Kyubit Business Intelligence OLAP analysis

1. Now we have to set which drillthrough columns we want to see by clicking on the Set drillthrough columns New window will open Drillthrough columns definition in which we select drillthrough columns from all available dimension hierarchies that are associated with measure group to which drillthrough measure belongs to Which dimensions are associated with which measure group is implicitly set inside cube structure In the Drillthrough columns definition browse for interesting dimension hierarchies columns on the left side of screen Tree view and click on interesting for your drillthrough After we click on it it will be shown in the list of selected columns on the right side of screen We can add remove or change order of columns After all columns are selected we would like to see for our drillthrough Run drillthrough button should be clicked Drillthrough columns definition window will close and in window Drillthrough results drillthrough will be executed and results will be displayed Depending on the number of result items drillthrough could take a While before is finished Drillthrough result table could be sorted by clicking on the column header and could be exported to Excel file User can redefine drillthrough columns to return as many times he likes OLAP Analysis with AnalysisPortal User manual www kyubit com support Q kyubit com 33 Kyubit Business Intelligence OLAP Analysis User manual
2. 1 161 646 73 33 758 43 28 608 84 30 516 10 28 036 66 32 804 80 28 799 57 30 134 64 26 701 58 9 427 24 10 301 93 8 552 54 7 872 23 3 147 56 2 850 62 3 266 34 3 385 12 3 800 83 Touring 3000 Yellow Touring 3000 Yellow Touring 3000 Yellow Touring 3000 Yellow 2 791 24 Touring 3000 Yellow 2 969 40 Sum 307 584 08 2 265 451 62 Clothing 27 181 81 Sum I 2 348 694 23 53 503 89 3 503 89 52 850 62 3 4 Expand member different dimension hierarchy To expand values and show members of other dimension hierarchy drag all dimension hierarchies to the same axis Categories or Series and click expand desired members It is possible to drag multiple dimension hierarchies to the same axis and on that way expand values from one hierarchy to another For example we could first drag Countries hierarchy and then Product hierarchy On that way first we would see values for all countries and then by expanding USA we would see Product categories sold in USA Expanding members with single or different dimension hierarchies could be combined and performed on both axes separately within same analysis giving powerful and fast option to analyze data from OLAP cube Internet Tax Amount 56 060 80 708 164 02 37 376 65 4 906 11 11 540 94 CY 2007 9 074 16 CY 2008 11 428 46 Sum Z 36 949 67 24 227 81 Category Education Calendar Year Accessories Country Australia Bachelo
3. Drillthrough columns definition Manage columns to return in drillthrough results a Permissions More Details operation Sales Available columns Defined columns to return in this drillthrough action ul Measures ai Amount KE Channel Product Name Le Currency Sales Unit Price IZ Date IZ Employee L Entity LZ Geography Product aa Product Available For Sale Date aa Product Brand Name aa Product Category Description aa Product Category Name aa Product Class Product Color Up OW Define Link aa Product Description EE Product Image URL EE Product Label aa Product Manufacturer aa Product Name aa Product Size Range 7 2 Drillthrough results links Drillthrough results could contain links that would lead us to some site application which would show us anything related to drillthrough data For example we could see for each work order its details in time tracking application which exists on our intranet To set up links in drillthrough results in Drillthrough columns definition while defining which columns to return in drillthrough click on the desired column to highlight it and then click Define link button New window will open Drillthrough column link which allows us to define link for selected column In the field Link HREF we write URL to some resource available by HTTP protocol and for variable query string element click on the some dimension hierarchy on the left For example defi
4. 26 985 36 523 34 Z 28 478 12 Loir et Cher 713 38 9 775 88 10 665 56 I 20 441 44 318 92 I 21 473 74 Pas de Calais 558 77 3 629 47 5 704 89 1 214 85 Z 10 549 21 234 94 Z 11 342 92 Clothing Sum Touring Bikes Sum Country vl State Province v t Germany France Sum United Kingdom Canada Australia United States Sum Z 63 406 78 76 630 04 103 377 85 138 690 63 256 422 07 Z 700 759 96 899 260 71 1 162 980 29 615 440 40 2 853 819 45 3 417 457 74 5 9 952 759 56 1 311 933 10 1 598 217 48 935 616 29 5 004 548 42 4 289 925 90 Z 14 520 584 04 Z 342 381 90 521 644 89 270 245 70 993 682 14 1 292 475 90 Z 3 844 801 05 2 553 575 71 3 282 842 66 Z 1 821 302 39 8 852 050 00 Z 8 999 859 53 Z 28 318 144 65 Z 27 035 22 32 239 51 53 164 62 70 259 95 133 507 91 Z 339 772 61 5 2 644 017 71 5 3 391 712 21 Z 1 977 844 86 9 061 000 58 9 389 789 51 Z 29 358 677 22 aa Country v1 State Province rT Germany France Seine Paris Nord Internet Sales Amou Seine Saint Denis Essonne Yveline Category Subcategory v Internet Sales Amou Internet Sales Amou Internet Sales Amou Internet Sales Amou internet Sales Amou Accessories Mountain Bikes Road Bikes Bikes Touring Bikes Sum Clothing Sum 62 232 59 1 003 800 98 1 380 342 85 424 370 52 Z 2 808 514 35 23
5. 3 391 712 21 Australia 5138 690 63 8 852 050 00 570 259 95 z 9 061 000 58 United States 5256 422 07 8 999 859 53 5133 507 51 Z 9 389 789 51 Sum I 5700 759 96 I 28 518 144 65 I 5339 772 61 1529 558 677 22 Sorting with selected member on opposite axis Grid sorting definition for Rows Sort by Internet Sales Amount Optional Sort using values in Columns Sort order Asc a Category Accessories Bikes Clothing Sum a Country Internet Sales Amou Internet Sales Amou Internet Sales Amou Internet Sales Amou Germany 562 232 59 52 808 514 35 523 565 40 I 52 894 312 34 France 63 406 78 52 553 575 71 27 035 22 5 2644 017 71 United Kingdom 576 630 04 53 282 842 66 532 239 51 E 53 391 712 21 Canada 103 377 85 1 821 302 39 53 164 52 I 1977 844 86 Australia 138 690 63 8 852 050 00 570 259 95 I 59 061 000 58 United States 256 422 07 55 999 59 53 5133 507 91 I 59 389 789 51 Sum I 5700 759 96 I 28 518 144 65 I 5339 772 61 1529 558 677 22 OLAP Analysis with AnalysisPortal User manual www kyubit com support O kyubit com 16 Kyubit Business Intelligence OLAP Analysis User manual 3 10 Sorting members on a particular dimension level Grid analysis has options to set sorting for each added dimension level individually For example one level could be sorted for one measure values other for different measure values and third could be sorted alphabetically Click the arrow beside added dimension level level contex
6. 565 40 5 2 894 312 34 13 160 02 186 654 01 276 410 85 57 671 49 Z 520 736 35 5 829 43 I 539 725 80 9 894 27 131 668 22 194 250 41 50 586 48 376 505 11 5 000 82 391 400 20 59 894 58 127 047 32 176 574 67 61 540 26 365 162 25 4 422 92 Z 379 479 75 55 243 89 83 601 34 149 604 96 38 033 73 Z 271 240 03 2 813 26 279 297 18 5 561 12 89 671 50 137 141 12 34 547 64 Z 261 360 26 1 743 42 Z 268 664 80 3 12 Grid values in percentage While analyzing in Grid view it is possible to see values expressed in percentage for each member on the Categories or Series axis Percentage could be shown for each row total sum of all members on Series axis or for column total sum of all members on Categories axis To select percentage view right click on the Grid empty area After menu shows up click on the View Rows Percentage or View Columns Percentage action a Country l State Province t Internet Sales Amou Germany 9 86 France 9 01 11 55 British Columbia 6 66 United Kingdom Alberta 0 08 Ontario 0 005 Sum 6 74 30 856 31 98 Sum 100 00 Canada Australia United States OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 18 Kyubit Business Intelligence OLAP Analysis User manual 3 13 Create and manage ad hoc User Named sets While analyzing data with grid analysis any user could use
7. 62 France 2 644 017 71 amp Set Column Sorting Germany 2 894 312 34 Show Hide Empty Series United Kingdom 3 391 712 21 United States 3 7 2 Show hide empty rows Pivot 9 389 789 51 Avg Ave 4 893 112 87 Create User Calculated Measure View Values View Column Percentage View Row Percentage In some situations while in grid analysis it will be convenient to customize grid column width for best grid visual perception User can select five different column with parameters from Small to XXL Column width will be saved together with analysis OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 12 Kyubit Business Intelligence OLAP Analysis User manual a Country a State Province Internet Sales Amount _ ee 9 061 000 55 gD Alberta 22 467 80 British Columbia 1 955 340 10 Set Aggregates Ontario 36 96 Avg Ave 659 281 62 France 2 644 017 71 Set Row Sorting Germany 2 894 312 34 Set Column Sorting United Kingdom 3 391 712 21 United States 9 389 789 51 Avg Ave 4 893 112 87 Pivot Canada Set Column Width Show Hide Empty Series Extra Large Create User Calculated Measure View Values View Column Percentage View Row Percentage Show All KPI s Clear 3 8 Filtering grid analysis data Drag and drop dimension hierarchy to filters area and narrow analysis to a particular point of interest Multiple filters could be selected
8. 630 04 5256 422 07 I 700 759 96 New Cube Reference Bikes Internet Sales Amou 5 388 717 92 1 052 870 20 1 858 062 01 52 049 498 51 2 399 665 29 55 772 613 54 E 18 521 427 47 Clothing Internet Sales Amou 70 259 95 553 164 62 27 035 22 523 565 40 32 239 51 5135 507 91 5 5339 772 61 Sum Internet Sales Amou I 55 597 668 50 I 51 209 412 67 F 1 948 504 01 I 52 135 296 50 I 52 508 534 84 I 56 162 543 52 I 19 561 960 04 OLAP Analysis with AnalysisPortal User manual www kyubit com support O kyubit com 7 Kyubit Business Intelligence OLAP Analysis User manual 3 2 Grid Analysis concepts Most common way of OLAP data analysis in Kyubit Business Intelligence application is Grid Analysis Drag and drop measures hierarchies levels from OLAP cube tree structure to grid areas on the right side to analyze OLAP data Following areas exist for grid analysis Cube structure Tree Categories area Axis Series area Axis Measures area Filters area Values area Kyubit Oy AnalysisPortal New Analysis Menu Analysis Grid Chart Analysis Adventure Works gil Measures l Customer l2 Date 4 Delivery Date Li Employee L Geography l Internet Sales Order Details l Product l Promotion l Reseller l Reseller Sales Order Details 4 Sales Channel l Sales Reason lZ Sales Summary Order Details l Sales Territor
9. Hydration Packs Tires and Tubes Sum Clothing Mountain Bikes Road Bikes Touring Bikes Caps Gloves Jerseys Shorts Socks Vests Sum 240 00 27 96 21 98 34 99 89 53 I 414 46 2 294 99 14 022 43 55 510 49 I 21 827 91 17 98 24 49 103 98 69 99 58 99 5 225 43 Z 22 467 80 6 840 00 5 088 00 7 645 21 1 160 70 8 748 04 28 061 98 6 158 88 39 223 62 102 926 43 613 145 41 921 593 86 264 735 21 5 1 799 474 48 2 157 60 6 073 52 21 773 77 16 237 68 791 12 5 905 50 52 939 19 1 955 340 10 7 080 00 5 088 00 7 683 16 1 160 70 8 792 00 Z 28 096 97 Z 6 158 88 I 39 318 14 103 377 85 I 615 440 40 Z 935 616 29 270 245 70 1 821 302 39 5 2 175 58 6 098 01 5 21 877 75 5 16 307 67 I 800 11 5 905 50 Z 53 164 62 I 1 977 844 86 3 6 Drill down member On a category axis it is possible to drill down certain member if it is a root category level member Right click member and select Drill down Bikes Bikes member will be automatically added to filters and level bellow will show members related to selected Bikes member aul Internet Sales Amount a Category Subcategory Internet Sales Amou Accessories 700 759 96 Bikes Expand all members Clothing Sum Drill down Bikes Isolate Bikes TY Product Categories Bikes nil Internet Sales Amount Internet Sales A
10. Value 5 Remove Close Drop Series Here a Country 7 Internet Sales Amou United States S9 389 789 51 Australia 9 061 000 58 United Kingdom 53 591 712 321 Germany 52 894 312 34 France 52 644 017 71 Sum I 27 380 832 356 OLAP Analysis with AnalysisPortal User manual www kyubit com support O kyubit com 15 Kyubit Business Intelligence OLAP Analysis User manual 3 9 Sorting all members on grid axis Grid analysis data could be sorted on axis level and on particular dimension level added to grid analysis To sort all members on an axis right click on grid analysis and select Set Row Sorting or Set Column Sorting Choose to sort by one of added measures or alphabetically If you wish to sort data using measure values optionally it is possible to select member on opposite axis upon which values sorting will be perform If opposite member is not selected sorting will be done by measure total on opposite axis Grid sorting definition for Rows Sort by Internet Sales Amount Optional Sort using values in Columns Sort order Asc a Category Accessories Bikes Clothing Sum a Country Internet Sales Amou Internet Sales Amou Internet Sales Amou Internet Sales Amou Canada 105 577 85 51 821 302 39 553 164 62 I 51 977 844 86 France 63 406 78 52 553 575 71 27 035 27 F 2 644 017 71 Germany 562 232 59 52 808 514 35 523 565 40 I 2 894 512 34 United Kingdom 76 630 04 3 282 242 66 32 239 51 F
11. a particular dimension level rrrrrrnnrrrrnnnnnnnrrnnnnnnnrrnnrnnnnrrnnrnnnnernnrnnnesrnnrnnneseennnn 16 EE EEE A O 16 3 12 Grid VAIUES IN percentage susan iis isnin eSak aA 17 3 13 Create and manage ad hoc User Named Sets rrannnnnnnnnrnnnnnrrnnnnnrnnnnnnrnnnnnsrnnnnnrnnnnnnrnnnnnsennnnesnnnnnesnnnnneee 18 3 13 1 Create Named Set by picking members rrranrrrrnnnnnnrrrnrnnnnrrrnrnnnnnrrnrnnnnerrnnnnnsesrnnnnnesennsnnnsssensnnnee 18 3 13 2 Create Named Set DY SPE SION 18 3 13 3 Edit existing User Named Sets rrrrannnnnnnnnrnnnnnrrnnnnnrnnnnnnrnnnnnrrnnnnernnnnnsrnnnnesnnnnnesrnnnnnsrnnnnesnnnnnesennnneen 19 3 14 Create and manage ad hoc User Calculated MeaSUres ccccscccssecccsececesecceseceeeecesenceseeeteeecesenceneues 20 3 14 1 Edit existing User Calculated Measures i csccssscdsneiaescexcceasdansnveasvacsneedsensenesuasatenctieyiveavcuvsaadipeavvarvet 21 NENNE 21 TG NNN E a a cocutepc pana tagsemaiepcatna aeaaie E E E senders 21 3 17 Analysis history move back and FOrWAM ccccssssscccccesseccecceesececceaueeccsseeecceesauseceeesaenseeessugaseesseges 22 4 Chart Analysis functionalities c cc cccccccccssssccccceessececcseecceesaeeeecessaeseeeeesaeeeeceesaessecessaeasceesseaaseeessaaaeeessaees 23 4 1 1520 EEE EE EE 24 4 2 EE EEE EE EE ER 24 4 3 ET NNN 24 4 4 POL COE eere E E AEE E E EE EAE E E A AE E E E E 25 4 5 LOE EEE E EE E E 25 4 6 Drill category member values Slice rr
12. associated with To view or change KPI details open KPI definition panel from the list All KPI s Measure Internet Sales Amount Cell KF Category Nordrhein Westfalen Measure Internet Sales Amount Measure Internet Sales Amount Cell KP Category British Columbia Close OLAP Analysis with AnalysisPortal User manual www kyubit com support Q kyubit com 36 Kyubit Business Intelligence OLAP Analysis User manual 9 Publishing Features Publishing Features provides functionalities to publish certain analysis and make it available on a designated URL for integration purposes with other web applications and services This way it is possible to merge your analyses grids charts and KPIs in other sites and apps with additional analysis appearance caching and security configuration for optimal visual and data integration 9 1 Publish Analysis In any moment of analyzing it is possible to publish current state of analysis On Report tab of analysis select Publish option and new window will appear with all publishing details Publishing details gives a lot of options and parameters that helps us to fine tune analysis outlook and set caching security and other options Publish Analysis amp URL http localhost 1130 report aspx Analysi Customers EMBED lt iframe frameborder 0 vspace 0 hspac Country GME Australia M France MA Germany United Kingdom J United states Publishing WO Cana
13. based on a single KPI threshold on grid level Column KPI for every value in specified column KPI will be shown based on a KPI threshold on a given column Cell KPI KPI will be show for a specified cell with threshold that is defined uniquely for that cell KPI definition panel will show up with KPI details for a given element To define a KPI it is necessary to define o Scoring pattern Increasing is better higher values are better Decreasing is better lower values are better o Good limit values over this limit are show as Success KPI icon o Bad limit values bellow this limit are shown with Fail KPI icon British Columb 1 955 340 10 Brunswick Manitoba Set Grid KPI Ontario 536 96 Set Column KP Drilithrogh by Quebec f Tota I 1 977 844 86 SSE AES EV 2 644 017 71 Show All KPI s Set Cell KPI OLAP Analysis with AnalysisPortal User manual www kyubit com support O kyubit com 35 Kyubit Business Intelligence OLAP Analysis User manual KPI Definition KPI Area Scoring pattern 8 2 Using KPI Increasing is Better W British Columbia nternet Sales Amount 2000000 1000000 Add Close To see all defined KPI for a certain analysis open Analysis right click on empty area and select Show all KPI s from context menu A list with all defined KPI thresholds will be displayed with indicator for which grid element this KPI is
14. kyubit com 26 Kyubit Business Intelligence OLAP Analysis User manual Y Applied filters Customer Geography Australia Category MM Accessories M eike MB clothing INTERNET ORDER COUNT isolate Australia isolate Clothing in Australia Drilithrough Australia by Drillthrough Clothi in Austra by Australia SSS Drill Australia By Country Drill Clothing in Australi By Drill Down Australia Y Applied filters Customer Geography Australia Category BB Accessories E Bikes BM clothing INTERNET ORDER COUNT Education Slicing category member values could be repeated as many times you like OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 27 Kyubit Business Intelligence OLAP Analysis User manual 4 7 Drill down If category dimension hierarchy consists of more levels Drill down option will be available in the action menu Drilling down will replace dimension hierarchy with its child level For example Country to State or State to City Right click on the member value Column Bar Line etc and select Drill Down action INTERNET SALES AMOUNT United States isolate United States Drillthrough United States by Drill United States By Drill Down United States Drill Down United States United Kingdom Germany France Australia 10M Y Applied filters Customer Geography United States Wyoming INTERNET SA
15. sil Internet sales amount share 3 14 1 Edit existing User Calculated Measures To edit existing User Calculated Measure right click User Calculate Measure in Cube metadata tree while in grid analysis and select Edit User Calculated Measure or go to Main Menu gt Share Items gt User Calculated Measures AnalysisPo rtal a User Calculated Measures Menu Analysis Delete Calculated Measure Name Folders C al My Ratio Cube references sal calc 12 sal test measurel Shared Items ea User Named Sets gall Internet sales amount share gt User Drillthrough Columns yal User Calculated Measures 3 15 Save analysis state In Grid or Chart view after every analysis action it is possible to save current state of analysis and run it again from the Kyubit Business Intelligence maps By default when saved analysis will be located in My analysis folder visible only to user who created analysis Existing analysis could be saved under different name using Save As option To run analyze again same analysis open Folders then My Analysis map and click on desired analysis 3 16 Share analysis To make analysis visible to other people open existing analysis and select Share option available in the top right corner Select one of the available folders and click Share button From now on current analysis will be located in designated folder and will not be visible in My anal
16. 008R2 User Named Sets L Favorite bikes ADVW2002E2 User Drillthrough Columns gal User Calculated Measures OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 20 Kyubit Business Intelligence OLAP Analysis User manual 3 14 Create and manage ad hoc User Calculated Measures While analyzing data with grid analysis any user could use OLAP database defined calculated measures or create ad hoc User Calculated Measures that will be stored in Kyubit Business Intelligence application and could be reused in different analyses and shared with other users using Kyubit Business Intelligence software To create ad hoc User Calculated Measure right click grid analysis area and select Create User Calculated Measure Show Hide Empty Series Pivot Create User Calculated Measure View Values View Column Percentage View Row Percentage Show All KPI s Clear Remove Series Remove Categories Open in Excel Enter MDX expression that will be used for User Calculated Measure Select measures and click Add Measure to add measure unique name to expression After you form complete expression validate expression by selecting Test MDX expression Enter appropriate MDX value for Format values for example Standard Currency Percent or any other valid MDX format values expressions Check official MDX documentation for Format values p
17. 14 36 33 515 83 28 547 67 26 985 36 20 441 44 10 549 21 152553 575 71 53 282 242 66 1 821 302 39 58 252 050 00 8 999 859 53 I 78 318 144 65 Internet Sales Amou 23 555 40 5 879 43 5 000 82 4 422 97 2 813 26 1 743 42 2 380 35 658 29 656 27 959 72 397 90 455 35 232 40 407 829 523 34 318 92 234 94 E 27 035 22 32 239 51 53 164 62 70 259 95 133 507 91 I 339 772 61 Internet Sales Amou r 7 894 312 34 I 539 725 80 I 391 400 20 I 5379 479 75 I 279 297 18 I 5268 664 80 I 5263 416 19 I 109 735 24 I 94 046 23 I 91562 51 E 54 641 72 I 46 755 90 I 34441 73 I 29 555 28 I 78 478 17 I 21473 74 I 11 342 97 r 2 644 017 71 5 3 391 712 21 I 1 977 844 86 9 061 000 58 I 9 389 789 51 1 29 358 677 22 Anytime while analyzing data in Kyubit Business Intelligence user has possibility to switch dimension hierarchies on the Categories and Series axis For many reasons switching axes could be very practical while OLAP Analysis with AnalysisPortal User manual www kyubit com support O kyubit com 17 Kyubit Business Intelligence OLAP Analysis User manual analyzing and visualizing data especially when working with Chart Analysis and switching back and forth with Grid Analysis To select Pivot action right click on the empty Grid area After menu pops up click on the Pivot action Category v Subcategory v Accessories Bikes Mou
18. LES AMOUNT ARSE O O O OOOO virginia Utah Texas South Carolina Orezon M Ghia Morth Carolina Mew York Montana Missouri Mississippi State Province Minnesata Massachusetts F Kentucky Illinois Georgia Florida california O Arizona isolate California Alabama q Drilithrough California by Drill California By 4 hl Drill Down California OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 28 Kyubit Business Intelligence OLAP Analysis User manual T Applied filters Customer Geography United State Wyoming INTERNET SALES AMOUNT CE O O O OOOO Wirginia Utah Texas South Carolina Orezon M Ghio 4 North Carolina Mew York Montana hlissouri I a Z D _ cL I a m on Mississippi Minnesota Massachusetts Kentucky Illinois Georgia Florida California BEE Arizona isolate California Alabama Drillthrough California by Drill California By hl Drill Down California 4 8 Chart visuals There are 6 different and independent visual elements which could be set up to optimize visualization and perception of your analysis data User should try several combinations to find most appropriate visual elements which best suits for given analysis Changing chart visuals does not impact analysis data values in any way 4 8 1 Chart Types There are 14 dif
19. Mountain 400 W Mountain 100 S Mountain 100 B Mountain 400 W Mountain 100 S Mountain 500 B Mountain 500 B Mountain 500 S 27 199 92 26 999 92 dg Customer basic data Custom drilithrough 520 249 94 10 199 97 9 719 82 8 639 84 6 779 88 32 318 58 26 162 66 20 006 I 32 318 58 I 27 199 92 I 26 999 92 I 26 162 66 Drilithrogh by Set Grid KPI Set Column KP Set Cell KPI I 8 639 84 I 6 779 88 OLAP Analysis with AnalysisPortal User manual www kyubit com support Q kyubit com 32 Kyubit Business Intelligence OLAP Analysis User manual Drillthrough results Cube Name Adventure Works Last update time 26 3 2009 11 44 19 Measure Internet Sales Amount Total Filters Product Mountain 400 W Silver 40 Style Womens Customer Geography California Product Categories Bikes Set drillthrough columns Customer Email Address Phone Internet Sales Amount Mackenzie R Cook mackenzie20 adventure works com 350 555 0175 769 49 Jade Murphy jadel2 adventure works com 109 555 0190 769 49 Dylan J Bryant dylan17 adventure works com 161 555 0181 769 49 Megan C Rivera megan37 adventure works com 114 555 0120 769 49 Marissa E Butler marissall adventure works com 974 555 0179 769 49 Dylan C Wilson dylan34 adventure works com 951 555 0169 769 49 Daniel L Clark daniel9SGadventure works com 259 555 0179 769 49 Alexandria A Gonzales alexandria17 adventure works c
20. OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 13 Kyubit Business Intelligence OLAP Analysis User manual Select members of hierarchy gt Customer Geography Selected me C New Castle Search C New Hartford Contains Ed All w Kennewick New Castle New Hampshire New Hartford L New Haven New Mexico C New South Wales New York C New York C Newark C Newcastle C Newcastle upon Tyne C Newport C Newport Beach Remove Filter 3 8 2 Isolating When narrowing our analysis to particular point of interest we could drag dimension hierarchies to Filters area but more practical and faster way to narrow analysis and reduce number of values shown in analysis is Isolating While analyzing data it is possible to select certain members on Categories or Series axis Column or Row Member and all of its children will be selected and highlighted in yellow color In that moment it is possible to click on the Isolate option in the analysis toolbar and instantly selected member and all of its children will be isolated for further analysis This means members not isolated on that axis will be removed from further analysis It is possible to select multiple members on Categories or Series axis Columns or Rows at the same time by holding left shift button After isolating Filters area will be refreshed with actual filter members as a result of isolatin
21. OLAP database defined Named set or create ad hoc User Named Set that will be stored in Kyubit Business Intelligence application and could be reused in different analyses and shared with other users using Kyubit BI software To create ad hoc User Named Set drag dimension hierarchy to any of grid axes click dimension hierarchy arrow and from hierarchy context menu select Create Named Set After saving User Named Set Cube metadata tree will be refreshed to include new User Named set a Country Australia Canada Level Value Filtering Level Sorting France Create Named Set Germany Remove Level United Kingdom Zra ass United States 59 389 789 51 Sum E 29 358 677 22 3 13 1 Create Named Set by picking members To create named set with static members of certain dimension hierarchy select Select named set members click Pick members and browse through dimension hierarchy or use search members to find members for named set Named set gt Customer Geography Name Europe set 89 Select named set members J Set named set expression France C Germany United Kingdom Pick members Delete members Delete 3 13 2 Create Named Set by expression To create dynamic set of named set members select Set named set expression and enter MDX expression that will be used to dynamically return members evaluated by expression Select Test expression to validate MDX expression input After saving named
22. P Analysis User manual 6 Exporting options While analyzing there are two exporting option always available Export to Excel file xlsx format Grid data and chart image will be exported to excel cells with related analysis elements Export to PDF file Chart image will be exported to PDF file with related analysis elements 7 Drillthrough features Usually analysis means exploring aggregated values for some business subjects Drilling and slicing functionalities will narrow analysis to particular point of interest But at certain moment we all want to see exact information who when and what for aggregated chunk of data For example with analysis we found that certain product is best selling product in some city in last quarter of the year but now we are very interesting to see details Show me the names dates and other purchasing details available in the OLAP cube structure Drillthrough action gives us possibility to see details for given analysis values Drillthrough action is available in Grid and Chart view and can be executed over some values already exists in our analysis In the Grid view right click on the cell will give us Drillthrough options or right click on the Chart value elements Lines Columns Bars etc in the Chart view Note that drillthrough actions for certain users could be restricted by OLAP database permissions Mountain 400 W Mountain 100 S Mountain 100 B Mountain 400 W Mountain 100 B
23. Using OLAP analysis features of Kyubit Business Intelligence www kyubit com Kyubit Business Intelligence OLAP analysis User Manual Using OLAP analysis features of Kyubit Business Intelligence 2015 All rights reserved www kyubit com 2 Kyubit Business Intelligence OLAP Analysis User manual Contents 1 OLAP CUDE TETEPCNCES iisdivssaiestivecnneawnssovacsnanvasavnaivnsdunbanvenvais duatiearnedeundeiesdnalphbuvsenedduanesenue lovedadestiabanienuaneusniient 4 Dig 0 EEE ER EE ER EE EE ER ER 5 2 1 ME ae EEE EEE EE EE EE T E 5 3 1 IEE AE 5 S A A EEE EE E 6 32 1 METT 7 SAP G 0 US EEE 8 3 3 Expand member single dimension hierarchy cccsscccccsseccccesscccsscccceuscccseeceseueceeseuecesseuseesaaeseesaaees 8 3 4 Expand member different dimension Nierarchy ccccsssscccccssseccccceseccccseeseccesceaeccesseeueecessueeeeesseees 9 3 5 Expand 3l Collapse all member EEE EE 9 3 6 Dril ene UN TON cre certs EE E E E ER NR EE ENER 10 IT Useranalysis SENG des AEREA 11 3 7 1 TTV 11 3 72 NENNE 11 3 8 Filtering grid analysis data ccccccssssccccssscccenscccsesccccensecssaececseueeesseuseeseaeceeseaeeessuaeeessuesesssueeesseaeeesees 12 3 8 1 TINN sariin r tletasage st E R E EE 12 3 8 2 FN 13 3 8 3 Dimension level value filtering rrrnnnnrrnrnnnnnrrrrnnnnnrrnrnnnnnrrnrnnnnnnrnnnnnnernnnnnnesrnnnnnnesrnnnnnnssnnnnnnsseee 14 3 9 SONG all MENDES ON erid AXIS Reder 15 3 10 Sorting members on
24. alysis User manual My Subscriptions Total product cost subscription All subscriptions created by me ee EN Eks Close 10 3 Subscription details There are several subscription settings that could impact the way users are receiving subscriptions Subscription Details Impersonate Subscription title Total product cost subscription Subscription item Analysis Total Product Cost by Month Occurs Weekly On this day CI Monday M Tuesday L Wednesday L Thursday L Friday L Saturday L Sunday At this time 9 00 Hour Min Recipients info kyubit com Include Include link embed image in email message Disabled O Edit scheduled time for subscription delivery Subscription item will be delivered via email to defined recipients Delete Close Subscription title sets the name that will appear when delivering dashboard analysis inside email message Subscription item selects Kyubit Business Intelligence content Analysis or Dashboard to deliver within subscription User can subscribe to all content with at least Read permissions Occurs defines scheduled time to deliver subscription There are three different time scheduling categories o Weekly set the week days to deliver subscription o Monthly set the month days to deliver subscription o Once set single day to deliver subscription Time sets time within day to deliver subscription Recipients list of email addresses to deliver subscription separat
25. and vice versa right click on empty chart area and select Pivot action from menu 4 5 Isolating To isolate certain member values right click on the member values Column Bar Line etc and select Isolate action Note that it is possible to isolate category members or if exists series member within category member To isolate series member right click on the series legend above chart member and select isolate action Isolate action will set addition filter for your analysis 4 6 Drill category member values Slice To further analyze data and go deeper into desired point of interest for certain category member right click on the member value Column Bar Line etc and select Drill action and select Slice dimension hierarchy that will used to slice current values Selected category member will be automatically isolated and set in filters Slice dimension hierarchy will become category dimension hierarchy Note that if series exists it is possible to Slice category member or series member within selected category member Category MMM Accessories pikes JR clothing INTERNET ORDER COUNT Isolate Australia solate Bikes in Australia Isolate Australia rillthrough Australia by lithrough Bikes in Austra by rill Australia By I Bikes in Australi By Down Australia ms EN EE EE I ar Country OLAP Analysis with AnalysisPortal User manual www kyubit com support Q
26. arameter User Calculated Measure Name Internet sales amount share Available measures Sales Amount Add Measure Measures Internet Sales Amount Measures Sales Amount Format Values Percent Seep Test MDX expression Delete OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com PMI Kyubit Business Intelligence OLAP Analysis User manual After you create User Calculated Measure Cube metadata tree will be refreshed to show new User Calculated Measure which then could be used in analysis AuulmiePortal a MAoni Veny Analysis F Adventure Works vil Measures B Internet Customers Internet Orders Internet Sales D Reseller Orders Reseller Sales D Sales Orders Sales Summary J Sales Targets User Calculate ul My Ratio wi caic 11 ul Internet Sales Amount al Sales Amount al Internet sales amount share Category Accessories Subcategory Mountain Bikes Road Bikes Touring Bikes Sum Bikes Clothing Components Sum Internet Sales Amount 700 759 96 9 952 759 56 14 520 584 04 3 844 801 05 1 28 318 144 65 339 772 61 1 29 358 677 22 Sales Amount 1 272 057 89 36 445 443 94 43 878 791 00 14 296 291 27 1 94 620 526 21 2 117 613 45 11 799 076 66 E 109 809 274 20 Internet sales amount share 55 09 27 31 33 09 26 89 87 29 16 05 101 06 sil test measurel
27. com support kyubit com 4 Kyubit Business Intelligence OLAP Analysis User manual 1 OLAP cube references To start analyzing data using existing OLAP database SSAS OLAP cube has to be referenced in the Kyubit Business Intelligence application Once it is referenced it can be reused in different analysis and reports and used by any users of Kyubit Business Intelligence which has permissions for the same Cube reference Cube reference just represents central catalogue of all available OLAP cubes to use in Kyubit Business Intelligence To define Cube reference for certain OLAP cube MS SQL Analysis Services 2005 2008 2012 2014 has to be installed on the intranet in the same intranet to which Kyubit Business Intelligence server belongs to While creating Cube reference user has to provide following data Server name address with MS SQL Analysis Services OLAP Database name Cube name Cube reference custom name Cube Reference m Permissions AWorks OLAP database Catalog Adventure Works DW 2006R2 SE Cube Name Adventure Works Set custom connection string Test connection Save Close Enter data for Analysis Services OLAP Cube reference Once created all user will be able to use Cube reference for analysis based on their permissions in OLAP cube Cube reference could be defined by server database elements or could defined as custom connection string so advanced users could add some extra parameters T
28. ct folder to share 2 1 My Analysis By default all users have My Analysis folder When saving analysis analysis is automatically saved in users My Analysis folder which is visible only to belonging user My Analysis folder cannot be deleted or renamed To move certain analysis to other folder analysis has to be shared connected to that particular folder Once shared to folder analysis is available to the group of users which have access permissions to view the content of the folder OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 6 Kyubit Business Intelligence OLAP Analysis User manual 3 OLAP Grid Analysis 3 1 Start Analysis To start analysis click on the Start Analysis on the Kyubit Business Intelligence page Note that if you have only one cube reference Grid Analysis screen will immediately become visible and ready for analysis If there are more cube references user will be asked for which OLAP cube to start the analysis If desired OLAP cube is not on the cube reference list select New Cube Reference and create new cube reference Select cube for analysis New Analysis Chart gl AWorks Contoso l contoso2 Report T Calendar CY 2007 CY 2008 a Country Australia Canada France Germany United Kingdom United States Sum a Category Accessories Internet Sales Amou 5138 690 63 5103 577 85 563 406 78 562 232 59 576
29. da Report Alias customers INTERNET SALES AMOUNT Caching minutes 1 impersonate User Name testAdmin Impersonate Password Published Visual elements Grid Visuals Chart Visuals Save internet Sales Australia 9 061 000 58 Alberta 22 467 80 British Columbi 1 955 340 10 Brunswick Canada Manitoba Ontario 36 956 Quebec Total 1 977 844 86 France 2 644 017 71 Bayern 399 966 78 Brandenburg 119 571 08 Hamburg 467 219 04 Germany Hessen 794 876 08 Nordrhein Westf 5459 591 85 amp 9 1 1 Publishing URL and EMBED string While we are configuring publishing options we can see the URL and EMBED string that we can use later to see published analysis 9 1 2 Report Alias This is unique identifier for published analysis When we set Report Alias we know on which URL our published analysis will be available For example for Report Alias with value of Alias1 URL will be http KyubitBl report aspx Analysis Alias1 9 1 3 Caching It is possible to set up caching time of published analysis in minutes This way users on some external portal site will see analysis from the memory without need to directly connect to OLAP data source every time someone hits page with given analysis and thus speeds up the whole experience with published analyses OLAP Analysis with AnalysisPortal User manual www kyubit com support O kyubit com 37 Kyubit Bus
30. e of delivery 10 1 My subscriptions Every user can see all his own subscriptions Analysis and Dashboards in Kyubit Business Intelligence where all his subscriptions could be managed Kyubit AnalysisPortal Analysis Analyses OLAP Data Sources OLAP Shared Items Subscriptions D My Subscriptions 9 All Subscriptions Dashboards F My Subscriptions O G 0O O O 0 G O G O O Create New Subscription Title t Production issues w First subscription W Margins extended report W Month sales w Bikes in Canada overall subscription ti Production Analysis ti Product Sales 04 UD sales Q4 PDF ti Sales 04 ov Sales 04 monthly W Total product cost subscription 10 2 Subscriptions within analysis When user opens certain OLAP analysis he can immediately see if he already has some subscriptions created to the analysis Kyubit ty AnalysisPortal Analysis Dashboards Analysis FJ Adventure Works All measure groups gil Measures Z Account IZ Customer Z Date LZ Delivery Date Z Department LZ Destination Currency Employee L Geography LZ Internet Sales Order Details LZ Organization Product Q Financial Q History fa Starkine Total Product Cost by Month cid al Total Product Cost Month of Year January February March April May June July August September October November December Sum Delete Subscription Occurence Wee
31. ed by semicolon OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 40 Kyubit Business Intelligence OLAP Analysis User manual e Include type of delivered content o Only link to Kyubit Business Intelligence analysis o Link embedded analysis image user immediately sees analysis image when opens email message HIHIHI o Link PDF dashboard document applicable only for dashboards e Disable all subscriptions marked disable will not be delivered at scheduled time OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com
32. erarchy on Series axis in Grid view will be shown as Series in Charts view In Grid analysis it is possible to select more dimension hierarchies for each axis Chart view will accept show only first dimension hierarchies for both axes OLAP Analysis with AnalysisPortal User manual www kyubit com support O kyubit com 24 Kyubit Business Intelligence OLAP Analysis User manual While doing Chart analysis Grid analysis is also refreshed in the background so user could combine both views to execute desired analysis and to apply desired actions It is the same set of analysis data If you switch to Grid view you will see that analysis values for your actions are automatically reflected in both analysis views Chart analysis could show up to 3 measures Each measure will be shown on separate chart one above other Unlike Grid analysis Chart analysis uses right click context menu that pops up and show available actions to select elements from cube structure and to perform particular analysis action 4 1 Categories To start Chart analysis at the minimum dimension hierarchy for Categories has to be selected To select particular dimension hierarchy for Categories Series or Filters first menu will show available dimensions and after click on certain dimension other menu pops up with all available dimension hierarchies for previously selected dimension Category dimension hierarchy members will be shown on X horizontal axis To cha
33. ferent chart types that could be selected for any analysis m Lines Splines m Bars Stacked Bars Stacked Bars 100 Columns Stacked Columns Stacked Columns 100 Areas Stacked Areas Stacked Areas 100 Pile Doughnut Radar OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com P Kyubit Business Intelligence OLAP Analysis User manual 4 8 2 Palette Defines color sets that would be used to show chart values Brigth Grayscale Excel Light Pastel EarthTones Semitransparent Berry Chocolate m Fire SeaGreen BrightPastel 4 8 3 Theme Defines background color for the chart area Blue White Warm 4 8 4 Enable 3D view Apply 3D view for given chart analysis and defined chart visuals 4 8 5 Semi transparent option Value elements Lines Columns Bars etc could be visually semitransparent above the chart area 4 8 6 Show values option Values could be presented with numbers beside each member value element 4 8 7 Pie Doughnut details For pie and doughnut chart types special setting is provided to support different value presentation options due to these chart type specifics OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 30 Kyubit Business Intelligence OLAP Analysis User manual 5 Report view After analysis gets shape and data we want we often
34. g Isolating is just another way of setting up analysis filters and can be used together in the same analysis a Country Internet Sales Amou Australia 59 061 000 58 Canada 1 977 844 86 France 2 644 017 71 Germany 52 894 312 34 United Kingdom 5 591 712 31 United States 55 389 789 51 Sum 1 29 358 677 22 OLAP Analysis with AnalysisPortal User manual www kyubit com support Q kyubit com 14 Kyubit Business Intelligence OLAP Analysis User manual TY Customer Geography Canada United Kingdom a Country Canada United Kingdom Sum Internet Sales Amou 51977 244 86 3 391 712 21 I 55 369 557 07 3 8 3 Dimension level value filtering For every added dimension level on grid analysis it is possible to define level filtering that would narrow number of level members to show in grid Click level arrow and select Level value filtering from level context menu Level value filters could be applied using any cube defined measure using desired query selector Top Top Percent Bottom Bottom Percent Is Higher Is Between etc and specified filter value Levels with defined Level value filtering will show different blue arrow on grid axis a Country GE PES VETE Level Sorting Canada Level Value Filtering France Create Named Set Germany United Kingda EE United States 59 389 789 51 Sum 1529 558 677 22 Remove Level Value filtering for level Country Measure Internet Sales Amount Filter
35. ies or Series area to cube tree or select dimension hierarchy one click and press Delete key 3 3 Expand member single dimension hierarchy If we drag dimension hierarchy that consist of several levels For example Geography Country State City Customer or Calendar Year Semester Quarter Month Week Day with each member on the Categories or Series area will be displayed collapse expand option which would expand values to show values for the next hierarchy level members For example with a few clicks we would see analysis for all countries drill down USA to states drill down California to cities and finally find values for San Francisco At the same analysis it is possible to drill down Categories and Series dimension hierarchies OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 9 Kyubit Business Intelligence OLAP Analysis User manual al Internet Tax Amount a Product Subcategory Category Accessories Mountain Bikes Road Bikes Touring 1000 Blue Touring 1000 Blue Touring 1000 Blue Touring 1000 Blue Touring 1000 Yellow Touring 1000 Yellow Touring 1000 Yellow Touring 1000 Yellow Touring 2000 Blue Touring 2000 Blue Touring 2000 Blue Touring 2000 Blue Touring 3000 Blue Touring 3000 Blue Touring 3000 Blue Touring 3000 Blue Touring 3000 Blue Touring Bikes Internet Tax Amount 56 060 80 796 220 81
36. iness Intelligence OLAP Analysis User manual 9 1 4 Impersonate If many people would request published analysis and we are not sure if all of them have necessary OLAP permissions to see all analysis elements it is possible to impersonate request for published analysis In this way we will use one windows user name and password that we are sure has all required OLAP permissions to connect and provided published analysis 9 1 5 Visuals Visual elements Grid Visuals and Chart Visuals provides us lot of visual elements we can customize while publishing analysis We will configure which elements to show or hide fonts colors alignments and other elements to fine tune published analysis appearance Visual elements Analyze Link N Name Show Show Chart O 9 9 9 S 9 K Grid over Chart Horizontal position Center 10 10 Calibri 12 Black OLAP Analysis with AnalysisPortal User manual www kyubit com support Q kyubit com 38 10 Kyubit Business Intelligence OLAP Analysis User manual Subscriptions Important aspect of Kyubit Business Intelligence analysis usage is to deliver analysis report to users using email subscriptions which contain OLAP analysis data in form of HTML with embedded analysis image Every user of Kyubit Business Intelligence with at least Read permission has privileges to make a subscription to OLAP analysis and receive analysis report on email within scheduled tim
37. kly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Monthly Weekly Time 14 30 09 35 15 00 13 00 13 50 16 10 8 15 7 30 9 00 Type DASHBOARD DASHBOARD DASHBOARD DASHBOARD DASHBOARD ANALYSIS DASHBOARD DASHBOARD DASHBOARD DASHBOARD ANALYSIS To Chart Report Back Clear History Subscribe 1 Gategory v Accessories Bikes Clothing Components Sum Total Product Cost Total Product Cost Total Product Cost Total Product Cost 35 136 93 4 636 857 52 583 479 76 257 151 05 38 394 83 7 677 423 65 100 541 44 484 204 62 39 340 59 6 602 443 60 96 208 09 423 384 71 49 107 75 5 675 780 85 126 206 34 622 148 52 64 615 46 8 840 181 01 162 201 81 1 045 998 79 558 809 36 7 585 842 27 153 602 54 993 064 46 51 437 30 5 496 634 76 156 708 15 1 080 824 82 69 604 03 8 542 726 62 224 151 64 1 686 479 99 567 788 43 7 428 347 62 202 823 12 51 554 415 80 546 472 74 5 250 047 83 124 758 83 587 508 79 58 255 44 8 547 195 02 162 844 43 1 071 792 05 58 627 88 7 821 948 85 155 251 30 959 136 59 637 590 73 Z 584 105 429 60 Z 1 748 777 45 10 766 110 18 By click on Subscribe link form with existing subscriptions of current user will be displayed with option to create new subscription edit or delete existing OLAP Analysis with AnalysisPortal User manual www kyubit com support O kyubit com 39 Kyubit Business Intelligence OLAP An
38. mou 9 952 75956 514 570 584 04 53 844 801 05 a Subcategory Mountain Bikes Road Bikes Touring Bikes Sum I 28 518 144 65 OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 11 Kyubit Business Intelligence OLAP Analysis User manual 3 7 User analysis settings Every user could define his own preference while analyzing OLAP data with Kyubit Business Intelligence application Every time user starts new analysis user settings will be applied Select User Settings available in the top right corner of the screen Current user settings Current user Show Hide empty cells Aggregate operation Grid column width User AD groups 3 7 1 Grid analysis Aggregates Hide Empty Rows Sum Large PERPETUUM Domain Users Everyone BUILTIN Administrators BUILTIN Users NT AUTHORITYVNTERACTIVE CONSOLE LOGON NT AUTHORIT Y Authenticated Users NT AUTHORITY This Organization LOCAL PERPETUUMMVPW korisnici RAT IL IE hE Save Refresh Close User can chose which aggregate function to apply and show while in grid analysis view To select aggregate function right click grid analysis area and select Set Aggregates a Country State Province Australia Alberta British Columbia Canada Ontario Internet Sales Amount 59 061 000 58 522 467 80 51 955 340 10 536 96 N Set Aggregates k set Column Width IT Set Row Sorting Ave wee WE 659 281
39. ne following link URL http timetracking Workorder aspx Workorder WorkOrder WorkOrderld Part of this URL is static and other part between brackets is dynamic in our drillthrough results Finally when we get drillthrough results we could click on each work order and open web application that shows us full details about given work order object Of course such application should exist but this is just a tip how and why we could use links with drillthrough functionalities 7 3 Saving drillthrough columns and reuse Typically for certain business situations we would like to get certain set of drillthrough columns Set of drillthrough columns could contain dozens of columns and of course we do not like to pick them again every time we run drillthrough for given situation Once picked and defined we could save them in Kyubit Business Intelligence application Saved set of drillthrough columns is associated with measure group and anytime in any analysis we could run drillthrough with saved set of drillthrough columns if the value we would like to drillthrough is from measure that belongs to associated measure group To reuse saved set of drillthrough columns right click in the analysis on some value and within Drillthrough options all available sets of drillthrough columns will be shown Outside of analysis saved set of drillthrough columns could be viewed and edited in Main Menu under menu tab Shared Items gt User Drillthrough column
40. nge category right click on empty chart area and select Change Category action from menu Select dimension and dimension hierarchy for the Category axis 4 2 Series To set Series dimension hierarchy right click on empty chart area and select Set Series action from menu Select dimension and dimension hierarchy for the Series axis Series dimension hierarchy members will be shown above chart with different color for each Series member Category MM Accessories i Bikes INTERNET SALES AMOUNT Set Series To Add Filter Change Chart Measure Add Measure Change Category Pivot Chart Show Hide Empty Series Sort alphabeti ta Open in PDF Country 4 3 Change or add measure It is possible to change current measure in Chart view or add new measures Up to 3 To remove certain measure please use grid view removing measure is not supported in Chart view To change or add measure right click on empty chart area and select Change Measure or Add Measure action from menu Select measure group and then particular measure While working with multiple measures chart will be displayed one above other so that Category members vertically line up for measure comparison OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 25 Kyubit Business Intelligence OLAP Analysis User manual 4 4 Pivot chart To switch members from Categories to Series
41. ntain Bikes Road Bikes Internet Sales Amou Internet Sales Amou Internet Sales Amou Internet Sales Amou Internet Sales Amou Internet Sales Amou Internet Sales Amou 62 232 59 1 003 800 98 1 380 342 85 424 370 52 2 808 514 35 23 565 40 2 894 312 34 Seine Paris 13 160 02 186 654 01 276 410 85 57 671 49 520 736 35 5 829 43 Z 539 725 80 Nord 9 894 27 131 668 22 194 250 41 50 586 48 376 505 11 5 000 82 391 400 20 Seine Saint Denis 9 894 58 127 047 32 176 574 67 61 540 26 365 162 25 4 422 92 379 479 75 Essonne 5 243 89 83 601 34 149 604 96 38 033 73 Z 271 240 03 2 813 26 Z 279 297 18 Yveline 5 561 12 89 671 50 137 141 12 34 547 64 Z 261 360 26 1 743 42 I 268 664 80 Hauts de Seine 6 068 76 91 678 91 120 484 86 42 803 31 I 254 967 08 2 380 35 263 416 19 Seine et Marne 2 269 55 38 847 68 55 205 76 12 753 96 Z 106 807 40 658 29 Z 109 735 24 Moselle 2 529 78 37 525 91 39 929 22 13 405 05 5 90 860 18 656 27 Z 94 046 23 Loiret 2 282 44 32 356 32 47 484 54 8 479 89 88 320 75 959 72 91 562 91 Garonne Haute 1 181 39 13 383 03 33 696 42 5 982 99 53 062 43 397 390 54 641 72 Val d Oise 1 786 19 14 365 86 21 511 59 8 636 91 5 44 514 36 455 35 46 755 90 Charente Maritime 693 50 16 081 36 15 050 41 2 384 07 5 33 515 83 232 40 Z 34 441 73 Somme 599 72 8 743 05 18 589 77 1 214 85 Z 28 547 67 5407 89 29 555 28 Val de Marne 969 42 14 230 87 9 628 08 3 126 42 Z
42. o assign permissions for other users select Permissions link OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 5 Kyubit Business Intelligence OLAP Analysis User manual 2 Folders To give other people permissions to see or edit created analysis analysis have to be connected shared with previously created folder Folder is object that groups all analyses with same Active Directory user group permissions Folders could be used to share analysis with common subject or belong to certain business unit or process Administrator or user with read write permission on a folder could manage permissions for other Active Directory user groups To see actual data from OLAP data source user needs permission on SSAS cube level but to see that certain analysis exists in Kyubit Business Intelligence application user needs permission also in Kyubit Business Intelligence folder with given analysis To create new folder and define folder permissions follow these steps On Main menu select Create Folder button on the right side of screen Set folder name and click Save To define permissions on folder select permissions and choose required Active Directory users and groups and finally select which access level should be given Read Access or Read Write Access Folder a Permissions To share analysis with other users create fi nissions While analyzing data se sele
43. om 147 555 0143 769 49 Sean A Howard sean19 adventure works com 223 555 0187 769 49 Rachel K Patterson rachel58 adventure works com 220 555 0196 769 49 Sarah C Washington sarah38 adventure works com 368 555 0136 769 49 Ethan Garcia ethan52 adventure works com 185 555 0117 769 49 Alexia D Flores alexia10 adventure works com 632 555 0172 769 49 Andrea Richardson andreal0 adventure works com 854 555 0190 769 49 Sydney M James sydney1l8 adventure works com 928 555 0156 769 49 Aidan Wood aidan2 adventure works com 129 555 0157 769 49 Rachel Wilson rachel9 adventure works com 230 555 0193 769 49 Evan S Ward evani3 adventure works com 584 555 0170 769 49 Wyatt A Barnes wyatt54 adventure works com 358 555 0164 769 49 Brandon La brandon26 adventure works com 445 555 0135 769 49 Mariah Russell mariah24 adventure works com 403 555 0138 769 49 Grace Cox grace36 adventure works com 326 555 0182 769 49 7 1 Custom drillthrough First available is Custom drillthrough option which can be selected anytime in Grid and Chart view Right click on some value select first Drillthrough and then Custom drillthrough action New Drillthrough results window will open showing elements of this drillthrough Cube name measures filters total Total presents value for given measure that we want to drillthrough Filters presents all cube dimension hierarchies that were set to filters to get this results
44. rrrrrrrnnnrrrrrrrnrrnnnnnnrrrrrnrnnnnnnnrrrrrnrnnnnnnerrennnnnnnnnesrennsnnnnseessennnnnnn 25 4 7 BLE OON REE A 27 4 8 H ET EE EEE ER 28 4 8 1 Go EEE REE 28 OLAP Analysis with AnalysisPortal User manual www kyubit com support O kyubit com 3 Kyubit Business Intelligence OLAP Analysis User manual 4 8 2 PE 29 4 8 3 TE 29 4 8 4 EE DUN 29 4 8 5 NT TN 29 4 8 6 SHOW Va SOU Oli EE EEE NE EE 29 4 8 7 PETN 29 RONNI 30 PFIN 31 7 Drillthrough features rrrrnnnnnnnrrrnrnnnnrrnrrnnnerrrnnnnneerrnrnnnesrnnnnnsesrnnnnnnesennnnnnesennnnnnessnnnnnnesennnnnnesnnnnnnessnnnnnnessee 31 7 1 Custom GPINENFOURM scaseavisceosvansaedtesdsnatenicsanedtconsalesameasiausastenssbueneusssrs sean suesabdasvoisnobansasiautesiansabousidedesiiwad 32 7 2 Bees EE EEE a T a i 33 7 3 Saving drillthrough columns and reuse cccccssssecccccessececcaussecccesueseceeseusececcsueseceessaaueeeessuaneceessuaasses 33 De KPTN ONA ae E A E E A A AEE EE E TA EEE 34 8 1 BET 0 Pi EEE 34 8 2 JG EEE EEE EE SEE ENE EEE T E 35 PENNEN 36 9 1 PONS 02 EE EEE 36 9 1 1 Publishing URL and EMBED StIing ccccssseccceseeccceneccceesceccsuscecseecessuesesseuscessuseessaeeeesaneeess 36 9 1 2 Eee EEE EEE eaten 36 9 1 3 CIEE RE EEE EE es ee eee 36 9 1 4 MOET NN 37 91 5 KE E E EE ET TE EE EE E E E E E 37 10 UNN 38 10 1 My Subscriptions seinien 38 10 2 SVS WIENIN NN 38 Wo NN 39 OLAP Analysis with AnalysisPortal User manual www kyubit
45. rs CY 2005 CY 2006 Graduate Degree Canada High School Partial College 36 712 08 Partial High School 10 437 99 Sum 145 704 19 204 286 06 224 681 15 United Kingdom 262 627 42 United States 719 988 78 Sum Z 2 265 451 62 27 181 81 France Germany Clothing Sum Z 2 348 694 23 3 5 Expand all Collapse all members To expand all sibling members of a particular hierarchy right click any of sibling members and select Expand all On the same way select Collapse all members to collapse all sibling members Exapand all Collapse all members is available only on categories axis OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 10 Kyubit Business Intelligence OLAP Analysis User manual a State Province Alberta ritish Columbia Ontario Sum Internet Sales Amou Internet Sales Amou Internet Sales Amou Z 103 377 85 1 799 474 48 7 1 821 302 39 Clothing Drill down Accessories 552 939 19 I 53 164 62 I 51 955 340 10 I 536 96 I 51 977 844 86 a Category Subcategory Internet 5a Accessories 102 976 45 536 96 Heile Expand all membe Sum Isolate Accessories State Province v Alberta British Columbia Ontario Sum Subcategory v Internet Sales Amou Internet Sales Amou Internet Sales Amou Internet Sales Amou r Accessories Bike Racks Bike Stands Bottles and Cages Cleaners Fenders Helmets
46. s OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 34 Kyubit Business Intelligence OLAP Analysis User manual 8 KPI functionalities Key Performance Indicators gives us quick overview of analysis results and categorize returned values as good or bad Kyubit Business Intelligence offers functionalities to define performance bounds for a certain analysis and shape them as KPI along desired returned values KPI threshold can be defined for whole analysis grid level column or cell level KPI is saved along with Analysis and each time is executed it shows KPI for defined elements sil Internet Sales Amount Country State Province internet Sales Amou Australia 9 061 000 58 Canada Alberta 22 467 80 British Columb 1 955 340 10 Brunswick Manitoba 7 Ontario 36 96 I Quebec Total I 1 977 844 86 France 2 644 017 71 Germany Bayern 399 966 78 Brandenburg 119 571 08 H Hamburg 467 219 04 Hessen 794 876 08 Nordrhein West 459 591 88 Saarland 653 087 48 Tota 2 894 312 34 United Kingdom 3 391 712 21 98 United States 9 389 789 51 amp Total I 29 358 677 22 8 1 Define KPI KPI can be defined and used only in analysis grid view After certain analysis is executed and results are show in grid view right click on any cell will show options to define KPI threshold for Grid view KPI for every value in grid KPI will be shown
47. set every time named set is used expression will be executed in the analysis scope to return members and use within analysis OLAP Analysis with AnalysisPortal User manual www kyubit com support O kyubit com Kyubit Business Intelligence OLAP Analysis User manual Named set gt Customer Geography m Permissions Name Top internet sales cities x Select named set members Set named set expression TopCount Customer City children 20 Measures Internet Sales Amount a Test expression Delete Close 3 13 3 Edit existing User Named Sets While in grid analysis authorized users could edit existing User Named Sets by right mouse click on User Named set in Cube metadata structure tree or in Main Menu gt Shared Items gt User Named Sets Ca Adventure Works Gray OLAP gill Measures database defind Customer Named sets Demographic 4 Location Sets Top 50 Custome Rich cities Canada amp Germany High Education Blue Customer AnalysisPortal defined aa Customer Geograp ean Named Sets E Date Delivery Date Kyubit 1 Named sets defined in AnalysisForta AnalysisPortal ser Named Sets Menu Analysis Delete Named Sets Fold Name Data Source olders C Rich cities ADW2008R2 Cube references Canada amp Germany ADW20D8R2 C 4 Cams and camcordsers contoso Shared Items C High Education ADW2
48. t menu will appear and select Level sorting a Category Bikes Indore nt D les Amou Accessories Inte ee at Cale Ass a Country Level Sorting Germany France Level Value Filtering United Kingc Canada Australia United States 256 422 07 Sum I 700 759 96 Create Named Set Remove Level 8 999 859 53 Z 528 318 144 65 On a picture bellow we see Country level members are sorted by Accessories ascending but members of State Province are sorted by Bikes in descending order It is possible to create sorting for every added dimension level on both axis a Category Accessories Bikes Clothing Sum a Country 1 gt State Province T Internet Sales Amou Germany Seine Paris Nord Seine Saint Denis Essonne Yveline Hauts de Seine Seine et Marne Moselle France Loiret Garonne Haute Val d Dise Charente Maritime Somme Val de Marne Loir et Cher Pas de Calais Sum United Kingdom Canada Australia United States Sum 3 11 Pivot 62 232 59 13 150 02 59 894 27 59 894 58 5 243 89 5 561 12 6 068 76 2 269 55 2 529 78 52 282 44 1 181 39 1 786 19 693 50 599 72 969 42 713 38 558 77 I 63 406 78 76 630 04 103 377 85 5138 690 63 256 422 07 700 759 96 Internet Sales Amou 52 208 514 35 520 736 35 376 505 11 365 162 25 271 240 03 261 360 26 254 967 08 106 207 40 90 860 18 88 320 75 53 062 43 44 5
49. tegory and series dimension hierarchies and time of execution Analysis history is reset with each new analysis Clear action OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com Kyubit Business Intelligence OLAP Analysis User manual History of recent analysis 7 Analysis Time Measures Filters Row Fields Column Fields 6 Analysis Time Measures Filters Row Fields Column Fields 5 Analysis Time Measures Filters Row Fields Column Fields 4 Analysis Time Measures Filters Row Fields Column Fields 3 Analysis Time kMla sriirae 21 19 47 Internet Sales Amount Country State Province Category Subcategory 21 19 44 Internet Sales Amount Category Subcategory Country State Province 21 19 41 Internet Sales Amount Country State Province Category Subcategory 21 19 38 Internet Sales Amount Country State Province Category 21 19 32 Imtarnat Talar Arma mt P Run from history P Run from history P Run from history k Run from history P Run from history 4 Chart Analysis functionalities To analyze data visually switch analysis view to Chart view Chart view and Grid view show same analysis data following the concept that first dimension hierarchy on the Categories axis in Grid view will be show on categories X axis in Chart view values for each measure will be shown on Y axis and finally first dimension hi
50. to existing analysis By dragging dimension hierarchies to Filters area we prepare grid to accept filter parameters Finally to set filters browse through dimension hierarchy or search for dimension hierarchy members to isolate analysis data Dimension hierarchies could be dragged to filters area from the cube tree or if exists from the dimension hierarchies that are already placed to categories or series area For example we could add Calendar dimension hierarchy to filters area and select CY2003 which would narrow analysis and show values only for Calendar Year of 2003 for the given dimension hierarchies on the Categories and Series area To remove filter from analysis drag filter from Filters area to cube tree or select filter one click and press Delete key Select members of hierarchy gt Product Categories Browse EE di All Products Mountain Bikes Accessories Touring Bikes Bikes Mountain Bikes W Road Bikes Touring Bikes Clothing Components 3 8 1 Search Members To find particular member to add to analysis filters add dimension hierarchy to filters and select Search tab Combine hierarchy members browsing and member search to find exact members for analysis filter Type in part of the member name select appropriate selector contains starts with ends with etc and select of dimension hierarchy level and narrow scope that will be searched to find members
51. want to show it to other people Many people we would like to show analysis are not familiar with OLAP and analysis technology concepts To get analysis view that would be as simple and straightforward as possible showing only business valuable data without all actions cube structure etc we switch to Report view that would show only final analysis data Report view hides almost all Kyubit Business Intelligence interface header menu etc and show plain analysis data elements which are ready to show to other people or send directly to printer Analysis name Analysis description if exists Grid results data if opted Chart result image if opted In Report view following actions are available Update Analysis details name description Select to show Grid Chart or both Send to print Export to Excel Export to PDF Switch back to Grid or Chart view Anz monthly Y Filters 1 Calendar Year CY 2003 2 Customer Geography Australia Canada Country o Australia o Canada 400k 300k 200k wl 100k PG Jf o C pe kas 7 I A I I I I I I I A TA gt 2 3 2 EN 2 gt b 2 Ga 4 zo a 2 a Zz ra O D D e S pas 3 a Q 2 O gt gt EA Ga r G EN gt S gt 2 2 2 as KA gt a gt gt Month OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 31 Kyubit Business Intelligence OLA
52. y L Ship Date W Source Currency 3 2 1 Cube Tree Structure Every OLAP cube consists of measures dimensions and hierarchies Cube structure is defined in OLAP database and within Kyubit Business Intelligence is displayed using tree view Analysis is performed by dragging desired elements Measures dimension hierarchies to appropriate areas on the right OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 8 Kyubit Business Intelligence OLAP Analysis User manual g Adventure Works ail Measures l Customer Q Demographic Q Location Sets ET 7 au Customer Eri Customer Geography All a Country aa State Province a City a Postal Code as Customer l Date 9 Calendar Fri Calendar Calendar Quarter of Year Calendar Semester of Year Calendar Week of Year E 24 Calendar Weeks Calendar Year 3 2 2 Categories and series To see some measure over some entity structure dimension drag OLAP dimension hierarchies from the OLAP tree structure visualized with the tree view on the left side of the screen to the Categories and or Series area For example Countries dimension hierarchy could be placed on Category axis and Product dimension hierarchy on the Series axis Corresponding values from OLAP cube will appear on the values area in the center of the screen To remove dimension hierarchy from analysis drag dimension hierarchy from Categor
53. ysis Shared folder does not mean that this analysis could be visible to everyone but only to users with permission for a particular folder Furthermore users with given permissions on folder will see that analysis with given name exists but when they try to OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 22 Kyubit Business Intelligence OLAP Analysis User manual execute one same users additionally must have permissions in OLAP database itself to successfully run analysis Typically folders would be created to separate analysis for different business units sectors or teams to separate points of interest and appropriately assign permissions Option to share analysis is available in Grid and Charts view if analysis is previously saved Share Analysis oshare Human Resources 3 17 Analysis history move back and forward After every analysis action in Grid or Charts view analysis state is saved in memory and could be used to Back or Forward functionalities which would reproduce analysis state from memory Additionally user can select History option and see all available analysis states up to 10 that exists in memory and could be run again either by Back and Forward option or by explicitly clicking on green arrow beside each analysis state in history panel History panel additionally shows basic elements of certain analysis state measures filers ca

Kyubit Business Intelligence OLAP analysis

Contents

Download Pdf Manuals

Related Search

Related Contents