We are trying to create a Performance Point dashboard that contains a filter which passes a week ending date into a ProClarity page containing a graph. The graph should then display the relevant year-to-date values up to and including the week ending date selected in the filter.

The graph has been created and saved to a ProClarity book in a library and it covers all dates in two years. The Performance point filter has been created to populate with all week ending dates for which data is available.

In Performance Point the Filter Link has been configured with a MDX forumula that passes the week ending dates up to the selected value: Ancestor(<>,[TIME].[CDM Fiscal].[Year]).Firstchild.Firstchild.Firstchild:<>. The filter works very well until we get more than 16 weeks into the year. After the 16th week we get: The web page could not be displayed. instead of the report.

According to this thread, named sets should help us, but I don't see any way to use them except to create a named set for each week of the year since they are not dynamic.

Please let us know if you have any ideas on how we can solve this problem,

Thank you, Rachael