BEx formatting VB

[Former Member]

Friends,

We have a couple of BEx formatting issues :

One of the issues we have is with drilling down in a structure without repeating the output. Specifically, I have a query with a structure consisting of various selections of g/l accounts, cost element groups, center groups and formulas summarizing these various accounts represented in each row of the structure. I have also added g/l account, cost elements and cost centers as a free characteristic so that I can drill down on that in order to see values on particular accounts, if needed.

The visual representation of this report is not acceptable to our client. Since there are formulas in the left column, the drilldown on accounts (in the right column) repeats all accounts on the summary level (which is natural when you think about it). However, this makes it hard for the end user to get an overview and the report output is substantial. We would rather have a drilldown in the structure itself, with totals on the highest levels, so that we do not get forced to drill down on both g/l account group level (or cost element or cost center) and summary level (summary of account groups).

Secondly, in this same structure, in some rows the drilldown detail of g/l accounts are relevant and in others the cost center or cost elements are relevant. We would like to see the appropriate relevant group for each row of the structure. Again, with a drill down on a structure, the display shows the drilldown for every row.

Appreciate you help!

Thanks

[Former Member · Accepted solution]

Rian,

Try supress zero rows, so you dont get extra rows in the query. The other issue you experience is part of using structures. Try to arrange Parent/Child nodes within your structure. This way you can expand or collapse any section without affecting all rows. Also since u are using GL account, try to use GL Account as a free characteristic and activate the hierarchy in conjunction with your structure. This helps with expand/collapse capabilities in your query.

Cheers!

[Former Member · Accepted solution]

Thanq Mike,

I did these. My issue is I have a structure

Example:

When we drilldown on the structure to see G/L Account and/or Sub Account (or any characteristic), the results are repeated for each row (Which is understandable). They do not want see the detail for every row in the structure because some are calculations. <b>Where there are calculations on the row structure, they just want to see the calculation total</b>.

The second issue is that some of the rows would require drilldown by cost center or some other element and we would not want to see the other drilldown characteristics (g/l account, Sub Account, etc.) on these select rows.

Is there a Visual Basic Solution for this...

Please help...