Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?



i want to create a crosstab report where product will be on rows year on column and revenue on measu..

Answer / 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

More Cognos Interview Questions

How to convert the tabular report into graphical report?Is this possible in cognos 8 report studio?

3 Answers   IBM, TCS,


wat is bus schema?

2 Answers  


Which one is better among Value and select & search prompts,in terms of performance?

2 Answers   L&T,


What is content Manager?

3 Answers   HCL, Kekran Mekran,


----------0Diff b/w Report Functions and Database functions?

1 Answers   IBM,


wt is tupple , Embed function ? wt is regular dimension ?

1 Answers  


What are the types of security?

0 Answers  


How to pass multiple values from picklist prompt to sub report filter?

2 Answers   IBM, Infosys,


How will you migrate your reports to QA environment?

2 Answers   Satyam,


what is a Galaxy Schema?

2 Answers   IBM,


Can you define a query subject?

0 Answers  


Where do you edit cognos sql in report studio?

3 Answers   HCL,


Categories