Thursday, 22 March 2007

Welcome to the Cognos Blogger

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!




At 24 October 2008 at 05:42 , Blogger Unknown said...

can you please explain the concept of granularity and determinants with examples in framework manager in cognos 8

At 1 November 2008 at 16:13 , Blogger Phil Thompson said...

Hi Divya,

I have created a new blog for you to explain determinants and granularity in more detail.

Let me know if it answers your question.


At 13 August 2009 at 23:55 , Blogger Unknown said...

Hi Phil,
Can you please explain about the
migration of cat, cubes,reports & upfront from series 7 to C8.
thanks in advace.

At 14 August 2009 at 09:47 , Blogger Phil Thompson said...

Hi Giri,

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

best regards


At 16 September 2009 at 17:07 , Blogger Cynthia Blue said...

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.

Is there any way to not include the totals?


At 17 September 2009 at 09:57 , Blogger Phil Thompson said...

Hi Cynthia, I've created a new post for you that describes the process you need.

best regards


At 27 October 2009 at 10:19 , Blogger Vamshi.N said...


Iam Having one list report 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....

At 13 March 2010 at 18:14 , Blogger venkat said...

hai Thompson

can we create a water flow chart in report studio.please guide me through the steps top .

At 13 March 2010 at 18:16 , Blogger venkat said...

hai thompson

can we create a water flow chart in report studio.please guide me the steps to create it.

At 13 March 2010 at 19:30 , Blogger Phil Thompson said...

Hi Venkat,

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.

I hope this helps


At 13 March 2010 at 21:57 , Blogger venkat said...

Hai Thompson

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

At 13 March 2010 at 23:22 , Blogger Phil Thompson said...

Hi Venkat,

OK - 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

At 25 August 2010 at 10:40 , Blogger Ramesh Parcha said...

Hi Phil,

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

At 29 February 2012 at 16:23 , Blogger vasavi said...

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


At 7 February 2013 at 12:01 , Blogger dissertationconsultant said...

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.

dissertation structure examples

At 23 May 2013 at 09:23 , Blogger Mannem Reddy said...

It was good session about determinents. Could you please gime me more clarity.


Post a Comment

Subscribe to Post Comments [Atom]

<< Home