Filters in DeepSee Dashboards

Question

Question

JAQUELINE KRIEGER · Mar 9, 2018

#Dashboards #InterSystems IRIS BI (DeepSee)

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

Discussion (10)1

Log in or sign up to continue

Peter Steiwer · Mar 9, 2018

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.

0 0

score 0 · Answer 1 · 2018-03-15T09:09:26-04:00

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.

score 1 · Answer 2 · 2018-03-15T09:23:12-04:00

> 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

score 0 · Answer 3 · 2018-03-15T10:29:23-04:00

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.

score 0 · Answer 4 · 2018-03-15T09:46:52-04:00

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.

score 0 · Answer 5 · 2018-03-15T09:00:32-04:00

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.

score 0 · Answer 6 · 2018-03-09T11:03:54-05:00

1) Filter controls have a target field that determine what widgets are affected. Please check the docs:

Target - Specifies which widgets this control affects. Specify one of the following:
- If this option is blank, the control affects only the widget that owns it.
- If this option is *, the control affects all widgets.
- If this option is the name of the widget, the control affects that widget. In this case, use the value given in the WIdget Name option for that widget.

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.

score 0 · Answer 7 · 2018-03-15T09:33:46-04:00

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.

score 0 · Answer 8 · 2018-03-09T14:18:09-05:00

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. '

Yes. When you specifying the target for the widget control you can specify:

Empty string for current widget
* for all widgets
Widget name for some specific widget
Comma-separated string of widget names - to specify arbitrary number of widgets

Fourth case sounds like what you need.

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.

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.

score 0 · Answer 9 · 2018-03-15T04:12:54-04:00

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!