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
- 3918 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 Metrics Studio is better than Report Studio?
Mention the difference between ‘macros’ and ‘prompt’?
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.
What are the message flows?
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
is cognos 7 is better than cognos 8
Can you define framework manager?
dumps needed ASAP for - C2020-180 Cognos IBM Certification
How to join multiple db in catalog?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
--------------Explain Table of contents?
What is the deployment requirements used in cognos?
What are the steps to import the two data sources in framework manager?
what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.
Explain the different types of views used in cognos.
