Skip to Content

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

/wp-content/uploads/2012/07/1fig_124200.png

Figure 1

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

/wp-content/uploads/2012/07/2fig_124201.png

Figure 2

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

Now on to Analysis Office 1.3:

/wp-content/uploads/2012/07/3fig_124232.png

Figure 3

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

/wp-content/uploads/2012/07/4fig_124233.png

Figure 4

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

/wp-content/uploads/2012/07/5fig_124234.png

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.

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