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
- 3942 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
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
Can you define confirmed dimension?
Explain the characteristics of cognos?
What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
what is the procedure for scheduling conditional rendering?
please please give me some banking calculations in framework manager.
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
What are the methods by which it non-durable model could be changed into the durable model?
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
-------------How you design DWH?
tell me two or three issues from client side and how to solve those issues?
What is a Framework manager?
What are initial page components of Cognos connection?
