Cognos Tutorial - Sparklines inside a Crosstab

Report Studio tutorial to show how to include a sparkline into a crosstab for each row item.
Please take a look at http://cognosoracle.blogspot.com for hi-res version of this video.
Thanks for watching.

Category:

Science & Technology

Tags:

• business intelligence
• cognos
• report studio
• inteligencia de negocios
• tecnificarte

[BlackVivaldi]

Great video but the results don't make sense. I expect to see spikes in the spark-lines for 2008 for almost all of the product. And look at the 3rd product: Devocryll15, why does it have spikes between roughly 2005 -2008 when there are barely any sales recorded? I expected a huge spike in 2008 for this product but the spark-lines appear to be dipping. What am I missing?

[maulazyhola]

@BlackVivaldi Good question. At some point of the video I explain that Crosstab values are grouped by year and the query that draws the sparklines is grouped by year and month. So it looks that 2008 was great for that product but the sales are spread around many months, perhaps the first quarter or so.

I hope this makes sense to you. To be honest I had to watch the video again and figure it out since I created this one long time ago and the original data was just a demo, it doesn' exist anymore.

[maulazyhola]

There is nothing to point, I really like helping whenever I can.

You are very close Aghsan, I think your problem is just changing a little bit your calculation.

Instead of months_between({sysdate}, birth/12), use months_between({sysdate}, birth)/12

This will return a float number,which you can format as required with Cognos.

Cheers!

[maulazyhola]

I haven't used the "_age" function. I usually just format a DATE field, and yes you may chose among a bunch of options such as dd/mm/yyyy, mmm/yyyy, etc.

If you want to display only the day just need to customize the format in Framework Manager or directly on Report Studio.

Cheers!

[aghsan]

cool series video.. please keep this good job up always

Cheers ;)

[maulazyhola]

@aghsan Thanks!

[ramukotha]

excellent, thanks.

[aghsan]

Thanks Mr.maulazyhola, I really appreciate your help

Cheers

[aghsan]

Dear maulazyhola,

Thanks for your kind response and prompt positive answer ;) I really appreciate it.

Would you kindly tell me how do you calculate the age?

because I use "months_between" function, for example

months_between ({sysdate}, [BIRTH_DT_TM]  )/12) , and its result is 0 for a new born, it doesn't show me the actual age, if this baby his age is a few monthes, or days.

Would you kindly tell me how can I fix this issue??

Thanks alot ;)

[aghsan]

You are very welcome;)

I have a question plz,

I use "_age" function, but as you know, its format doesn't look very nice, and I need to format it. I would like to see YY "Year", MM "Month", DD "Day", and

sometimes, there is no year nor month, just day, so I need a label to descries that. can you help me?

Thanks in advance.