i want to create a crosstab report where product will be on rows year on column and revenue on measure. based on the users selection in value prompt, if user select the August 15, crosstab year column should display values for aug 15, aug 14, aug 13 and aug 12 i.e for last for years but same month. how could we achieve this?
- 1 Answers
- 3296 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
First i need to know,
1. is it a relational or Dimensional Package
2. about your Time Dimension
See, in go Sales Query Package, its easy.
Firstly, Create a crosstab report where product will be on rows year on column and revenue on measure. (Assume this as (Query 1)), Create a value prompt - USE value & Display Value is "Month" Query Item. - (Assume this as (Query 2))
Create a detail Filter as [Sales (query)].[Time].[Month] = ?Month? in (Query 1).
Unlock the Cells. then Drag Layout Expression to left side of the " <#Year#> " and then drag Month Parameter into the expression and then click ok .
Give some Default value for that value prompt like March.
| Is This Answer Correct ? | 0 Yes | 1 No |
What are all the components of Report Studio?
2. What is With Clause In Cognos?
Usage of Stored Procedures in Cognos
1 Answers General Motors GM, TCS,
How Metrics Studio is better than Report Studio?
Write a SQL query which should fetch the 5th maximum salary of an employee from the table?
What is the difference between filter & Condition?
How is possible this scenario using in type-in prompt.?
Why need staging area database for dwh?
Can you define fan trap?
what is the difference between aggregation and roll up aggregation?
plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........
what is render variable
5 Answers Accenture, Cap Gemini, Systime, TCS,
Teradata 
