-
编辑 删除
Creating Portable Xcelsius Colour Schemes
Within your Xcelsius install directory (default is: C:\Program Files\Business Objects\Xcelsius\assets\themes\built-in) you will find a group of XML files, which create the colour schemes whithin...
-
编辑 删除
Optional Prompts with Default Values in Designer
Truth be told, today I felt like a total rookie. I got a requirement that screamed "don't dare duplicate that report just so you can have a version to schedule and version to run on demand". The requi...
-
编辑 删除
Show Percentage Change in Xcelsius / SCDD Charts
I recently had a requirement to show a month over month change by percentage in an Xcelsius chart. As you may have found out, there is no way to customize the tooltip labels within Xcelsiu...
-
编辑 删除
webi function
QuerySummary() will give you summary of the query, which include all the filters, number of rows fetched, universe name and more useful information. PromptSummary() tells you all the prompts present o...
-
编辑 删除
Crystal Reports to XML
Crystal Reports to XMLXML (Extensible Markup Language) has had export support from Crystal Reports for quite a while. While the Export to XML option allows for specification of a transform. file (XSL...
-
编辑 删除
Work-around for flash player hangs/freezes during initialisation
Are you also facing the problem that the flash player hangs/freezes during execution of an xcelsius file? Try if the following work-around works also for you.I am (was) facing the same problem: a swf...
-
编辑 删除
Linux中oracle——解决backspace和上下键使用出现乱码
Vi编辑器修改文件.bash_profile可解决backspace出现乱码问题 使用SecureCRT或是pietty_ch连接到一台安装有Oracle DB 10g的RHEL4.2的机器，linux使用的shell是默认的bash。 在bash提示符下，使用Del键或者Ba...
-
编辑 删除
Oracle Date Caculation
1.查询条件中 1.Where to_char(date_column,'yyyy') = '2005' 2.Where trunc(date_column,'y') = to_date('01-jan-2005','dd-mon-yyyy')后者不...
-
编辑 删除
Oracle字符集问题
一、什么是oracle字符集 Oracle字符集是一个字节数据的解释的符号集合,有大小之分,有相互的包容关系。ORACLE 支持国家语言的体系结构允许你使用本地化语言来存储，处理，检索数据。它使数据库工具，错误消息，排...
-
编辑 删除
Oracle 获取DDL语句方法
select dbms_metadata.get_ddl('TABLE','DEPT','SCOTT') from dual; select dbms_metadata.get_ddl('INDEX','DEPT_IDX','SCOTT') from dual; select dbms_metadata.get_ddl('PROCEDURE','PRO1','SYS...
-
编辑 删除
Xcelsius中删除空值的行
实际应用中有可能需要删除原始数据中空值的行，如图：红色部分原始数据，A列为记录行号，没有可以手工添加;B列是维度；C列是指标。需求是，需要删除B列值为0（或空）行，黄色部分为期望结果。操作如下：1、D...
