Print Page - How to pick the data form DB from available data

Title: How to pick the data form DB from available data
Post by: inu on 21 Oct 2016 02:34:41 AM

Hi Team,

I am using filter for time as

[Agreement Fact - Monthly].[Time Dimension(Fiscal Calendar)].[Month Key] between #prompt('Par_From_MonthYear', 'token', 'to_char (_add_months(current_date,-7), ''YYYYMM'')')# and #prompt('Par_To_MonthYear', 'token', 'to_char (_add_months(current_date,-5), ''YYYYMM'')')#

I want to use a function or any possible statement in place of current_Date, so that report will fetch the available data by default.

Regards,
Inam

Title: Re: How to pick the data form DB from available data
Post by: BigChris on 25 Oct 2016 02:08:22 AM

I don't understand - what do you want in place of current_date?

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: inu on 21 Oct 2016 02:34:41 AM