COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: inu on 27 Feb 2017 08:37:04 AM

Title: Need to use symbols in crosstab report.
Post by: inu on 27 Feb 2017 08:37:04 AM
Hi Team,
I have to use some symbols to show the data in the form of images like arrows for growth, degrowth.
Please find the attachment.

Please suggest..


Regards,
Inam
Title: Re: Need to use symbols in crosstab report.
Post by: AnalyticsWithJay on 27 Feb 2017 08:50:26 AM
Here a tutorial (http://public.dhe.ibm.com/software/dw/dm/cognos/reporting/layout_and_formatting/image_indicators_in_a_crosstab.pdf) Inam...

The property you're looking for is 'Define Contents'.
Title: Re: Need to use symbols in crosstab report.
Post by: MFGF on 01 Mar 2017 03:58:45 AM
Quote from: inu on 27 Feb 2017 08:37:04 AM
Hi Team,
I have to use some symbols to show the data in the form of images like arrows for growth, degrowth.
Please find the attachment.

Please suggest..


Regards,
Inam

Are you using Cognos Analytics (Cognos 11) or Cognos 10?

MF.
Title: Re: Need to use symbols in crosstab report.
Post by: Mimo91 on 01 Mar 2017 08:40:10 AM
Hi inu,

I believe only way of doing this is to place images of these arrows in server and in report use those images based on conditions as required.
Title: Re: Need to use symbols in crosstab report.
Post by: inu on 02 Mar 2017 10:14:06 AM
Quote from: MFGF on 01 Mar 2017 03:58:45 AM
Are you using Cognos Analytics (Cognos 11) or Cognos 10?

MF.


Cognos analytics Cognos 11)
Title: Re: Need to use symbols in crosstab report.
Post by: inu on 02 Mar 2017 10:18:40 AM
Quote from: CognoidJay on 27 Feb 2017 08:50:26 AM
Here a tutorial (http://public.dhe.ibm.com/software/dw/dm/cognos/reporting/layout_and_formatting/image_indicators_in_a_crosstab.pdf) Inam...

The property you're looking for is 'Define Contents'.


Yeah, that I know.. I m not talking about arrow symbol.. Moreover the symbol in right side of the attached image... Which will change based on the values..
I don't know... That is symbol or what.
Plz suggest..

Regards,
Inam
Title: Re: Need to use symbols in crosstab report.
Post by: inu on 02 Mar 2017 10:22:35 AM
Quote from: Sourav91 on 01 Mar 2017 08:40:10 AM
Hi inu,

I believe only way of doing this is to place images of these arrows in server and in report use those images based on conditions as required.

No boss, I m asking something else... Please see the right side of the image.


Thanks
Title: Re: Need to use symbols in crosstab report.
Post by: Mimo91 on 03 Mar 2017 12:08:09 AM
Quote from: inu on 02 Mar 2017 10:22:35 AM
Hi inu,

I believe only way of doing this is to place images of these arrows in server and in report use those images based on conditions as required.

No boss, I m asking something else... Please see the right side of the image.


Thanks

Are you talking about 3-Year Trending column? If yes, then I believe this is not an image. It is showing some fact values for 3 years. You can implement this by using Microchart (Line with Open, Close, Min and Max Value markers).
Title: Re: Need to use symbols in crosstab report.
Post by: inu on 03 Mar 2017 07:31:30 AM
Quote from: Sourav91 on 03 Mar 2017 12:08:09 AM
Are you talking about 3-Year Trending column? If yes, then I believe this is not an image. It is showing some fact values for 3 years. You can implement this by using Microchart (Line with Open, Close, Min and Max Value markers).


Yes, correct .. I wanted to know this. Thanx.
and What chart i have to use for %Realization column in the image.

Please suggest.

Regards,
Inam
Title: Re: Need to use symbols in crosstab report.
Post by: MFGF on 03 Mar 2017 07:59:01 AM
Quote from: inu on 03 Mar 2017 07:31:30 AM

Yes, correct .. I wanted to know this. Thanx.
and What chart i have to use for %Realization column in the image.

Please suggest.

Regards,
Inam

Looks a bit like a bullet chart to me?

MF.
Title: Re: Need to use symbols in crosstab report.
Post by: Mimo91 on 03 Mar 2017 08:33:31 AM
Quote from: inu on 03 Mar 2017 07:31:30 AM

Yes, correct .. I wanted to know this. Thanx.
and What chart i have to use for %Realization column in the image.

Please suggest.

Regards,
Inam

Hi Inam,

I am not sure what will be the chart in CA. But in Cognos 10.2 Microchart with Line with Open, Close, Min and Max Value markers can be used for this.

Regards,
Sourav
Title: Re: Need to use symbols in crosstab report.
Post by: inu on 03 Mar 2017 09:00:11 AM
Quote from: Sourav91 on 03 Mar 2017 08:36:00 AM
Hi Inam,

I am not sure what will be the chart in CA. But in Cognos 10.2 Microchart with Line with Open, Close, Min and Max Value markers can be used for this.

Regards,
Sourav

Thanx,  I was thinking about bullet..that's available in CA.  But that is not matching with mock up.

Thanx..
Title: Re: Need to use symbols in crosstab report.
Post by: Mimo91 on 06 Mar 2017 01:33:00 AM
Quote from: inu on 03 Mar 2017 09:00:11 AM
Thanx,  I was thinking about bullet..that's available in CA.  But that is not matching with mock up.

Thanx..

Hi Inu,

I believe for %Realization column you have to use Bullet Chart and for 3-Year Trending column you have to use Microchart.

Regards,
Sourav