Report Portal

Referencing Parameters in SSRS Calculated Members

Issue: You author an SSRS report that connects to a cube. You want to create a calculated member that uses a report parameter. For example, the Selector calculated member in the following query returns 1 if a given employee has exceeded 1 million in sales for the dates specified by the user in the report parameter. (Sample query)

However, when you run the query you get the following error if you target Analysis Services 2005: The DateCalendar parameter cannot be resolved because it was referenced in an inner subexpression.


Tags: ssrs


2007-2015 VidasSoft Systems Inc.