BusinessObjects Enterprise XI 3.1 .NET SDK Runtime Deployment

需积分: 10 2 下载量 8 浏览量 更新于2024-08-01 收藏 301KB PDF 举报
"xi3-1_boe_net_runtime_en" 这篇文档是关于BusinessObjects Enterprise XI 3.1 .NET SDK运行时部署的指南。BusinessObjects Enterprise是SAP公司(当时是BusinessObjects公司)的一个企业级商业智能(BI)平台,它提供了数据集成、分析和报告的功能。.NET SDK(软件开发工具包)允许开发人员使用Microsoft .NET框架来构建与BusinessObjects平台交互的应用程序。 在.NET SDK运行时部署中,主要涉及以下几个关键知识点: 1. **.NET SDK**:这是一个针对开发人员的工具集,包含了库、文档、示例代码等,用于创建、扩展或集成BusinessObjects应用程序。使用.NET SDK,开发者可以用C#、VB.NET或其他.NET语言来开发自定义的BI解决方案。 2. **BusinessObjects Enterprise XI 3.1**:这是BusinessObjects的一个版本,提供了一系列的报表、分析和数据挖掘工具。XI代表“eXtreme Intelligence”,3.1是其版本号。这个版本可能包含了改进的性能、新的功能和对之前版本的增强。 3. **运行时部署**:此文档专注于在目标环境中安装和配置所需的组件,使得基于.NET的应用程序能够顺利运行。这包括设置必要的依赖项、注册dll文件、配置服务器连接等。 4. **版权和专利**:文档开头列出了一系列美国专利号,表明BusinessObjects(现为SAP的一部分)拥有这些专利,可能涵盖其产品中的某些技术。这强调了产品和技术的知识产权保护。 5. **产品品牌和商标**:文档中提到了BusinessObjects的多个产品和服务名称,如BusinessProcess OnDemand、Crystal Reports、Desktop Intelligence等,这些都是BusinessObjects BI产品线的重要组成部分,各自服务于不同的BI需求,如报表设计、数据分析和自助式查询。 6. **开发和集成**:使用BusinessObjects .NET SDK,开发人员可以构建定制的报告和分析应用,这些应用可以直接嵌入到其他业务系统中,实现无缝的数据可视化和决策支持。 7. **支持的技术**:由于是.NET SDK,这意味着它与Microsoft的开发环境和.NET框架兼容,能够利用.NET的多语言支持和丰富的库。 这篇文档是为那些希望使用BusinessObjects Enterprise XI 3.1的.NET SDK来开发和部署BI解决方案的开发者准备的,它提供了详细的指导,帮助他们在自己的环境中正确配置和运行BusinessObjects相关的.NET应用程序。

select lot_hs.lot_id as lot_id,lot_type,lot_hs.mainpd_id, created_time,COMPLETE_TIME, value(bank.banktime,0) as banktime , round ( ( 1.00*(days(COMPLETE_TIME)-days(created_time)) + (hour(COMPLETE_TIME)-hour(created_time))*1.00/24 + (minute(COMPLETE_TIME)-minute(created_time))*1.00/24/60 + (second(COMPLETE_TIME)-second(created_time))1.00/24/60/60) - value(bank.banktime,0),3) as use_days, customer_id, coalesce(cc.cust_id_define,lot_hs.customer_id) as cust_id2, cc.cycletime_target as ct_target, date,layer, round(count() over(partition by coalesce(cc.cust_id_define,lot_hs.customer_id),cc.cycletime_target)*0.9,0) cnt, row_number() over(partition by coalesce(cc.cust_id_define,lot_hs.customer_id),cc.cycletime_target order by ( ( days(COMPLETE_TIME)-days(created_time) + (hour(COMPLETE_TIME)-hour(created_time))*1.00/24 + (minute(COMPLETE_TIME)-minute(created_time))*1.00/24/60 + (second(COMPLETE_TIME)-second(created_time))*1.00/24/60/60) - value(bank.banktime,0))/layer) id From (select date(a.claim_time) as date, a.lot_id, a.lot_type,a.mainpd_id,a.prodspec_id,a.custprod_id, case when(date(b.created_time) <= '2009-01-05') then b.created_time + 21 days else b.created_time end as created_time, CASE WHEN A.CUST_id in ('MCA','NPA','SET') THEN a.COMPLETE_TIME ELSE a.COMPLETE_TIME END COMPLETE_TIME, a.cust_id as customer_id, a.ope_category, c.layer From f3rpt.F3_TB_DAILY_FABOUT a, f3rpt.fvlot b, (select mainpd_id, sum(masks)layer from f3rpt.ASMCRPT_VW_MAINPD_MASKS_ALL group by mainpd_id) as c, (select * from (select lot_id, max(claim_time)claim_time, count(case when(ope_category='Ship')then lot_id else null end) as LS, count(case when(ope_category='Unship') then lot_id else null end) as LUS from f3rpt.F3_TB_DAILY_FABOUT where substr(lot_id,1,2) not in('CA','CW','ES','E0','EM') and lot_type = 'Production' AND LOT_ID NOT LIKE 'H%' and substr(lot_id,7,4)='.00F' and ope_category in ('Ship','Unship') and year(claim_time) = year(current date - 1 days) and month(claim_time) = month(current date - 1 days) group by lot_id) as a where LS - LUS > 0 ) as lot Where a.lot_id = b.lot_id and b.mainpd_id = c.mainpd_id and a.lot_id = lot.LOT_ID and a.claim_time = lot.claim_time and a.ope_category = 'Ship' and a.cust_id in ('SM','BOE','GSC','NPA','GTA') ) as lot_hs left outer join (select lot_id,max(bankin_time) banktime from f3rpt.asmc_dpm where bankin_time>0 group by lot_id) bank on (lot_hs.lot_id = bank.lot_id) left join f3cim.f3cim_cfg_cust_rule cc on case when lot_hs.customer_id='WXM' THEN 'WII'||SUBSTR(lot_hs.mainpd_id,6,1) else lot_hs.customer_id end = cc.cust_id and locate(cc.mainpd_id,lot_hs.mainpd_id)>0 and locate(cc.prodspec_id,lot_hs.prodspec_id)>0 and locate(cc.custprod_id_45,substr(lot_hs.custprod_id,3,3))>0 where lot_hs.ope_category = 'Ship' ;以上sql如何优化

2023-06-07 上传
2023-06-08 上传