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
- 4000 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 are the steps to import the two data sources in framework manager?
What are the steps involved in migrating CRN enviroment to Cognos 8?
3 Answers BMW, Goyal Group, Mersan,
-------------------What is Deployment?
what are typees of dimensions
how to find the rank in report studio? i need steps for this question.
What is the difference between Open Connection command ang Open Session Command?
what are diff b/w cognos and business objects
---------- Purpose of Factless Facttable?
how you migrate reports to cognos 8 from previous versions?
What is the difference between macro & Parameter
plz anybody help me, how many reports we can create in one project?, and what are the names?in real time project at first what we will do?
What do you understand by the term 'dynamic cube'?
Teradata 
