Interested to Buy Any Domain ? << Click Here >> for more details...
How to findout YEAR CALCULATION?
THAT MEANS YOU SHOW THIS YEAR REVENUE AND LAST YEAR REVENUE.
WHEN YOU FILTER THIS YEAR VALUE THE RESULT SHOULD DISPLAY
THIS YEAR RESULT AND LAST YEAR RESULT.
- 3 Answers
- 7725 Views
- Kudos India, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pooja
Why do we need to do that? i mean why do we need to display
revenue of 2 years, when we are choosing a particular year
to display the value? What is the scenario?
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nasa
scenario:
Display 2013 and 2014 revenue and compare that country wise?
report studio-> list-> drag and drop a country data item
from branch query subject
drag a QUERY CAL from tool box drop beside country column
Name: 2013_revenue
expression:
if(order_year=2013) then(sales.revenue)
else(0)
drag a QUERY CAL from tool box drop beside 2013_revenue
column
Name: 2014_revenue
expression:
if(order_year=2014) then(sales.revenue)
else(0)
drag a QUERY CAL from tool box drop beside 2014_revenue
column
Name: variance_between_2013 and 2014
expression:
2014_variance - 2013_variance
ok
save and run
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / uzval_vee
by using expressions, i mean by using conditional
constructs and thru graphs we can view the revenue and
caliculated data as well.
| Is This Answer Correct ? | 0 Yes | 1 No |
please tell me architecture of the cognos8?
How Metrics Studio is better than Report Studio?
How to schedule the report twice in a day?
Can you define metrics designer?
what is the automation tool used for data warehouse testing???
3 Answers Covansys, IBM, Wipro,
What is Report item
What is Bitmap Index?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
Which service handles requests for cognos connection,query studio and event studio.
----------------What is meant by DSS?
What is the deployment requirements used in cognos?
How to find out OLTP data OLAP data ? i.e 5 years data is OLTP or OLAP. please anybody help me...
Teradata 
