Filters in DeepSee Dashboards
Hi Community, I have a dashboard with 4 widjets, two of them use the same filter date and the others two another filter date. I want to know if it's possible that when I selected a date in one widjet affected also the other widjet with the same date. I saw that the filter can affect all of the widjets or only one, the owner of the filter. The other thing that the client ask me, if exists the possibility to create a generic date and when the user choose the range of date, will affect all of the widjets, independent that are different dates. If it's possibly, the only way , i think, it's trough KPI Thanks for your help
You can accomplish this by using pivot variables. By using this approach, the pivot variable can act as the Key for two different date dimensions. Example:
Pivot variable with value of &[2017].
[Date1].[H1].[Year].$variable.Year
[Date2].[H1].[Year].$variable.Year
On your dashboard, you would want to use the Apply Pivot Variable control instead of the Apply Filter control.
Thanks for you answer Alessandro. The first problem was solved using the comma to indicated only two widjets. The other one I wrote to Evgency telling him the problem that i'm having.
Best Regards.
> when I choose the dimension appears only the name of the relation and in the field dimension level didn´t appear anything.
Please clarify what the issue is, preferably in a new post as Evgeny suggested
Jaqueline!
I guess you have widgets with pivots which include dates in from different cubes/dimensions and want them to be filtered by one control with date dimension. Right?
It's better if you provide the MDX query of at least two of different widgets (better in a new question) and we'll try to find an answer.
Hi Eduard,
In relation of my first problem, it's solved. About the second question I have four widjets that user a filter with a calendar, by range of Day. The idea is to use only one generic filter that affects the four widjets. Two of them uses the same date and the others another date. To implement the solution with the pivot variable and the computed dimensions I wrote to Evgency explaining the problem, because one of the date becames from a relationship that exists in the cube and didn´t appear the dimension level when I build the computed dimension.
Thanks for yor help.
Hi Evgeny,
Sorry for asking two questions in the same post, for the next time will be only one. About the problems that I had, the first one works, I used the comma to select the widjets that will be affected by the date. In relation of the second problem, the possibility to have a generic date that affects all of the widjtes with different dates, I still have a problem because I have to build two calculated dimensions and one of the date comes from a relation, then when I choose the dimension appears only the name of the relation and in the field dimension level didn´t appear anything.
Thanks.
1) Filter controls have a target field that determine what widgets are affected. Please check the docs:
2) About your second question on a generic date, try using a pivot variable used as "Literal" and of type "Day". I tested that it works in a simple case using Patients in SAMPLES. If you call the pivot variable "myDate", you can use it in a calculated dimension with this expression:
[BIRTHD].[H1].[DATE].$variable.myDate
Then you can use the calculated dimension as filter or in rows/columns. The dashboard will have to have a widget with a Apply Pivot Variable control, and use the Target field as described in point 1.
I am glad point 1 helped, though I see that you flagged as accepted answer another one which is about the problem you have not yet solved.
Yes. When you specifying the target for the widget control you can specify:
Fourth case sounds like what you need.
Can you elaborate on that? Do you mean filtering by week/month/season/year/etc.? That's possible. There are a lot of ranges available, but you can add your own by extending %DeepSee.Time.AbstractLevel.
Hi, Jaqueline!
Could you please share is everything works for you now with filters?
And one more from me as DC Manager - please post only one question in every question in DC ) so for this case, it should be 2 different posts about two different questions) THe reason is that you can have more than one answers which cover different questions. Thanks in advance!
Social networks
InterSystems resources
Log in or sign up
Log in or create a new account to continue
Log in or sign up
Log in or create a new account to continue
Log in or sign up
Log in or create a new account to continue