cube-js/cube

Use input values in calculated measures

Open

#1,865 opened on Jan 24, 2021

View on GitHub
 (3 comments) (0 reactions) (1 assignee)Rust (19,563 stars) (1,965 forks)batch import
backend:serverhelp wanted

Description

Is your feature request related to a problem? Please describe. I would like to use one or more user inputs in calculated measures. This will allow me to implement what-if scenarios. For example, if I have insurance liability data and evaluate liability by various dimensions based on the probability of an event occurring (e.g. earthquake), users may input a probability in percentage and measures should recalculated using this value in real-time.

Describe the solution you'd like

  1. Ability to pass custom parameters in query
  2. Availability of these parameters in server side so that they can be referenced in measure formula

Describe alternatives you've considered A clear and concise description of any alternative solutions or features you've considered.

Additional context Add any other context or screenshots about the feature request here.

Contributor guide

Tech stack
rusttypescript
Domain
backendanalytics
Issue type
feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
4
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
3-5 days
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
blocked
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
clear
Prerequisites
Cube.js basicsRust programmingQuery pipeline understanding
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
25
Research direction
Investigate how Cube's schema compiler currently handles calculated measures in the /schema compiler directory. Look at existing query parameter support in the API layer (likely in /packages/cubejs api gateway). Review comments in the issue for any design discussions. Consider proposing a design document that outlines parameter passing mechanisms and integration with measure formulas.
Use input values in calculated measures · cube-js/cube#1865 | Good First Issue