Crosstab report with time dimension and country dimension.

[Meandcognos]

Hi Gurus,

I initiated to building a crosstab report with dimensions(time and country) against a measure average revenue (revenue / working days).
I'm not much aware DMR function of achieving.
Please advise

[MFGF]

Hi Gurus,

I initiated to building a crosstab report with dimensions(time and country) against a measure average revenue (revenue / working days).
I'm not much aware DMR function of achieving.
Please advise

Hi,

Assuming you have a package that describes and presents this data, you simply drag and drop the items from the package into your crosstab.

MF.

[Meandcognos]

Thanks for the reply...

In package we have defined time, country dimension with scope relationship with revenue measure.

Country Dim:
India
  Karnataka
     Bangalore

Time dim
Year
Quarter
Month
Week
Day

Design a crosstab report in fashion to achieve drill up and drill down functionality with average revenue /working days(YTD-->QTD-->MTD)

Example  :

If user click year 2016 then average revenue should be calculated on the basic  YTD(Year to date) --> Quarter (Quarter to date) -->  Months(Month to date)..like that.
against country dim.

report running date : 08-11-2016 then YTD should be 222 days(only working days), Average Revenue for India in 2016 should 200000/222 = 901

           2016   2015   2014
India    901           801           890
Australia   1200   1100   1150
China   1002   950            1122


I'm new in DMR  Please advise to achieve functionality in report studio achieve a crosstab report with drill up and drill down without performance issue.

[Invisi]

Are you using a cube or a database? The manual tells you how to set up a hierarchy in your dimensions.

As for performance, that can be a matter of your database...

[Meandcognos]

Are you using a cube or a database? The manual tells you how to set up a hierarchy in your dimensions.

As for performance, that can be a matter of your database...

Using Dimensional model with database......

Is there any DMR function to know the Level position while running drill down in report.

That would be helping me to find average revenue /working days(YTD-->QTD-->MTD).


Many Thanks!!!

[MFGF]

Using Dimensional model with database......

Is there any DMR function to know the Level position while running drill down in report.

That would be helping me to find average revenue /working days(YTD-->QTD-->MTD).


Many Thanks!!!

Already asked and answered in your other thread!

http://www.cognoise.com/index.php/topic,31930.msg104290.html#msg104290

MF.

[Meandcognos]

Wow!!!....Thanks MFGF!!!!.......it's level works :)

Please advise now, how to calculate average revenue ( total revenue /working days(YTD-->QTD-->MTD) in DMR model against working days in report Studio or do we have change any set in Framework manager ?

In database, having 3 years of data as current year (2016), Previous year (2015) and previous to previous year (2014).

Let say report running date : 08-11-2016 then current yrs YTD should be 222 days(only working days) and previous year YTD 260 and Previous to previous year YTD 260.

Many Thaanks