BPC Report Filter on Values Rather than Properties?
I have what I think is a very common issue with OLAP. I would like to hear how others deal with it.
It is easy to filter on properties, but users cannot write to properties and change their values. Users can, however, easily submit a numeric response with the proper dimensionality.
The problem is how can you filter a report on these values? For example, a budget item may be marked with 1 or 2--either approved or not approved. How do I write a report showing all the items that have been approved?
Can I use MDX to do that? Is it efficient? Can I use an evDRE()? Can I use comments and a relational table within Excel to somehow filter the cube's data?
I am interested in hearing how others have tackled this problem.