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

Olap Slicer

Started by cognos05, 20 Jul 2020 10:11:17 AM

Previous topic - Next topic

cognos05

Hi ,

This is purely related to olap reporting .

I wanted to add a slicer like ,

if(caption(#prompt('prmagency','mun','[ABC]')#)='Test1')
Then
([Region1])
Else
([Region2])

I am gettign an error

OP -ERR-0233  Slicer member set expression = if rolevalue ('_member caption')
For anything other than a set of members from the datasource ,the results may not be what you expect.

This caption of prompt works fine on a calculation if not used in slicer.

Just trying to understand what i am trying to do wrong here .