Skip to Content
0

AO 2.4 - Measures filters not maintained after refresh

Sep 21, 2017 at 09:01 AM

56

avatar image
Former Member

Unlike Dimensions, filters applied on Measures will disappear once prompts refresh takes place. This badly affects the nice feature of having your local customized copy of AO for excel so once you open it and hit refresh Measures filters will be cleared. This might be an expected behavior as previous post suggests but is there any way to solve this?

I am using 2.4 SP4

Thank you

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Tammy Powlas
Sep 21, 2017 at 09:01 AM
0

Hi Marc - I wonder if you could put some formulas on the measure filters, and then see if that is maintained after the refresh?

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Tammy, so after looking into my answer below, is there a possible solution or I just need to live with that ?

0
avatar image
Former Member Sep 21, 2017 at 04:05 PM
0

Hi Tammy, thanks for the quick response.

I have tried adding a dynamic calculation to the Measures filters and it appeared as a separate column and it got maintained successfully after the refresh.

I hope this is what you mean by adding a formula as I am not a technical AO user

Marc

Share
10 |10000 characters needed characters left characters exceeded
Tammy Powlas
Sep 25, 2017 at 04:14 PM
0

Marc - I think it is a good solution; I am not sure what else you are looking for?

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Sep 26, 2017 at 10:56 PM
0

Hi Tammy, yes it's a good solution however if we add a dynamic calculation to one or more of our measures in the BEx query designer the problem remains when refreshing prompt values and It works fine with Refresh ALL. If we add a dynamic calculation manually as a new measure we get no issues.

Do you have any suggestions that can be applied in the query designer ?

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Sep 28, 2017 at 05:22 PM
0

Hi Tammy - I really appreciate a quick response on this as we're going live very soon

Share
10 |10000 characters needed characters left characters exceeded