mdx in mdxlib

[#1]

I am starting out in BPC. I have a simple function called

extic. I call this function in "formula" property of Account member "EXTICSALES".

The syntax for calling function is extic()

I dont have arguments for the function.

The formula is just an addition of 2 accounts. Since I want to standardize this function I want to have in MDXLIB.

Actual Syntax is as follows.

*Function EXTIC

[ACCOUNTDIM].[EXTICSales]=[ACCOUNTDIM].[ExtSales] + [ACCOUNTDIM].[ICSales]

*ENDFUNCTION

Error Msg below. when I process dimension.

- Formula error - syntax error - token is not valid: " [ACCOUNT].[EXTICSALES]=^{[ACCOUNT].[EXTSALES]} + [ACCOUNT].[ICSALES]()"

Now the next question I have is in my syntax should I say Accountdim or Account.

Edited by: jack johnson on Aug 6, 2008 1:25 AM

[Former Member]

I think I made some mistakes in repeating the same syntax we use in the dimension spreadsheets in the mdxlib.

Used functions with arguments.