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.
Be the first to leave a comment
You must be Logged on to comment or reply to a post.