Hiding crosstab columns in WebI 6.1b

building reports webintelligence legacy
1

Hi,

In WebI, is it possible to build a crosstab and hide specific crosstab columns? For example, Category 3 is hidden…

                Category 1 | Category 2 | Category 4 | Category 5
Product A          ##             ##          ##          ##
Product B          ##             ##          ##          ##
Product C          ##             ##          ##          ##
Product D          ##             ##          ##          ##
Product E          ##             ##          ##          ##
Product A          ##             ##          ##          ##

Thx!
Chris

cjweis (BOB member since 2003-10-02)

2

I would think you could do that quite simply with a filter… no? Just create a report filter that excludes the value for column 3, leaving everything else in place.

Dave Rathbun :us: (BOB member since 2002-06-06)

3

Dave, I forgot to mention that’s a restriction – we need to have the columns hidden on a few tabs while being displayed on others. Sorry I left that out. In full-client I believe we’d just use a filter in the block… do you know of any workarounds that would allow that to be done in WebI?

Thanks for the help!
Chris

cjweis (BOB member since 2003-10-02)

4

Quote with emphasis added:

Webi 6 offers 3 levels of filters: Document, Report, and Block. Pick the one that works for you. 8) Document filters will affect every block on every report. Report filters affect every block on a specific report. Block filters affect only the block where they are applied.

Dave Rathbun :us: (BOB member since 2002-06-06)

5

Dave,

I was in Drill mode… that was the problem. :oops: Thanks for the help!!!

Thx!
Chris

cjweis (BOB member since 2003-10-02)