I am trying to write a report that shows duplicates. I have the query and it works outside of BusinessObjects but when I run it in BO, the duplicates are aggregated on the report. When I view the raw data, I see the duplicate lines. I looked in HELP and it said that there was an option to select to avoid duplicate row aggregation. I have looked in TOOLS/OPTIONS for the report and in FILE/PARAMETERS and TOOLS/OPTIONS for the universe but cannot find this option.
Does anyone know where I can find it??
Go into the Query Panel. Bottom Left hand corner there is an Options Button. There it allows you to restrict or not to restrict duplicate rows.
DebraAnn Braun
BusinessObjects Developer
Frito-Lay, Inc.
I am trying to write a report that shows duplicates. I have the query and it works outside of BusinessObjects but when I run it in BO, the duplicates are aggregated on the report. When I view the raw data, I see the duplicate lines. I looked in HELP and it said that there was an option to select to avoid duplicate row aggregation. I have looked in TOOLS/OPTIONS for the report and in FILE/PARAMETERS and TOOLS/OPTIONS for the universe but cannot find this option.
Does anyone know where I can find it??
Thanks
Judith Dotson
1 Select the entire table and right click. 2 Select Format Table and under the General settings turn on the check box preceding Avoid Duplicate Rows Aggregation.
George Baranowski
QuadraMed
I am trying to write a report that shows duplicates. I have the query and it works outside of BusinessObjects but when I run it in BO, the duplicates are aggregated on the report. When I view the raw data, I see the duplicate lines. I looked in HELP and it said that there was an option to select to avoid duplicate row aggregation. I have looked in TOOLS/OPTIONS for the report and in FILE/PARAMETERS and TOOLS/OPTIONS for the universe but cannot find this option.
Does anyone know where I can find it??
What DebraAnn suggested will work to restrict the duplicates in the raw data…but since you WANT the duplicates (and BO provides them by default) what I think you are asking for is how to avoid aggregation of those duplicates in the report. To do this:
With your block highlighted, select FORMAT, TABLE (or crosstab, depending which you have)
On the ‘General’ Tab, there is an option to ‘Avoid Duplicate Row Aggregation’. Enable the option and exit.
I’ve had several instances of users complaining that BusinessObjects is
“hiding data” from them by using its auto-aggregation feature. Is there any
other way to get duplicate rows to appear within a table without having to
click on the table and select “Avoid Duplicate Rows Aggregation”? I’m
basically looking for a way to leave this non-aggregation feature turned on by
default instead of having to tell my users that they need to make sure they
click on every table they create. I haven’t seen anything in the Supervisor
of Designer pieces that would set that feature.
Recently I have had user complaints about BusinessObjects hiding the true
totals from them. Although I have re-iterated many times that they need to
click on “Avoid Duplicate Rows Aggregation” to show all of the rows, I still
keep encountering these problems. Is there any way through the Supervisor or
Designer to default the report to always show duplicates instead of the other
way around? It seems dangerous that BusinessObjects would automatically
aggregate and not show the full result set by default.
One method that people use is to create 2 objects out of each measure. For
example, if you create a dimension object out of Quantity and a measure
object out of Quantity, then you have some nice options. If your users
choose the dimension, then nothing aggregates. If they choose the measure,
then they get the aggregation.
I’ve had several instances of users complaining that BusinessObjects is
“hiding data” from them by using its auto-aggregation feature. Is there any
other way to get duplicate rows to appear within a table without having to
click on the table and select “Avoid Duplicate Rows Aggregation”? I’m
basically looking for a way to leave this non-aggregation feature turned on by
default instead of having to tell my users that they need to make sure they
click on every table they create. I haven’t seen anything in the Supervisor
of Designer pieces that would set that feature.
If one of your objects is a measure, set it to ‘None’ aggregation in the
Properties tab of the object properties dialog in Designer. Drawback is that
if the user wants aggregated data after all, (s)he’ll have to create a new
variable in reporter, identical to the measure but with aggregation switched on.
You could indeed deal with this by defining two objects in the universe for the
same measure: one with aggregation, the other without.
If none of the objects is a measure, then aggregation should not occur
automatically.
mirko.
Recently I have had user complaints about BusinessObjects hiding the true
totals from them. Although I have re-iterated many times that they need to
click on “Avoid Duplicate Rows Aggregation” to show all of the rows, I still
keep encountering these problems. Is there any way through the Supervisor or
Designer to default the report to always show duplicates instead of the other
way around? It seems dangerous that BusinessObjects would automatically
aggregate and not show the full result set by default.
Greg,
Another option is to create a ‘Default’ template that has the ‘Avoid
Duplicate Rows Aggregation’ Display checked. Then have have the users under
the ‘New Document’ Options, use that ‘Default’ template each time a new
report is created (See ‘Tools’, ‘Options’, ‘New Document’). That way by
default the report they start with will not have the duplicate rows hidden.
Hi Listers,
Can we set ‘No duplicate rows’ option as default for all BO PC Client Users ? In addition to this for WebI252 too we need the equivalent option as ‘Avoid Duplicate rows aggregation’ parameter set to ‘Yes’
by default . We are having a shared BO502 installation .All suggestions are welcome …