Hi Experts,
I have a report model on top of a cube. I have a calculated metrics called Policy Count and different amounts in cube.
When i try to create report in report builder with Policy count, amounts and different dimensional attributes it doesnt work.
The problem is report builder allows me to select either Policy count in the report or the amount field.
Have anyone faced this problem.
The same report works in cube browser.
Regards'
Neeraj
Make sure your calculated and non-calculated measures are housed in the same measure group folder. To move the calcualted measure to a measure group's folder, go to the Calculations tab in the Cube Designer. There is a Properties button in the toolbar which will allow you to choose the calculated member and which measure group to associate it with. (Don't set the display folder.) Deploy your cube and rebuild your Report Model off the DSV.
B.
No comments:
Post a Comment