Logo Top Site    Home   Documents and Lists   Create   Site Settings   Help    Up to DSP BSM Integration
Sales Scorecard
 
 
 
 
 Office Scorecard View
Edit Page FiltersFilter StatusCollapse AllExpand AllSwitch to Filter ModeFilter Mode
Geography
  
......
Product
  
......
Time
  
......
 ActualPlanStatusTrend
 Sales 
Sales106 083,41
103 842,49
100%
0%
Sales YTD352 798,56
337 604,87
100%
 
No of Customers8 957,00
8 957,00
50%
0%
 Short Step by Step instruction

 

  1. Switch between the KPI's (note the performence due to no compenents)
  2. Stop on KPI: Sales
  3. Click on Mexico: Launches an SQL RS Report filtered on Mexico
  4. Open the filter (top left icon in Office Scorecard View)
  5. Filter on Food - See Food Sub Groups in the DSP Report view (detailed info)
  6. Filter on Mexico - See States of Mexico in the DSP Report view (detailed info)
  7. Click on Detailed link (the name) on any DSP Report View - Launch the Pivot Table
  • Step 7 requires installation of the DSP client
  • Install the trial version from our web site
  • Goto http://www.dspanel.com and click on the following link
  • 2 - Second: Download the fully functional trial version
  • No product key needed for installation on a client
  • This demo uses HTTP access to Analysis Services

From the DSP online Help - How to add a DSP Report View to MS BSM:

http://support.dspanel.com/help43/Report_View/Add_Report_View.htm  

 
[Geography]35[Geography].[(All)]True0100[Geography].[All Geography][Product]35[Product].[(All)]True0100[Product].[All Product][Salesperson]35[Salesperson].[(All)]True0100[Salesperson].[All Salesperson]left0#FF0000,#FFD700,#0080008080141500dspDemo Sales Measure CubeProvider=MSOLAP.2;Data Source=http://demo.dspanel.com/olap;Initial Catalog=dspDemoSalesOLAPDB;MDX Unique Name Style=3;MDX Compatibility=2;Persist Security Info=False;Connect Timeout=60;Client Cache Size=25;Auto Synch Period=10000;dspDemoSalesMeasureCubedspM1[Measures].[Actual]01#,0dspM2[Measures].[Plan]01#,0dspPA[Measures].[PA]5-20#,0dspPC[Measures].[PC]5-20#,0dspArrow[Measures].[Arrow]iif(([Measures].[dspM1] - (_TD_.PrevMember, [Measures].[dspM1])) / iif((_TD_.PrevMember, [Measures].[dspM1])=0,1,Abs((_TD_.PrevMember, [Measures].[dspM1])))*100 <= [Measures].[dspPA] * -1, -1, iif(([Measures].[dspM1] - (_TD_.PrevMember, [Measures].[dspM1])) / iif((_TD_.PrevMember, [Measures].[dspM1])=0,1,Abs((_TD_.PrevMember, [Measures].[dspM1])))*100 >= [Measures].[dspPA], 1, 0))-21#,0dspColor[Measures].[Color]iif(([Measures].[dspM1]-[Measures].[dspM2])/iif([Measures].[dspM2]=0, 1, Abs([Measures].[dspM2]))*100 <= [Measures].[dspPC] * -1, -1, iif(([Measures].[dspM1]-[Measures].[dspM2]) / iif([Measures].[dspM1]=0,1,Abs([Measures].[dspM2]))*100 >= [Measures].[dspPC], 1, 0))-21#,0dspME[Measures].[ME]IIF(Sum({[dspTM]}, [Measures].[dspM1]) <> 0 Or Sum({[dspTM]}, [Measures].[dspM2]) <> 0, 1, 0)-20#,0[Geography].[All Geography][Product].[All Product][Time].[Month].&[24]
Sales
SPS2dspwwt01.uscmain1dspwsc011.clsWPContentdspwsr02.clsWPResult400100[Time]1[Time].[Month]1321001[Time].[Month].&[10][Time].[Month].&[11][Time].[Month].&[12][Time].[Month].&[13][Time].[Month].&[14][Time].[Month].&[15][Time].[Month].&[16][Time].[Month].&[17][Time].[Month].&[18][Time].[Month].&[19][Time].[Month].&[20][Time].[Month].&[21][Time].[Month].&[22][Time].[Month].&[23][Time].[Month].&[24]True0
TimeGeographyProductSalespersonActualPlanArrow SensitivityColor SensitivityArrow ValueColor ValueExclude Empty Rows
     
   
         
0[Geography].[All Geography][Product]35[Product].[(All)]True0100[Product].[All Product][Salesperson]35[Salesperson].[(All)]True0100[Salesperson].[All Salesperson][Time]11[Time].[(All)]True0100[Time].[Month].&[22][Time].[Month].&[23][Time].[Month].&[24]left3011001120010nullnull2#7B68EE,#2E8B57,#87CEFA,#32CD32,#800080,#00008B,#EEE8AA,#9932CC,#F08080,#B0E0E6,#FF69B4,#FFD700100100341500#,0dspDemo Sales Measure CubeProvider=MSOLAP.2;Data Source=http://demo.dspanel.com/olap;Initial Catalog=dspDemoSalesOLAPDB;MDX Unique Name Style=3;MDX Compatibility=2;Persist Security Info=False;Connect Timeout=60;Client Cache Size=25;Auto Synch Period=10000;dspDemoSalesMeasureCube[Measures].[Actual]UseProviderFormatting00[Measures].[Plan]UseProviderFormatting00[Measures].[Actual YTD]UseProviderFormatting00[Measures].[Plan YTD]UseProviderFormatting00[Geography].[All Geography][Product].[All Product][Time].[Month].&[24]
Sales YTD
SPS2dspwwt05.uscmain3dspwsc051.clsWPContentdspwsr02.clsWPResult400150[Geography]35[Geography].[(All)]True010
GeographyProductSalespersonTimeActualPlanActual YTDPlan YTD
 
0[Geography].[All Geography][Product]35[Product].[(All)]True0100[Product].[All Product][Salesperson]31[Salesperson].[(All)]True0100[Salesperson].[All Salesperson][Salesperson].[Salesperson].&[5][Salesperson].[Salesperson].&[6][Salesperson].[Salesperson].&[1][Salesperson].[Salesperson].&[3][Salesperson].[Salesperson].&[4][Salesperson].[Salesperson].&[2][Time]15[Time].[(All)]True0100[Time].[All Time]30classic_01left41510Sales PersondspDemo Sales Measure CubeProvider=MSOLAP.2;Data Source=http://demo.dspanel.com/olap;Initial Catalog=dspDemoSalesOLAPDB;MDX Unique Name Style=3;MDX Compatibility=2;Persist Security Info=False;Connect Timeout=60;Client Cache Size=25;Auto Synch Period=10000;dspDemoSalesMeasureCube[Measures].[No Of Customers]#,000[Measures].[Trend][No Of Customers Trend]SYMBOL:TrendArrow00[Geography].[All Geography][Product].[All Product][Time].[Month].&[24]
No of Customers
SPS2dspwwt03.uscmain1dspwsc031.clsWPContentdspwsr02.clsWPResult200100[Geography]35[Geography].[(All)]True010
GeographyProductSalespersonTimeNo Of CustomersTrend