Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts,
I have a big mess with the filters and the set analysis, I have several problems.
I am using 4 main variables - 2 are for the KPIs and 2 are for the other objects.
For each KPI I am using Set Analysis and define each variable to the relevant field.
For example: Sum({<Year={'$(vKpiYear)'}, Month={'$(vKpiMonth)'}, Flag1={1}>}Sales)
The KPIs should not be affected by any user selection, not even selections in the fields listed in the Set Analysis.
When I added 1 to the Set Analysis, only the mentioned fields (Year, Month, Flag1) affect the KPIs, but that shouldn't happen either.
Sum({1<Year={'$(vKpiYear)'}, Month={'$(vKpiMonth)'}, Flag1={1}>}Sales)
The rest of the objects should affect by user selection in the filter panes.
I need to use the other 2 variables to set a default filter in a filter pane (a dynamic filter that updated every month) - set the value of vSelYear as default of Year and set the value of vSelMonth as default of Month. The user can change this defauld and filter by additional fields. Every selection will affect all objects except the KPIs.
My problem is associating the variable value to a field in the filter panes.
The client prefers that I not use Alternate State for the first problem and refuses to use extension for the second problem.
How can the problems be solved?
Hope I was clear. Many Thanks!
R you using Linked or Unlinked calendar??
If you r using a linked calendar kindly check the variables that you have made from Master Calendar Dates?
May be you are using a different table dates in variable and you have made you master calendar from different table.