Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Accumulations in CrossTabs
Accumulations in CrossTabs [message #691370] Fri, 01 July 2011 06:13 Go to next message
Marco is currently offline Marco
Messages: 216
Registered: August 2009
Senior Member
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

Report message to a moderator

Re: Accumulations in CrossTabs [message #691558 is a reply to message #691370] Fri, 01 July 2011 13:43 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member
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

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: Accumulations in CrossTabs [message #691587 is a reply to message #691370] Fri, 01 July 2011 15:35 Go to previous messageGo to next message
Marco is currently offline Marco
Messages: 216
Registered: August 2009
Senior Member
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

Report message to a moderator

Re: Accumulations in CrossTabs [message #691603 is a reply to message #691587] Fri, 01 July 2011 15:49 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member
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

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: Accumulations in CrossTabs [message #691612 is a reply to message #691603] Fri, 01 July 2011 16:39 Go to previous messageGo to next message
Marco is currently offline Marco
Messages: 216
Registered: August 2009
Senior Member
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

Report message to a moderator

Re: Accumulations in CrossTabs [message #691618 is a reply to message #691612] Fri, 01 July 2011 16:56 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member
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

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: Accumulations in CrossTabs [message #691814 is a reply to message #691618] Sat, 02 July 2011 08:40 Go to previous message
Marco is currently offline Marco
Messages: 216
Registered: August 2009
Senior Member
Jason,

I found this approach to be a dead end anyway.

Please take a look my new thread where I describe my requirements with sample data.

Thanks,
Marco

Report message to a moderator

Previous Topic:how to remove Null Value.
Next Topic:how to set the content of a text element runtime in brit 2.2.1
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 25 02:33:29 EDT 2013

Powered by FUDForum. Page generated in 0.02633 seconds