Changes to Query not reflected in views

[Former Member]

We want to use various views off of a 'master' query to publish in our portal. I was working on the assumption that an advantage of the views was that if a change needed to be made it could be made in the query and then all the views off of that query would reflect the change. However I have discovered that some changes made in the query do not get reflected in the views. For example if I change the scaling on a key figure, this change does not get reflected in the views. In one case, as a test, I modified a formula in the query and also changed the scaling. The view reflected the modified calculation but did not reflect the new scale.

Does anyone know how to force these type of changes or is there documentation that at least list those changes made to the query that will not get reflected in the views?

Any help would be appreciated.

Stan Pickford

[Former Member]

Hi Stanley,

You can go to RSRT and regenerate the view. The Problem will be resolved.

[Former Member]

Hi Dinesh,

Thanks for your response. I went to RSRT - Enviornment - Generate Queries Directly and selected the appropriate info provider and executed the transaction and the view that I had created still is not reflecting the changes I made to the query (scaling and number of decimal points displayed. I didn't see anyplace to specifically regenerate a view. Have I missed something here?

Thanks - Stan

[Former Member]

Hi Stan,

Right click on the "properties" in the view. In the "interaction" tab check if you selected the box "return to global definition on refresh".

That may do the trick..

Anil.

[Former Member]

Hi Stan,

in general: Everything which belongs to the query view object won't be overwritten by query changes.

What belongs to the query view object? Basically everything you can change during execution of a query (Dynamic filters, Drill-Down-State, Properties of characteristics, structure elements (keyfigures) and Query-View).

What does not belong the query-view object: Definition of structure elements, Navigation space (characteristics available during runtime), Static filters.

Heike