Hi all
I have a report that look like this : (this is an example)
Date Product-Id Sales
1998-12-01 1 14
1998-12-01 2 22
1998-12-02 1 8
1998-12-02 2 6
And I would like to have it displayed like this :
Sales / Date
Product-ID 1998-12-01 1998-02-02
Listserv Archives (BOB member since 2002-06-25)
You could just put max(sales) instead of sales Or you could insert a break on product id and then drag and drop everything into the summary line - after that do a fold …
Martin Lidl
Consultant
KPN-Orange
e-mail: martin.lidl@orange.be
“Normal is the average of extremes”
pher@ROYAL.NET on 17/12/98 10:36:46
Please respond to Business Objects Query Tool BUSOB-L@LISTSERV.AOL.COM
cc: (bcc: Martin Lidl/IT/Kpn-Orange)
And I would like to have it displayed like this :
Sales / Date
Product-ID 1998-12-01 1998-02-02
Listserv Archives (BOB member since 2002-06-25)
Thank you for this answer. But my report is exactly the following :
Nr Date Difference
15302.00 1.11.1998 29.00
15302.00 2.11.1998 19.00
15303.00 1.11.1998 61.00
15303.00 2.11.1998 -4.00
Then I insert a crosstab as explained in the manual, but instead of getting
1.11.1998 2.11.1998
15302.00 29.00 19.00
15303.00 61.00 -4.00
I get
1.11.1998 2.11.1998
15302.00 29.00
15302.00 19.00
15303.00 61.00
15303.00 -4.00
Note that this is Ok with the Island Resort universe
Where is there something wrong ???
Pierrot
You could just put max(sales) instead of sales Or you could insert a break on product id and then drag and drop everything into the summary line - after that do a fold …
Listserv Archives (BOB member since 2002-06-25)
Doesn’t it even work if you insert a break on Nr. so that you get a summary line and then COPY (not move) the Difference in the summary line? After that do a fold on the Break ??
If that does not work I am really confused …
Berst Regards Martin
pher@ROYAL.NET on 17/12/98 13:12:01
Please respond to Business Objects Query Tool BUSOB-L@LISTSERV.AOL.COM
cc: (bcc: Martin Lidl/IT/Kpn-Orange)
Thank you for this answer. But my report is exactly the following :
Nr Date Difference
15302.00 1.11.1998 29.00
15302.00 2.11.1998 19.00
15303.00 1.11.1998 61.00
15303.00 2.11.1998 -4.00
Then I insert a crosstab as explained in the manual, but instead of getting
1.11.1998 2.11.1998
15302.00 29.00 19.00
15303.00 61.00 -4.00
I get
1.11.1998 2.11.1998
15302.00 29.00
15302.00 19.00
15303.00 61.00
15303.00 -4.00
Note that this is Ok with the Island Resort universe
Where is there something wrong ???
Pierrot
You could just put max(sales) instead of sales Or you could insert a break on product id and then drag and drop
everything
into the summary line - after that do a fold …
Listserv Archives (BOB member since 2002-06-25)
Pierrot,
Try adding an In statement to the body of the crosstab. Select the body and Edit formula - add to the measure In (, ).
HTH!
Sue
Business Objects Consultant
I get
1.11.1998 2.11.1998
15302.00 29.00
15302.00 19.00
15303.00 61.00
15303.00 -4.00
Note that this is Ok with the Island Resort universe
Where is there something wrong ???
Pierrot
Listserv Archives (BOB member since 2002-06-25)
The easy way is just to click on the edit break, and then remove duplicates.
Cheers
Listserv Archives (BOB member since 2002-06-25)
I found where the problem was : the Object we used in the body of the crosstab was a Detail, not a measure.
I redefined it to a measure with a max aggregation function and it works fine now.
Thanks alot anyway for having taken time to look at my problem
Pierrot
At 17.12.98 13:36, you wrote:
Doesn’t it even work if you insert a break on Nr. so that you get a summary line and then COPY (not move) the Difference in the summary line? After that do a fold on the Break ??
If that does not work I am really confused …
Berst Regards Martin
pher@ROYAL.NET on 17/12/98 13:12:01
Please respond to Business Objects Query Tool BUSOB-L@LISTSERV.AOL.COM
cc: (bcc: Martin Lidl/IT/Kpn-Orange)
Thank you for this answer. But my report is exactly the following :
Nr Date Difference
15302.00 1.11.1998 29.00
15302.00 2.11.1998 19.00
15303.00 1.11.1998 61.00
15303.00 2.11.1998 -4.00
Then I insert a crosstab as explained in the manual, but instead of getting
1.11.1998 2.11.1998
15302.00 29.00 19.00
15303.00 61.00 -4.00
I get
1.11.1998 2.11.1998
15302.00 29.00
15302.00 19.00
15303.00 61.00
15303.00 -4.00
Note that this is Ok with the Island Resort universe
Where is there something wrong ???
Pierrot
You could just put max(sales) instead of sales Or you could insert a break on product id and then drag and drop
everything
into the summary line - after that do a fold …
Web archives (9am-5pm ET only): listserv.aol.com/archives/busob-l.html
OR search: Mail to listserv@listserv.aol.com, ‘search a_phrase in BUSOB-L’
Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’
OR search: Mail to listserv@listserv.aol.com, ‘search a_phrase in BUSOB-L’ Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’
Listserv Archives (BOB member since 2002-06-25)
pher@ROYAL.NET wrote:
Thank you for this answer. But my report is exactly the following :
Nr Date Difference
15302.00 1.11.1998 29.00
15302.00 2.11.1998 19.00
15303.00 1.11.1998 61.00
15303.00 2.11.1998 -4.00
Then I insert a crosstab as explained in the manual, but instead of getting
1.11.1998 2.11.1998
15302.00 29.00 19.00
15303.00 61.00 -4.00
Hello Pierrot,
most probably the problem is with the definition of your sales objects. You should
look how it’s defined in your universe.
under the object properties you should choose an aggregation function other than none.
Desiree
Listserv Archives (BOB member since 2002-06-25)
Check if your dates are not masked timestamps. I mean, BO can display them as dates, but the data itself may include hours and minutes etc. (but formatted as a date).
In that case, the behaviour is normal because two seemingly equal date can mask different underlying values.
Hope this does it,
Diederik
Listserv Archives (BOB member since 2002-06-25)
pher@ROYAL.NET wrote:
Hi all
I have a report that look like this : (this is an example)
Date Product-Id Sales
1998-12-01 1 14
1998-12-01 2 22
1998-12-02 1 8
1998-12-02 2 6
And I would like to have it displayed like this :
Sales / Date
Product-ID 1998-12-01 1998-02-02
2 22 6
I don’t find how to do it, because BO always displays 4 lines instead of 2. I of course tried the ovbious : breaks, variables formulas, folding …
It seems as if your “Sales” is not an aggregatable measure (check in designer, in the object properties/advanced(?) tab for an aggregation function when projecting…) this should be the sum function in your case…
The other thing you can do is: use “sum(Sales)” in the crosstab cell instead of simply “Sales”…
DI Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna / Austria Tel: +43-1-8151456-12, Fax: +43-1-8151456-21 e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at
Listserv Archives (BOB member since 2002-06-25)
Comments: RFC822 error: MESSAGE-ID field duplicated. Last occurrence
was retained.
I have a report that look like this : (this is an example)
Date Product-Id Sales
1998-12-01 1 14
1998-12-01 2 22
1998-12-02 1 8
1998-12-02 2 6
And I would like to have it displayed like this :
Sales / Date
Product-ID 1998-12-01 1998-02-02
2 22 6
I don’t find how to do it, because BO always displays 4 lines instead of 2. I of course tried the ovbious : breaks, variables formulas, folding …
It seems as if your “Sales” is not an aggregatable measure (check in designer,
in the object properties/advanced(?) tab for an aggregation function when projecting…) this should be the sum function in your case…
THAT WAS IT ! In our case, Sales was not even a measure, it was a Detail ! The first thing I had done was to redefine it as a measure, but unfortunately (for me) the aggregation was set to ‘none’ although I had wanted ‘max’. Probably a too quick bad mouse movement. I set the measure aggregation to ‘max’ and everything is working fine again.
Thanks to all who answered
Pierrot
Listserv Archives (BOB member since 2002-06-25)