If you are unable to create a new account, please email support@bspsoftware.com

 

FM create detail filter with parameter which will be provided in Report Studio

Started by sandippk, 01 Jan 2016 08:13:12 AM

Previous topic - Next topic

sandippk

Dear All,

I am trying to create below detail filter on query subject in Framework manager:

[BUSINESS VIEW].[T_Status].[DISPLAY_DATE] in_range ?Date_Range?. I have marked the usage of this filter as ALWAYS.

The Date_Range is the parameter whose value will be provided while running the report i.e. through date range prompt.  Please note Date_Range variable is assigned to data range prompt created on prompt page using report studio.

When I am trying to validate this Query subject with the filter, it gives an error :

XQE-QRY-0404 There are parameters or variables that require values. Also query subject is marked as broken.

1) Any idea why I am getting this error
2) Is it possible to create a filter with parameter in FM whose value will be provided during Report execution ?

Happy New Year.

Thanks
SK

MFGF

Quote from: sandippk on 01 Jan 2016 08:13:12 AM
Dear All,

I am trying to create below detail filter on query subject in Framework manager:

[BUSINESS VIEW].[T_Status].[DISPLAY_DATE] in_range ?Date_Range?. I have marked the usage of this filter as ALWAYS.

The Date_Range is the parameter whose value will be provided while running the report i.e. through date range prompt.  Please note Date_Range variable is assigned to data range prompt created on prompt page using report studio.

When I am trying to validate this Query subject with the filter, it gives an error :

XQE-QRY-0404 There are parameters or variables that require values. Also query subject is marked as broken.

1) Any idea why I am getting this error
2) Is it possible to create a filter with parameter in FM whose value will be provided during Report execution ?

Happy New Year.

Thanks
SK

Spooky! I got asked the exact same question by a colleague this morning! The answer is yes - it should work, and it does for me in my Cognos 10.2.2 instance. What version of Cognos 8 are you using?

What format are you entering your dates in? Are they dates or dates with time?

You could try substituting the ?Date_Range? parameter for a prompt macro, eg:

[BUSINESS VIEW].[T_Status].[DISPLAY_DATE] in_range { #substitute(',',':',promptmany('Date_Range','date','2015-01-01,2015-02-01'))# }

Cheers!

MF.
Meep!