Skip to Content
0

BRAIN 109 in Analysis for Office 2.3

Apr 07, 2017 at 07:27 AM

148

avatar image

Hi,

we have a problem in development system after transporting an Analysis Workbook.

After opening we get the message "No data was found that meets the used conditions" and "Notification Number BRAIN 109".

When opening in RSRT the query works fine, also when I insert the query in a new empty sheet / workbook. So the query could not be the problem. In test system the workbook is also working fine.

Any ideas?

Thanks in advance and regards,

Andreas

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

5 Answers

Tammy Powlas
Apr 07, 2017 at 08:54 AM
0

Hello Andreas - it sounds like a BW error message; on the BW back end, is there a short dump (transaction ST22)?

Please also see SAP note: https://launchpad.support.sap.com/#/notes/2246733/E

Share
10 |10000 characters needed characters left characters exceeded
Andreas Schindler Apr 07, 2017 at 09:22 AM
0

Hello Tammy,

at first many thanks for your fast answer!

We are on Rel. 7.4 with SP15, so I think the note does not help.

I have checked ST22 and SM21, here I cannot find a dump or error message.

In my mind it could be the case the there are diffrent server components in the system for the Analysis installation. But I do not know how to check without basis people. Do you know a way for this?

Thanks in advance for other ideas and further help.

Regards,

Andreas

Share
10 |10000 characters needed characters left characters exceeded
Andreas Schindler Apr 07, 2017 at 11:03 AM
0

An additional information: we are using NetWeaver BW without BI Platform.

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

Hi Andreas - thank you for the detailed information. So far I can find this wiki: https://wiki.scn.sap.com/wiki/display/BI/OT-OLAP-CBA

In terms of server components, can I assume you are using the Analysis Office front end with NetWeaver? Nothing else installed on the BI platform? Also what version of Excel are you using?

Another idea is to turn on profiling for Analysis Office https://blogs.sap.com/2016/08/25/check-profiling-statistics-in-analysis-for-office-to-improve-performance/ not so much for performance but perhaps a way to see where the problem occurs

0
Gregor Horvath Apr 12, 2017 at 12:51 PM
0

Have you checked whether some filters are active in the workbook?

I somehow remember that errormessage.....I had then another filtervalue active....

regards

Greg

Share
10 |10000 characters needed characters left characters exceeded
Andreas Schindler Apr 18, 2017 at 04:03 AM
0

Thanks for your help, we have opened a SAP OSS message. If we found a solution I will update.

Share
10 |10000 characters needed characters left characters exceeded