Cognos Tutorial - Sparklines inside a Crosstab

[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.

[ramukotha]

excellent, thanks.

[aghsan]

Thanks Mr.maulazyhola, I really appreciate your help

Cheers

[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!

[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 ;)

[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]

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.

[aghsan]

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

Cheers ;)

[maulazyhola]

@aghsan Thanks!

[sevre002]

I'm learning a lot! Great video.

[maash1514]

Thank you so much!!! that's amazing!

[maash1514]

Thank you so much!!! that's amazing!

[victoriasyoverlap]

waaaaaaaaaaaaa, that is so neat. How many years have u worked in this field??????????????

[maulazyhola]

@victoriasyoverlap Thanks, I'm not such a pro lol... but yes, I've been doing Cognos for quiet a while, since 2004. Although I'm more a Database guy, but when it comes to reporting and BI, Cognos really shines.

Cheers!

[iAspireAcademy]

Very good video on Cognos, Thanks for sharing

[vishalkharade]

Hi Maulazyhola,

I have 2 things to say about your videos

1st is that you have very good knowledge of cognos and 2nd you are very good in explaining what you want show.

Thanks for these videos. They are very helpful to all new comers.

[maulazyhola]

Thanks! It is a shame I haven't got enough time to create more tutorials, but I feel good that they're useful.

[HopeInChrist2]

Great job! And what a neat idea to put the chart inside the crosstab.  Thanks for sharing.

[guptavishwas]

great work and good intentions to spread knowlege

[kumtiger]

Thanks for sharing !.

[akkineni007]

Excellent Video !!!

Your accent is Good .There is nothing to Point. I appreciate your great effort.

[maulazyhola]

Do you think so? Ha ha. I think it's terrible but thank you!

[maulazyhola]

Thank you. I'm glad you found it useful.

[donreturns]

NICE VIDEO.........