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 |
What are the differences between cognos reportnet 1.1 report studio and cognos 8 report studio?
can any one pls send me the project flow at the time of interview
Can you define a query subject?
hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file
how can i test the reports in cognos
How to select multiple values from Type-in prompt? Example - I want to enter into type-in prompt in 'Product name--- Liza' display report data in 'product name is Leza' only OR I want to enter into type-in prompt in 'All', that time display report data in all are report data. How is possible this Scenario using in type-in prompt.
How do you create IQD in FWM? Pls, give the procedure with an example. I told him that we could create using Native SQL method in FWM; it is correct or do you do another method there?
-----------Diff b/W Aggregate Function and Rollup Aggrigate Function?
How to create a Left Outer Join in FM? Please explain.
What is the difference between a data mart and a data warehouse?
whats the difference between previous version of cognos and cognos 8 BI?
can we insert list report in corsstab report?