I'm in the following situation : olap parameterized report - using an Analysis Services data provider - with 4 filters and parameters.
One of the filters - Time dimension and one of its hierarchies - includes 2 calculated members called: Primary and Secondary, which basically describe a time interval of a day based on some business rules.
An Excel pivot tabel retrieves data without any problems. But a SSRS 2008 matrix report fails when picking up one of the calculated members , as it does not support it, just like olap browseren in AS 2008 does not support filtering by any calculated
member. So it's difficult to find a good explanations to the users ...
I'm not quite sure that using the ole db provider for analysis services in stead of analysis services will solve my problem. That's why following question :
Are you absolutely sure that using the ole db provider for analysis services will solve my issue ?
If not, is it any other work around ?
If yes, are there any tips and tricks of using / typing within the ole db provider for analysis services editor when using parameters. ( I tried it once without any succes and found it quite complicated when it comes to handling expressions
Thank a lot for your answer.
View Complete Post