Home

Kyubit AnalysisPortal 2.0

1. Server side prerequisites e Windows Vista Windows 7 Windows Server 2003 2008 2012 e NET Framework 3 5 SP1 e IIS 6 or newer version e ASP NET e MS SQL Server 2005 2008 2012 for AnalysisPortal internal database MS SQL Server should be available somewhere on the intranet Also Express edition of SQL Server could be used e MSCharts available in AnalysisPortal installation Client side prerequisites to use full features of AnalysisPortal is one of the following browsers e Internet Explorer 9 10 e Chrome e Safari Client side prerequisites to use AnalysisPortal Report or PublishedAnalysis is one of the following browsers e Internet Explorer 7 8 9 10 e Chrome e Safari e FireFox www kyubit com support kyubit com 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 User manual 1 2 Kyubit Subscription service installation Kyubit Subscription service is windows service application with features to send subscription mails with attached analysis created with AnalysisPortal software Subscription service is installed separately since it could be installed on same or on different server as AnalysisPortal application Kyubit Subscription service server prerequisites e Windows Vista Windows 7 Windows Server 2003 2008 2012 e NET Framework 3 5 SP1 or higher 1 3 Planning deployment AnalysisPortal is web application that has to be installed on the
2. 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 e Grid view KPI for every value in grid KPI will be shown based on a single KPI threshold on grid level e Column KPI for every value in specified column KPI will be shown based on a KPI threshold on a given column e 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 Good limit values over this limit are show as Success KPI icon Bad limit values bellow this limit are shown with Fail KPI icon www kyubit com support kyubit com 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 User manual British Columb 1 955 340 10 Drilithrogh by k Brunswick Manitoba Set Grid KPI Ontario 536 96 Set Column KPI Quebec ES Q Set Cell KPI Total I 1 977 844 86 2 644 017 71 Show All KPI s KPI Definition Ceili Scoring pattern Increasing is Better M Category
3. United States Sum Category Accessories Bikes Clothing Sum Seine Paris Nord Seine Saint Denis 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 nm Subcategory Mountain Bikes Road Bikes Touring Bikes Sum a Category Accessories Internet Sales Amou 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 5 63 406 78 76 630 04 103 377 85 138 690 63 256 422 07 Z 700 759 96 Subcategory Bikes Mountain Bikes internet Sales Amou 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 5 899 260 71 1 162 980 29 615 440 40 2 853 819 45 3 417 457 74 9 952 759 56 a Country v1 State Province vf Germany France 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 Seine Paris Road Bikes Internet Sales Amou 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 5
4. 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 each new analysis Clear action www kyubit com support kyubit com 2012 www kyubit com All rights reserved Errors and omissions expected History of recent analysis 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 Liles orc Kyubit AnalysisPortal 2 0 User manual 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 Internct Talar Arret P Run from history k Run from history k Run from history k Run from history k 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
5. 530 134 64 526 701 58 59 427 24 510 301 93 58 552 54 57 872 23 53 147 56 62 850 62 53 266 34 53 385 12 53 800 83 53 503 89 53 503 89 52 850 62 52 791 24 52 969 40 I 5307 584 08 52 265 451 62 527 181 81 Z 52 348 694 23 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 Category Country a Education Calendar Year Internet Tax Amount Accessories Clothing Sum Australia Bachelors Graduate Degree High School Partial College Partial High School Sum France Germany United Kingdom United States Sum www kyubit com support kyubit com 56 060 80 708 164 02 37 376 65 4 906 11 11 540 94 59 074 16 11 428 46 Z 36 949 67 24 227 81 36 712 08 10 437 99 Z 145 704 19 204 2
6. Calibri Font Size Font Color www kyubit com support Qkyubit com O 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 User manual 10 Subscriptions Subscription functionalities allows us to subscribe to receive analysis via email messages on a given time period Analysis grid charts and KPI are embedded in email so user automatically sees analysis without need to click additional link Any user can subscribe to analysis that is visible to him her and manage its own subscriptions while Administrator can manage subscription of any user Menu nalysi Create Subscriptions Title Occurence Maps Australia and Canada internet Weekly Sales Cube references Gender Children every 11 in month Monthly O usa Once Drillthrough columns amp education occupation Weekly Subscriptions My Subscriptions All Subscriptions 10 1 Subscription service Kyubit Subscription Service needs to be installed in order to subscription starts to deliver mails See installing and configuring section 10 2 Create subscription On the left side menu open Subscription section and then select Create Subscription New window will open with subscription details e Title Subscription title also is text that will appear in mail subject e Analysis Select analysis to subscribe to e Occurs Select time scope in which this subsc
7. calculated measures defined in AnalysisPortal To assign ActiveDirectory user groups permissions to any of these objects open certain object needs Read Write permission and select Permissions in the up right corner Existing permissions will be shown in the list Find users and groups from ActiveDirectory and add them to the list Mark users and groups and select Remove to remove them from object permissions www kyubit com support kyubit com 2012 www kyubit com All rights reserved Errors and omissions expected ON Kyubit AnalysisPortal 2 0 User manual Folder ay Permissions Add User Add Group Permissions are not set for this object Hide Permissions To set that absolutely all users can see or edit given object select Add users and mark Everyone Unrestricted access and give Read or Read Write permission Find Users from Active Directory C Everyone Unrestricted access Add Read Access Add Read Write Access Close www kyubit com support kyubit com 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 User manual 2 3 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 ActiveDirectory user group permissions Folders could be used to share analysis with common subject or belong t
8. 08 0 00 6 74 30 86 31 98 100 00 inte Kyubit AnalysisPortal 2 0 User manual 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 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 a Level Sorting Australia Level Value Filtering Canada France Create Named Set Germany Remove Level United Kingdon I5I71Z United States 59 389 789 51 Sum 1529 558 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 9 Select named set members Ir France Up C Germany C United Kingdom Down 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 wil
9. 4 422 92 2 813 25 1 743 42 2 380 35 5658 29 5656 27 5959 72 5397 90 645535 232 40 407 89 552334 318 92 8234 94 I 6539 725 80 6391 400 20 I 6379 479 75 5 279 297 18 I 268 664 80 I 263 416 19 109 735 24 I 94 046 23 5 91 562 51 5 54 641 72 I 46 755 90 5 34 441 73 1 29 555 28 I 28 478 12 1 21 473 74 5 11 342 97 Sum I 63 406 78 76 630 04 552553 575 71 I 27 035 22 3 282 242 56 632239 51 1 821 307 39 453 164 62 8 852 050 00 470 259 95 58 999 859 53 5133 507 91 I 28 318 144 65 Z 5339 772 61 5 82 644 017 71 5 83 391 712 21 I 61 977 844 86 I 9 061 000 58 I 9 389 789 51 1429358 677 22 United Kingdom Canada 103 377 85 Australia 138 690 63 United States 256 422 07 Sum 700 759 96 www kyubit com support kyubit com O 2012 www kyubit com All rights reserved Errors and omissions expected 3 11 Pivot Anytime while analyzing data in AnalysisPortal user has possibility to switch dimension hierarchies on the Kyubit AnalysisPortal 2 0 User manual 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 Country vi State Province vf Germany France United Kingdom Canada Australia
10. British Columbia Series Measure internet Sales Amount when value is gt 2000000 when value is gt 1000000 when value is lt Add Close 8 2 Using KPI 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 Shov Remove Measure Internet Sales Amount K Catego s I emove Measure Internet Sales Amount Cell KP Category British Columbia Show Remove Close www kyubit com support kyubit com 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 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
11. Import license 2 1 1 Activate deactivate users Every user who connects to AnalysisPortal is automatically becoming AnalysisPortal user Administrator does not have to add any user explicity Additionally administrator has privileges to activate deactivate any user in Administration gt Users amp Admins section Deactivated user will receive message that his her account is deactivated first time he she tries to connect to AnalysisPortal 2 1 2 Add remove user to Administrator role To add any user to Administrator role go to Administration gt Users amp Admins section mark user checkbox and click Set Admin Rights or Remove Admin Rights to remove user from Administrator role 2 2 AnalysisPortal objects and ActiveDirectory user group permissions To any of AnalysisPortal object types ActiveDirectory user groups permission could be assigned so other users could see and utilize their functionality Any object is visible only to his creator when created and to administrators To be visible to other users appropriate permissions needs to be set AnalysisPortal objects are e Cube reference reference to SSAS OLAP cube e Folder grouping of many analyses with common permissions set and or common business subject e Analysis OLAP grid and chart analysis e User Named sets named sets defined in AnalysisPortal e User Drillthrough columns columns to return in drillthrough action e User Calculated Measures
12. OU ag EE EEE EN 36 4 8 7 Pie Doughnut details 36 S REDON TT EEE EEE E EN EE 36 PENN 37 7 Drilthrough TunctionalitieS 444444 37 7 1 SUs ae OE ET a r E E O 38 7 2 Drilithrough results ARS an ea am ee ee eee ne 39 7 3 Saving Arillthrough columns and reuse cccssissccsscccesevdecensanssncessvnecnowavsarsnsendonssnaeesseussaeavencdaovervudedeoarses 39 www kyubit com support kyubit com O 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 User manual 8 KPlfunctionalities rrrrrnnrrnnnnnrnsrrnvrrnnnnenrrrnnrrnnnneererennrnnnnnessrnnnnnnnnnesssennrnnnnnsssssnnnnnnnnnessssnnnnnnnnsssssnnnsnnnnnene 40 8 1 BE Ne E OE E ENER 40 8 2 Le Go POE EEE EE SEE EN EE EN EEE 41 UIST ARE LE EEE EE NE 42 9 1 Publish Analyysi ES een ee nee on ERE NTE 42 9 1 1 Publishing URL and EMBED SEINE dans her een caesnese mens cine Odeon 42 9 1 2 REPOT Avr 42 9 1 3 og EEE E 42 9 1 4 DEVAS RAT AIS E RE 43 9 1 5 ET a a a a EEE 43 10 SOS COS dd eee eer 44 DL TN 44 102 Create subscripti Laser are einen 44 10 3 Subscription service lOp a NE 45 1 Installation and configuration 1 1 AnalysisPortal installation Prerequisites AnalysisPortal is standalone OLAP web application designed for Microsoft OLAP and Business Intelligence environment It relies on Microsoft software infrastructure and technologies which make prerequisites to install and work with AnalysisPortal software
13. if you do not want users to enter their credentials in AnalysisPortal application but you want browser to automatically detect user windows credentials There are some advanced system engineer concepts have to be taken to provide this kind of configuration We suggest engineers to start from Microsoft knowledge base http support microsoft com kb 917409 1 4 3 Scenario C AnalysisPortal IIS is on separate server from SSAS Basic authentication We would recommend Basic authentication if your SSAS is on a separate server than IIS AnalysisPortal for its simplicity User has to enter their credentials in the browser first time they connected to AnalysisPortal but once they have supplied user name password and mark checkbox for browser to remember them they do not have to supply it again If you use AnalysisPortal to expose OLAP data over internet it is recommended to add SSL encryption to your IIS web application AnalysisPortal and access it over HTTPS To set Basic authentication go to your IIS Manager open AnalysisPortal site under IIS Authentication disable Windows Authentication and enable Basic Authentication and that s it To return to Scenario A enable Windows Authentication and disable Basic Authentication www kyubit com support kyubit com 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 User manual 1 5 Troubleshooting after installat
14. rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 User manual 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 e Lines e Splines o Bars e Stacked Bars e Stacked Bars 100 e Columns e Stacked Columns e Stacked Columns 100 e Areas e Stacked Areas e Stacked Areas 100 e Pie e Doughnut e Radar 4 8 2 Palette Defines color sets that would be used to show chart values e Brigth e Grayscale e Excel e Light e Pastel e EarthTones e Semitransparent e Berry e Chocolate e Fire e SeaGreen e BrightPastel 4 8 3 Theme Defines background color for the chart area e Blue e White e Warm 4 8 4 Enable 3D view Apply 3D view for given chart analysis and defined chart visuals www kyubit com support kyubit com 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 User manual 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 cou
15. 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 URL EMBED lt iframe frameborder 0 vspace 0 hspac Publishing Report Alias Caching minutes impersonate User Name impersonate Password Published Visual elements Grid Visuals Chart Visuals http localhost 1130 report aspx Analys customers S Country EN Australia MA France MA Germany IN Canada INTERNET SALES AMOUNT 1 testAdmin pu DL y Customers WM United states United Kingdom Save Close internet Sales Australia 9 061 000 58 Alberta 22 467 80 British Columbi 1 955 340 10 Brunswick Canada Manitoba Ontario 536 96 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 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 va
16. 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 possible 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 www kyubit com support
17. 39 51 z 53 391 712 21 Australia 5138 690 63 8 852 050 00 70 259 95 9 061 000 58 United States 5256 422 07 58 999 859 53 6133507 91 I 59 389 789 51 Sum I 700 759 96 1428 318 144 65 I 8339 772 61 5429358 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 62 232 59 2 808 514 35 23 565 40 I 2 894 312 34 France 563 406 78 52 553 575 71 527 035 22 z 52 644 017 71 United Kingdom 76 630 04 53 282 842 66 832 239 51 5 3 391 712 21 Canada 6103 377 85 51 821 302 39 553 164 62 I 51 977 844 86 Australia 5138 690 63 8 852 050 00 570 259 95 I 9 061 000 58 United States 5256 422 07 55 999 859 53 133 507 91 I 9 389 789 51 Sum I 700 759 96 I 28 318 144 65 z 339 772 61 1 29358 677 22 www kyubit com support Qkyubit com O 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 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 le
18. 52759 56 a Subcategory Mountain Bikes Road Bikes 14 520 584 04 Touring Bikes 53 844 801 05 sum 2528318 144 65 3 7 User analysis settings Every user could define his own preference while analyzing OLAP data with AnalysisPortal 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 Hide Empty Rows Aggregate operation Sum Grid column width Large PERPETUUM Domain Users Everyone BUILTIM IA dministrators BUILTIN Users NT AUTHORITYINTERACTIVE CONSOLE LOGON NT AUTHORITY Authenticated Users NT AUTHORITY This Organization LOCAL PERPETUUM VPN korisnici RIT EVIE KE User AD groups Save Refresh Close 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 N Set Aggregates None Set Column Width d Sum Internet Sales Amount 9 061 000 58 Alberta 22 467 80 British Columbia 1 955 340 10 Ontario 36 96 a Country v State Province v Australia Canada IT Set Row Sorting France Germany United Kingdom United States Avg Avg Ave 659 281 62 2 644 017 71 2 894 312 34 3 391 712 21 9 389 789 51 Avg 4 893 112 87 Set Column Sorting Show Hid
19. 73 52 21 773 77 16 237 58 5791 12 5 905 50 E 52 93919 5 1 955 340 10 Ontario Internet Sales Amou On the same way select Collapse all members to collapse all sibling members Exapand all Collapse all sum Internet Sales Amou 536 96 E 5103 377 85 I 1 821 302 39 I 553 164 62 I 536 96 I 1 977 844 86 Sum Internet Sales Amou Internet Sales Amou z I 7 080 00 I 55 088 00 9 99 I 7 583 16 z 5 1 160 70 21 98 I 8 792 00 3 I 28 096 97 5 I 56 158 88 54 99 I 39 318 14 I 36 96 I 103 377 85 z 5615 440 40 E I 5935 616 29 I 5270 245 70 I 1 821 302 39 1 52 175 58 I 6 098 01 1 21 877 75 I 16 307 67 5800 11 I 5 905 50 E I 453 164 62 I 436 96 I 1 977 844 86 Ontario 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 ul Internet Sales Amount Internet Sales Amou 5700 759 96 a Category a Subcategory Accessories Bikes Clothing Expand all members Drill down Bikes Isolate Bikes Sum www kyubit com support kyubit com O 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 User manual T Product Categories Bikes ul Internet Sales Amount Internet Sales Amou 59 9
20. 86 06 224 681 15 262 627 42 719 988 78 2 265 451 62 27 181 81 Z 2 348 694 23 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 User manual 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 al members is available only on categories axis a State Province Alberta Internet Sa a Category a Subcategory Accessories Bikes Clothing Expand all membe Drill down Accessories Sum Isolate Accessories ritish Columbia Internet Sales Amou 5102 926 43 51 799 474 48 552 939 19 Z 51 955 340 10 a State Province Alberta a Subcategory Bike Racks Bike Stands Bottles and Cages a Category Cleaners Accessories Fenders Helmets Hydration Packs Tires and Tubes sum Mountain Bikes Road Bikes Touring Bikes Sum Caps Gloves Jerseys Clothing Shorts Socks Vests sum 3 6 Drill down member Internet Sales Amou 240 00 827 96 421 98 434 99 89 53 I 414 46 52 294 99 14 022 43 55 510 49 I 21 827 91 417 98 824 49 103 98 869 99 58 99 5 225 43 I 22 467 80 British Columbia Internet Sales Amou 6 840 00 55 088 00 87 645 21 1 160 70 58 748 04 78 061 98 56 158 88 639 223 62 F 102 926 43 5613 145 41 921 593 86 5264 735 21 E 51 799 474 48 2 157 60 6 0
21. 89 77 59 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 Nord Touring Bikes Internet Sales Amou 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 342 381 90 521 644 89 270 245 70 993 682 14 1 292 475 90 3 844 801 05 Sum internet Sales Amou 2 808 514 35 520 736 35 376 505 11 365 162 25 271 240 03 261 360 26 I 254 967 08 106 807 40 90 860 18 88 320 75 Z 53 062 43 2 44 514 36 Z 33 515 83 Z 28 547 67 I 26 985 36 Z 20 441 44 Z 10 549 21 2295391771 3 282 842 66 1 821 302 39 8 852 050 00 8 999 859 53 I 28 318 144 65 Clothing Internet Sales Amou 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 390 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 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 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 Interne
22. Kyubit AnalysisPortal 2 0 User manual AnalysisPortal 2 0 User manual 2012 All rights reserved www kyubit com Kyubit AnalysisPortal 2 0 User manual Contents 1 Installation and configuration srorrrrnnnnrrrnrnnnnrrrnrnnnnnrrnrnnnnerrnrnnnnerrnnnnnsesrnnnnnsesennnnnsesennnnnnesennnnnnesnnnnnssssennnnnee 4 1 1 AnalysisPortal installation Prerequisites ss 4 1 2 Kyubit Subscription service installation ss 5 1 3 Ea aa deployment EEE te oi 5 1 4 Deployment in distributed environment and authentication concepts 6 1 4 1 Scenario AnalysisPortal IIS is on the same server as SSAS Default rrrrrrrrnnrnnnrrrnnrnnnnnnne 6 1 4 2 Scenario B AnalysisPortal IIS is on separate server from SSAS Kerberos rrrrrrrrnnnrrrrrrrnnnnnn 6 1 4 3 Scenario C AnalysisPortal IIS is on separate server from SSAS Basic authentication 6 1 5 Troubleshooting after installation Veere 7 1 5 1 Opening AnalysisPortal return 500 19 Error sise 7 1 5 2 Opening AnalysisPortal return 401 2 Unauthorized Error 7 1 5 3 Opening AnalysisPortal return message Login failed for user KyubitUser 7 1 5 4 Recommended IIS SCENES isc cascccscsasntnasnnntcnndsaswseneinesdinesmaasdendonstanasnanndaniaeaedensoaaddeeseantevnionsadenennene 7 2 AnalysisPortal structure amp administration cccccccssssecccccesseccccceseceeccsesececssaeseecesseeneceessuanscee
23. Qkyubit com O 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 User manual 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 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 M Accessories pikes J Clothing INTERNET SALES AMOUNT Set Series To Add Filter Change Chart Measure Add Measure Change Category Pivot Chart Show Hide Empty Series Sort alphabetically Asc Sort alphabeticaily Desc l 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 4 4 Pivot chart To switch m
24. United States Germany 3 O O France a Australia MA 2M an 6M oh 10M www kyubit com support kyubit com 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 User manual Wyoming INTERNET SALES AMOUNT TEESE O OOOO Vi rginia Utah Texas South Carolina Orezon Ohio North Carolina New York Montana 4 Missouri Mississippi Minnesota State Province Massachusetts Kentucky 4 Illinois Georgia Florida oito AA Arizona Isolate California Alabama Drilithrough California by Ml Drill California By Y Applied filters Customer Geography California Wood and Hills West Covina is INTERNET SALES AMOUNT Torrance Spring Valley BEE Santa Moni ce RE Santa Cru z San Gabriel San Francisco San Diego m San Carlo Redwood City BE Palo Alto Oak and ES ov 20 ooo al city Oakland 125 898 25 Mill Valley 3 Los Angeles ES Long beach AO Lincoln Acres ES Lemon Grove Lakewood EE La Joll a Imperial Beach Grossmont M Glendal e M Fremont El Caj on EE m Downey TT Daly City S Coronado S Concord xa Co ma City Of Commerce Citrus Heights Chul a Vi sta Cerritos Carson Canoga Park j Camarillo Burling 0 oaa Bell Gardens Barstow p 4 k www kyubit com support kyubit com 2012 www kyubit com All
25. Womens Customer Geography California Product Categories Bikes Set drillthrough columns Email Address Phone Internet Sales Amount mackenzie20 adventure works com 350 555 0175 769 49 jade12 adventure works com dylan17 adventure works com megan37 adventure works com marissall adventure works com dylan34 adventure works com daniel9 adventure works com alexandria17 adventure works com sean19 adventure works com rachel58 adventure works com sarah38 adventure works com ethan52 adventure works com alexia10 adventure works com andrea10 adventure works com sydneyl8 adventure works com aidan2 adventure works com rachel9 adventure works com evan13 adventure works com wyatt54 adventure works com brandon26 adventure works com mariah24 adventure works com 109 555 0190 769 49 161 555 0181 769 49 114 555 0120 769 49 974 555 0179 769 49 951 555 0169 769 49 259 555 0179 769 49 147 555 0143 769 49 223 555 0187 769 49 220 555 0196 769 49 368 555 0136 769 49 185 555 0117 769 49 632 555 0172 769 49 854 555 0190 769 49 928 555 0156 769 49 129 555 0157 769 49 230 555 0193 769 49 584 555 0170 769 49 358 555 0164 769 49 445 555 0135 769 49 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
26. add some extra parameters To assign permissions for other users select Permissions link For more details on permissions see section 2 2 www kyubit com support Qkyubit com O 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 User manual 2 6 Licensing After evaluation period ends AnalysisPortal will not be available to perform any further analysis functionalities To activate AnalysisPortal and all of its functionalities it has to be registered with valid license key file After license has been purchased license file lic will be provided which should be uploaded in Administration Licensing section Licensing AnalysisPortal licensing information AnalysisPortal version 2 0 0 0 Kyubit AnalysisPortal is currently running in Evaluation Mode This software is not licensed To obtain license please visit www kyubit com If you received license file lic from Kyubit please submit System Name Domain MachineName License file Browse Register Visit www kyubit com for more details on licensing www kyubit com support kyubit com 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 User manual 3 Grid Analysis features 3 1 Start Analysis To start analysis please click on the Start Analysis on the AnalysisPortal page Note that if you have only one cube reference Grid Analysis screen w
27. and Chart view Right click on some value selecte 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 hierarhies 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 hierarhies that are assiciated 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 show up Depending on the number of result items dri
28. chies 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 Seechen Lidl da All Products _ Mountain Bikes Accessories _ Touring Bikes Bikes Mountain Bikes W Road Bikes Touring Bikes Clothing Components Remove Filter www kyubit com support kyubit com 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 User manual 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 contain
29. e Empty Series Pivot Create User Calculated Measure View Values View Column Percentage View Row Percentage 3 7 2 Show hide empty rows This setting shows or hides rows from OLAP database that not include any data www kyubit com support kyubit com 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 User manual 3 7 3 Edit grid column width 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 a Country State Province Internet Sales Amount ee mea 59 061 000 58 eemmmmm 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 Germany 2 894 312 34 Set Column Sorting Canada Set Column Width United Kingdom 3 391 712 21 United States 9 389 789 51 Avg Ave 4 893 112 87 Pivot 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 hierar
30. e 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 querystring element we click on the some dimension hierarchy on the left For example we 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 detail 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 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 a
31. ed 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 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 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 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
32. embers 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 category members or if exists series member within category member www kyubit com support kyubit com 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 User manual 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 as explained in 3 4 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 M clothing INTERNET ORDER COUNT Isolate Australia isolate Bikes in ali Isolate Australia Drilithrough Australia by Drilithrough B
33. ent or any other valid MDX format values expressions Check official MDX documentation for Format values parameter www kyubit com support kyubit com O 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 User manual User Calculated Measure Name Internet sales amount share Available measures Sales Amount Add Measure Measures Internet Sales Amount Measures Sales Amount Format Values Percent es Test MDA expression Delete Close 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 Kyubit AnalysisPortal New Analysis Grid Chart Report Menu Analysis Analysis al Internet Sales Amount ul Sales Amount ul Internet sales amount share FJ Adventure Works ml Measures 9 Internet Customers 0 Internet Orders Internet Sales 0 Reseller Orders Internet Sales Amount 700 759 96 Category Subcategory v Accessories 9 Reseller Sales Sales Orders 3 Sales Summary 0 Sales Targets Bikes Mountain Bikes Road Bikes Touring Bikes Sum 9 952 759 56 14 520 584 04 3 844 801 05 Z 28 318 144 65 Clothing Components Sum 29 358 677 22 3 User Calculate 339 772 61 ai My Ratio easures ball calc 11 al test measurel ul Internet sales amount share 3 14 1 Edit existi
34. ferences Shared Items User Named Sets Kyubit AnalysisPortal 2 0 User manual Analysis User Named Sets Delete Named Sets Name C Rich cities C Canada amp Germany C Cams and camcordsers 1 High Education 1 Favorite bikes Data Source ADW2008R2 ADW2008R2 conteso ADW2008R2 ADW2008R2 k User Drillthrough Columns gal User Calculated Measures 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 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 Perc
35. iew the content of the folder www kyubit com support kyubit com 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 User manual 2 5 Cube references To start analyzing data for certain 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 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 O O O Cube reference custom name Cube Reference a Permissions OLAP database Catalog Adventure Works DW 2006R2 SE Cube Name Adventure Works L 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
36. ikes in Austra by Drill Australia By Drill Bikes in Australi By Drill Down Australia mm CO gt Country Y Applied filters Customer Geography Australia Category MMB Accessories pikes M clothing INTERNET ORDER COUNT ak 2k Isolate Australia isolate Clothing in Australia Drilithrough Australia by k i Drilithrough Clothi in Austra by gt Australia 7 1 Drill Australia By Country Drill Clothing in Australi By b Drill Down Australia www kyubit com support kyubit com 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 User manual Applied filters Customer Geography Australia Category MM Accessories pikes i clothing INTERNET ORDER COUNT 1000 Education Slicing category member values could be repeated as many times you like 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 d Drill United States By United Kingdom s Drill Down United States Drill Down
37. ile by setting value for key ActiveDirectorySearchUserName value Enter user name key ActiveDirectorySearchUserPassword value Enter password www kyubit com support kyubit com O 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 User manual 1 4 Deployment in distributed environment and authentication concepts Some important remarks on IIS web application authentication methods and topology of AnalysisPortal and SSAS SQL Server Analysis Services environment It is related how user credentials are passed from browser to IIS web application AnalysisPortal and then forwarded to SSAS and OLAP database to return OLAP data 1 4 1 Scenario A AnalysisPortal IIS is on the same server as SSAS Default In this case default Windows authentication could be used This concept is default when AnalysisPortal application is installed There is no need to set up Kerberos authentication protocol between IIS and SSAS Browser will automatically recognize user Windows credentials pass it to IIS AnalysisPortal and then forward to SSAS to reach OLAP data without any problem This is default configuration after AnalysisPortal installation because it is most suitable for product evaluating purposes 1 4 2 Scenario B AnalysisPortal IIS is on separate server from SSAS Kerberos Kerberos authentication between IIS and SSAS has to be configured for this scenario This scenario is suitable
38. ill 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 fl AWorks a Contoso contoso New Cube Reference New Analysis Grid Chart Report 7 Calendar CY 2007 CY 2008 a Category Accessories Bikes Clothing sum a Country Internet Sales Amou Internet Sales Amou Internet Sales Amou Internet Sales Amou Australia 5138 690 63 55 388 717 92 570 259 95 I 55 597 668 50 Canada 103 377 85 1 052 870 20 553 164 62 Z 51 209 412 67 France 563 406 78 1 858 062 01 627 035 22 5 1 948 504 01 Germany 562 232 59 52 049 496 51 523 565 40 I 2 135 296 50 United Kingdom 76 630 04 52 399 665 29 532 239 51 I 2 508 534 84 United States 256 422 07 5 772 613 54 133 507 91 I 56 162 543 52 Sum I 5700 759 96 2 18 521427 47 I 5339 772 61 I 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 O O O Measures area www kyubit com support kyubit com 2012 www kyubit com All righ
39. ion Some environment settings and configuration could lead to certain problems with AnalysisPortal application usage 1 5 1 Opening AnalysisPortal return 500 19 Error Resolution ASP NET is not installed as a part of IIS features Windows 7 Go to Control Panel gt Programs gt Turn Windows Features gt Internet Information Services gt World Wide Web Services gt Application Development Features gt Select ASP NET Windows Server 2008 R2 Go to Control Panel gt Programs gt Turn Windows Features gt Expand Roles gt Right click Add Role Services gt Select ASP NET 1 5 2 Opening AnalysisPortal return 401 2 Unauthorized Error Resolution Windows Authentication is not enabled as a part of IIS features Windows 7 Go to Control Panel gt Programs gt Turn Windows Features gt Internet Information Services gt World Wide Web Services gt Security gt Select Windows Authentication Windows Server 2008 R2 Go to Control Panel gt Programs gt Turn Windows Features gt Expand Roles gt Right click Add Role Services gt Select Windows Authentication 1 5 3 Opening AnalysisPortal return message Login failed for user KyubitUser Resolution MS SQL Server is not configured to run in mixed mode Windows and SQL Server authentication Open MSSQL Management Studio gt Right click server instance gt Under Security select option SQL Server and Windows authentication 1 5 4 Rec
40. l 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 analysis scope to return members and use within analysis www kyubit com support Qkyubit com O 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 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 pp 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 g Adventure Works Gray OLAP database defind Named sets gil Measures l Customer Demographic Location Sets Top 50 Custome Rich cities _ Canada amp Germany High Education Blue aa Customer AnalysisPortal 28 Customer Geograp rase amed Se l Date 4 Delivery Date www kyubit com support kyubit com 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal Q Menu Folders Cube re
41. ld 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 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 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 e Analysis name e Analysis description if exists e Grid results data if opted e Chart result image if opted In Report view following actions are available e Update Analysis details name description e Select to show Grid Chart or both e Send to print e Export to Excel e Export to PDF e Switch back to Grid or Chart view www kyubit com support kyubit com 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 User manual monthly Y Filters 1 Calendar Year CY 2003 2 Customer Geography Australia Canada Country
42. les Amount Filter Filter Value a Country United States Australia United Kingdom Germany France Sum www kyubit com 5 Remove Close Internet Sales Amou 59 389 789 51 9 061 000 58 63 391 712 21 2 894 312 34 2 644 017 71 E 27 380 832 36 support kyubit com O 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 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 Internet Sales Amou Internet Sales Amou Internet Sales Amou Internet Sales Amou Canada 103 377 85 1 821 302 39 53 164 62 I 1977 844 86 France 863 406 78 5255357571 827 035 22 5 2 644 017 71 Germany 562 232 59 S2 808 514 35 523 565 40 I 52 894 512 34 United Kingdom 576 630 04 53 282 842 66 532 2
43. llthrough 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 www kyubit com support kyubit com 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 User manual User can redefine drillthrough columns to return as many times he likes Drillthrough columns definition Drilithrough definition name Basic Customer Datal Cube Adventure Works Measure Group Internet Sales Available columns to return in drillthrough Columns to return in this drillthrough action Customer er Email Address 2 Customer Phone gill Measures M Contacts uu 22 Customer 44 as Email Address aa as Phone J Demographic gj Location S Other IZ Date LZ Delivery Date LZ Internet Sales Order Details IZ Product LZ Promotion LZ Sales Reason Z Sales Territory LZ Ship Date v Source Currency Run drillthrough 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 th
44. lue 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 www kyubit com support Qkyubit com O 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 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 Show Analyze Link Show Name Show Description Show Filters Show Grid Show Chart Grid over Chart DONERE Horizontal position Center Offset Top 10 Offset Left 10 Font
45. ng User Calculated Measures Sales Amount 1 272 057 89 36 445 443 94 43 878 791 00 14 296 291 27 94 620 526 21 2 117 613 45 11 799 076 66 Z 109 809 274 20 History Save Internet sales amount share 55 09 27 31 33 09 26 89 Z 87 29 16 05 Z 101 06 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 www kyubit com support kyubit com 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 User manual Kyubit Ua AnalysisPortal User Calculated Measures Menu Analysis Delete Calculated Measure Name Folders al My Ratio Cube references ball calc 11 q ail test measurel Shared Items al Internet sales amount share User Named Sets User Drillthrough Columns gal 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 desir
46. ng 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 58 Canada 51 977 844 86 France 62 644 017 71 Germany 52 894 312 34 United Kingdom 53 391 712 21 United States 59 389 789 51 Sum 1529 358 677 22 www kyubit com support Qkyubit com O 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 User manual T Customer Geography Canada United Kingdom a Country Canada United Kingdom sum Drop Series Here Internet Sales Amou 51 977 844 86 63 391 712 21 5 369 557 07 3 8 3 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 Dimension level value filtering a Country 7 Australia Canada France Level Sorting Level Value Filtering Create Named Set Germany United Kingda United States sum Remove Level 59 389 789 51 E 29 358 677 22 Value filtering for level Country Measure Internet Sa
47. o Australia o Canada 400k 300k 200k 100k k E I l l l E Q amp CA A FE vA Zo ge Os A z 3 2 2 v E 2 2 2 D D Q S 2 S Ea p gt 2 r 8 gt gt j Q We 3 W gt R Q gt gt Month 6 Exporting options While analyzing there are two exporting option always available e Export to Excel file xlsx format Grid data will be exported to excel cells with related analysis elements e Export to PDF file Chart image will be exported to PDF file with related analysis elements 7 Drillthrough functionalities 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 gi
48. o certain business unit or process Administrator or user with read write permission on a folder could manage permissions for other ActiveDirectory 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 AnalysiPortal folder with given analysis To create new folder and define folder permissions follow these steps On Main menu select Create Folder link on the right side of screen Set folder name and click Save To define permissions on folder select permissions and choose required ActiveDirectory users and groups and finally select which access level should be given Read Access or Read Write Access See chapter 2 2 for details a Permissions To share analysis with other users create folder and assign appropriate permissions While analyzing data select option to share analysis and select folder to share 2 4 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 v
49. ommended IIS Settings Check bellow IIS features configuration in your environment in order to ensure that IIS serves all necessary content to AnalysisPortal application To check IIS settings on Window Server 2008 go to Administrative tools gt Server Manager gt Roles gt Right click on web server IIS gt Add Role Service and then check items in the list with our recommended settings 1 Application Development Features NET extensibility e ASP NET ISAPI Extensions e ISAPI Filters 2 Common HTTP Features Default document e Directory browsing HTTP Errors e Static content 3 Security Windows authentication www kyubit com support kyubit com 2012 www kyubit com All rights reserved Errors and omissions expected _ 8 Kyubit AnalysisPortal 2 0 User manual 2 AnalysisPortal structure amp administration Before start to analyze data it is good to be familiar with some basic concepts that help users to organize and manage related AnalysisPortal data 2 1 Administrator role Users who belong to Administrator role have maximum privileges in AnalysisPortal application Administrators can see and manage any object in AnalysisPortal By default user who installs AnalysisPortal is automatically becoming member of Administrator role Only members of Administrator role have the right to do following actions Activate deactivate users Assign remove Administrator privileges to any user Manage licensing
50. raphy 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 www kyubit com support Qkyubit com O 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 User manual ul Internet Tax Amount a Category Accessories Clothing Sum a Product a Subcategory 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 Touring 3000 Yellow Touring 3000 Yellow Touring 3000 Yellow Touring 3000 Yellow Touring 3000 Yellow Sum Internet Tax Amount 556 060 80 796 220 81 1 161 646 73 533 758 43 528 608 84 530 516 10 528 036 66 532 804 80 528 799 57
51. ription will be delivered Monthly weekly or only once e Select day or days weekday day in month or single date on which this subscription will be delivered e Time Select time on which this subscription will be delivered e Recipients Enter email addresses of recipients you wish to receive mail with analysis e Disabled If you wish to temporary disable subscription select Disabled option After you save subscription it will appear on the list My Subscriptions www kyubit com support Qkyubit com O 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 User manual Subscription Title Australia and Canada internet Sales Analysis Australia and Canada Internet Sales Amount vi Occurs Weekly Y On this day Cl Monday Ml Tuesday M Wednesday LI thursday L Friday L saturday L sunday Atthis time 09 30 vw info kyubit com Recepients Disabled Save Close 10 3 Subscription service log In the Subscription Service installation folder log files will be created to track Subscription Service actions and messages For each day in week one log file will be created Next week old log files will be overwritten www kyubit com support Qkyubit com O 2012 www kyubit com All rights reserved Errors and omissions expected
52. s 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 L New Castle New Hartford new Search Contains EZ All Kennewick _ New Castle New Hampshire New Hartford New Haven New Mexico C New South Wales _ New York New York Newark Newcastle Newcastle upon Tyne Newport Newport Beach Remove Filter Close 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 Isolati
53. sent what kind of values we want to analyze measure For example it could be Sales amount product ordered working hours etc To start analysis with particular measure it should be dragged from the OLAP tree structure on the left to measures area on the right Note if measure is not explicitly selected analysis will be performed with default cube measure It is possible to select drag multiple measures for the same analysis so the date among the measures could be compared To remove measure from analysis drag measure from Measures area to cube tree or select measure one click and press Delete key ul Internet Sales Amount nil Internet Tax Amount ul Drder Count 3 2 3 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 Geog
54. ser manual 3 8 1 Search Members rrnnnnrrnnnnnnrsnnnvrnnnnnnnssnnnvrnnnnnnnssnnnsnnnnnnnssnnnnsnnnnnnsssnnnsrnnnnnesssnnnsrnnnnnesssnnnsnnnnnenssneee 20 3 8 2 eee REE EE EE eget 20 3 8 3 Dimension level value filtering Jaap deb le ester oser 21 3 9 Sorting all members on grid AXIS siennes 22 3 10 Sorting members on a particular dimension level ss 23 LE PNO a E S emace oes E unetentsoaced E E E E 24 3 12 Grid values in percentage rrrrrrrnnrnrrrrrnnnnrrrrnnnnnrrnrrnnnerrnrnnnneernnnnnnesrnnnnnnesennnnnsesennnnnnessennnnnessennnnnessnsnnn 24 3 13 Create and manage ad hoc User Named sets ss 25 3 13 1 Create Named Set by picking members 25 3 13 2 Create Named Set by expression sssseenssssserssserersssrrresssrrresssreressereresserressseeressereressereressrereee 25 3 13 3 Edit existing User Named Sets ninn A EE E AEAEE 26 3 14 Create and manage ad hoc User Calculated Measures ss 27 3 14 1 Edit existing User Calculated Measures ss 28 a NVE 29 NNN 29 3 17 Analysis history move back and forward ss 29 NNN da ee 30 4 1 PN 30 4 2 EEE EE EP D Sn et 31 4 3 Change OF add NET vrede 31 4 4 POT 31 4 5 Ea ea EEE SR EEE EE EEE 31 4 6 Drill category member values Slice svarer 32 4 7 lo 33 4 8 Ga GET sinssrspiniri rnn 35 4 8 1 CAR ee 35 4 8 2 PE 35 4 8 3 VNR 35 4 8 4 206 19 DE TE EE EE EE ee 35 4 8 5 SENT PN Nede 36 4 8 6 Se NUES
55. server with web server IIS SQL Server instance for AnalysisPortal internal database and SQL Server Analysis Services instance could be installed on a single server or distributed to multiple servers For example AnalysisPortal could be installed on Server A its database could be located on Server B and use OLAP data while analyzing from SSAS SQL Server Analysis Services on Server C Single Server Deployment Server IIS AnalysisPortal installation o e SQL Server instance for AnalysisPortal Internal database e SQL Server Analysis Services SSAS instance For Analysis Distributed Environment Deployment Server A e IIS AnalysisPortal installation Server B e SQL Server instance for AnalysisPortal Internal database Server C e SQL Server Analysis Services SSAS instance For Analysis AnalysisPortal communicates with its internal SQL server database using SQL server login KyubitUser created during AnalysisPortal setup After AnalysisPortal setup connection to SSAS SQL Server Analysis Services is impersonated with current user credentials using AnalysisPortal web application 1 3 1 User credentials for ActiveDirectory search During setup procedure user could enter valid credentials for user that would be used for all search towards ActiveDirectory when searching for Peoples and Groups If credentials are not entered during installation they could be set in AnalysisPortal installation path web config f
56. ssagaeeeessaneseeees 8 2 1 AO SEA EE EE Donne 8 2 1 1 Activate CE GE 00 EO aoa aesacsinanttpaclasan te tucasuawetaiesintincaiaiia saa aupcnbea dap oa suaaenwasnaseanstinosiant 8 2 1 2 Add remove USEF LO Administrator role ner tie rare iina hi 8 22 AnalysisPortal objects and ActiveDirectory user group permissions 8 2 3 FON CCUG ss D D E E AE 10 2 4 MINN 10 2 5 Bo R E e a 11 2 6 HCN rv 12 3 Grid Analysis features ccccccssssecccscsssecccscsseeccsenseecccsenssececseussesecseassesecsenssesecssasseseessussereessassersessassetees 13 3 1 SE AO a ME 13 a2 ond Analysis EE 13 3 2 1 C be structure Tee a D ee UNN 14 3 2 2 EEG JE EE EN EE A EE eee 15 32 3 S aee E E A E EE EE ET ne 15 3 3 Expand member single dimension hierarchy rrrrrrnnnnrrnnnnnnnrnnrnnnnnrrnnnnnnnrnnnnnnnnrnnnnnnssennnnnnsssensnnnsssennnn 15 3 4 Expand member different dimension hierarchy ss 16 319 Expand all Collapse all members uuuuastuasasearnmmsnssenstgngassmmmrtugasemutvansnmmteiesn 17 3 6 PAN 17 3 7 USER NAN SS EN ee 18 5 4 1 Grid analysis EE EEE 18 3 7 2 Show hide empty rOwsS rrnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnneene 18 313 EE erid CO ORAN EN 19 3 8 Fitering grid analysis At decide anse enr en ie niet 19 www kyubit com support kyubit com 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 U
57. ssociated measure group www kyubit com support kyubit com 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 User manual 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 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 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 ul 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 Ontario 536 30 Quebec Total I 1 977 844 86 France 2 644 017 71 Germany Bayern 399 966 78 gt Brandenburg 119 571 08 Hamburg 467 219 04 Hessen 794 876 08 Nordrhein West 459 591 88 Saarland 653 087 48 H Total I 2 894 312 34 United Kingdom 3 391 712 21
58. t p Z for column total sum of all members on Categories axis Sales Amou 9 894 27 131 668 22 194 250 41 50 586 48 376 505 11 5 000 82 391 400 20 Seine Saint Denis Essonne Sum Internet Sales Amou 2 894 312 34 539 725 80 391 400 20 Z 379 479 75 279 297 18 I 268 664 80 Z 263 416 19 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 2 644 017 71 3 391 712 21 1 977 844 86 9 061 000 58 9 389 789 51 29 358 677 22 Yveline 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 Internet Sales Amou 55 243 89 83 601 34 149 604 96 38 033 73 Z 271 240 03 2 813 26 Z 279 297 18 Internet Sales Amou 5 561 12 89 671 50 137 141 12 34 547 64 Z 261 360 26 1 743 42 268 664 80 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 TL State Province T Germany France United Kingdom Canada Australia United States Sum British Columbia Alberta Ontario Sum Internet Sales Amou www kyubit com support kyubit com O 2012 www kyubit com All rights reserved Errors and omissions expected 9 86 9 01 11 55 6 66 0
59. ts reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 User manual o Filters area o Values area Kyubit Ry AnalysisPortal New Analysis Menu Analysis Grid chart Report Analysis Ca Adventure Works gil Measures l Customer l Date l Delivery Date Li Employee 4 Geography l Internet Sales Order Details l Product l Promotion l Reseller l Reseller Sales Order Details l Sales Channel L Sales Reason 4 Sales Summary Order Details 4 Sales Territory L Ship Date L Source Currency 3 2 1 Cube structure Tree Every OLAP cube consists of measures dimensions and hierarchies Cube structure is defined in OLAP database and within AnalysisPortal is shown using tree view Analysis is performed by dragging desired elements measures dimension hierarchies to appropriate areas on the right Cd Adventure Works gil Measures 2 Customer A Demographic Location J Set Customer Eri Customer Geography All a Country state Province City Postal Code Customer L Date Calendar a 22 Calendar as Calendar Quarter of Year Calendar Semester of Year Calendar Week of Year Eu Calendar Weeks i E HEE iz BEE Calendar Year www kyubit com support kyubit com 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 User manual 3 2 2 Measures Measures repre
60. ve 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 www kyubit com support kyubit com 2012 www kyubit com All rights reserved Errors and omissions expected Kyubit AnalysisPortal 2 0 User manual Mountain 400 W Mountain 100 S Mountain 100 B Mountain 400 W Mountain 100 B Mountain 400 W Mountain 100 S Mountain 100 B 20 249 94 Mountain 400 W Mountain 100 S 10 199 97 Mountain 500 B 9 719 82 Mountain 500 B 8 639 84 Mountain 500 S 6 779 88 32 318 58 27 199 92 26 999 92 26 162 66 I 32 318 58 I 27 199 92 I 26 999 92 I 26 162 66 gg Customer basic data Drilithrogh by Custom drilithrough Set Grid KPI Set Column KP 520 006 Set Cell KPI Show All KPI s I 8 639 84 I 6 779 88 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 Customer Mackenzie R Cook Jade Murphy Dylan J Bryant Megan C Rivera Marissa E Butler Dylan C Wilson Daniel L Clark Alexandria A Gonzales Sean A Howard Rachel K Patterson Sarah C Washington Ethan Garcia Alexia D Flores Andrea Richardson Sydney M James Aidan Wood Rachel Wilson Evan S Ward Wyatt A Barnes Brandon La Mariah Russell Style
61. vel context menu will appear and select Level sorting a Category Accessories Bikes Inte ot les Amou a Country Inbnrmnt Talar A maman Germany Level Sorting France Level Value Filtering United Kingc Canada Australia United States 6256 422 07 Sum I 5700 759 96 Create Named Set Remove Level 8 999 859 53 I 828 318 144 65 On a picture bellow we see Country level members are sorted by Accessories ascending but members of State Provice 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 Internet Sales Amou Internet Sales Amou Internet Sales Amou Internet Sales Amou 52 208 514 35 23 565 40 F 2 894 312 34 a Country gt State Province vf Germany 562 232 59 France Seine Paris Mord Seine Saint Denis 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 613 160 02 9 894 27 9 894 58 55 243 89 55 561 12 56 068 76 2 269 55 2 529 78 52 282 44 1 181 39 1 786 19 693 50 5599 72 5969 42 713 38 558 77 6520 736 35 376 505 11 365 162 25 271 240 03 261 360 26 6254 967 08 106 807 40 90 860 18 88 320 75 453 062 43 44 514 36 433 515 83 428 547 67 426 985 36 420 441 44 10 549 21 85 829 43 5 000 82

Kyubit AnalysisPortal 2.0

Contents

Download Pdf Manuals

Related Search

Related Contents