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

Slicer vs detail filters

Started by oscarca, 05 Feb 2019 04:48:39 AM

Previous topic - Next topic

oscarca

Hello Cognoise,

I have a data item expression that looks like this:
substring(
roleValue('_memberCaption';[General Ledger - Income Statement].[Result division].[Result division].[Result division]);1;1)

which gives me the first letter of all the Result divisions (e.g A, B, C, D).

What I want to do, is to filter this expression, only showing Result division "A" and "D"

One solution I came up with was to put this expression in detail filters:
[Result division] starts with 'A' or [Result division] starts with 'D'

The question is then: Is this possible to achieve this using other filter techniques like slicer or filter function instead ? Since I prefer to not use Detail filters when working with OLAP source. (The report loading time became much longer).

Best regards,
Oscar