Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4062 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 |
Why is auto-regression used in forecasting used on cognos platform?
what r the names of the reports that u prepared???
9 Answers Covansys, IBM, Wipro,
What is TRAP in Framework manager?What's the use of TRAP? Where We are using this?
how can I test reports in cagnos?
How the Bursting happens in same report and how to Print the bursting Report?
what is textsource variable
what do you mean by parallel execution of query?
how many facts&dimensions tables in project? it's very urgent.........
what is a join? what are the types of joins?
advantages of detailed filter??? and summarized filter???
Can any one tell me cognos training class in chennai? thanks in advance...
can any one say the which is the best performance in framework manager
Teradata 
