How to implement an MDX query in report studio

[sg]

Hi,

I have an MDX query which runs fine below.

Select {
ParallelPeriod([Invoice Date].[Fiscal Period].[Fiscal Period],1,
ClosingPeriod([Invoice Date].[Fiscal Period].[Fiscal Period],[Invoice Date].[Fiscal Period].DefaultMember))} on 0
from [TYCO_PA_CUBE]

Now i need to implement the same in an expression in report studio. Please let me know how it is implemented. I tried writing an expression

ClosingPeriod([TYCO_PA_CUBE].[Invoice Date].[Invoice Date.Fiscal Period].[Fiscal Period],[TYCO_PA_CUBE].[Invoice Date].DefaultMember)

but it throws parsing error. Any help in this regard would be appreciated.

Thanks,
Sg

[CognosPaul]

Cognos doesn't use native MDX in queries, you have to write the functions according to the cognos specifications. Try the following:

Code Select Expand

ClosingPeriod([TYCO_PA_CUBE].[Invoice Date].[Invoice Date.Fiscal Period].[Fiscal Period],defaultmember([TYCO_PA_CUBE].[Invoice Date]))