Hi - Apologies for the basic question. I am learning Business Objects and am looking to put together a report from a query with SKU number and SKU description. This is from the e-fashion Webi universe. I want to apply a count to SKU number but for some reason it will not work. Why would this be? Count works in my other reports.
Thanks
compilersaysyes (BOB member since 2014-10-02)
If you can be more descriptive about “it does not work” we may be able help, is it bringing back results or not is the figures wrong etc.
BarkyBaloo (BOB member since 2007-07-04)
Sorry. It is not bringing back results. 211 should appear at the bottom Count:211 but it does not, although when I R-click the column, insert and count, the timeout clock appears as if it is performing the calculation but then when I scroll down “Count 211” line is not there.
Thank you again.
compilersaysyes (BOB member since 2014-10-02)
Also, I have changed the query to one that would bring up a significantly lower number of results (8). When I run could then, it appears.
However for two other queries with 203 and 211 records, it count does not appear.
compilersaysyes (BOB member since 2014-10-02)
That was meant to be 8, apologies.
counting 8 results works
counting 211 does not (no count appears on the page)
compilersaysyes (BOB member since 2014-10-02)
Are you sure you are on the final page?
Testing it produces 3 pages the count exists at the very end of the column on the last page
BarkyBaloo (BOB member since 2007-07-04)
Ah yes I did not see that it went to page three!
Thank you so much and sorry for such a newbie question.
Best
compilersaysyes (BOB member since 2014-10-02)
always a pleasure
BarkyBaloo (BOB member since 2007-07-04)
HI
USE COUNT([DIMENSION];ALL) IT WORKS
arun pandey (BOB member since 2015-04-05)