In order to create YTD functionality in a subject area based on an Essbase cube I used the following formula in the business layer, exposing it in the presentation layer as normal; -
evaluate('Y-T-D(%1)',"myserver"."myApplication".""."myDb"."Period - Default")
When I try to use this in answers I get the following error; -
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 12002] Socket communication error at call=recv: (Number=10054) An existing connection was forcibly closed by the remote host. (HY000)
Anyone tell me where I am going wrong?