Print Page - OP-ERR-0181 / How to return empty data set

Title: OP-ERR-0181 / How to return empty data set
Post by: gagnonp on 30 Oct 2013 09:48:48 AM

I'm using the following slicer in a OLAP based report: #prompt('Project','token','')#

The Project parameter contains somehting like: [PP_F202 E].[All Projects].[All Projects].[Project Code]->:[PC].[@MEMBER].[JA53]

Sometimes, the Project mun does not exist in the cube therefore we get the OP-ERR-0181 error. (The Project parameter is built with a string manipulation from an 'injected' SQL relational query to retrieve the user's preferred Project Numbers.)

Is it possible to change the slicer so it returns an empty dataset when a MUN does not exist?

I tried the filter function but cannot get it to work syntax-wise.

Title: Re: OP-ERR-0181 / How to return empty data set
Post by: gagnonp on 01 Nov 2013 08:28:36 AM

Anyone?

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: gagnonp on 30 Oct 2013 09:48:48 AM