Pushing Dashboard Parameters to Generic Inquiry Parameters

@BenjaminCrisman  Benjamin, so is there a way to have a parameter value that is not hard coded into the widget flow to the GI?

In the example below I want the dashboard user to select the value somehow, but it appears as if the only option is to provide a value ion the widget itself.

@BenjaminCrisman This is the same topic a few weeks ago we had quite bit of conversation about it in Private Chat.

Acumatica Parameter logic in my opinion is definitely wrong. It misses a mapping table between DB Parameters and GI parameters. As a result of this bad design, it is not possible to run any GI that requires mandatory parameters.

The data flow in my opinion should be:

1. user defines the parameters in DB
2. in each widget, user have a mapping table to map each GI parameter to a DB Parameter or set an static value for it.
3. user can set additional filtering on GI same as current situation.
4. On DB widgets refresh, the engine reads the DB Parameters, passes them to GI Parameters, executes the GI and applies the additional filtering if applicable from step 3
5. Returns the processed result and displays in desired form as per widget.

I gave you a very simple example in the private chat that I copy it here:

“I need a simple column chart that compares current period Actual and Budget Revenue to the prior year equivalent period.

Let say 202301-202304 actual & budgeted revenue compared to 202201-202204 in one graph. I know I can create multiple graph for my purpose but to keep scaling the same and have a neat layout I need them in a single graph.”

if Acumatica team wants to improve on its DB I am personally ready for free consultation as it will be useful for the whole community. 
Also, that might be a good idea that @Chris Hackett as community manager in one of those quarterly/monthly sessions invite the Acumatica team and some people who have some suggestions and ideas to discuss and brainstorm on it. The DB can be much more robust and insightful.

Cheers

Hi , @Chris Hackett I have the same request. The pivot is a good tool, but in my case it’s unusable for my people without passing it a parameter.

I’ve created an idea for this, as I just encountered the same issue on some finance dashboards I’m building.  Please go and vote and add your comments here: