Getting error on generating MUN

[cognos05]

Hi,

My member unique name for a time period is

[Sales].[Time Period].[Time Period].[Year]->:[PC].[@MEMBER].[20130701-20140630]

I am using below code in the data item expression and its throwing parsing error.
Am I missing some brackets or paranthesis. I dont know to see to what this statement is executed.

(#'[Sales].[Time Period].[Time Period].[Year]->:[PC].[@MEMBER].[timestampMask(_add_years($current_timestamp,-1),'yyyy') + '0701-'+ timestampMask($current_timestamp,'yyyy')+'0630'+ ']'#)

Thanks,
Nithya

[MFGF]

Hi,

My member unique name for a time period is

[Sales].[Time Period].[Time Period].[Year]->:[PC].[@MEMBER].[20130701-20140630]

I am using below code in the data item expression and its throwing parsing error.
Am I missing some brackets or paranthesis. I dont know to see to what this statement is executed.

(#'[Sales].[Time Period].[Time Period].[Year]->:[PC].[@MEMBER].[timestampMask(_add_years($current_timestamp,-1),'yyyy') + '0701-'+ timestampMask($current_timestamp,'yyyy')+'0630'+ ']'#)

Thanks,
Nithya

Hi,

Try this:

#'[Sales].[Time Period].[Time Period].[Year]->:[PC].[@MEMBER].[' + timestampMask(_add_years ($current_timestamp,-1),'yyyy') + '0701-' + timestampMask($current_timestamp,'yyyy') + '0630]'#

Cheers!

MF.

[cognos05]

Yes it worked . Thanks MFGF.

Regards,
Nithya