BPC 7.5 sp8 Microsoft - Error processing Dimension(connection cannot be used...)

[Former Member]

Hi Guys

where Processing a a Dimension I get the error below.

  - The connection cannot be used to perform this operation. It is either closed or invalid in this context. in:

SELECT DimName, DimCaption, EVDimType, HIR FROM tblDimension WHERE CubeName=N'Carbon'(K2logic)

Regards

Sisa

[former_member186498]

Hi Sisa,

there is a problem with your server connection,

• close\open admin console and retry to process the dim
• try to process the dimension and the application in SSAS
• check if you have a wrong port for the SQL instance
• verify that the Server Options in BPC Server Manager and the values in tbldefaults are the same
• try resetting Login Credentials, see please http://service.sap.com/sap/support/notes/1102054

Regards

     Roberto