/content/folder[@name='Future Chips Inc.']/folder[@name='Data Packages']/package[@name='Executive Insight Model2']/model[@name='model'] [Business View].[Scorecard Data].[Strategy][Business View].[Scorecard Data].[Metric][Business View].[Scorecard Data].[Actual][Business View].[Scorecard Data].[Target][Business View].[Scorecard Data].[Status][Business View].[Scorecard Data].[Trend][Business View].[Scorecard Data].[Region][Business View].[Scorecard Data].[Trend][Business View].[Scorecard Data].[Status][Business View].[Scorecard Data].[MonthName] NationalSep [Business View].[Scorecard Data].[Strategy][Business View].[Scorecard Data].[Actual][Business View].[Scorecard Data].[Target][Business View].[Scorecard Data].[Status][Business View].[Scorecard Data].[Trend][Business View].[Scorecard Data].[Region][Business View].[Scorecard Data].[MonthName] NationalSep [Union1].[State][Union1].[New_Business][Union1].[Renewal_Retention][Business View].[Measures].[DPW][Business View].[Region].[Region][Business View].[Line of Business].[LOB][Business View].[Line of Business].[LOB Parent][Business View].[SIC Code].[SBU Description][Business View].[Region].[State Abbr][Business View].[Time Dimension].[Month][Business View].[Time Dimension].[Month Label][Business View].[SIC Code].[SIC Segment Name][Business View].[Measures].[Renewed Count]JulyAugustSeptember[Business View].[Measures].[DPW][Business View].[Region].[Region][Business View].[Line of Business].[LOB][Business View].[Line of Business].[LOB Parent][Business View].[SIC Code].[SBU Description][Business View].[Time Dimension].[Month Label][Business View].[Measures].[Renewed Count][Business View].[SIC Code].[SIC Segment Name]JulyAugustSeptember [Business View].[Region].[Region][Business View].[SIC Code].[SBU Description] [Business View].[Scorecard Data].[Metric][Metric]='Apps Submitted' [Business View].[Region].[State Name][Business View].[Measures].[DPW][Business View].[Measures].[Renewed Count]rank([New Business] within set [State Name])[Business View].[Region].[Region]rank([Renewal Retention] within set [State Name])rank([New Business] within set [Region])rank([Renewal Retention] within set [Region])rank([Renewal Retention] within set [State Name]) [Business View].[Region].[State Name][Business View].[Measures].[DPW]rank([New Business] within set [State Name])[Business View].[Region].[Region] [National Rank] < 6 [Business View].[Region].[State Name]rank([Renewal Retention] within set [State Name])[Business View].[Measures].[Renewed Count][Business View].[Region].[Region] [National Rank] < 6 [Business View].[Measures].[DPW][Business View].[Region].[Region]rank([New Business] within set [Region]) [Regional Rank]<6 [Business View].[Measures].[Renewed Count][Business View].[Region].[Region]rank([Renewal Retention] within set [Region]) [Regional Rank]<6[Business View].[SIC Code].[SBU Description][Business View].[Time Dimension].[Month Label][Business View].[Measures].[Renewed Count][Business View].[Measures].[DPW]JulyAugustSeptember'Metric''Regional''Details'[scorecarddata].[region].[region].[Region]Region[scorecarddata].[region]region[scorecarddata].[region].[region]region[scorecarddata].[strategy].[strategy].[Strategy]Strategy[scorecarddata].[strategy]strategy[scorecarddata].[strategy].[strategy]strategy[scorecarddata].[metric].[metric].[Metric]Metric[scorecarddata].[metric]metric[scorecarddata].[metric].[metric]metric[scorecarddata].[monthname].[monthname].[MonthName]MonthName[scorecarddata].[monthname]monthname[scorecarddata].[monthname].[monthname]monthname[scorecarddata].[scorecarddata.measures].[Actual]Actual[scorecarddata].[scorecarddata.measures]scorecarddata.measures[scorecarddata].[scorecarddata.measures].[Target]Target[scorecarddata].[scorecarddata.measures]scorecarddata.measures[scorecarddata].[region].[region].[Region]Region[scorecarddata].[region]region[scorecarddata].[region].[region]region [Business View].[Region].[State Abbr][Business View].[Region].[Region][Business View].[Measures].[DPW][Business View].[Measures].[Renewed Count] Select * From ( values ( cast('FL' as varchar(20) ), cast('Southeast' as varchar(20) ), cast(0 as decimal ), cast(0 as decimal ) ), ( 'GA', 'Southeast',0,0 ), ( 'SC', 'Southeast',0,0 ), ( 'NC', 'Southeast',0,0 ), ( 'SC', 'Southeast',0,0 ), ( 'AL', 'Southeast',0,0 ), ( 'KY', 'Southeast',0,0 ), ( 'TN', 'Southeast',0,0 ) ) ButtonImages (State, Region, New_Business, Renewal_Retention ) [SQL1].[State][SQL1].[Region][SQL1].[New_Business][SQL1].[Renewal_Retention] 'Home''Northwest''Southwest''West''Midwest''Southeast''Northeast'[Business View].[Region].[State Abbr][Business View].[Region].[State Name][Business View].[Measures].[DPW][Business View].[Region].[Region] Home Main http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/home_logo3.png Executive InsightDecision makers need insight into the key performance areas of new and renewal business. This sample report is integrated with the Executive Insight for Insurance solution. Contact your IBM Business Analytics & Optimization representative if you would like a similar version for you and your staff. No Data Available Table http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/home_column_chart.png Metric AnalysisKey performance metrics for New and Renewal business by region against targets.MainOn No Data Available Table http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/home_region.png Regional AnalysisRegional performance for new premiums and renewals presented with national and regional maps.MainOn No Data Available Table http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/home_pie.png Regional DetailsNew Business and Renewals broken out by Strategic Business Unit and Line of Business.MainOnCopyright © 2012 IBM Corporation. All rights reserved. Sample data is used in this example. These records may contain fictional data manually or machine generated, or factual data compiled from academic or public sources, or data used with permission of the copyright holder. Other company, product, and service names may be trademarks or service marks of others; IBM has received permission of the copyright holder. No Data Available Image http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/toolbar_logo2.png On No Data Available Image http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/toolbar_metric_off.png OnOffOff http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/toolbar_metric_on.png On No Data Available Image http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/toolbar_regional_off.png OffOnOff http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/toolbar_regional_on.png On No Data Available Image http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/toolbar_details_off.png OffOffOn http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/toolbar_details_on.png New Business Renewal Retention Region: Metric Regional Details National Regional National Northeast Northwest SoutheastSouthwestMidwestWest National Metric Regional Details National Regional Metrics List No Data Available Status http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/statusgreen.png http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/statusyellow.png http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/statusred.png Trend http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/trendup.png http://localhost/ibmcognos/samples/images/yellow_neutral.gif http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/trenddown.png - Trend No Data Available Metrics List No Data Available Status http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/statusgreen.png http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/statusyellow.png http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/statusred.png Trend http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/trendup.png http://localhost/ibmcognos/samples/images/yellow_neutral.gif http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/trenddown.png Trend No Data Available New Business Renewal Retention National Northeast Northwest SoutheastSouthwestMidwestWest National View No Data Available Image http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/nbnorthwest.png No Data Available Image http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/nbsouthwest.png No Data Available Image http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/nbwest.png Image No Data Available Image http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/nbmidwest.png Image No Data Available Image http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/nbnortheast.png Image http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/nbblank.png No Data Available Image http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/nbsoutheast.png ImageTop Regions - New Business No Data Available Top States - New Business No Data Available State View NationalNationalTop States - New Business No Data Available StateNational Rank View NationalNationalTop States - New Business No Data Available StateNational Rank View NationalNationalTop States - New Business No Data Available StateNational RankSouthwest View NationalNationalTop States - New Business No Data Available StateNational RankMidwest View NationalNationalTop States - New Business No Data Available StateNational RankWest View NationalNationalTop States - New Business No Data Available StateNational Rank National Northeast Northwest SoutheastSouthwestMidwestWest National View No Data Available Image http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/rwnorthwest.png No Data Available Image http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/rwsouthwest.png No Data Available Image http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/rwwest.png Image No Data Available Image http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/rwmidwest.png Image No Data Available Image http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/rwnortheast.png Image http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/rwblank.png No Data Available Image http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/rwsoutheast.png ImageTop Regions - Renewals No Data Available Top States - Renewals No Data Available State Northeast View NationalNationalState Rank - Renewals No Data Available National Rank Northwest View NationalNationalState Rank - Renewals No Data Available National Rank Southeast View NationalNationalState Rank - Renewals No Data Available National RankSouthwest View NationalNationalState Rank - Renewals No Data Available National RankMidwest View NationalNationalState Rank - Renewals No Data Available National RankWest View NationalNationalState Rank - Renewals No Data Available National Rank National Northeast Northwest SoutheastSouthwestMidwestWest New Business Renewal Retention Strategic Business Unit BreakdownLine of Business Breakdown No Data Available No Data Available No Data Available No Data Available Category Breakdown No Data Available No Data Available National Strategic Business Unit BreakdownLine of Business Breakdown No Data Available No Data Available Category Breakdown No Data Available Insurance Executive Insight Overview Metric Analysis Regional Analysis Regional Details http://localhost/ibmcognos/samples/images/OpenInsuranceblue.png No Data Available Table http://localhost/ibmcognos/samples/images/umbrella.png Metric AnalysisA high-level, regional and national set of metrics with a scorecard of the selected month and a corresponding chart.Metric Analysis No Data Available Table http://localhost/ibmcognos/samples/images/cashcards.png Regional AnalysisThe Key Strategies of New Business and Renewal Retention presented with national and regional maps.Regional Analysis No Data Available Table http://localhost/ibmcognos/samples/images/family.png Regional DetailsNew Business and Renewals broken out by Strategic Business Unit and Line of Business.Regional Details Overview Metric Analysis Regional Analysis Regional Details http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Refine Result Set http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png /ibmcognos/pat/images/filter.gif Filter by Metric Type /ibmcognos/pat/images/filter.gif Filter by Region National Regional National Regional http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Metrics List http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png No Data Available Status http://localhost/ibmcognos/samples/images/green.gif http://localhost/ibmcognos/samples/images/yellow.gif http://localhost/ibmcognos/samples/images/red.gif Trend http://localhost/ibmcognos/samples/images/green_up_arrowl.gif http://localhost/ibmcognos/samples/images/yellow_neutral.gif http://localhost/ibmcognos/samples/images/red_down_arrowl.gif Details http://localhost/ibmcognos More New Business Renewal Retention http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Metrics Trend http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Apps Submitted Hit Ratio New NPW New PoliciesPrime Business %Quoted Net NewQuotes Issued http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Metrics Trend http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Flat Cancel Net Written Renewal Premium Non-Renew Renewal Premium Quoted Renewals Quoted Renewals Taken Terminations http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Metrics List http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png No Data Available Status http://localhost/ibmcognos/samples/images/green.gif http://localhost/ibmcognos/samples/images/yellow.gif http://localhost/ibmcognos/samples/images/red.gif Trend http://localhost/ibmcognos/samples/images/green_up_arrowl.gif http://localhost/ibmcognos/samples/images/yellow_neutral.gif http://localhost/ibmcognos/samples/images/red_down_arrowl.gif Details http://localhost/ibmcognos More New Business Renewal Retention http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Metrics Trend http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Midwest Southwest West Northeast Northwest Southeast http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Metrics Trend http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Midwest Southwest West Northeast Northwest Southeast Overview Metric Analysis Regional Analysis Regional Details http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Refine Result Set http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png /ibmcognos/pat/images/filter.gif Filter by Metric Type New Business Renewal Retention /ibmcognos/pat/images/filter.gif Filter by Region National Northeast Northwest SoutheastSouthwestMidwestWest New Business Renewal Retention National Northeast Northwest SoutheastSouthwestMidwestWest http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png National View http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Top Regions - New Business http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png No Data Available http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Top States - New Business http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png No Data Available http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Northeast View http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png NationalNational http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Top States - New Business http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png No Data Available http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Northwest View http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png NationalNational http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Top States - New Business http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png No Data Available http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Southeast View http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png NationalNational http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Top States - New Business http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png No Data Available http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Southwest View http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png NationalNational http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Top States - New Business http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png No Data Available http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Midwest View http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png NationalNational http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Top States - New Business http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png No Data Available http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png West View http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png NationalNational http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Top States - New Business http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png No Data Available National Northeast Northwest SoutheastSouthwestMidwestWest http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png National View http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Top Regions - Renewals http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png No Data Available http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Top States - Renewals http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png No Data Available http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Northeast View http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png NationalNational http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png State Rank - Renewals http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png No Data Available http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Northwest View http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png NationalNational http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png State Rank - Renewals http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png No Data Available http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Southeast View http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png NationalNational http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png State Rank - Renewals http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png No Data Available http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Southwest View http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png NationalNational http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png State Rank - Renewals http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png No Data Available http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Midwest View http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png NationalNational http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png State Rank - Renewals http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png No Data Available http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png West View http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png NationalNational http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png State Rank - Renewals http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png No Data Available National Northeast Northwest SoutheastSouthwestMidwestWest Overview Metric Analysis Regional Analysis Regional Details http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Refine Result Set http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png /ibmcognos/pat/images/filter.gif Filter by Metric Type New Business Renewal Retention /ibmcognos/pat/images/filter.gif Filter by Region National New Business Renewal Retention http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Strategic Business Unit Breakdown http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png No Data Available [Regional Details].[SBU Description]=[Prompt].[SBU Description] No Data Available [Regional Details].[SBU Description]=[Prompt].[SBU Description] http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Line of Business Breakdown http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png No Data Available New Business No Data Available http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Category Breakdown http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png No Data Available No Data Available National http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Strategic Business Unit Breakdown http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png No Data Available [Regional Details].[SBU Description]=[Prompt].[SBU Description] No Data Available [Regional Details].[SBU Description]=[Prompt].[SBU Description] National http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Line of Business Breakdown http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png No Data Available No Data Available http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png Category Breakdown http://localhost/ibmcognos/samples/images/bar_38_mid_1x35px.png No Data Available No Data Available National Metrics ListMetrics Trend National Regional Metrics List No Data Available Status http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/statusgreen.png http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/statusyellow.png http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/statusred.png Trend http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/trendup.png http://localhost/ibmcognos/samples/images/yellow_neutral.gif http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/trenddown.png - Trend No Data Available Metrics List No Data Available Status http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/statusgreen.png http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/statusyellow.png http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/statusred.png Trend http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/trendup.png http://localhost/ibmcognos/samples/images/yellow_neutral.gif http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/trenddown.png Trend No Data Available New Business Renewal Retention Strategic Business Unit BreakdownLine of Business Breakdown No Data Available No Data Available Category Breakdown No Data Available Strategic Business Unit BreakdownLine of Business Breakdown No Data Available No Data Available Category Breakdown No Data Available No Data Available No Data Available Image http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/nbnorthwest.png No Data Available Image http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/nbsouthwest.png No Data Available Image http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/nbwest.png Image No Data Available Image http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/nbmidwest.png Image No Data Available Image http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/nbnortheast.png Image http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/nbblank.png No Data Available Image http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/nbsoutheast.png Image National Northeast Northwest SoutheastSouthwestMidwestWest National View No Data Available Image http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/nbnorthwest.png No Data Available Image http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/nbsouthwest.png No Data Available Image http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/nbwest.png Image No Data Available Image http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/nbmidwest.png Image No Data Available Image http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/nbnortheast.png Image http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/nbblank.png No Data Available Image http://vottbidemo01.ottawa.ibm.com:81/ibmcognos/ux_images_repo/insurance/nbsoutheast.png ImageTop Regions - New Business No Data Available Top States - New Business No Data Available State View NationalNationalTop States - New Business No Data Available StateNational Rank View NationalNationalTop States - New Business No Data Available StateNational Rank View NationalNationalTop States - New Business No Data Available StateNational RankSouthwest View NationalNationalTop States - New Business No Data Available StateNational RankMidwest View NationalNationalTop States - New Business No Data Available StateNational RankWest View NationalNationalTop States - New Business No Data Available StateNational Rank InsuranceDraft9SepNew BusinessNationalOverviewNationalSeptemberManufacturingApps SubmittedMiningHomeOffOffOffInsurance Executive Insight if([Metric Analysis - National].[Status1]='Excellent') then ('E') else if ([Metric Analysis - National].[Status1]='Average') then ('A') else ('P') if([Metric Analysis - National].[Trend1]='Getting better') then ('Up') else if ([Metric Analysis - National].[Trend1]='No Change') then ('No') else ('Down') if([Metric Analysis - Regional].[Status1]='Excellent') then ('E') else if ([Metric Analysis - Regional].[Status1]='Average') then ('A') else ('P') if([Metric Analysis - Regional].[Trend1]='Getting better') then ('Up') else if ([Metric Analysis - Regional].[Trend1]='No Change') then ('No') else ('Down')