If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to implement an MDX query in report studio

Started by sg, 21 Jul 2009 08:59:51 AM

Previous topic - Next topic

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:

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