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

Why the slicer wont work but Data Item's expression does

Started by _jl_, 03 Jul 2013 04:11:33 AM

Previous topic - Next topic

_jl_

Hi,

Just wondering. I have a prompt page in which I have query to receive years. By default there were years showing up from 2012 to 2016. So I tried to Slice the year data item. Drag the "Year" item to Slicer and set an expression:

periodsToDate([cubeName].[Date].[Date].[Date], #'[cubeName].[Date].[Date].[Year]->:[PC].[@MEMBER].['+timestampMask($current_timestamp,'yyyy')+'0101-'+timestampMask($current_timestamp,'yyyy')+'1231]'#)
-> Didn't have any effect.

Then removed the slicer and set the exact same expression for the "Year" at the properties pane. -> Working fine by now. Gives me only choises for 2012 and 2013. Just wondering why this works and the slicer doesn't??

BR,
jl