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?
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 |
How applying "Level Span" in Cognos 8.3?
What are the different type of securities can we apply in framework manager?
how to improve performance in report studio level
what is the difference between aggregation and role up aggregation ?
What are the different uses of a repository manager?
hi Here ive question on Reportnet when we save a report in reportstudio with what ext it save
what is the use of layout calculation?
What is the use of Excel files in Cognos8?
What are user classes?
How to configure the Cognos configurations to work in the Windows 2000 Server machine?
Can u please describe the different types of traps with eg. Thanks
What is the use of Tree Prompt? Where it is used?Pls give me a real time example?