BusinessObjects BI Server 入门与管理详解

需积分: 10 3 下载量 152 浏览量 更新于2024-07-23 收藏 1.12MB PDF 举报
"《Business Objects BI Server 入门指南》是一份全面的教程，专为希望了解和管理 BusinessObjects BI (Business Intelligence) 服务器的用户设计。该指南深入介绍了 BusinessObjects BI Server 的核心概念、功能和操作流程，特别关注了 WebIntelligence 的使用。 1. **BusinessObjects BI Server简介**：首先，读者会理解 BI Server 的基本定义，它是 BusinessObjects 产品系列的一部分，旨在为企业提供强大的数据分析和可视化工具。此指南面向各种用户，包括企业决策者、数据分析师和 IT 维护人员。指南明确指出，对于本帮助文档的读者，无论是初次接触还是已有经验的用户，都旨在提供清晰的指导。 2. **管理 BusinessObjects BI Server**：章节涵盖了管理 BI Server 的各个方面，如安装前的准备，包括兼容性（如与 Linux 操作系统的支持），以及日常运维任务。管理部分着重于中央管理控制台的配置，如何利用 InfoView 进行数据管理和仪表板创建，以及WebIntelligence 的管理和许可证管理，包括添加和监控许可证信息。 3. **WebIntelligence**：作为 BI Server 的关键组件，WebIntelligence 被详细介绍。用户将学习如何创建和编辑 WebIntelligence 文档，这些文档是交互式报表和数据探索的重要工具。这部分内容对于理解和操作 WebIntelligence 工作流至关重要。 此外，指南还强调了知识产权保护，包括 BusinessObjects 的专利和商标权益，以及第三方供应商许可软件的使用规范。在目录中，每个章节都有详细的索引，方便用户快速查找所需的信息。 通过阅读本入门指南，用户将掌握如何有效地部署、管理和利用 BusinessObjects BI Server，提升企业的数据分析能力，支持更明智的决策制定。"

Business Objects入门教程

2012-07-05 上传
Business Objects入门教程，总共八课组成。每一课的目标都是对一个实际的业务 介绍问题做一份报表。每一课都会通过一步步的实际操作向您演示怎样做一份报表。 主要介绍了BO查询、报表、分析和报表的分发等几个方面，

Business Object Universe Designer 指南 （中文版）

2011-12-01 上传
Business Object Universe Designer 指南 （中文版）

SAP_Business_Objects_培训SAP_Business_Objects_培训

2011-03-18 上传
### SAP Business Objects 培训知识点详述 #### 一、SAP Business Objects XI Enterprise：管理用户和内容 - **培训目标**：本课程为期两天，由专业讲师引导，主要面向系统管理员，介绍如何管理 SAP Business ...

SELECT crs.*, bus.work_no business_work_no, bus.name business_name FROM sto_menu crs LEFT JOIN ord_business bus ON crs.business_Id = bus.id

2024-06-27 上传
JOIN条件是`crs.business_Id = bus.id`，这意味着你依据`business_Id`字段将这两个表中的记录对应起来。 - 在结果集中，你选择了特定的几列：`bus.work_no`、`business_work_no`和`bus.name`、`business_name`。`...

SELECT bc.id as businessCompanyId, bc.company_name as businessCompanyName, any_value(su.`user_name`) as businessUser, bcff.type as fileType, fcl.clean_type as fileType, -- CASE sex WHEN ‘1’ THEN ‘男’ WHEN ‘2’ THEN ‘女’ ELSE ‘其他’ END CASE fcl.clean_type when 0 then count(fcl.id) as goodsCodeErrorNum when 1 then count(fcl.id) as hospitalNameErrorNum when 2 then count(fcl.id) as orderTypeErrorNum END FROM business_company bc INNER JOIN business_company_flow_file bcff ON bcff.business_company_id = bc.id INNER JOIN business_flow_detail bfd ON bcff.id = bfd.flow_file_id INNER JOIN flow_clean_log fcl ON fcl.business_flow_detail_id = bfd.id LEFT JOIN sys_user su ON su.user_id = bc.user_id GROUP BY bc.id, bcff.type, fcl.clean_type

2023-06-08 上传
具体来说，它查询了 business_company 表、business_company_flow_file 表、business_flow_detail 表、flow_clean_log 表和 sys_user 表，然后根据 business_company 的 id、business_company_flow_file 的 type 和 ...

解读下这段sqlselect region_code,count(*) from ( select substr(region_code,0,6) region_code,receive_number from tysl.accept_business_index where receive_time between to_date('2023/5/1','yyyy/mm/dd') and to_date('2023/6/1','yyyy/mm/dd') and state !='90' union all select substr(region_code,0,6) region_code,receive_number from tysl_gy.accept_business_index where receive_time between to_date('2023/5/1','yyyy/mm/dd') and to_date('2023/6/1','yyyy/mm/dd') and state !='90' union all select substr(region_code,0,6) region_code,receive_number from tysl_zy.accept_business_index where receive_time between to_date('2023/5/1','yyyy/mm/dd') and to_date('2023/6/1','yyyy/mm/dd') and state !='90' union all select substr(region_code,0,6) region_code,receive_number from tysl_lps.accept_business_index where receive_time between to_date('2023/5/1','yyyy/mm/dd') and to_date('2023/6/1','yyyy/mm/dd') and state !='90' union all select substr(region_code,0,6) region_code,receive_number from tysl_ga.accept_business_index where receive_time between to_date('2023/5/1','yyyy/mm/dd') and to_date('2023/6/1','yyyy/mm/dd') and state !='90' union all select substr(region_code,0,6) region_code,receive_number from tysl_as.accept_business_index where receive_time between to_date('2023/5/1','yyyy/mm/dd') and to_date('2023/6/1','yyyy/mm/dd') and state !='90' union all select substr(region_code,0,6) region_code,receive_number from tysl_bjs.accept_business_index where receive_time between to_date('2023/5/1','yyyy/mm/dd') and to_date('2023/6/1','yyyy/mm/dd') and state !='90' union all select substr(region_code,0,6) region_code,receive_number from tysl_trs.accept_business_index where receive_time between to_date('2023/5/1','yyyy/mm/dd') and to_date('2023/6/1','yyyy/mm/dd') and state !='90' union all select substr(region_code,0,6) region_code,receive_number from tysl_qn.accept_business_index where receive_time between to_date('2023/5/1','yyyy/mm/dd') and to_date('2023/6/1','yyyy/mm/dd') and state !='90' union all select substr(region_code,0,6) region_code,receive_number from tysl_qxn.accept_business_index where receive_time between to_date('2023/5/1','yyyy/mm/dd') and to_date('2023/6/1','yyyy/mm/dd') and state !='90' union all select substr(region_code,0,6) region_code,receive_number from tysl_qdn.accept_business_index where receive_time between to_date('2023/5/1','yyyy/mm/dd') and to_date('2023/6/1','yyyy/mm/dd') and state !='90' )group by region_code order by region_code

2023-06-09 上传
index、tysl_as.accept_business_index、tysl_bjs.accept_business_index、tysl_trs.accept_business_index、tysl_qn.accept_business_index、tysl_qxn.accept_business_index、tysl_qdn.accept_business_index。...

$where = null; //$where = new Where(); if($business_no != '1') { // $where['cia.business_no'] = $business_no; $where = "cia.business_no='".$business_no."'"; }else if($keyword){ $where = ["cia.business_no|pi.customer_name","like","%".$keyword."%"]; } $res = Db::name('ceb_inquiry_apply')->alias("cia") ->leftJoin('pg_inquiry pi','pi.business_no = cia.business_no') //->leftJoin('pg_inquiry_detail pid','pid.inquiry_id= pi.id') ->field('cia.*,if(cia.update_time,cia.update_time,cia.create_time) as time') ->field('pi.bank_name,pi.branch_bank_name,pi.customer_name,cia.business_no as business_no') ->order("time","desc") ->where($where) //->group('pid.inquiry_id') ->paginate($paginate); return $res;报错：查询表达式错误:'cia.business_no|pi.customer_name'，如何解决

2023-06-07 上传
$where['cia.business_no'] = $business_no; } else if ($keyword) { $where['cia.business_no|pi.customer_name'] = ['like', "%".$keyword."%"]; } ``` 然后在查询语句中使用 `$where` 变量即可。

使用Java实现，对sql="SELECT stat_date AS stat_date, dim_id AS dim_id, province_id AS province_id, province_name AS province_name, city_id AS city_id, city_name AS city_name, county_id AS county_id, county_name AS county_name, business_name AS business_name, business_type AS business_type, business_license AS business_license, legal_person_name AS legal_person_name, addr AS addr, DATE_FORMAT( establish_date, '%Y年%m月%d日' ) AS establish_date, reg_capital_amt /1000000 AS reg_capital_amt, LEFT (business_scope, 20) AS business_scope, demonstration_level AS demonstration_level, credit_level AS credit_level, org_manage_score_td AS org_manage_score_td, finance_manage_score_td AS finance_manage_score_td, economic_strength_score_td AS economic_strength_score_td, serv_effect_score_td AS serv_effect_score_td, product_quality_score_td AS product_quality_score_td, social_reputation_td AS social_reputation_td, FORMAT(composite_score_td, 1) AS composite_score_td FROM app_bussiness_portrait_df where 1=1 and stat_date = (select max(stat_date) from app_bussiness_portrait_df ) and county_id = '${regionId}' and business_type = '${business_type}' "进行解析，使用druid解析，解析出每个字段来源

2023-06-02 上传
name AS county_name, business_name AS business_name, business_type AS business_type, business_license AS business_license, legal_person_name AS legal_person_name, addr AS addr, DATE_FORMAT( ...

优化这个sql select FLOW_COMMON.c_business_id as business_id, (select max(f.end_time) from flow_hi_track f where f.business_id = FLOW_COMMON.c_business_id and f.action_type != 'CLAIM' ) as deal_time from template_flow_common FLOW_COMMON right join template_hollycrm1680160914000 hollycrm1680160914000 on FLOW_COMMON.c_business_id = hollycrm1680160914000.c_business_id where FLOW_COMMON.tenant_id = 'T000' and FLOW_COMMON.valid = 1 and lower(FLOW_COMMON.c_state) != 'draft' and ( ( FLOW_COMMON.c_flow_id in ('FLOW20230330152148238756') and (FLOW_COMMON.c_processing_group in ('1650685461842100265') ) or FLOW_COMMON.c_cur_assignee = '1639203916409208891' ) or FLOW_COMMON.c_creator = '1639203916409208891' or FLOW_COMMON.c_flow_id in ('FLOW20230330152148238756') or FLOW_COMMON.c_business_id in ('1650765461521956870', '1650765461521956870', '1650817085812506712', '1650831863482155082', '1654094763571281921', '1654001405104488514', '1654294361434751036', '1654445890410119245', '1654441313937915946', '1654433554383241232', '1653329109050196051', '1655380751421538376', '1655380751421538376', '1654732194700066894', '1654765190966673497', '1655862681678118938', '1654732194700066894', '1654732194700066894', '1654732194700066894', '1654441313937915946', '1656855682290286598', '1654732194700066894', '1654732194700066894', '1654732194700066894', '1656106327421747261') or (FLOW_COMMON.c_processing_group in ('1650685461842100265')) ) and FLOW_COMMON.c_workorder_type = 'C0018' and FLOW_COMMON.c_business_type = 'C00180008,C001800080001,C0018000800010001' LIMIT 572540,10;

2023-07-25 上传
OR EXISTS (SELECT 1 FROM template_flow_common t WHERE FLOW_COMMON.c_business_id = t.c_business_id AND t.c_business_id IN ('1650765461521956870', '1650817085812506712', '1650831863482155082', '...

SELECT * FROM T_BUSINESS_VIRTUAL_LOCATION WHERE F_TRAY_CODE = (SELECT TOP 1 F_TRAY_CODE FROM T_BUSINESS_STOCK_BILL WHERE F_STATUS = #{status} AND F_TYPE = #{type} AND F_IS_VIRTUAL = '1' ORDER BY MAKE_TIME ASC) 用QueryWrapper改造 sqlservier数据库

2023-06-14 上传
QueryWrapper<BUSINESS_VIRTUAL_LOCATION> queryWrapper = new QueryWrapper(); queryWrapper.eq("F_TRAY_CODE", new QueryWrapper<BUSINESS_STOCK_BILL>() .select("TOP 1 F_TRAY_CODE") .eq("F_STATUS", ...
xyzsy83
  • 粉丝: 0
  • 资源: 4
上传资源 快速赚钱

最新资源