Question:
Hi All,
When I execute a query I am getting this msg always.
"Warning - Callculated result as...was not executed"
Please tell me how to resolve it.
Thanks
Manju
Answer:
if you double click on the message, you probably get more info... Pls share it.
Answer:
Hi,
Yes, here the detailed msg
The Function Calculated result as...can't be executed along a hierarchy axis. In other words, atleast one characteristics of the axis bears a presentation hierarchy or the whole axis is represented as a hierarchy. In accordance with the logic of this function, the hierarchy thus needs to be fully expanded. However, this contradicts the princple that only displayed values can be used in the calculation
.......................
Can you give me some tips to resolve this issue,
Thanks
Manju
Answer:
Apparently you have defined a special 'calculate result as' which is not working together with the hierarchy in you query.
I think there was an OSS note explaining this issue more in detail (but if i remember well, there was no real solution for it).
So, search OSS with some of the keywords or maybe the long message you just posted also contains the techincal ID of the error message (possibly something beginning with BRAIN...). If you ahve this message ID, use this to search OSS and you should find it right away