Hello Gurus,
I am using a DMR Model as the basis for a simple Chart report.
The Categories on the Chart is the 'Month name'(Attribute) from Time Dimension.
The Series is the 'Year'(Attribute) and the measure is 'Revenue'.
When running the report, the Chart doesn't seem to Group the Months as desired and is repeating duplicate values on the categories which is not desired.
Where as the same Chart report is Grouped on months as desired in a relational Model.
I think this behavior in DMR Model is caused due to each member being unique. i.e. Jan(2011) is not the same as Jan(2012).
Is there any way to achieve this kind of Grouping on Attributes using a DMR package in Report Studio?
Attached is the report image.
Hi,
do you use the ibm demo data? How does the attribute looks like, is it "jan" or "jan/2012"?
In case its just the month, there might be sth. like a month ID, which has the year in it as well.
most likely similar to "201201".
the month id should be related to the month name, in which case the solution to your issue would be to sort the month id by an ascending order.
to do this check the property panel for the sorting option.
gl and cheerz :P
Hi charon,
My issue was with Grouping the Chart categories when using an Attribute from a Level in DMR.
Any way I have got a solution for it from here: http://cognossimplified.blogspot.in/2011/10/op-err-0144-grouping-on-property-or.html
Thanks for your time...