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
Hi, a case when can't do it ?
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
Hi,
just create data item instead of quarters then assign like [query][quarter]='Q1' then 'one' and so on...
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?
write string variable as case when ([Query2].[quarter]='Q1' then 'A' ad so on..
lik tht u can give different colrs for different qrts
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............
Again one more work with this same task.
I want in crosstab report(on measurable values)......
Can anyone help please.............?
Quote from: sadiqndl on 27 Feb 2014 06:49:22 AM
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.
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
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.
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?
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.