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

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

Started by gagnonp, 30 Oct 2013 09:48:48 AM

Previous topic - Next topic

gagnonp

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.