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

Display Quarter section

Started by Arumugam, 09 Mar 2017 12:01:39 AM

Previous topic - Next topic

Arumugam

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?