Hi,
Can we add filter by Hierarchy level
Thanks a lot
There are some functions which allow you to use a level as a parameter or use members in a level as parameters.
In general, it is usually better to filter in the business layer. This is because that will mean that the result set which is passed to the dimension and processed in the creation of the dimension is smaller because of the filtering. This in itself improves performance. The subsequent processing to filter out things in the dimension would be prevented because your filtering was done in the business layer.
You should be aware that your question is not very clearly stating your intention. I had to think whether you meant filtering itself (either in filters or a data security filter) or, possibly, object security. Just in case it is the latter, you can't secure levels in a hierarchy and thus exclude them.
Thanks a lot for your reply,
Actually i want to add Summary Filter to a Measure Dimension in the package.
so the aggregation in Analysis Studio and Report Studio will use it automatically.
Regards,