Skip to Content
Former Member
Nov 18, 2016 at 04:33 AM

Save 2 Input ready queries built on the same aggregation level

87 Views Last edit Nov 23, 2016 at 08:20 AM 2 rev

Hello experts,

I have the following scenario.

I have built a DSO on which one Aggregation level is built.

On top of this, i created two different filters for different primary key values, and built two queries, each using a different filter.

The queries are input ready, and now I consume them in Analysis for Office.

I have added both the queries on the same sheet in the workbook.

When I edit a value in query and save it, it works fine. When i edit a value on the other query and save it, it works fine.

But when i try to edit values in both the queries, and then click on save, the value in query two is getting saved incorrect. It is taking only the delta value.


Query 1 - current value 100, input value 200

Query 2 - current value 150 input value 250

Now after save, the queries appear as below.

Query 1 - current value 200

Query 2 - current value 100

I tried to use recalculate after in enter the value in Query 1, then edit Query 2, and click on recalculate again, and then save. Even then the problem persists.

Is there any way I can solve this issue?