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

Struggling with Cognos 11 visualizations

Started by Marvin Falentin, 05 Apr 2017 02:36:49 AM

Previous topic - Next topic

Marvin Falentin

Hey everyone,

I'm trying to re-build one of our "old reports" from Cognos 10 and still have some Problems, I just write down to what conclusions I've come so far and you correct me if I'm wrong :)

I tried to show some very simple data (three different status of a process and the amount of those status) in a stacked bar chart. I tried the new "standard chart" but, unlike in Cognos 10, I was not able to change the size of the bar itself nor the conditional colouring for the bar (we're only using one bar). All I found was the suggested colour palette which is not suitable for our customers. Also it would be nice to be able to re-arrange the order the three different status' are displayed in the bar, but to me it seems not to be possible right now. We're using an active report.

Am I right so far or have I just not been able to figure out how to do it in Cognos 11? I'd be really glad for some insight here!

Kind regards,

Marvin

Lynn

Quote from: Marvin Falentin on 05 Apr 2017 02:36:49 AM
Hey everyone,

I'm trying to re-build one of our "old reports" from Cognos 10 and still have some Problems, I just write down to what conclusions I've come so far and you correct me if I'm wrong :)

I tried to show some very simple data (three different status of a process and the amount of those status) in a stacked bar chart. I tried the new "standard chart" but, unlike in Cognos 10, I was not able to change the size of the bar itself nor the conditional colouring for the bar (we're only using one bar). All I found was the suggested colour palette which is not suitable for our customers. Also it would be nice to be able to re-arrange the order the three different status' are displayed in the bar, but to me it seems not to be possible right now. We're using an active report.

Am I right so far or have I just not been able to figure out how to do it in Cognos 11? I'd be really glad for some insight here!

Kind regards,

Marvin

There is a filter button in the top right of the visualization gallery dialog that comes up when you try to add a visualization. It lets you choose New Visualizations, Legacy Visualizations, or Charts. Perhaps there are other options that would help you achieve what you need. I would recommend visualizations rather than charts for an active report since charts can really increase the file size if there are a lot of them or if active report controls allow many varieties of the same chart via data decks and such.

Marvin Falentin

QuoteThere is a filter button in the top right of the visualization gallery dialog that comes up when you try to add a visualization. It lets you choose New Visualizations, Legacy Visualizations, or Charts. Perhaps there are other options that would help you achieve what you need. I would recommend visualizations rather than charts for an active report since charts can really increase the file size if there are a lot of them or if active report controls allow many varieties of the same chart via data decks and such.

Unfortunately Lynn, that's exactly the problem: I tried the "New Visualizations" first but I'm neither able to adjust the Colors (I want / need conditional coloring from Cognos 10 but you can only select the Cognos 11 colors so far which are not fitting for our customers) nor can I adjust the size or width of the bar itself. At least I have not been able to do it.

I'm still looking into this issue but so far I have not been able to fix it myself, guess I just have to use the old chart and wait for Cognos to implement those features I need. :(

Kind regards,

Marvin

Lynn

Legacy visualizations can be customized, or someone who knows how to code in JSON can create them. I've looked at the customizer but haven't actually tried to do anything with it. Not sure I'm skilled enough to do much beyond tweaking color codes.

http://www.cognoise.com/index.php?topic=30778.0

AnalyticsWithJay

Do you know which colors you're looking for? If not, I like to use coolors.co when designing color schemes.

Here's the JSON code that you're looking to edit in the visualization zip:


"color":
               [
                  {
                     "id":"_PALETTE_",
                     "scale":
                     {
                        "local":false
                     },
                     "field":
                     {
                        "$ref":"series"
                     },
                     "modifies":"both",
                     "palette":
                     [
                        "#1183ad",
                        "#39b2ac",
                        "#60942c",
                        "#d4a600",
                        "#d15c00",
                        "#b2293d",
                        "#a64c8b",
                        "#532f8c",
                        "#84c7e0",
                        "#9ce3e0",
                        "#b3d66d",
                        "#ffe36a",
                        "#fabe79",
                        "#e88686",
                        "#de92ca",
                        "#ad95cf",
                        "#1b6a87",
                        "#1f918b",
                        "#39671a",
                        "#a68500",
                        "#cc6110",
                        "#82202a",
                        "#80226e",
                        "#4e2c70",
                        "#53abcc",
                        "#6ecfc7",
                        "#86b347",
                        "#f0cc00",
                        "#e6944a",
                        "#e2515b",
                        "#c767ae",
                        "#9169bf"
                     ]
                  }
               ],



Marvin Falentin

Thanks for your help guys, I thought about customizing the colors of our chart but as far as I know you can't customize the new charts colors so I'm using an "old one" again now and it's still doing the trick :)

Case solved (kinda)

Kind regards,

Marvin

rteruyas

Thanks for your help guys, I thought about customizing the colors of our chart but as far as I know you can't customize the new charts colors so I'm using an "old one" again now and it's still doing the trick :)

Case solved (kinda)

Kind regards,

Marvin


Legacy visualizations (also known as RAVE1) can be customized with VizCustomizer. You can even save it with a different name so that you dont overwrite the default one.
https://www.ibm.com/blogs/ba-support-link/rave-customize-and-apply-visualizations/

New visualizations (RAVE2) palette cannot be changed at this moment unfortunately, but I still keep my hopes up
Happy Reporting!
[Ray]