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
- 3673 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 batches and it’s details?
Why Star Schema is de-normalized? Please explain in detail probably with some examples.
what is the difference b/w mdx and sql?
If anyone need COGNOS 8 Certification Dumps of any "COG - Code", u can get from S_Cog@Yahoo.Com, i scored 100 % with these Dumps
plz giv ans . user1 developed some repot ,user2 modify the same report and user 3 also some updates in that same report ? how to indentify that report will be modified r not ?
difference between stored procedure and function?
set scope level in transformer
how can you set the image in the report
Once reports are delivered to client, how will they inform back? If they are experiencing any problem in the reports.
1.Can we use 2 packages in report studio at a time is there any alternative for this? 2. What are Star Dimensions and Star Facts? 3.What are dimensions and facts in project ? 4.What is difference between 3 NF and Star Schema ? 5. What Is Data Modelling? 6. How much time do u need to create a report ,if u have four dimensions and 1 fact ? 7. How do u create a Model ? 8. How do u connect a Parameter in a list ,such a way it has to show relative objects in Cross tab ? 9. To display region list in separate pages ,how do u do ?
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
Is it possible to join multiple Databases in a Catalog?
Teradata 
