|
|
| Re: Accumulations in CrossTabs 2 [message #692132 is a reply to message #691839] |
Sun, 03 July 2011 17:03   |
|
Marco,
I am pretty certain this is correct. I converted your example to a
rptdesign and a csv file for a starting point. Can you have a look at
it to see what needs to change?
Jason
On 7/2/2011 10:31 AM, Marco wrote:
> One fundamental problem seems to be that I cannot aggregate on cube
> dimensions if they are not also dimensions of the crosstab, right?
>
Attachment: example.zip
(Size: 3.69KB, Downloaded 148 times)
|
|
|
| Re: Accumulations in CrossTabs 2 [message #692133 is a reply to message #692132] |
Sun, 03 July 2011 17:04 |
|
BTW you will need to change the location of the csv file in the data source.
Jason
On 7/3/2011 1:03 PM, Jason Weathersby wrote:
> Marco,
>
> I am pretty certain this is correct. I converted your example to a
> rptdesign and a csv file for a starting point. Can you have a look at it
> to see what needs to change?
>
> Jason
>
> On 7/2/2011 10:31 AM, Marco wrote:
>> One fundamental problem seems to be that I cannot aggregate on cube
>> dimensions if they are not also dimensions of the crosstab, right?
>>
>
|
|
|
|
| Re: Accumulations in CrossTabs 2 [message #693056 is a reply to message #692149] |
Tue, 05 July 2011 17:18 |
|
Marco,
Look at the revised example. Specifically look at the filters on the
expressions. Is this what you want?
Jason
On 7/3/2011 2:06 PM, Marco wrote:
> Jason,
>
> Thanks a lot for your example. Now I can better explain what I want.
>
> <D2-1 D3L1-1 D3L2-1 M D1 D2 last> should be 4 because there are 12 rows
> for this criteria:
> 2000 1 1 1 D2-1 D3L1-1 D3L2-1 D4-1 1 1 1
> 2000 1 1 2 D2-1 D3L1-1 D3L2-1 D4-1 2 2 1
> 2000 1 1 3 D2-1 D3L1-1 D3L2-1 D4-1 4 3 1
> 2000 1 1 1 D2-1 D3L1-1 D3L2-2 D4-1 1 1 3
> 2000 1 1 2 D2-1 D3L1-1 D3L2-2 D4-1 2 2 3
> 2000 1 1 3 D2-1 D3L1-1 D3L2-2 D4-1 4 3 3
> 2000 1 1 1 D2-1 D3L1-1 D3L2-1 D4-2 1 1 1
> 2000 1 1 2 D2-1 D3L1-1 D3L2-1 D4-2 2 2 1
> 2000 1 1 3 D2-1 D3L1-1 D3L2-1 D4-2 4 3 1
> 2000 1 1 1 D2-1 D3L1-1 D3L2-2 D4-2 1 1 3
> 2000 1 1 2 D2-1 D3L1-1 D3L2-2 D4-2 2 2 3
> 2000 1 1 3 D2-1 D3L1-1 D3L2-2 D4-2 4 3 3
>
> And it should not sum it up but take the last for Dim1 which is 4 no
> matter what Dim3 and Dim4 are. Dim 3 and Dim4 are irrelevant, so just
> take any one of this 4. So it should ignore all duplicates which just
> differ outside of the criteria (Dim1 and Dim2), and take last instead of
> sum. It seems that your implementation ignores Dim3 or Dim4 instead of
> both.
>
> <D2-1 D3L1-1 D3L2-1 M D1 D2 agg> should be 6 because there are the same
> 12 rows, and it should just take the first 3 rows as the other 9 rows
> are duplicates within the criteria. Here it should be summed up over
> Dim1 which makes 6. So again it should ignore duplicates which just
> differ outside of the criteria.
>
> <D2-1 D3L1-1 D3L2-1 M D2 D3 agg> should be 3 because there are 6 rows
> matching the criteria:
> 2000 1 1 1 D2-1 D3L1-1 D3L2-1 D4-1 1 1 1
> 2000 1 1 2 D2-1 D3L1-1 D3L2-1 D4-1 2 2 1
> 2000 1 1 3 D2-1 D3L1-1 D3L2-1 D4-1 4 3 1
> 2000 1 1 1 D2-1 D3L1-1 D3L2-1 D4-2 1 1 1
> 2000 1 1 2 D2-1 D3L1-1 D3L2-1 D4-2 2 2 1
> 2000 1 1 3 D2-1 D3L1-1 D3L2-1 D4-2 4 3 1
>
> Again the second 3 are just duplicates to the first 3 as they just
> differ in Dim4 which is to be ignored. So the first three are to be
> taken and summed up over Dim1 which makes 3.
>
> My requirements might look strange. But this is really what I need.
>
> It would be great if you help me further.
>
> Thanks,
> Marco
|
|
|
|
| Re: Accumulations in CrossTabs 2 [message #694587 is a reply to message #694381] |
Fri, 08 July 2011 22:22 |
|
Marco,
You could change the expression based on parameter etc. It would depend
on where you want that value to come from.
Jason
On 7/8/2011 9:11 AM, Marco wrote:
> Jason,
>
> Your approach to filter on specific values does not work for a few
> reasons. The main one is that I do not know the specific values when
> creating the design, and they may change.
>
> Can I setup filters in a generic way to select just one row per distinct
> value of a dimension?
>
> Thanks,
> Marco
|
|
|
Powered by
FUDForum. Page generated in 0.02529 seconds
] 
Search
Help
Register
Login
Home
