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
- 4070 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 is set to be cardinality?
Interval Prompt's Usage? Example for usage in Project
Can we install Cognos 8.4 on Windows Vista...Please let me know....Thanks!!!
How to apply securities for reports in cognos connection?
Can you define framework manager?
what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?
can any one pls send me the project flow at the time of interview
can we create a chart without measure
How do you improve the performance of the Cognos Analytics report
wt is tupple , Embed function ? wt is regular dimension ?
difference between impromptu and cognos8
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
Teradata 
