How Analysis Office 1.3 Works with BEx Query Designer Conditions and Exceptions

Follow RSS feed Like

1 Like 403 Views 0 Comments

Figure 1

Figure 1 shows the BEx Query Designer Exception to show as “bad” if the budget balance is less than zero.

Figure 2

Figure 2 shows BEx Query Designer Conditions to show only the top 6 budget lines.

Now on to Analysis Office 1.3:

Figure 3

In Analysis Office it honors the BEx Query conditions by only showing the top 6 budget lines

Figure 4

Figure 4 shows I can turn off the BEx Conditions using the Filter ribbon

Figure 5

Figure 5 shows that Analysis Office 1.3 honors the BEx Exceptions by highlighting the lines that are over budget.

Notice, however, you cannot edit the Condition in Analysis Office.