Writeback ValQ data using Microsoft Flow

ValQ
September 20, 2019

One of the key features in ValQ is the ability to writeback your scenario and simulation data to a database.

In this blog, we will use the writeback option in ValQ to post the data to a URL, whose flow can be processed further as per our preference. In our example, we will use Microsoft Flow to process this information and update a database.

ValQ lets you utilize the writeback feature in just 3 steps.

Writeback ValQ data using Microsoft Flow

1. Configure your writeback URL in ValQ

For this example, we have set up Microsoft Flow (see visual) to writeback the data to our SQL database.

Once the flow is setup – copy its URL, paste it under ValQ (Design mode) -> General -> Writeback, and click ‘Save’.

2. Simulate and create ValQ scenarios

Firstly, you may want to ensure that you have the Key Inputs and KPIs defined in the model. ValQ provides you the option to writeback the data of entire model or just the Key Inputs and KPIs.

You can now run your simulations and create relevant scenarios with ease using ValQ.

3. Writeback the scenarios

Once the scenarios and simulations are ready, click on the ‘Writeback’ icon at the top of the navigation panel.

After clicking, the Writeback Options’ box allows you to choose the Scenarios and Nodes (All or KPIs + Key Inputs) that you would like to capture.

After making the selection, click ‘Submit’.

A message saying ‘Scenarios posted successfully’ at the bottom-right of the canvas confirms the successful writeback of your data into the database.

To learn more, tune into one of our ValQ Webinars or try our product for free here.

Get ValQ brochure

Discover the incredible power of dynamic and collaborative business planning with ValQ
Download now

Visualize and analyze business outcomes with ease

Discover how ValQ delivers agile, interactive and intuitive business planning.
Request a Demo

Get ValQ brochure

Discover the incredible power of dynamic and collaborative business planning with ValQ
Download now

Visualize and analyze business outcomes with ease

Discover how ValQ delivers agile, interactive and intuitive business planning.
Request a Demo
ValQ
About ValQ!
ValQ empowers analysts, executives and decision-makers across departments and functions. Model any business scenario in minutes, build complex business plans, what-if simulations, create & compare budgets, forecasts and scenarios – all within Microsoft Power BI. The product is developed by Lumel Technologies (formerly Visual BI), which has a decade of experience in building add-on solutions on top of BI platforms (SAP BI and Power BI) with our suite of innovative products such as xViz and Inforiver.

Headquarters

5920 Windhaven Pkwy, #130
Plano TX 75093
Inforiver
xViz
cross linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram