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
Quote from: Meandcognos on 15 Nov 2016 01:01:08 AM
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.
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.
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...
Quote from: Invisi on 16 Nov 2016 08:04:00 AM
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!!!
Quote from: Meandcognos on 17 Nov 2016 10:15:14 PM
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.
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