Open Dashboard using parameter

Questions & Answers
2

eazyBI have several functions to get the currently logged in user:
CurrentUser() - retrieves logged in eazyBI username
CurrentUserName() - retrieves a name of logged in eazyBI user
CurrentUserEmail() - retrieves email of logged in eazyBI user

You can create new calculated measures with any of the function as a formula and add them to a report to check the values in each of them.

You should make sure that custom cube you are creating with SQL contains any of the value (eazyBI username, email, or name) and you map this column as Key column for dimension representing users. Let’s assume you have a dimension User with level User for this.

Then you can build a calculated member in this dimension User:

Aggregate(
    IIF( IsEmpty([User].[User].getMemberByKey(CurrentUser())),
        {},
      [User].[User].getMemberByKey(CurrentUser())
      )
      )

I used a function CurrentUser you can switch to any other mentioned above that matches your imported data.

Then you can build a set of reports where you are using this dimension with this calculated member selected on Pages.

Create a dashboard with those reports. While in edit mode of the dashboard, open Pages selection of one report for this dimension and set it as a common page. Save the dashboard with these settings.

The dashboard will automatically refresh results in all reports based on logged in user.

You can also check how this work in our Demo account Project overview dashboard over Jira data for Assignee. There is common page selection in Assignee dimension Current Assignee.

Daina / support@eazybi.com

1 Like