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

date format

Started by shivani_cog, 07 Dec 2011 11:35:45 AM

Previous topic - Next topic

shivani_cog

Week of the year = [Sales].[Time].[Date].[Week].[Week of the Year]
Week Number = CASE WHEN
(?time_range?='Begin & End Date') AND
( ([Sales].[Time].[Date].[Date].[Date]) between ?Begin_date? AND ?end_date?) 
THEN ([week of the year])
ELSE 0
END
Error : Incompatible data types in case statement.
how do I fix it ?

MFGF

By the looks of things, Week of the year is a MUN pointing to a specific member in your cube? If this is the case, you are using a different data type altogether when you try to substitute the integer 0 into your expression with the case statement.

Regards,

MF


Snet form my fumblefingers
iPhon 5 usig Tapatalk
Meep!

shivani_cog

Hi MFGF,
Thanks for your answer.
Where do I put 0?

HalfBloodPrince

#3
Instead of 0  try to return  null or just put ''