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...
Xcelsius中删除空值的行
实际应用中有可能需要删除原始数据中空值的行,如图:红色部分原始数据,A列为记录行号,没有可以手工添加;B列是维度;C列是指标。需求是,需要删除B列值为0(或空)行,黄色部分为期望结果。操作如下:1、D...