I create a local cube with the create cube statement. I want to use my own libraries for calculatete measures. I can call vba functions. I want to have somethink like this:
CREATE CUBE myCube (
LEVEL [RD1ALL] TYPE ALL OPTIONS(SORTBYNAME),
MEASURE [ZM1] FUNCTION COUNT FORMAT '#0' ,
COMMAND (USE LIBRARY ""TBLTest.cGlobal"") ,
COMMAND (CREATE MEMBER [myCube].[Measures].ZMCalc1 AS 'TBLTEST!UDFTest(10)'))"
But unfortunately it doesn´t work.
Any Ideas how I can use udfs?