# Query Parameters for Dynamic Dimensions, Measures, and more **URL:** \ **Category:** Feature Suggestions\ **Tags:** prioritized, aml, query-parameter\ **Created:** [January 22, 2022, 3:40pm UTC](https://community.holistics.io/t/query-parameters-for-dynamic-dimensions-measures-and-more/686 "2022-01-22T15:40:58Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![anthonytd](https://community.holistics.io/user_avatar/community.holistics.io/anthonytd/32/374_2.png) [@anthonytd](https://community.holistics.io/u/anthonytd)\ **Post date:** [January 22, 2022, 3:40pm UTC](https://community.holistics.io/t/query-parameters-for-dynamic-dimensions-measures-and-more/686/1 "2022-01-22T15:40:58Z")
> **Update** : See upcoming feature announcement of [Dynamic Models](https://community2.holistics.io/t/upcoming-launch-dynamic-models-aka-query-parameters/1341). ### Problems and Use-cases Dynamically modifying the query result returned from data exploration according to dashboard input. Use-cases - [How to dynamically change column that is used for a measure based on a filter/parameter](https://community2.holistics.io/t/how-to-dynamically-change-column-that-is-used-for-a-measure-based-on-a-filter-parameter/678) - [More Control on Dashboard Date Filters - Feature Suggestions](https://community2.holistics.io/t/more-control-on-dashboard-date-filters/706/2) - [Accepting user input variables in reports in 2.7 / 3.0](https://community2.holistics.io/t/accepting-user-input-variables-in-reports-in-2-7-3-0/495) - Create Reusable Fitler Group - [Reusable filters - aka filtergroups](https://community2.holistics.io/t/reusable-filters-aka-filtergroups/705) - [More Control on Dashboard Date Filters](https://community2.holistics.io/t/more-control-on-dashboard-date-filters/706/6) - Dynamic revenue value and format based on the currency Filter - Dynamic schemas - Dynamic data source - Set parameters dynamically via user attributes - etc. ### Proposed Solution: Query Parameter Allow Admins/Analysts to define parameters that can inject a value to SQL/AML and dynamically change the output of the queries. 1. Define a Query Parameter in a Data Model (or an AML project - TBD) with a set of allowed values 2. Inject the Query Parameter to AML objects such as Dimension, Measure, Business Calculation, etc. 3. Create a Query Parameter Filter in dashboards or visualizations to allow data consumers to change the query results according to the selected filter value _This feature is under the discovery phase and highly prioritized. We are looking for more feedback and use-cases from the community, please don’t hesitate to share them below_ ---
**Author:** ![Alex\_H](https://community.holistics.io/user_avatar/community.holistics.io/alex_h/32/357_2.png) [@Alex\_H](https://community.holistics.io/u/Alex_H)\ **Post date:** [January 22, 2022, 9:22pm UTC](https://community.holistics.io/t/query-parameters-for-dynamic-dimensions-measures-and-more/686/2 "2022-01-22T21:22:08Z")
Fantastic to hear this is highly prioritised. Would also be good to be able to set parameters dynamically via user attributes. ---
**Author:** ![anthonytd](https://community.holistics.io/user_avatar/community.holistics.io/anthonytd/32/374_2.png) [@anthonytd](https://community.holistics.io/u/anthonytd)\ **Post date:** [January 23, 2022, 3:41pm UTC](https://community.holistics.io/t/query-parameters-for-dynamic-dimensions-measures-and-more/686/3 "2022-01-23T15:41:42Z")
> [@Alex\_H](#): > > Fantastic to hear this is highly prioritised. Would also be good to be able to set parameters dynamically via user attributes. Oh yeah, thanks for the suggestion, almost forgot about the user attributes, just added to the potential use-case 👌 ---
**Author:** ![Abdel](https://community.holistics.io/user_avatar/community.holistics.io/abdel/32/299_2.png) [@Abdel](https://community.holistics.io/u/Abdel)\ **Post date:** [February 6, 2022, 11:42pm UTC](https://community.holistics.io/t/query-parameters-for-dynamic-dimensions-measures-and-more/686/4 "2022-02-06T23:42:41Z")
Hi, Would this be also appliccable for switching between datasource schema’s, based on the user attribute? See example AML below with the schema parameter ```auto Model model_name { type: 'table' label: "Model Label" data_source_name: 'data_source_name' table_name: '"{{@schemaparam}}"."table_name"' } ``` ---
**Author:** ![anthonytd](https://community.holistics.io/user_avatar/community.holistics.io/anthonytd/32/374_2.png) [@anthonytd](https://community.holistics.io/u/anthonytd)\ **Post date:** [February 7, 2022, 2:08am UTC](https://community.holistics.io/t/query-parameters-for-dynamic-dimensions-measures-and-more/686/5 "2022-02-07T02:08:46Z")
> [@Abdel](#): > > Would this be also appliccable for switching between datasource schema’s, based on the user attribute? See example AML below with the schema parameter Yeah, it should be, can call it dynamic schema ---
**Author:** ![Abdel](https://community.holistics.io/user_avatar/community.holistics.io/abdel/32/299_2.png) [@Abdel](https://community.holistics.io/u/Abdel)\ **Post date:** [February 7, 2022, 6:44pm UTC](https://community.holistics.io/t/query-parameters-for-dynamic-dimensions-measures-and-more/686/6 "2022-02-07T18:44:32Z")
@anthonytd, Is this feature available to be activated on our account or not yet? ---
**Author:** ![huy](https://community.holistics.io/user_avatar/community.holistics.io/huy/32/390_2.png) [@huy](https://community.holistics.io/u/huy)\ **Post date:** [February 14, 2022, 4:57am UTC](https://community.holistics.io/t/query-parameters-for-dynamic-dimensions-measures-and-more/686/7 "2022-02-14T04:57:00Z")
Hi Abdel, not yet. As mentioned in the original post, this feature is still under research & development. ---
**Author:** ![DataGeekDude](https://community.holistics.io/user_avatar/community.holistics.io/datageekdude/32/430_2.png) [@DataGeekDude](https://community.holistics.io/u/DataGeekDude)\ **Post date:** [July 19, 2022, 1:36pm UTC](https://community.holistics.io/t/query-parameters-for-dynamic-dimensions-measures-and-more/686/8 "2022-07-19T13:36:28Z")
Can I check in regards to this feature, will this allow URL query params to be passed to a dashboard/report so that you can created dynamic links to a dashboard and have it pre-filtered? ---
**Author:** ![di.hoang](https://community.holistics.io/user_avatar/community.holistics.io/di.hoang/32/421_2.png) [@di.hoang](https://community.holistics.io/u/di.hoang)\ **Post date:** [July 21, 2022, 5:46am UTC](https://community.holistics.io/t/query-parameters-for-dynamic-dimensions-measures-and-more/686/9 "2022-07-21T05:46:03Z")
Hi @DataGeekDude, This feature only allows admins/analysts to inject a value to SQL/AML and dynamically change the output of the queries. So I’m afraid that it’s not what you’re looking for. Btw, I found that you’ve created another topic for your request here: [URL Filter Parameters to filter a dashboard dynamically right away](https://community2.holistics.io/t/url-filter-parameters-to-filter-a-dashboard-dynamically-right-away/753). Did Khai’s answer help solve your case? ---
**Author:** ![DataGeekDude](https://community.holistics.io/user_avatar/community.holistics.io/datageekdude/32/430_2.png) [@DataGeekDude](https://community.holistics.io/u/DataGeekDude)\ **Post date:** [July 21, 2022, 7:50am UTC](https://community.holistics.io/t/query-parameters-for-dynamic-dimensions-measures-and-more/686/10 "2022-07-21T07:50:42Z")
Yes Khai’s answer did, I guess I was wondering if this was partly the `fstate` parameters that he mentioned in the post or if that is still to be implemented? ---
**Author:** ![di.hoang](https://community.holistics.io/user_avatar/community.holistics.io/di.hoang/32/421_2.png) [@di.hoang](https://community.holistics.io/u/di.hoang)\ **Post date:** [July 21, 2022, 8:15am UTC](https://community.holistics.io/t/query-parameters-for-dynamic-dimensions-measures-and-more/686/11 "2022-07-21T08:15:43Z")
Hi @DataGeekDude this feature won’t cover the `fstate` param that Khai mentioned in your post. At the moment, both features are still under research; however, they are highly prioritized in our roadmap. We’ll let you know when we start implementing them 😊 ---
**Author:** ![DataGeekDude](https://community.holistics.io/user_avatar/community.holistics.io/datageekdude/32/430_2.png) [@DataGeekDude](https://community.holistics.io/u/DataGeekDude)\ **Post date:** [July 21, 2022, 9:53am UTC](https://community.holistics.io/t/query-parameters-for-dynamic-dimensions-measures-and-more/686/12 "2022-07-21T09:53:09Z")
Ah ok, thanks for letting me know! ---
**Author:** ![Gabriel](https://community.holistics.io/letter_avatar_proxy/v4/letter/g/9de0a6/32.png) [@Gabriel](https://community.holistics.io/u/Gabriel)\ **Post date:** [October 18, 2022, 3:14pm UTC](https://community.holistics.io/t/query-parameters-for-dynamic-dimensions-measures-and-more/686/13 "2022-10-18T15:14:24Z")
Is it possible to get an ETA on this feature? I have a bunch of use cases that depend on this and I would like to know if its worth investing time into alternative solutions. ---
**Author:** ![huy](https://community.holistics.io/user_avatar/community.holistics.io/huy/32/390_2.png) [@huy](https://community.holistics.io/u/huy)\ **Post date:** [October 19, 2022, 3:57am UTC](https://community.holistics.io/t/query-parameters-for-dynamic-dimensions-measures-and-more/686/14 "2022-10-19T03:57:04Z")
We’ve started the Research phase for this functionality Gabriel. But just to make sure, could you share your specific use cases so that we know if we’re building will fit with what you have in mind? ---
**Author:** ![Gabriel](https://community.holistics.io/letter_avatar_proxy/v4/letter/g/9de0a6/32.png) [@Gabriel](https://community.holistics.io/u/Gabriel)\ **Post date:** [October 26, 2022, 2:33pm UTC](https://community.holistics.io/t/query-parameters-for-dynamic-dimensions-measures-and-more/686/15 "2022-10-26T14:33:42Z")
Most pressingly for me would be the ability to “segment” users for the Retention Heatmap / Cohort visualization, which right now requires me to pre-aggregate on various user attributes and is neither sustainable nor elegant. Passing through a dashboard filter to a query model’s WHERE clause would solve this issue. The same could be solved if it were possible to build the Retention Heatmap / Cohort visualization with more dynamic inputs (SUM(x) as cohort size etc.) - but that’s a different topic. ---
**Author:** ![huy](https://community.holistics.io/user_avatar/community.holistics.io/huy/32/390_2.png) [@huy](https://community.holistics.io/u/huy)\ **Post date:** [October 28, 2022, 7:40am UTC](https://community.holistics.io/t/query-parameters-for-dynamic-dimensions-measures-and-more/686/16 "2022-10-28T07:40:17Z")
Well noted Gabriel. That’s exactly the use case that this functionality would solve. As shared we’re in the research and design phase for this functionality at the moment. I hope to share some specification with you when we get to something concrete. ---
**Author:** ![mabr](https://community.holistics.io/user_avatar/community.holistics.io/mabr/32/407_2.png) [@mabr](https://community.holistics.io/u/mabr)\ **Post date:** [December 14, 2022, 8:14am UTC](https://community.holistics.io/t/query-parameters-for-dynamic-dimensions-measures-and-more/686/17 "2022-12-14T08:14:33Z")
I have another use case for you @huy: We want to make a dashboard for financial “What If” analysis. Say we have a dashboard with a pivot table with our actual P&L results and our forecasted results for the next years. I would then like to use parameters to control for an x% increase or decrease to some metric and how that affects our results. If I had a parameter, where I could set it to a 5% drop I could then inject that into my measure and all other measures, that depend on it. This is something that I am currently trying to solve as we have hundreds different excel spreadsheets with different variations today, and it is very hard to manage. ---
**Author:** ![huy](https://community.holistics.io/user_avatar/community.holistics.io/huy/32/390_2.png) [@huy](https://community.holistics.io/u/huy)\ **Post date:** [December 14, 2022, 10:58am UTC](https://community.holistics.io/t/query-parameters-for-dynamic-dimensions-measures-and-more/686/18 "2022-12-14T10:58:59Z")
Thanks for the additional use cases Martin. We’re starting the implementation for this feature. We will share more updates later this month on this. ---
**Author:** ![huy](https://community.holistics.io/user_avatar/community.holistics.io/huy/32/390_2.png) [@huy](https://community.holistics.io/u/huy)\ **Post date:** [December 21, 2022, 8:25am UTC](https://community.holistics.io/t/query-parameters-for-dynamic-dimensions-measures-and-more/686/19 "2022-12-21T08:25:35Z")
Hi all, we’re making an early announcement of the feature here to make sure it aligns with our users’ expectations. Please see the announcement here: > [@Launched: Dynamic Models (aka Query Parameters)](https://community2.holistics.io/t/upcoming-launch-dynamic-models-aka-query-parameters/1341): > > Note: This is an early feature launch announcement, meaning the feature is still in development. We make this announcement early to gather feedback and make sure what we build actually helps solve our users’ use cases. Holistics is currently working on a significant improvement to our Modeling layer called “Dynamic Models” ([feature request](https://community2.holistics.io/t/query-parameters-for-dynamic-dimensions-measures-and-more/686/19)). This feature allows analysts to define reports that can take user inputs, and inject them directly into a model/report definition. This feature is current…