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
- 3994 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
Answer Posted / mohanakkireddy16
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 |
Post New Answer View All Answers
How create measures and dimensions?
Explain difference between powerplay transformer and power play reports?
How can I test reports in cagonos?
Is it possible to join multiple Databases in a Catalog?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
What is the difference between a data mart and a data warehouse?
How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?
What DB View and Bus View?
What are the types of hierarchies?
New coloums are added in database, then how you know in report level
How to test a cube?
Can you explain dynamic query mode?
Can you define snapshot?
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?
