Skip to Content
Author's profile photo Tammy Powlas

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


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.

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.