如何在Birt Designer中对数据立方体进行切片? [英] How to slice a data cube in Birt designer?
问题描述
我在Birt设计器中使用以下数据创建了一个数据立方体:
I created a data cube in Birt designer with the following data :
- 衡量:营业额
- 维度:产品,位置和时间
我现在有一个要以二维数组显示的三维OLAP数据立方体.
I have now a three-dimensional OLAP data cube I want to display in a two-dimensional array.
我的问题是我不知道如何为一维分配常量值(例如:product ="computer"或time ="2014")
My problem here is I don't know how to assign a constant value for one dimension (for example : product = "computer" or time = "2014")
推荐答案
有两种方法可以做到这一点.在性能方面,最有效的方法是将参数添加到多维数据集的主要数据集中并在此处进行过滤.
There are a couple of ways to do this. In terms of performance, the most efficient one would be to add a parameter to the main dataset of the cube and filter here.
如果您无法在数据集中进行过滤(例如,如果其他报表元素使用了第三个datacube维),则另一个选择是:
If you can't filter in the dataset (for example if other report elements make use of the third datacube dimension), another option is:
- 将要切片的维度添加为交叉表的第一列维度,例如下面屏幕的产品系列"维度.
- 添加交叉表过滤器并为此维度设置表达式过滤,例如通过过滤报表参数的值或常量值
- 好用的,如果您不希望显示它:在交叉表中选择尺寸的值(在此示例中只需单击"PRODUCTLINE"标签),然后将可见性属性设置为隐藏".
- Add the dimension you want to slice as a first column dimension of the crosstab, such "Product line" dimension of the screen below.
- Add a cross-tab filter and set an expression filtering on this dimension, for example by filtering on the value of a report parameter or on a constant value
- Facultative, if you don't want it to be displayed: select the value of the dimension in the crosstab (just click "PRODUCTLINE" label in this example) and turn the visibility property to "hide".
这篇关于如何在Birt Designer中对数据立方体进行切片?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!