Note that the parameter of this dashboard M_Product_ID is taken from the corresponding window field, and the dashboard is refreshed every time a new record is navigated: Of course, do not forget to create the corresponding field in the window. and in Dashboard Content field you choose the dashboard configured above.in the Reference you select Dashboard Content.note the usage of Column SQL as NULL, this is to avoid the need of creating a column in the database.Then you can configure a column in the desired table (in this example M_Product): Also these kind of dashboards are not intended for the Home, so the options to Show in Dashboard and Show in Login are disabled: It is possible to show a dashboard content as a field, for this to work you need to define your dashboard content in System tenant, there is no need to pass parameters in this case as they will be discovered in the window. The resulting dashboard looks like this at home: Instead of value you can also define a query using prefix. Dashboard Parameters: pass here the dashboard parameters, this works the same as the process parameters in the same window, you can pass multiple parameters defined as name=value separated by comma.Dashboard: select here the metabase dashboard to embed.To show a metabase dashboard as a Home dashboard you need to configure a new record in the Dashboard Content window, key fields: NOTE: This option is available in release 8.2 after version For a more direct experience the dashboard can be set to open a default dashboard for the user, and prefill the parameters with defaults: The user needs to open the form, select a dashboard, and fill the parameters. The configuration above is enough for the BI Dashboard form. Is Default for User: When defined for a user, it defines if the BI Dashboard form will show this dashboard for the user by default when opened.User: If a specific user has access to this dashboard.Role: If the role has access to this dashboard, or.You can define the server and dashboards in System and give permissions in Tenant, or you can define the dashboard in the Tenant too: Then you can define the access to the dashboard per user or role. Trigger Refresh: In the BI Dashboard form defines if changing the value of this variable triggers a refresh of the dashboard.Displayed: If the parameter is displayed.Read Only: If the parameter is read-only.Default Logic: The default logic, as usual in iDempiere dictionary.Reference, Reference Key: The type of the parameter, as usual in iDempiere dictionary.DB Column Name: The internal name of the parameter, this MUST match the name of the filter configured for the dashboard, is NOT case sensitive.Sequence: Sequence to order the capture of the parameters.Name: The name of the parameter, to be shown to the user.Then you need to define the parameters of the dashboard: Bordered, Titled: If you want metabase to show a border and a title on the dashboard.Height, Width: If you want specific dimensions for the dashboard, otherwise, just leave it in zero and will use the metabase settings.Auto Refresh in Seconds: For the BI Dashboard window to auto-refresh every this configured seconds.Token Expiration in Seconds: This is a security option, how long the generated URL will be valid, a very long expiration time can expose the data on your server so is recommended to keep this low.Theme: select a theme supported by metabase.Dashboard #: The number, here is the second connection with metabase configuration, this is the dashboard ID that you took note above.Metabase Server: The server where the dashboard is found.In the window Metabase Dashboard you can configure the different dashboards that you want to embed into iDempiere: Embedding Secret Key: here you must enter the secret key that metabase generated.URL: the URL where the metabase is located (usually this must be the same server as iDempiere, see Security Considerations below).In the window Metabase Server you need to configure: You can find the menu options for Metabase in Performance Analysis > Metabase: The parameters must be marked as Locked, or Editable if they are optional.The dashboard ID is required in iDempiere.The parameter ad_client_id is ALWAYS passed, so is better to use native query questions that support parameters (as of version 0.39.2 of metabase still doesn't support variables in other types of queries, just native):Īttach the question to a dashboard, set up filters and match the filters with the question variables:Ĭonfigure embedding the dashboard in other applications, here is important to take note: This plugin integrates metabase dashboards to be shown in different parts of iDempiere:įirst you need to enable embedding in metabase, this generates a secret key that is required in iDempiere:.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |