Friday, February 10, 2012

Calculated Members when generating a report model

I created and deployed calculated member as measures in my cube but when I generate a model in Reporting services the calculated members do not appear? Should they? or did I miss something? Anyone else experience this?

Thank you!

In get calculated members (calculated meaures) to surface in a report model, they have to be associated with a measure group. On the calculations tab in BIDS, click on the Calculation Properties button on the menu bar and then associate each calculated measure with a measure group. Recreate your report model and they should appear along with the measures that belong to that measure group.

HTH,

Dave Fackler

|||

Thank you, that was it! They are there now when I re-generate the model.

Janet

No comments:

Post a Comment