Hi All, I have an interesting error for you. I am using a third party dll to create a calculated cell in Analysis Services to populate data in a cube. When accessing the cube through the MDX sample application or Analysis Services the results are returned correctly (as demonstrated in mdx_no_err.bmp), but when using a tool that uses xmla to connect to the cube I receive the error: "A user-defined function from interface PowerOLAP is not safe to be called. An error occurred in an attempt to get a cell value", as displayed in the attached image xmla-err.bmp. Any suggestions would be useful for how to ensure that this interface can be made to be "trusted" by xmla. Thanks in advance, Cathie
Hi Cathie, This is because the XMLA SDK is on the middle tier and it doesn't allow unsafe UDFs to be executed... If possible you could make your DLL "safe" by implementing the IObjectSafety interfaces. Thanks, Akshai -- This posting is provided "AS IS" with no warranties, and confers no rights Please do not send email directly to this alias. This alias is for newsgroup purposes only. "Cathie" wrote in message news:uhMY1cbvFHA.3932@TK2MSFTNGP15.phx.gbl... > Hi All, > > I have an interesting error for you. I am using a third party dll to create > a calculated cell in Analysis Services to populate data in a cube. When > accessing the cube through the MDX sample application or Analysis Services > the results are returned correctly (as demonstrated in mdx_no_err.bmp), but > when using a tool that uses xmla to connect to the cube I receive the error: > "A user-defined function from interface PowerOLAP is not safe to be called. > An error occurred in an attempt to get a cell value", as displayed in the > attached image xmla-err.bmp. > > Any suggestions would be useful for how to ensure that this interface can be > made to be "trusted" by xmla. > > Thanks in advance, > Cathie > >
