Hi and welcome to the Cognos blog. I'm intending to use this blog to post new techniques and answers to other Cognos developers questions. If you need help - just ask!
this is a BIG question and and requires an answer bigger than I can give on the blog. I'll create another thread for a summary of how to migrate from series7 to series8
I am trying to create a crosstab report that will drill down to a detail report.
I would like the user to be able to click on a dollar amount field.
I need to have the dollar amounts totalled, too, though. But I don't want the total fields to show a link or a drill down feature. Only the amount itself.
But when I create the drill down, it applies it to every amount field, including the totals.
I'm unsure what you mean by water flow chart. If you require a custom way of showing metrics on a chart you could use map manager. This would mean that your company would have to pay for a new 'map' to be created. You can then integrate this map into report studio and use it in a report.
.the y-axis shows revenue ,x-axis shows producttype and range is years. if for 2005 the revenue is 2000,and 2006 the revenue is 3000, and 3007 the revenue is 4500
then the graph should show rev 2000 for year 2005,for year 2006 it shld show only the diference data of previous years and current year( eg rev for 2005,2006 is 2000,3000 resp.for year 2006 it shld show rev 1000 visible and remaining 2000 is in visible).
How to convert Millinium secnds into HHMMSS in Framework Manager, I canvert through sql query using 'Convert' function, where as in FWM, could you tell me how to convert... Thanks RP
Hi Phil, Explaining about Determinnats is amazing.I couldn't understand waht determinanats are untill i looakd at it.Could you explaing the migration process from 7.3 Transformer to 8.4 transformer
Your blog postWelcome to the Cognos Blogger is superb in fact, i have seen your post and That was very learning and very enjoyable for me. Gratitude for blog posting Really Such Things. I should suggest your site to my friends.
can you please explain the concept of granularity and determinants with examples in framework manager in cognos 8
ReplyDeleteHi Divya,
ReplyDeleteI have created a new blog for you to explain determinants and granularity in more detail.
Let me know if it answers your question.
Phil
Hi Phil,
ReplyDeleteCan you please explain about the
migration of cat, cubes,reports & upfront from series 7 to C8.
thanks in advace.
giri
Hi Giri,
ReplyDeletethis is a BIG question and and requires an answer bigger than I can give on the blog. I'll create another thread for a summary of how to migrate from series7 to series8
best regards
Phil
I am trying to create a crosstab report that will drill down to a detail report.
ReplyDeleteI would like the user to be able to click on a dollar amount field.
I need to have the dollar amounts totalled, too, though. But I don't want the total fields to show a link or a drill down feature. Only the amount itself.
But when I create the drill down, it applies it to every amount field, including the totals.
Is there any way to not include the totals?
Thanks!
Hi Cynthia, I've created a new post for you that describes the process you need.
ReplyDeletebest regards
Phil
Hi,
ReplyDeleteIam Having one list report ..in that client needs a prompt which will shows the data for LAST 15 MINUTES .
Please help me out how to get the data for last 15 minutes...i mean pls explain me in brief....
hai Thompson
ReplyDeletecan we create a water flow chart in report studio.please guide me through the steps top .
hai thompson
ReplyDeletecan we create a water flow chart in report studio.please guide me the steps to create it.
Hi Venkat,
ReplyDeleteI'm unsure what you mean by water flow chart. If you require a custom way of showing metrics on a chart you could use map manager. This would mean that your company would have to pay for a new 'map' to be created. You can then integrate this map into report studio and use it in a report.
I hope this helps
Phil
Hai Thompson
ReplyDelete.the y-axis shows revenue ,x-axis shows producttype and range is years.
if for 2005 the revenue is 2000,and 2006 the revenue is 3000, and 3007 the revenue is 4500
then the graph should show rev 2000 for year 2005,for year 2006 it shld show only the diference data of previous years and current year( eg rev for 2005,2006 is 2000,3000 resp.for year 2006 it shld show rev 1000 visible and remaining 2000 is in visible).
Hi Venkat,
ReplyDeleteOK - I understand what you are after now. I'll get onto this on Monday and give you some examples of how to create the chart. Cheers Phil
Hi Phil,
ReplyDeleteHow to convert Millinium secnds into HHMMSS in Framework Manager, I canvert through sql query using 'Convert' function, where as in FWM, could you tell me how to convert...
Thanks
RP
Hi Phil,
ReplyDeleteExplaining about Determinnats is amazing.I couldn't understand waht determinanats are untill i looakd at it.Could you explaing the migration process from 7.3 Transformer to 8.4 transformer
Thanks,
Vasavi
Your blog postWelcome to the Cognos Blogger is superb in fact, i have seen your post and That was very learning and very enjoyable for me. Gratitude for blog posting Really Such Things. I should suggest your site to my friends.
ReplyDeletedissertation structure examples
It was good session about determinents. Could you please gime me more clarity.
ReplyDelete