|
Re: Accumulations in CrossTabs [message #691558 is a reply to message #691370] |
Fri, 01 July 2011 17:43 |
|
Marco,
Have you tried to build the report in the designer? If so take a look
at the xml the designer creates.
Jason
On 7/1/2011 6:13 AM, Marco wrote:
> Hi,
>
> I have the following cube:
>
> dim1
> year
> quarter
> month
> dim2
> dim3
> level1
> level2
> level3
> dim4
> measure1
> measure2
> measure3
>
>
> From this a want to create the following crosstab:
>
> columns = dim1 year and quarter
> rows = dim2
> measure1 is independent from dim1, dim3, and dim4 -> display any e.g. LAST
> measure2 is independent from dim3 and dim4 -> take and of them but SUM
> over dim1 quarter
>
>
> I created the following for measure2 with DEAPI:
> AggregationCell in MeasureView with
>
> <property name="aggregationOnRow">Group_Dim2/Dim2</property>
> <property name="aggregationOnColumn">Group_Timeline/Quarter</property>
> <property
> name="resultSetColumn">Measure2_Group_Dim2/Dim2_Group_Timeline/Quarter</property>
>
>
>
> DataBinding Measure2_Group_Dim2/Dim2_Group_Timeline/Quarter with
>
> <expression name="expression">data["Measure2_Aggregation"]</expression>
> <property name="dataType">decimal</property>
> <simple-property-list name="aggregateOn">
> <value>Group_Dim2/Dim2</value>
> <value>Group_Timeline/Quarter</value>
> </simple-property-list>
> <property name="aggregateFunction">LAST</property>
>
>
> DataBinding Measure2_Aggregation with
>
> <expression name="expression">measure["Measure2"]</expression>
> <property name="dataType">decimal</property>
> <simple-property-list name="aggregateOn">
> <value>Group_Timeline/Quarter</value>
> </simple-property-list>
> <property name="aggregateFunction">sum</property>
>
>
> This brings me the error message
>
> "Group_Dim2/Dim2/Dim2" aggregate on in cube nest aggregation
> "Measure2_Group_Dim2/Group_Timeline/Quarter" does not exist in its based
> aggregation(s).
>
>
> I tried some variations but did not succeed. I am totally lost.
>
> Can somebody clarify how to get this kind of aggregations.
>
> Thanks,
> Marco
|
|
|
|
Re: Accumulations in CrossTabs [message #691603 is a reply to message #691587] |
Fri, 01 July 2011 19:49 |
|
It would help if you can illustrate with some sample data.
Jason
On 7/1/2011 3:35 PM, Marco wrote:
> Hi Jason,
>
> Thanks for the answer.
>
> I don't know how to built the report in designer either. I found no
> option or selection for aggregations that would lead to the type of
> aggregation I want.
>
> Please take a closer look on my "micro specification". Maybe you can
> give me a hint how to do it.
>
> Thanks,
> Marco
|
|
|
|
Re: Accumulations in CrossTabs [message #691618 is a reply to message #691612] |
Fri, 01 July 2011 20:56 |
|
The issue may have something to do with the measure being independent
from a dimension. I am not 100% sure. Can you try to add a data item
with its expression something like data["mymeasure"]?
Jason
On 7/1/2011 4:39 PM, Marco wrote:
> I have not data available since this is a much simplified illustration
> of my real model.
>
> But from the specs it should be quite obvious how the data could look
> like. Please tell me what exactly is not clear. I'd be happy to explain.
>
> Thanks,
> Marco
|
|
|
|
Powered by
FUDForum. Page generated in 0.04556 seconds