COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Arumugam on 09 Mar 2017 12:01:39 AM

Title: Display Quarter section
Post by: Arumugam on 09 Mar 2017 12:01:39 AM
Need a help.My report has cover page at front which needs to show the username and user selected prompt(it is radio button with 3 choices - rolling 13 months,prior QTD & rolling 13 quarters).Rolling 13 months & prior QTD display proper dates at the front page but rolling13 quarters is not displaying..Have used query like this

Data item -
Quarter/Month - (#prompt('pSelect','token','','[Claims - ODS].[Date].[','',']')#)
First member set - roleValue ('_memberDescription',head([Quarter/Month],1))
Last member set - roleValue ('_shortName',tail([Quarter/Month],1))

for rolling 13 months & prior QTD members are defined at first level but for a quarter it is like 2016 Q4 under that 3 months ( oct,nov,dec) is there.will it be a issue?