Hi @ Viz
In My point of view
upto 3 level - is Better performane
after is not Good
Using a single context filter that significantly reduces the size of the data set is better than applying multiple context filters.Context filters are meant to improve the performance.
A context filter should at a minimum reduce the size of the data by 1/10 or more. Not reaching this could cause performance to be worse.
1 of 1 people found this helpful
good morning Alex
understand what context filters doe and when they are applied - they reduce the amount of data in the underlaying table that supports the specific worksheet to which they are applied - and in the order of operation they are executed immediately after data source filters but before set, LOD's or dimension filters are applied - so the affect those calculations -
I don't believe there are limits on the number of context filters but consider how they will affect other calculations or sets on your worksheet -
if the goal is just to reduce a large data set for efficient performance and the data being filtered out applies to the entire book consider a Data Source filter
but if you want to change the way calculations behave because of when the context filter are applied use what you need -
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thank you for reply @Jim Dehner, @Nagarajan K and @srishti pandey
This question recently asked in an interview where I was able to explain the Order of Operations, however the interviewer was focusing on the maximum number of context filter which could be applied on a sheet or workbook.
I would like to see if anyone else also wants to share his/her knowledge.
Has anyone else been experienced with this question?
Any else who wants to add his/her experience to my question?
I don't think there is any limit to the amount of context filters that can be applied, therefore it would be the equivalent number of elements as there are dimensions and measures in the dataset (i.e. one for each dimension and measure)
Thank you Peter!