Skip to Content
0
Former Member
May 29, 2008 at 01:22 AM

Suppressing hierarchy drill down of structure formulas

363 Views

Hi Experts,

Here's the situation. In BEx query designer in the rows section, we have created a structure (without key figures) whose selections are filtered on certain nodes of 0GL_ACCOUNT hierarchy. Within that structure there are also formulas that are calculations using other selections in the same structure. For example, for Structure A, we have 'Selection 1' restricted on the 'Revenue' node of the Financial Statement hierarchy of 0GL_ACCOUNT. 'Selection 2' is restricted on the 'Expenses' node. Finally, 'Formula 1' is the calculation 'Selection 1 - Selection 2' (Revenue - Expenses).

Below Structure A we also have dragged and dropped 0GL_ACCOUNT (but we do not activate the hierarchy). This is to display all the account details below each Structure selection. However, in the 'Properties' of the 'Row Area', underneath the 'General' tab and 'Display As Hierarchy' option, we check the 'Active' box and choose 'Expand To' = G/L Account. What this does is that it displays the Accounts underneath the Structure selections as it were a hierarchy (even though we do not activate the hiearchy itself for 0GL_ACCOUNT).

The problem is that when we run this query in Excel (or the web), the Formula 1 row also displays the G/L Account details when we do not want it to show the individual accounts. We only want to see the individual accounts for the structure selections 'Revenue' and 'Expense', but we do not want to see the accounts for the Formula. We just want to one row with the total value.

Does anybody know of a way to disable the expanding functionality of the "pseudo-hierarchy" for the Formula 1 within the structure without disabling the expanding/collpasing functionality of the other selections in the structure?

Thanks,

K-D