Hello,
I have unsuccessfully tried to make Drill down parameters work from within a dashboard charting object.
The problem is related to version 2019.3.4.0 for Web.
My Dashboard comprises of a clustered column chart on the first page 'Übersicht'. Data for that chart stems from an embedded
Excel workbook. When a bar is clicked, the dashboard on the second page 'DrillDownDashboard' should open and the selected value
should be passed on to the variable VarAdressGruppe.
The variable VarAdressGruppe is used as SQL Parameter by the stored procedure which fetches the details for the table object on the second page.
This is what happens:
When a user clicks on a column, the dashboard 'DrillDownDashboard' is opened and the value chosen by the user is correctly displayed as tab name.
The parameter value however is not replaced by the current value, instead the expression itself is passed on as parameter value.
When the procedure is called like:
EXEC [dbo].[SPGetKundenPortfolio] @VarAdressGruppe
This is what the profiler shows:
exec sp_executesql N'EXEC [dbo].[SPGetKundenPortfolio] @VarAdressGruppe',N'@VarAdressGruppe nvarchar(27)',@VarAdressGruppe=N'{DSDatenA.AdressgruppeKurz}'
What is the correct way to assign the current value chosen from a chart element to a variable and use that value in a stored procedure?
The attached MRT.File DB002DefectChartDrillDown.mrt depicts the problem.
The attached screenshots depict the behavior:
Screenshot1: The clustered column chart on dashboard page 1
Screenshot2: Dashboard2 for the chosen value 'Apo'. No data is returned by stored procedure because placeholder in expression is not replaced by current value.
Screenshot3: Drill down parameter configuration for interaction of type drill down. Current value from attribute DSDatenA.AdressgruppeKurz should be passed on to VarAdressGruppeKurz.
I would be very grateful for any help.
Drill down parameters not working in Dashboard
Drill down parameters not working in Dashboard
- Attachments
-
- Screenshot3.JPG (46.35 KiB) Viewed 1463 times
-
- Screenshot2.JPG (32.99 KiB) Viewed 1463 times
-
- Screenshot1.JPG (74.31 KiB) Viewed 1463 times
-
- DB002DefectChartDrillDown.mrt
- (563.67 KiB) Downloaded 140 times
-
- Posts: 6266
- Joined: Tue Mar 20, 2018 5:34 am
Re: Drill down parameters not working in Dashboard
Hello,
That issue was fixed and will be available in the next build in the next week.
Thank you.
That issue was fixed and will be available in the next build in the next week.
Thank you.
Re: Drill down parameters not working in Dashboard
This works in Version 2019.3.5.
-
- Posts: 6266
- Joined: Tue Mar 20, 2018 5:34 am
Re: Drill down parameters not working in Dashboard
Hello
We are always glad to help you!
Thank you.
We are always glad to help you!
Thank you.