COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: backhandx on 28 Dec 2016 08:24:52 AM

Title: Problem with column name ending with a number
Post by: backhandx on 28 Dec 2016 08:24:52 AM
Hi everyone,

I have 3 levels in a hierarchy: L1, L2 and L3. I explain the issue: Suppose the level L1 is displayed in a list. When I tried to filter the level L1, its name becomes L2 in the filter.
This is confusing for the user because we may think that we filter L2 not L1.

So, I'm wondering if there is a way the name of the filtered level ( L1)  will be L1 1 instead of incrementing the number of the level.

Thanks for your reply.

Title: Re: Problem with column name ending with a number
Post by: SpareTire on 28 Dec 2016 11:56:18 AM
I have to assume that by filtering, you mean your user is drilling down? If so, try the data tab, drill behavior and then Advanced. You can define how you want the drill down effect to look.