Home

Kyubit AnalysisPortal OLAP analysis

1. 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 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 Ta 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 5 32 318 58 5 27 199 92 5 26 9
2. 376 505 11 5 000 82 391 400 20 Seine Saint Denis Internet Sales Amou 9 894 58 127 047 32 176 574 67 61 540 26 Z 365 162 25 4 422 92 Z 379 479 75 Essonne Internet Sales Amou 5 243 89 83 601 34 149 604 96 38 033 73 Z 271 240 03 2 813 26 279 297 18 Yveline Internet Sales Amou 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 Internet Sales Amou 9 86 9 01 11 55 6 556 0 08 0 00 Sum 6 74 Australia 30 86 United States 31 98 Sum 100 00 a Country l State Province t Germany France United Kingdom British Columbia Alberta Ontario Canada 3 13 Create and manage ad hoc User Named sets While analyzing data with grid analysis any user could use OLAP database defined Named set or create ad hoc User Named Set that will be stored in AnalysisPortal application and could be reused in different analyses and shared with other users using
3. 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 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 assoc
4. Favorite bikes conteso ADW2008R2 ADW2008R2 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 AnalysisPortal application and could be reused in different analyses and shared with other users using AnalysisPortal software To create ad hoc User Calculated Measure right click grid analysis area and select Create User Calculated Measure OLAP Analysis with AnalysisPortal 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 User manual www kyubit com support kyubit com 20 Kyubit AnalysisPortal OLAP Analysis User manual 7 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 parameter User Calculated Measure Name Internet sales amount share Available measures Sales Amoun
5. Z 9 389 789 51 529 558 677 22 Sum Optional Sort using values in Columns Sort order a Country Germany France United Kingdom Canada Australia United States Sum a Category Accessories Internet Sales Amou 562 232 59 63 406 78 76 630 04 103 577 85 138 690 63 2756 422 07 700 759 96 Asc Bikes Internet Sales Amou 2 808 514 55 2 553 575 71 3 282 847 66 1 821 502 39 8 852 050 00 8 999 859 53 E 928 318 144 65 Clothing Internet Sales Amou 523 565 40 27 035 22 32 239 51 553 164 62 70 259 95 5133 507 91 5 339 772 61 sum Internet Sales Amou z 2 894 512 34 E 2 644 017 71 3 391 712 71 51 977 844 86 9 061 000 58 z S9 389 789 51 E 29 358 677 22 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 context menu will appear and select Level sorting a Category Accessories 1 Bikes lmbarmnt Dalar A mamaa Inte ee D les Amo U Level Sorting Level Value Filtering a Country Germany France United Kingc Canada Australia United States Sum Create Named Set Remove Level 256 422 07 Z S700 759 96 8 999 859 53 E 28 318 144 65
6. 102 926 43 613 145 41 921 593 86 264 735 21 Z 1 799 474 48 2 157 60 6 073 52 21 773 77 16 237 68 791 12 5 905 50 Z 52 939 19 1 955 340 10 Z 36 96 OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 7 080 00 5 088 00 7 683 16 1 160 70 8 792 00 Z 28 096 97 Z 6 158 88 5 39 318 14 Z 103 377 85 615 440 40 Z 935 616 29 Z 270 245 70 1 821 302 39 2 175 58 6 098 01 21 877 75 16 307 67 800 11 5 905 50 Z 53 164 62 Z 1 977 844 86 10 Kyubit AnalysisPortal OLAP Analysis User manual 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 Sim Drill down Bikes Isolate Bikes TY Product Categories Bikes N 3 Subcategory Internet Sales Amou Mountain Bikes 59 952 759 56 Road Bikes 14 520 584 04 Touring Bikes 3 844 801 05 Sum Z 28 518 144 65 ail Internet Sales Amount 3 7 User analysis settings Every user could define his own preference while analyzing OLAP data with AnalysisPortal applicatio
7. 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 Bad limit values bellow this limit are shown with Fail KPI icon British Columb 1 955 340 10 Brunswick Manitoba Set Grid KPI Ontario 236 96 Set Column KP Quebec 7 Drilithrogh by Set Cell KPI Total 1 977 844 86 Gene 2 644 017 71 Show All KPI s OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 34 Kyubit AnalysisPortal OLAP Analysis User manual KPI Definition KPI Area Scoring pattern 8 2 Using KPI ES Increasing is Better 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 associated with To view or change KPI details open KPI definition panel from the list All KPI s Measure Internet Sales Amount Cell KP 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 kyubit com 35 Kyubit AnalysisPortal
8. 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 t amp URL http localhost 1130 report aspx Analysi Customers EMBED lt iframe frameborder 0 vspace 0 hspac Country D Australia B France HEB Germany United Kingdom J United States Publishing WO Canada 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
9. 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 AnalysisPortal 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 columns OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 33 Kyubit AnalysisPortal 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 AnalysisPortal offers functionalities to define performance bounds for a certain analy
10. 2 644 017 71 Bayern 399 966 78 Brandenburg 119 571 08 Hamburg 467 219 04 Germany Hessen 794 876 08 Nordrhein Westf 459 591 88 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 AnalysisPortal 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 kyubit com 36 Kyubit AnalysisPortal 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 ana
11. 307 584 08 Z 2 265 451 62 27 181 81 Z 2 348 694 23 OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 9 Kyubit AnalysisPortal OLAP Analysis User manual 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 36 949 67 24 227 81 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 2 265 451 62 Clothing 27 181 81 Sum Z 2 348 694 23 a Category a Education a Calendar Year Accessories Country Australia Bachelors CY 2005 CY 2006 Gra
12. AnalysisPortal 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 France Level Sorting Level Value Filtering Create Named Set Germany Remove Level United kingdom ZII ass United States 9 389 789 51 Sum E 29 358 677 22 OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 18 Kyubit AnalysisPortal OLAP Analysis User manual 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 Select named set members Set named set expression _ France C Germany C United Kingdom Delete Close 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 set every time named set is used expression will be executed in the ana
13. OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 16 Kyubit AnalysisPortal OLAP Analysis User manual 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 Bikes Internet Sales Amou 2 808 514 35 Clothing Sum Internet Sales Amou F 2 894 312 34 Accessories Internet Sales Amou 23 565 40 Internet Sales Amou 62 232 59 a Country 1 State Province T Germany Seine Paris Nord Seine Saint Denis Essonne Yveline Hauts de Seine Seine et Marne 13 160 02 9 894 27 9 894 58 5 243 89 5 561 12 6 068 76 2 269 55 520 736 35 376 505 11 365 162 25 271 240 03 261 360 26 254 967 08 106 807 40 5 829 43 5 000 82 4 422 92 2 813 26 1 743 42 2 380 35 658 295 539 725 80 391 400 20 E 379 479 75 E 279 297 18 268 664 80 E 263 416 19 E 109 735 24 2 529 78 2 282 44 1 181 39 1 786 19 693 50 599 72 969 42 90 860 18 88 320 75 53 062 43 44 514 36 33 515 83 28 547 67 76 985 36 70 441 44 10 549 71 5 2 553 575 71 3 282 847 66 1 821 302 39 8 852 050 00 8 999 859 53 I 28 318 144 65 5656 27 959 72 397 90 455 35 5232 40 407 89 523 534 318 92 234 9
14. Sales Amou 70 259 95 553 164 62 27 035 22 523 565 40 32 239 51 Internet Sales Amou 5 597 668 50 Z 1 209 412 67 F 1 948 504 01 z 52 135 796 50 F 2 508 534 84 United States Sum 256 422 07 E 700 759 96 5 772 613 54 E 18 521 427 47 133 507 91 Z 339 772 61 E 6 162 543 52 E 19 561 960 04 3 2 Grid Analysis concepts Most common way of OLAP data analysis in AnalysisPortal 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 OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 7 Kyubit AnalysisPortal OLAP Analysis User manual Filters area Values area Kyubit a Analysis AnalysisPortal i New Analysis Menu Analysis Analysis ie Adventure Works gill Measures 14 Customer 4 Date 4 Delivery Date 4 Employee W Geography 2 Internet Sales Order Details 4 Product lZ Promotion 14 Reseller 4 Reseller Sales Order Details 4 Sales Channel 4 Sales Reason 4 Sales Summary Order Details 4 Sales Territory 4 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 databa
15. isolate California Alabama Drilithrough California by Drill California By 4 Ml Drill Down California OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 27 Kyubit AnalysisPortal OLAP Analysis User manual T Applied filters Customer Geography United States Wyoming INTERNET SALES AMOUNT CE O O O OOOO Wirginia Utah Texas South Carolina Orezon M ahia Morth Carolina Mew York Montana Mlissouri 1 a Z D _ cL I a m on Mississippi Minnesota Massachusetts Kentucky Illinois Georgia Florida califo i a Arizona isolate California Alabama Drilithrough 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 different 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 Analysi
16. 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 AnalysisPortal application user needs permission also in AnalysisPortal folder with given analysis OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 5 Kyubit AnalysisPortal OLAP Analysis User manual 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 permissions While analyzing data se select folder to share Delete Close 2 1 My Analysis By default all users have My Analysis folder When saving analysis an
17. 389 789 51 Sum E 29 358 677 22 TY Customer Geography Canada United Kingdom a Country Internet Sales Amou Canada 1 977 844 86 United Kingdom 53 391 712 21 Sum z 5 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 Country Australia Level Sorting Canada Level Value Filtering France Create Named Set Germany Remove Level United States 9 389 789 51 sum 29 558 677 22 OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 14 Kyubit AnalysisPortal OLAP Analysis User manual Value filtering for level Country Measure Intermet Sales Amount Filter Value 5 Remove Close Drop Series Here Internet Sales Amou United States 59 389 789 51 Australia 59 061 000 58 United Kingdom 3 391 712 21 Germany 7 894 512 34 France 7 644 017 71 Sum E 27 380 832 36 3 9 Sorting all members on grid axis Grid analysis data could be sorted on axis level and o
18. 4 E 27 035 22 32 239 51 53 164 62 70 259 95 133 507 91 Z 339 772 61 E 94 046 23 Z 91 562 91 E 54 641 72 I 46 755 90 5 34 441 73 I 29 555 28 E 28 478 12 5 21 473 74 E 11 342 92 F 2 644 017 71 F 3 391 712 21 F 1 977 844 86 9 061 000 58 9 389 789 51 I 29 358 677 22 Moselle France Loiret Garonne Haute Val d Oise Charente Maritime Somme Val de Marne Loir et Cher 5713 38 Fas de Calais 5558 77 Sum E 63 406 78 76 530 04 103 377 85 Australia 138 690 63 United States 5256 422 07 Sum 700 759 96 United Kingdom Canada S11 Pivot Anytime while analyzing data in AnalysisPortal user has possibility to switch dimension hierarchies on the Categories and Series axis For many reasons switching axes could be very practical while 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 Subcategory Accessories Bikes Clothing Sum Road Bikes Internet Sales Amou Mountain Bikes Touring Bikes Sum Country 4 State Province vt Internet Sales Amou Internet Sales Amou Internet Sales Amou Internet Sales Amou Internet Sales Amou Internet Sales Amou Germany France United Kingdom Canada Australia United States Sum Seine Paris Nord Seine Saint Den
19. 99 92 5 26 162 66 Drilithrogh by Set Grid KP Set Column KP Set Cell KP 8 639 84 Z 6 779 88 OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 31 Kyubit AnalysisPortal 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 dylani7 adventure works com 161 555 0181 769 49 Megan C Rivera megan37 adventure works com 114 555 0120 769 49 Marissa E Butler marissali adventure works com 974 555 0179 769 49 Dylan C Wilson dylan34 adventure works com 951 555 0169 769 49 Daniel L Clark danielS adventure works com 259 555 0179 769 49 Alexandria A Gonzales slexandrial7 adventure works com 147 555 0143 769 49 Sean A Howard seanl9 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 alexial0 adventure works com 632 555 0172
20. 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 INTERNET SALES AMOUNT Set Series To Add Filter Change Chart Measure Add Measure Change Category vot Chart Show Hide Empty Series Sort alphabetically Asc Sort alphabeticaily Desc i Open in PDF i i i i Country OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 24 Kyubit AnalysisPortal OLAP Analysis User manual 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 44 Pivot chart To switch members from Categories to Series 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 c
21. 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 al Internet Tax Amount a Category a Subcategory Product Internet Tax Amount Accessories 56 060 80 Mountain Bikes 796 220 81 Road Bikes 1 161 646 73 Clothing Sum Touring 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 3000 Yellow Touring 3000 Yellow Touring 3000 Yellow Touring 3000 Yellow Touring 3000 Yellow Sum 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 3 503 89 3 503 89 2 850 62 2 791 24 2 969 40 Z
22. Using OLAP analysis features of AnalysisPortal www kyubit com T Kyubit AnalysisPortal OLAP analysis User Manual Using OLAP analysis features of AnalysisPortal 2015 All rights reserved www kyubit com 2 Kyubit AnalysisPortal OLAP Analysis User manual Contents 1 OLAP c DErelerENCE Si eenean een ere E eter E T eter EE E E EE EE EEEE renter errr cerry etree errr etree 4 2 Folders n a ee ee ee er ee eee ee 4 2 1 MY PANS Se aE EEEE E EEE E ERE EE IEA ORE E E AE EA E EE 5 3 1 Start GIy SIG ie ne E E E EEE E E E E E E TE E E E S 6 3 2 1 C bbe Tree StruUctUre seoser E e EE E EEE E E E EE E EEE EREE EEE EE EEEE REEE EEEE 7 3 2 2 Categories and SENES enr aoe e E E E E E E E auton 8 3 3 Expand member single dimension Nierarchy ccccccccccccsssssssseeeeeccccccecesuaesssseeeeeeeeeeeesssauseessseeeeceeeeeesssaaaeeassseeeeeeeeeesssauaansaseeeeess 8 3 4 Expand member different dimension Nierarchy ccccccsssssssssseeecccccccecssaeeesseeeeeccceeeesssaueeessseeeeceeeeeesssaaaasssseeeeeeeeeesssauaaasseeeeess 9 3 5 Endal olap e EnEn S aa a E AER AAEN et EEEE E EN 9 3 6 TC Vit member eeri pa EE E E E E EEE EEEE EEE 10 3 7 User analysis SS CCIE Sy sre E A AEE AE EE EO E 10 3 7 1 GIG AVS S AEEregateS innisin an anae aE EE AAR EEA AAE TEA EEA EE EEEE E R EE E EE 11 3 7 2 Show hide empty rOWS cccccccccccccccccessssssssneeeeeececeeceseeeeesseeeeeeeeeeesesseeeeeeaeeeeeeeeeeceseseeeeeaseeeeeeeeeeeeeeeeeeeaaaeeeee
23. York Newark C Newcastle C Newcastle upon Tyne C Newport C Newport Beach Remove Filter Close OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 13 Kyubit AnalysisPortal OLAP Analysis User manual 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 isolating 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 9 061 000 52 Canada 1 977 844 86 France S2 644 017 71 Germany 52 894 312 34 United Kingdom 53 391 712 21 United States 59
24. Z 88 320 75 Z 53 062 43 Z 44 514 36 Z 33 515 83 28 547 67 Z 26 985 36 Z 20 441 44 Z 10 549 21 2 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 23 565 40 5 829 43 5 000 82 4 422 92 2 813 26 1 743 42 2 380 35 658 29 656 27 959 72 397 90 455 35 232 40 407 89 523 34 318 92 234 94 27 035 22 32 239 51 53 164 62 70 259 95 133 507 91 Z 339 772 61 OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com Z 2 894 312 34 539 725 80 391 400 20 Z 379 479 75 Z 279 297 18 Z 268 664 80 Z 263 416 19 Z 109 735 24 94 046 23 91 562 91 54 641 72 Z 46 755 90 34 441 73 29 555 28 28 478 12 21 473 74 11 342 92 5 2 644 017 71 3 391 712 21 Z 1 977 844 86 9 061 000 58 Z 9 389 789 51 29 358 677 22 17 Kyubit AnalysisPortal OLAP Analysis a Category Subcategory Accessories Mountain Bikes Road Bikes Bikes 2 Touring Bikes Sum Clothing Sum User manual Country 1 State Province Germany t France Seine Paris Internet Sales Amou 62 232 59 1 003 800 98 1 380 342 85 424 370 52 2 808 514 35 23 565 40 Z 2 894 312 34 internet Sales Amou 13 160 02 186 654 01 276 410 85 57 671 49 Z 520 736 35 5 829 43 Z 539 725 80 internet Sales Amou 9 894 27 131 668 22 194 250 41 50 586 48
25. alysis 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 AnalysisPortal OLAP Analysis User manual 3 OLAP Grid Analysis 3 1 Start Analysis To start analysis click on the Start Analysis on the AnalysisPortal 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 a AWorks Contoso al contoso2 New Cube Reference New Analysis Chart Report T Calendar CY 2007 CY 2008 a Category Accessories Bikes Clothing Sum a Country Australia Canada France Germany United Kingdom Internet Sales Amou 138 690 63 103 577 85 63 406 78 562 232 59 76 630 04 Internet Sales Amou 5 388 717 92 1 052 870 20 1 858 062 01 2 049 498 51 2 399 665 29 Internet
26. ategory 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 MM Accessories pikes JR Clothing INTERNET ORDER COUNT Isolate Australia solate Bikes in Australia Isolate Australia Drillthrough Australia by Drilithrough Bikes in Austra by Drill Australia By Bikes in Australi By Down Australia lm ES a Country OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com Kyubit AnalysisPortal OLAP Analysis User manual Y Applied filters Customer Geography Australia Category MM Accessories D eike JB clothing INTERNET ORDER COUNT isolate Australia isolate Clothing in Australia Drilithrough Australia by Drillthro
27. duate Degree High School France Germany 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 a State Province Alberta Internet 5a ritish Columbia Ontario Sum Internet Sales Amou 103 377 85 7 1 821 302 39 5 53 164 62 5 51 977 844 86 Internet Sales Amou 336 96 Internet Sales Amou 102 926 43 1 799 474 48 52 939 19 5 1 955 340 10 a Category a Subcategory Accessories Bikes Clothing Expand all member Drill down Accessories Sum Isolate Accessories Z 56 96 State Province Alberta Internet Sales Amou Ontario Sum Internet Sales Amou British Columbia a Subcategory Internet Sales Amou Internet Sales Amou Bike Racks Bike Stands Bottles and Cages Cleaners Accessories Fenders Helmets Hydration Packs Tires and Tubes Sum Mountain Bikes Road Bikes Touring Bikes Sum Caps Gloves Jerseys Shorts Socks Vests Sum Clothing 240 00 27 96 21 98 34 99 89 53 Z 414 46 2 294 99 14 022 43 5 510 49 Z 21 827 91 17 98 24 49 103 98 69 99 8 99 Z 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
28. eeeeeeeceeensgaas 11 3 8 Filtering eridianalysis data ereinen ES E E oes ge case E EE EE EEEE Ee evacuson eneyee 11 3 8 1 Searc VIB MMO GIS m oense aE EE TE E EEEE E EEE E E E E ERE E EE E EEEE 12 3 8 2 SOIA UNE e E E E E 13 3 8 3 Dimensiomlevel value NS IDES eeren a A E E E E E AE E A E A REEE 13 3 9 Sorting all members on grid aXiS ig carresesesscaettetnscnatece ste tecionenest esp tee ite Gascrnamteuated cuseidnecevactoustedasltuideq eaa asl diiheessatactou sane beancueteasnadet cpsaueteaoeimne 14 3 10 Sorting Members on a Particular dimension LOVE cece ccccsssssssssseeeecccccceessaaueessseeeeeeeeeeeesssssaeesseeeeeeeeeeeesssuaaaeessseeeeeeeeeeesaaaagees 15 3 11 PIVOT ee ene ene eee eee ee E E E EEA E EE E e ee EE E 16 3 12 Gi VSS in Percentile eaaa EEEE EERE EREEREER EEEE EE EEE E EE E E E EEEE EEEE EEE 17 3 13 Create and manage ad hoc User Named sets sssssssseeccccccceceaaeeesssseeeccceeeeeessueeesseeeeeceeeeeessssaeeesesseeeeeeeeessssauaessaseeseeeeeeeees 17 3 13 1 Create Named Set by picking MEMBDES veisinscassnressvasavacdaannensdunanyavdnenssandunawenniiarsvavduasdoanivaenennivssanandeaonrmndaasnnarbesnavardeanaenssins 18 3 13 2 Create Named Set by expresSiON msrersssessirrirrirsssssrssites irinin isens Vats rini EENT En SVANA EINER ENTON S mean SENEESE ANNE NV KENE ENON AESSR ENE RES 18 3 13 3 Edit existing User Named SEtSeererais errien nn iE E ETA E TE E E EEEE EE E AEE EE E EE ier 19 3 14 Create and manage ad
29. h new analysis Clear action 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 Acar arar 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 Internat Talar Arnant OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com P Run from history P Run from history P Run from history P Run from history P Run from history 23 Kyubit AnalysisPortal OLAP Analysis User manual 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 hierarchy on Series axis in Grid view will be shown as Series in Charts view In Grid analysis it is possib
30. h 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 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 Available folders to share Human Resources OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 22 Kyubit AnalysisPortal OLAP Analysis User manual 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 category and series dimension hierarchies and time of execution Analysis history is reset with eac
31. hoc User Calculated Measures ccccccccccssssssssssseeeccceecceeseaaaussseececeeeeeesssauaaeseseeeceeeeeeessssuaaaasseeeseeeeeeeeeas 19 3 14 1 Edit existing User Calculated Measures ccccccssssssssssseeecccccceecessuaeeessseeeeeceseeessssseeeessseeeeeeeeeessssauaesassseseeeeeeeesssaaaaanaseeeess 21 3 15 SAVE analysis Staten sissssrinerissid isro sinari sik ne EANAN E EANET a EAEAN A EAEE EANAN OAOD VEEE ESA TEANA TEENGAA EE iA 21 3 16 Share LS I eaer eee E E E EE E E EE E E AEE EEE E ETE 21 3 17 Analysis history move Dack and TO Wald srcnsennussenansnarcnsavenaasam EEEN RERE UTTER EENET EE EEE EREET EE NEER EEEE EEEE ESEE EEE K 22 4 Chart Analysis TUNCHONANTES ae perrie eE E EE AEE E AEE E EAEE E EE EA EAEE 23 4 1 CAEP Ones mera rara EE E E EE AE EEE E E EET 23 4 2 E E A E eae TUDO La Sua daa Sue 23 4 3 Change or add measure ccs sactaccatacndstisnartoeuspacesgapascsanubneadeauneetacuuiecapaquee ete anstaeni sins ctpseencannceuantodesiaqutsesnaderqansqnezuimensnabenieaeetan 24 4 4 Pivot chart nea a ete ee ee E eee ee ee ee ee te ee ee ee ee ee err nee 24 4 5 PSG AIEEE ane E arian anaes EE eaunnensaniuanss aun nuesaeuseseaiiaan E E E E 24 4 6 Drill category member values Slice Gicasccsncatinnosesssieinactdannencsinanncdaunneaddann conan ncn siacdnadasqadaneesadained saad eeeisaddseissaahiadasnadeqasnaabinantnensaand 24 4 7 Bg Ro OW Menea eee eaten A ae ec ee ere ee eee ee er er ee ee ert ee ere cre ern 26 4 8 Tie visuals oaeee scene
32. iated 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 kyubit com 32 Kyubit AnalysisPortal OLAP Analysis User manual 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 tjut Measures ai Amount KE Channel Product Name Le Currency Sales Unit Price IZ Date IZ Employee IZ Entity LZ Geography Product aa Prod
33. ile 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 Country a State Province Internet Sales Amount OI Danana oa 9 061 000 58 da Alberta 22 467 80 British Columbia 1 955 340 10 Set Aggregates Ontario 36 96 Avg Avg 659 281 62 France 2 644 017 71 Set Row Sorting Normal Germany 2 894 312 34 Set Column Sorting Large United Kingdom 3 391 712 21 United States 9 389 789 51 Ave 4 893 112 87 Pivot Canada Set Column Width Small 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 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 d
34. imension 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 OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 12 Kyubit AnalysisPortal OLAP Analysis User manual Select members of hierarchy gt Product Categories a Search Selected members _ All Products C Mountain Bikes Accessories _ Touring Bikes _ Bikes Mountain Bikes N Road Bikes _ Touring Bikes Clothing Components Remove Filter 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 Select members of hierarchy gt Customer Geography Browse searc Selected members New Castle new New Hartford Contains All Kennewick C New Castle C New Hampshire New Hartford New Haven New Mexico C New South Wales New York New
35. ination Currency 1 Employee July 51 437 30 5 496 634 76 156 708 15 L Geography August 69 604 03 8 542 726 62 224 151 64 September 67 788 43 7 428 347 62 202 823 12 V Internet Sales Order Details gt nes October 46 472 74 5 250 047 83 124 758 83 E Organization November 58 255 44 8 547 195 02 162 844 43 LK Product December 58 627 88 7 821 948 85 155 251 30 Financial Sum 637 590 73 84 105 429 60 Z 1 748 777 45 Q History PS Starking Total Product Cost 257 151 05 484 204 62 423 384 71 622 148 52 1 045 998 79 993 064 46 1 080 824 82 1 686 479 99 1 554 415 80 587 508 79 1 071 792 05 959 136 59 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 kyubit com Subscribe 1 To 38 Kyubit AnalysisPortal OLAP Analysis User manual My Subscriptions Total product cost subscription All subscriptions created by me E TET o 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 Wedne
36. ion issues w First subscription O Margins extended report ti Month sales w Bikes in Canada overall subscription ti Production Analysis ti Product Sales 04 UD sales Q4 PDF ti Sales Q4 ti Sales 04 monthly ti 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 AnalysisPortal a Total Product Cost by Month Delete Subscription Occurence Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Weekly Monthly Weekly 14 30 09 35 15 00 13 00 13 50 16 10 8 15 7 30 9 00 Time History Type DASHBOARD DASHBOARD DASHBOARD DASHBOARD DASHBOARD ANALYSIS DASHBOARD DASHBOARD DASHBOARD DASHBOARD ANALYSIS Components Sum Analysis Dashboards Grid Chart Report Back Clear Analysis al Total Product Cost Adventure Works All measure groups Category slim Accessories Bikes Clothing al Measures s Month of Year Total Product Cost Total Product Cost Total Product Cost Account January 35 136 93 4 636 857 52 83 479 76 KE Customer February 38 394 83 7 677 423 65 100 541 44 LK Date March 39 340 59 6 602 443 60 96 208 09 Z Delivery Date April 49 107 75 5 675 780 85 126 206 34 IZ Department May 64 615 46 8 840 181 01 162 201 81 inati June 58 809 36 7 585 842 27 153 602 54 iZ Dest
37. is Essonne Yveline Hauts de Seine Seine et Marne Moselle Loiret Garonne Haute Val d Oise Charente Maritime Somme Val de Marne Loir et Cher Pas de Calais Sum t t Ft F 62 232 59 13 160 02 9 894 27 9 894 58 5 243 89 5 561 12 6 068 76 2 269 55 2 529 78 2 282 44 1 181 39 1 786 19 693 50 599 72 969 42 713 38 558 77 Z 63 406 78 76 630 04 103 377 85 138 690 63 256 422 07 Z 700 759 96 1 003 800 98 186 654 01 131 668 22 127 047 32 83 601 34 89 671 50 91 678 91 38 847 68 37 525 91 32 356 32 13 383 03 14 365 86 16 081 36 8 743 05 14 230 87 9 775 88 3 629 47 Z 899 260 71 1 162 980 29 615 440 40 2 853 819 45 3 417 457 74 Z 9 952 759 56 1 380 342 85 276 410 85 194 250 41 176 574 67 149 604 96 137 141 12 120 484 86 55 205 76 39 929 22 47 484 54 33 696 42 21 511 59 15 050 41 18 589 77 9 628 08 10 665 56 5 704 89 1 311 933 10 1 598 217 48 935 616 29 5 004 548 42 4 289 925 90 14 520 584 04 424 370 52 57 671 49 50 586 48 61 540 26 38 033 73 34 547 64 42 803 31 12 753 96 13 405 05 8 479 89 5 982 99 8 636 91 2 384 07 1 214 85 3 126 42 1 214 85 Z 342 381 90 521 644 89 270 245 70 993 682 14 1 292 475 90 Z 3 844 801 05 2 808 514 35 Z 520 736 35 Z 376 505 11 Z 365 162 25 Z 271 240 03 261 360 26 254 967 08 106 807 40 Z 90 860 18
38. it AnalysisPortal 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 AnalysisPortal application Once it is referenced it can be reused in different analysis and reports and used by any users of AnalysisPortal which has permissions for the same Cube reference Cube reference just represents central catalogue of all available OLAP cubes to use in AnalysisPortal 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 AnalysisPortal 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 L Set custom connection string Test connection Save Clos 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 To assign permissions for other users select Permissions link 2 Folders To give
39. ivered at scheduled time OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com
40. le to select more dimension hierarchies for each axis Chart view will accept show only first dimension hierarchies for both axes 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 change 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
41. lysis 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 kyubit com 37 Kyubit AnalysisPortal OLAP Analysis User manual 10 Subscriptions Important aspect of Kyubit AnalysisPortal 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 AnalysisPortal with at least Read permission has privileges to make a subscription to OLAP analysis and receive analysis report on email within scheduled time of delivery 10 1 My subscriptions Every user can see all his own subscriptions Analysis and Dashboards in AnalysisPortal where all his subscriptions could be managed Dashboards Kyubit AnalysisPortal Analysis Analyses OLAP Data Sources OLAP Shared Items Subscriptions D My Subscriptions 9 All Subscriptions O G 0O O O 0 G O G O O Create New Subscription My Subscriptions Title t Product
42. lysis scope to return members and use within analysis 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 OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 19 Kyubit AnalysisPortal OLAP Analysis User manual 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 Cal Adventure Works gill Measures Customer a fi i Pri gaa Gray OLAP database defind Named sets Demographic Location Sets Top 50 Customers Rich cities oo Canada amp Germany High Education Blue AnalysisPortal defined Named Sets Customer Customer Geogrrap 4 Date W Delivery Date Kyubit AnalysisPortal a Menu Analysis Folders Cube references Shared Items User Named Sets R User Drillthrough Columns ail User Calculated Measures User Named Sets Delete Named Sets Name C Rich cities Canada amp Germany Data Source ADW 2008R2 ADW 2008R2 C Cams and camcordsers C High Education C
43. n 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 Hide Empty Rows Aggregate operation Sum Grid column width Large User AD groups PERPETUUM Domain Users Everyone BUILTIN Administrators BUILTIN Users NT AUTHORITTIINTERACTIVE CONSOLE LOGON NT AUTHORIT Y Authenticated Users NT AUTHORITY This Organization LOCAL PERPETUUMIVPW korisnici RTA ee A N i i E Save Refresh Close OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 11 Kyubit AnalysisPortal OLAP Analysis User manual 3 7 1 Grid analysis Aggregates 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 Country State Province Internet Sales Amount Ny 59 061 000 52 Australia Alberta 22 467 80 British Columbia 1 955 340 10 Set Column Width Ontario 226 96 AVE Ave 659 281 62 France 2 644 017 71 amp Set Column Sorting Germany 92 894 312 34 Show Hide Empty Series United Kingdom 53 391 712 21 Pivot United States 59 389 789 51 Ave 4 8935 112 87 Create User Calculated Measure Canada Tt Set Row Sorting View Values View Column Percentage View Row Percentage 3 7 2 Show hide empty rows In some situations wh
44. n 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 Intemet Sales Amount Optional Sort using values in Columns Sort order OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com Kyubit AnalysisPortal OLAP Analysis a Country Canada France Germany United Kingdom Australia United States sum User manual a Category Accessories Internet Sales Amou 1053 377 85 63 406 78 562 732 59 76 630 04 138 690 63 256 422 07 z 5700 759 96 Bikes Internet Sales Amou 1 821 502 59 2 553 575 71 2 808 514 55 3 987 84 66 8 852 050 00 8 999 859 53 Z 28 518 144 65 Clothing Internet Sales Amou 553 164 62 27 035 22 523 565 40 32 239 51 570 259 95 133 507 91 E5339_772 61 Sorting with selected member on opposite axis Grid sorting definition for Rows Sort by Intemet Sales Amount 3 Internet Sales Amou Z 1 977 844 86 F 2 644 017 71 z 2 894 512 34 3 391 712 71 9 061 000 58
45. res 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 AnalysisPortal a User Calculated Measures Analysis Delete Calculated Measure Fold Name olders yal My Ratio Cube references wall calc 12 al yal test measurel Shared Items yal Internet sales amount share User Named Sets gt User Drillthrough Columns al 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 AnalysisPortal 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 analysis Shared folder does not mean that this analysis could be visible to everyone but only to users wit
46. sPortal User manual www kyubit com support kyubit com 28 Kyubit AnalysisPortal 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 m 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 Pe Kyubit AnalysisPortal OLAP Analysis User manual 5 Report view After analysis gets shape and data we want we often 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
47. sday 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 LJ 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 AnalysisPortal 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 separated by semicolon OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com Bie Kyubit AnalysisPortal OLAP Analysis User manual e Include type of delivered content o Only link to AnalysisPortal analysis o Link embedded analysis image user immediately sees analysis image when opens email message a ame we ee RININ o Link PDF dashboard document applicable only for dashboards e Disable all subscriptions marked disable will not be del
48. se and within AnalysisPortal is shown using tree view Analysis is performed by dragging desired elements Measures dimension hierarchies to appropriate areas on the right F Adventure Works gil Measures 2 Customer Demographic Location Sets i au Customer 4 Customer Geography All a Country State Province City Postal Code Customer Calendar a aa Calendar Calendar Quarter of Year Calendar Semester of Year Calendar Week of Year a aa Calendar Weeks a3 Calendar Year OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 8 Kyubit AnalysisPortal OLAP Analysis User manual 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 Categories 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
49. sis 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 s Country State Province internet Sales Amou Australia 9 061 000 58 Canada Alberta 22 467 80 British Columb 1 955 340 10 Brunswick Manitoba Ontario 36 96 Quebec Total E 1 977 844 86 France 2 644 017 1 Germany Bayern 399 966 78 Brandenburg 119 571 08 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 United States 9 389 78951 Tota 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 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
50. ssa rt cege EE E scene ssn EE EE EE E sols EE suas aves EA EEE EA E EE E EA EEE EEA EEE 27 4 8 1 Chart TYPES eere E E E E S 27 4 8 2 Palette ices eae wn E EEE EE REEERE EE EEEE EEEE EE EEE EEEE EE 28 4 8 3 Theme ceee e cents cee es er secese geen ersten canna rst cope pane ena epataceenmamnaepenecmunienemnanpeheammeermamiantenenmmicuamiengencauige 28 4 8 4 BEAT US US ets ade E sonra do E E sao asnends asueardnes nade E E 28 4 8 5 Semi LranS Parent ODU ON raon enean ERa RENE EEN E EEEE ERER a CERE EAEE ER EEEREN EEN EER a EREE ER EEEE ERER e CEREA EER ER EEEE ER 28 4 8 6 Show VES UIP score cine ceuasoacesdanieacyatie cnscusbeendead neceocagedua ates chaduwtneaiacuhesdenextacngacisuchoteuirantetiiecietermanesuuineietaxnecieetnceeen 28 4 8 7 BS Dour MEE ci A faces wa ates eevee wi ct pee ceca Sane ade deve aetna eed cg A 28 5 Report VIEW ensrreec inser siten E EE O E E ETE ETE A 29 OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 3 Kyubit AnalysisPortal OLAP Analysis User manual EXPO RUNG ODEO IS anisan n a RERE E E E EEE E E EE E E EE EE EE EE E EE 30 EM FOUS SUING ONAN eS ereere ena EEA EEE EEEE AAE EE A EEEE E E EA e 30 7 1 Custom drillthrough 1 o3 caaniineersnandseptaranves sorantonntanmenatenaneiencunne nants enveaatiesseaniowen randy eaietuevand anenad native toanindananinen aan nan nnbnaaautenaenanenath 31 7 2 Drillthrough results links Ge raecossepnnestaass cavoneamsavtneeness hiaceunniunecsanhliaen
51. t Add Measure Measures Internet Sales Amount Measures Sales Amount Format Values Percent gt Test MDX expression 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 Analysis ortal New Analysis Users Menu Analysis Grid Chart Report History Save Save As Analysis al Internet Sales Amount al Sales Amount ul internet sales amount share Adventure Works wh Measures J Internet Customers Internet Orders J Internet Sales Reseller Orders Category Subcategory internet Sales Amount Sales Amount internet sales amount share Accessories 700 759 96 1 272 057 89 55 09 J Reseller Sales D Sales Orders Sales Summary J Sales Targets D User Calculat easures ail My Ratio wl calc 11 sil test messurel al internet sales amount share Mountain Bikes Road Bikes Touring Bikes Sum Bikes Clothing Components Sum 9 952 759 56 14 520 584 04 3 844 801 05 28 318 144 65 339 772 61 29 358 677 22 36 445 443 94 43 878 791 00 14 296 291 27 94 620 526 21 2 117 613 45 11 799 076 66 109 809 274 20 OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 27 31 33 09 26 89 E 87 29 16 05 101 06 71 Kyubit AnalysisPortal OLAP Analysis User manual 3 14 1 Edit existing User Calculated Measu
52. that would show only final analysis data Report view hides almost all AnalysisPortal 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 oO Jf o ee ra kas 7 I A l l l A TA a 2 a z amp 3 2 oo 2 2D b 2 DS 4 zo a 2 a Zz a O D D 2 S pas 3 a Q 2 O P v a EA amp r amp a S gt 2 2 2 as KA 2 a gt Month OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 30 Kyubit AnalysisPortal OLAP 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
53. uasd vaaaqen acamneduesuniddeciancheaecmnbeqununenesaasdsannuntsanieapeauimvteanawenneae 32 7 3 Saving drillthrough columns and reuse ssnssssssnnnenennsssssssssrrtreereeossssssrrrrrrrrersssssssrtrerereoeossssssrrrrerrerosssssssrererrreosessssenerrerreesessss 32 Be UMS FV UNS e e as Sats a aa Sa a gat See a Sea See ac ee ee 33 8 1 Detinee TP is ee E E E E E E E E A EEE EE EE 33 8 2 USINE KPI ae E E E E a a 34 Publishing Features i ynucccaanntettseusesvaucuesueuauendsapaweni wera oandl eaves sduaacusnnieaansntinuacentiaennsnieemeandbepunandderanerd lesen dasnvaheiianeesieaundee sume senmuctsenment der 35 9 1 PURINE SNS cererea EE EE EEEE EE EEEE EAEE AE EEE EEEE EEE EEES 35 9 1 1 Publishing URL and EMBED SNIN Esaeren E tons E EE EEEE EAEE EER EEEE EEEE ER E E E A E RE 35 9 1 2 REDOT AlNAS ceneno e a EEA EAE EE ETE EE 35 9 1 3 CACHE aeea E A A A E E E 35 9 1 4 IMpersonate sssrinin ie onansnvotunnhtiantanid venus RE E ETSE ETE E LETTIE EEEN ETE EEEE LETE AEE EEEIEE EEEO TEASEE EEES ESTERE ETETEA 36 9 1 5 Visuals eee E EE EE E 36 BASS CN C1 NS eae e E E A E E E T E E E 37 10 1 MY SUDSCHAP IONS esmee ee E E AEE EE EE E E T 37 10 2 S bscriptions Within analysis ar aciee ects cascee ceaninsceaasisicte ine vate EN NK CREEA EEN ONEEN EAE EEEN EAO EEEE EEOAE TEENER EEEE TEENER NEEESE 37 10 3 SE SCF ION AETS sea eaa E E E EEE E EE EEE EE E E E E E R 38 OLAP Analysis with AnalysisPortal User manual www kyubit com support kyubit com 4 Kyub
54. uct Available For Sale Date aa Product Brand Name aa Product Category Description aa Product Category Name aa Product Class 3 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 define 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
55. ugh 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 JR 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 26 Kyubit AnalysisPortal 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 SALES AMOUNT ARSE O O O OOOO virginia Utah Texas South Carolina Orezon M Ghia Morth Carolina Mew York Montana Missouri Mlississippi State Province Minnesata Massachusetts Kentucky Illinois Georgia Florida SAER O Arizona

Kyubit AnalysisPortal OLAP analysis

Contents

Download Pdf Manuals

Related Search

Related Contents