Skip to Content

Analysis for Office 2.4 error after combing two queries and try to add new lines to the hierarchy

Jul 24, 2017 at 09:35 PM


avatar image

The following issue has bothered me for a while:

I use CDS views and pre-defined financial version to create a query with data in hierarchy format. Say like this one:


Then I created a master query which includes all the available g/l account in the hierarchy:


Then if I want to add new SAP lines underneath hierarchy separately, and let the new added lines empty cell equals to data within the hierarchy, both of them works fine.

However, after combining the two queries like the following shown:


Now if I want to add new lines, it has two cases:

1. the added new line can be equal to data I selected within the hierarchy, however, after refresh or change the name of this line first column, the data which I assigned to that new line will automatically disappears

2. when I try to let the new line cell equals to one of the cell or add random numbers in the cell, it will pop up an error like this:


Does anyone have any clue on how to solve this issue? This is very urgent.

Thank you!

10 |10000 characters needed characters left characters exceeded

On your last screen shot, what is in the "folder log file" button - can you share what is there when you click it?

* Please Login or Register to Answer, Follow or Comment.

1 Answer

Tammy Powlas
Jul 25, 2017 at 09:33 AM

Hi - I also found this SAP note - - it says there is a program error in 2.4 SP3 and to download SP4 - can you download SP4 and try again?

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Tammy, thanks for getting back to me. I checked the official SAP Analysis for Office software pack, I believe SP4 has not been released yet.

Please feel free to share more thoughts if you can. Thanks again!


You're right; it looks like it won't be available until August 7th - I think your fix will be in that SP