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

Cognos 11 create active report - slicer

Started by michalsal, 28 Mar 2018 04:59:07 AM

Previous topic - Next topic

michalsal

Hi,
I try on Cognos 11.08 create active report that:
- will have data toggel buton bar, with type of product. It is important that user of report can choose more than one type of product.
- table ( i tried crosstab), with months in columns, and measures in rows
- type of product should be "hidden filter", I can't put this field direct into crosstab.

I tried:
- standalone crosstab, with adding only in query TYPE of PRODUCT, but I didn't put this field into crosstab. Of course I can't create connection  from toggel buton bar to crosstab, that filter TYPE of PRODUCT. If field isn't put direct into crosstab, creator of connection don't see it.
- second idea: i created data deck, that is filtered by toggel buton bar. Into data deck I put crosstab and I created master detail relationship between deck and crosstab. It works when I choose one type of product, but with more than one it doesn't work. I imagine that master detail relationship is based on "type of product = type of product", not on type of product in type of product".
- third idea: i used data list, however I can't use months as columns

I want achieve effect like crosstab and slicer in Excel.

thanks in advance for any idea