Deploy Dashboard for Kinetic with BAQ Parameter

Kinetic ERP
1

Hi,

In the classic dashboard application when there is a BAQ parameter an alert pops-up on the dashboard when it is refreshed to prompt for the parameter value.
In the Kinetic preview, a slide out appears titled BAQ parameter, but with no option to enter any values ? How can we enter the BAQ parameter in Kinetic ?

Thanks in Advance.

2

To confirm you built a classic dashboard then deployed it as a kinetic one?

3

Correct

4

Is your field in the parameter an integer type?

If so, this is a known issue reported in PRB0246228 and will be fixed in 2022.1.4. Below is the description and workaround for PRB0246228
PROBLEM DESCRIPTION:
If you have a parameter set as datatype int within a BAQ and then use that BAQ on a dashboard and deploy
that dashboard as Kinetic, the kinetic version does not list that parameter to edit it, it prompts for
parameters in general but the specific INT parameter will not be listed, unless you change the datatype
to be nvarchar. This does not happen in the assembly version

You can try this as a workaround.
Create a nvarchar parameter.
Create a nvarchar calculated field to convert the integer field to character: convert(varchar, youTable.yourField)
Then create a ‘SubQuery Criteria’ to use the parameter instead of a’Table Criteria’.
Table: Calculated
Field: Your calculated field

5

Yes Parameter is integer, I will give that a go, many thanks !

6

We have a similar scenario where once we enter the date range in the slide out for the BAQ parameter, it works but as we scroll down to view the data, the slide out keeps on displaying and wants you to re-enter the parameters. Anyone experiencing this issue that the slide out on BAQ parameters keeps on displaying as you scroll down?

7

You wou

You would think it would cache it.

A workaround is to turn off paging for the grid. Buried somewhere in the properties.

8

Which property grid would the paging be found in?

9

Data - Grid Model - Provider Model - Server Paging

10

Thanks, that worked with getting rid of BAQ parameter being popped up each time you scroll down.

1 Like
11

With huge BAQs it could be a problem. But It works ok for me with a few thousand rows.

12

Btw, that’s probably a bug, or an oversight.

I wonder if it’s been reported?