Display Result rows and hide Detail rows in a web report !!

[Former Member]

Hi all,

I Want to hide the detail rows and just display the result rows in a web query.

I have Customer and Material in rows and cal keyfig under columns.

Right now i see the output of query like this on web:

Customer| Material | Cal keyfigure

1 | 1 | 10

| 2 | 20

| 3 | 30

Result 60

If i use Material in free characteristics i see the output like this:

Customer Cal keyfigure

1 | X

I want to achieve the following in the web query in the initial display

customer Cal keyfig

1 | 60

and after drilldown on Material it shud look like :

Customer | Material |Cal keyfigure

1 | 1 | 10

| 2 | 20

| 3 | 30

Result | 60

Also this cal keyfigure is based on exception aggr Material

I created a class in SE24 and wrote the following code in the " Characteristic_Cell" Method.Also i used this Class in the web template.

if I_IOBJNM eq 'Material'.

"and" i_is_sum is initial. ** (initial means nt result row)

free C_CELL_CONTENT.

endif.

But still am nt able to get the desired input

Any Valuable suggestions will be greatly appreciated.

Thanks

Doodle

[Former Member · Accepted solution]

One "hack" to get this done is set the total column in BEx to "top left" and use WAD to only show the first column on the web. The result is, you actually produce the total report but the underlying records are hidden from the user.

Procedure:

In BEx:

- Click query properties

- Display Tab

- Set Results Position to "Top/Left"

- Save the BEx query

In WAD for this BEx query

- In the properties tab, select table that the BEx query is associated with

- Click Web Item

- Scroll all the way down

- Set "Data Display from Column" to 1 (should be this by default

- Set "Data Display to Column" to 1 also

This has worked for me for requirements to show totals, average of values where the actual records were not to be shown. Hope this works for you.

Regards,

Petter

Message was edited by: M Petter

[Former Member · Accepted solution]

Peter,

Thansk for the info.

I ahve already done that earlier.It doesnt work out that way for me as i have 5 rows and around 20 columns

I need to manipulate with data at the table level to hide the detail rows for that particular object "Material" using the methods, if i am nt wrong.

-Thanks

Doodle

[Former Member · Accepted solution]

Hi

You have to maniupulate the HTML code using table interface class methods. I have tried with below code and it is hiding detail rows and only shwoing result rows with the same structure of your query.

CAPTION_CELL code

When 'DATAPROVIDER_1'.

If I_X = 1 .

Concatenate C_Cell_content '</td><!--' into C_cell_content.

Endif.

If I_X = 3.

Concatenate '--><td>' C_Cell_content into C_cell_content.

Endif.

Endcase.

CHARACTERISTIC_CELL code

Case N_DATA_PROVIDER_NAME.

When 'DATAPROVIDER_1'.

If I_X = 1 and not C_cell_content is initial and I_IS_SUM ne 'X'.

Concatenate '--><tr><td class=SAPBEXstdItem>' C_Cell_content

'</td><!--' into C_cell_content.

Endif.

Endcase.

DATA_CELL code

Case N_DATA_PROVIDER_NAME.

When 'DATAPROVIDER_1'.

If I_IS_SUM = 'X' and I_X = 3.

Concatenate '--><td class="SAPBEXaggData">' C_Cell_content

'</td></tr><!--' into C_cell_content.

Endif.

Endcase.

STRUCTURE_CELL code

Case N_DATA_PROVIDER_NAME.

When 'DATAPROVIDER_1'.

If I_X = 3.

Concatenate '--><td class="SAPBEXstdItem">' C_Cell_content

'</td></tr><!--' into C_cell_content.

Endif.

Endcase.

Hope it helps

MB

[Former Member · Accepted solution]

Hi,

Great piece of advice.

Is there a way to achieve a similar requirement for a chart, meaning to suppress all detail rows and only pass the result row to the chart for display?

Regards,

Xibi

[Former Member · Accepted solution]

Hi Xibi,

There is way to modify the charts programatically .

The following blog explains about using ADOBE FLASh graph. I think you may use use to fulfill requirement.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/142ccc21-0901-0010-6895-9c6...

Regards

MB

[Former Member · Accepted solution]

MB,

Great advice.

Have you done something similar in the past so you can shares your experiences?

Regards,

Xibi

[Former Member · Accepted solution]

Xibi,

I have not worked on the flash graphs.

Regards

MB

[Former Member · Accepted solution]

Hi xibi,

i did something similar, which is sold as product.

please view the following Link for more details.

This stuff is implemented in BW 3.x as normal Web Items. Which means they can be bound to every BW Query and can be easily integrated in to BW Web Application. They support Drill-Down functionality. Also included are Flash Maps with currently 180 Maps, also with drilldown.

<a href="http://www.ibs-solution.de/flash/movie/IBS_Solution_Flash_Charts.html">Flash Movie Proview</a>

Do not hestitate to contact me.

best regards,

Kai

[Former Member · Accepted solution]

Hi!

Very good example, but i have some issue - we are running on BI7.0 NW2004s.

Does anybody know how to set MODIFY_TABLE parameter in new WAD??

best regards,

Dmitry

[Former Member · Accepted solution]

This option is not available in BI 7 WAD. See FAQ secion.

https://websmp206.sap-ag.de/~sapidb/011000358700006960392005E#8