客户端解决方案

BIBI//--11BusinessIntelligenceBusinessIntelligenceBIBI//--22BIBICubeCubeDWDWOLAPOLAPClientClientBIBI//--33BIBI//--44ExcelPivotTableExcelPivotTableOWCOWCReportingServiceReportingServiceBIBI//--55ExcelPivotTableExcelPivotTableBIBI//--66MicrosoftOfficeExcel2003MicrosoftOfficeExcel2003--……OLAPOLAP––––BIBI//--77BIBI//--88foodmartfoodmartOLAPOLAPMicrosotMicrosotOLEDBProviderforOLEDBProviderforOLAPServices8.OLAPServices8.localhostlocalhostfoodMartfoodMart2000200022BIBI//--99BIBI//--1010BIBI//--1111BIBI//--1212BIBI//--1313––ExcelExcel––MDXMDX––––––––ASASBIBI//--1414OWCOWCOfficeWebComponentOfficeWebComponentBIBI//--1515--11FrontpageFrontpage20032003--WebWeb……BIBI//--1616--22,,……BIBI//--1717--33BIBI//--1818BIBI//--1919--44FrontpageFrontpageBIBI//--2020BIBI//--2121BIBI//--2222––––––MDXMDX––––––ASAS––ActiveXActiveXThinClientThinClientBIBI//--2323ReportingServiceReportingServiceReportingService?ReportingService?ReportingServiceReportingService––––OLAPOLAP––BIBI//--2424ReportingServiceReportingServiceBIBI//--2525SELECT{[SELECT{[Measures].[StoreMeasures].[StoreSales],Sales],[[Measures].[StoreMeasures].[StoreCost]}Cost]}ONCOLUMNS,ONCOLUMNS,{{Descendants([Product].[AllDescendants([Product].[AllProducts],Products],[[Product].[BrandProduct].[BrandName],LEAVES)}Name],LEAVES)}ONROWS,ONROWS,{Time.[1997].[Q1],Time.[1997].[Q2],Time.[1997].[{Time.[1997].[Q1],Time.[1997].[Q2],Time.[1997].[Q3],Time.[1997].[Q4]}Q3],Time.[1997].[Q4]}ONPAGESONPAGESFROMSalesFROMSalesBIBI//--2626––ThinClientThinClient––––––––––MDXMDXBIBI//--2727BIBI//--2828BIBI//--2929––––10%10%––20032003––MDXMDXBIBI//--3030MDXMDXFILTER(FILTERFILTER(FILTER([([Customers].[Name].MembersCustomers].[Name].Members,,(([(([Measures].[SalesMeasures].[Sales],[],[Products].[ProductProducts].[ProductLine].&[PCs].&[BusinessLine].&[PCs].&[BusinessPCs],[Time].&[2002])0)),PCs],[Time].&[2002])0)),(([(([Measures].[SalesMeasures].[Sales],[],[Products].[ProductProducts].[ProductLine].&[PCs].&[Servers],[Time].&[2002])=Line].&[PCs].&[Servers],[Time].&[2002])=0))0))BIBI//--3131vs.vs.BIBI//--3232BIBI//--3333BIBIBIBIBIBI––ProClarityProClarity––PanoramaPanorama––Brio/Brio/CognosCognos/CrystalAnalysis/CrystalAnalysis––BIBI//--3434ASASTheOLAPSurvey2003TheOLAPSurvey2003BIBI//--3535BICompetitiveFrameworkBICompetitiveFrameworkPartnerPartnerCompetitorCompetitorIBMIBMOracleOracleSAPSAPBusinessBusinessObjectsObjects**PlatformPlatformCognosCognosProClarityProClarityPanoramaPanoramaOutlooksoftOutlooksoftApplicationApplicationMicrostrategyMicrostrategyHyperionHyperionSPSSSPSSSASSASTeradataTeradataFontSizeIndicatesFontSizeIndicatesSignificanceSignificanceInformaticaInformaticaActuateActuateTemtecTemtecMISAGMISAGIntelligentAppsIntelligentAppsLawsonLawsonEpicorEpicorAlphabloxAlphabloxMcKessonMcKessonBIBI//--3636ASAS––ProClarityProClarity––PanoramaPanorama––BOBO––CognosCognos––BrioBrioBIBI//--3737ProClarityProClarityBIBI//--3838––CDCD––––--://cse.gscas.ac.cn/TeachModel/course/bi/resources.aspesources.asp––BIBI//--3939CubeforCubeforbrowsingbrowsingBIBI//--4040Server=Server=LOCALHOSTLOCALHOSTOKOKCubeCubeBIBI//--4141BIBI//--4242BIBI//--4343(*.(*.bbkbbk))––cubecube––CubeCubeCubeCubeBIBI//--4444––––––––––BIBI//--4545MDXQueryMDXQuerySELECT{[Time].[1997].[Q1],[Time].[1997].[Q2],[Time].[1997].[Q3],[Time].[1997].[Q4]}ONCOLUMNS,{[Product].[ProductFamily].[Drink],[Product].[ProductFamily].[Food],[Product].[ProductFamily].[Non-Consumable]}ONROWSFROM[Sales]WHERE([Measures].[StoreSales])BIBI//--4646MDXMDXNN++=N+1=N+1––––––––BIBI//--4747––––BIBI//--4848BIBI//--4949BIBI//--5050BIBI//--5151BIBI//--5252BIBI//--5353BIBI//--5454BIBI//--5555//BIBI//--5656––––––shift+shift+––Shift+Shift+BIBI//--5757BIBI//--5858DemoDemoBIBI//--5959––BIBI//--6060––//––BIBI//--6161////––//NN––––––////BIBI//--6262BIBI//--6363––ASASActionAction––––ASASDrillThroughDrillThroughBIBI//--6464BIBI//--6565BIBI//--6666––––BIBI//--6767BIBI//--6868ASASBIBI//--6969KPIKPI––KPI?KeyperformanceindicatorKPI?Keyperformanceindicator––––––––2003200355––NamedsetNamedsetBIBI//--7070KPIKPIBIBI//--7171KPIKPIGrowthfromPriorPeriodGrowthfromPriorPeriodRollingPeriodSumRollingPeriodSumPeriodPeriod--toto--dateSumdateSumPercentContributionPercentContributionOpen/ClosingBalanceOpen/ClosingBalanceRankRankBIBI//--7272KPIKPIKPIKPIProClarityProClarity––XMLXMLKPIKPI––KPIKPIBIBI//--7373KPIKPIkpikpiBIBI//--7474BIBI//--7575KPIKPIMDXMDXBIBI//--7676––..bbkbbk––ExcelExcel––ExcelExcel––PowerpointPowerpoint––WordWord––TextText––OutlookOutlookofflineoffline––––OfflineOfflineLocalCubeLocalCubeBIBI//--7777PanoramaPanoramaJavaAppletJavaAppletBIBI//--7878KPIKPIBIBI//--7979BIBI//--8080BIBI//--8181BIBI//--8282––––––––––ProClarityProClarity––PanoramaPanorama––