Skip to Content

Save 2 Input ready queries built on the same aggregation level

Nov 18, 2016 at 04:33 AM


avatar image
Former Member

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?



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

0 Answers