COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: erics on 20 Jan 2015 01:28:08 PM

Title: Trying to create a variable in Cognos 10.1
Post by: erics on 20 Jan 2015 01:28:08 PM
Hi There,
I've just started a new job, and trying to learn Cognos 10.1 on the fly. I have some Cognos experience, but with an old version and simpler reports.
I'm having issues trying to emulate what is done on an older report written by an older programmer who is no longer here.

For one of my tables, two of my columns have sums. One of the columns that does not have a sum seems to contain a string that says Rate: <summary(currentRate)> and then has more txt after it.
When I click on the cell, I see literally nothing in the properties.
I'm wondering if anyone knows how this is done?

I've used Cognos before, but I would just use procs to generate my data and cognos to output it nicely in the past ...

Thanks,
Eric
Title: Re: Trying to create a variable in Cognos 10.1
Post by: Francis aka khayman on 21 Jan 2015 01:51:09 AM
a screenshot, among other things, would greatly help
Title: Re: Trying to create a variable in Cognos 10.1
Post by: charon on 21 Jan 2015 06:50:23 AM
Hi erics,
pls deliver some more information about the report specification (screenshot is fine) and the exact thing you are trying to achieve, there are a lot of amazing competent people in this forum who would like to help you out. And i would like 2 help as well  ;D
regards
charon
Title: Re: Trying to create a variable in Cognos 10.1
Post by: Lynn on 21 Jan 2015 07:39:40 AM
Quote from: erics on 20 Jan 2015 01:28:08 PM
Hi There,
I've just started a new job, and trying to learn Cognos 10.1 on the fly. I have some Cognos experience, but with an old version and simpler reports.
I'm having issues trying to emulate what is done on an older report written by an older programmer who is no longer here.

For one of my tables, two of my columns have sums. One of the columns that does not have a sum seems to contain a string that says Rate: <summary(currentRate)> and then has more txt after it.
When I click on the cell, I see literally nothing in the properties.
I'm wondering if anyone knows how this is done?

I've used Cognos before, but I would just use procs to generate my data and cognos to output it nicely in the past ...

Thanks,
Eric

I suspect the report was unlocked using the padlock icon on the toolbar and that text and data items were then dragged into the cell.

Some formal training would be well worthwhile.
Title: Re: Trying to create a variable in Cognos 10.1
Post by: erics on 21 Jan 2015 01:22:40 PM
Holy smokes, that was the answer all along.
I just needed to unlock the screen, then I can put multiple variables in the same cell.
Thank you so much all, it's really, really appreciated!
And yes, formal training is forthcoming :)
Title: Re: Trying to create a variable in Cognos 10.1
Post by: Lynn on 21 Jan 2015 01:30:26 PM
Quote from: erics on 21 Jan 2015 01:22:40 PM
Holy smokes, that was the answer all along.
I just needed to unlock the screen, then I can put multiple variables in the same cell.
Thank you so much all, it's really, really appreciated!
And yes, formal training is forthcoming :)

Glad that helped -- welcome to Cognos and Cognoise  :)
Title: Re: Trying to create a variable in Cognos 10.1
Post by: Francis aka khayman on 21 Jan 2015 07:52:33 PM
way to go Lyn! that never crossed my mind