specific output for the result

[sadiqndl]

Hi everyone,

I have a Situation where Iam using QUARTER(from time) and REVENUE(from sales fact) columns.
Now when I run the report the result will be as per Quarter-wise revenues will be displayed like
Q1     230
Q2     450
Q3     5800
Q4     58966

Now I want the Report to be displayed as
One         230
Two         450
Three      5800
Three      58966.

Any one please help........
Thanks in advance

[hittony]

Hi, a case when can't do it ?

[sadiqndl]

Can U please Explain step by step procedure, Because i used case condition and run the case without any errors but im getting confused where to use the case condtion in properties pane

[mitwa]

Hi,

just create data item instead of quarters then assign like [query][quarter]='Q1' then 'one' and so on...

[sadiqndl]

Ya I did that but I need to change the output data not style like background colour, font color like that.....


did u get it?

[mitwa]

write string variable as case when ([Query2].[quarter]='Q1'  then 'A' ad so on..
lik tht u can give different colrs for different qrts

[sadiqndl]

No its not the way, through this way we can change the display of the data but not result.

The CORRECT ONE is use QUERY CALCULATION. just now got this answer from Cognos Developers Forum and it worked.


Thanks for the effort............

[sadiqndl]

Again one more work with this same task.
I want in crosstab report(on measurable values)......


Can anyone help please.............?

[MFGF]

Again one more work with this same task.
I want in crosstab report(on measurable values)......


Can anyone help please.............?

Can you explain what you mean? If you are using a crosstab, your query calculation will go in the row headings area and your measure will go in the measures area. Is this what you mean?

MF.

[sadiqndl]

I have a crosstab report in which im using Revenue as MEASURABLE value........
In this when i run the report, I will get some values in middle, right.....

I want them to be replaced with any string values........


For eg., If i get the revenue as 111410, I want this value to be replaced as "OK I GOT VALUE"
I apllied CASE condiotion, if else then  tried with Query calculation
I got the answer with list report but i want with crosstab

[MFGF]

What you are trying to achieve is difficult in a crosstab. Cells in the middle are designed to show measure values only. You can work around it with some effort, but it's a bit messy.

Take a look here:

http://www.cognoise.com/index.php/topic,21666.msg65939.html#msg65939

MF.

[sadiqndl]

Hi this approach may help me a bit, let me try and
And at the same time I can easily see he is Using text values as measures but
I am using measurable values only but output as string.

So I am think we should convert this numeric value to string then apply it in Query Calculation. will this work?
HOW?
Or any other approach?

[Lynn]

He is using a numeric measure, such as cellValue() = 1, and then displaying a string, such as 'Bulb'. What makes you think you need to covert your measure to a string?

Based on the example in your earlier post you'd want revenue as your measure and then a report expression something like:
when cellValue() = 111410 then 'OK I GOT VALUE'

I would imagine you don't want to reference every possible revenue figure in your case statement, so perhaps a range of values is the report expression you would be creating.