Client-side simulation and parameters values in report

[romuald_colletaz]

Hi all,

The client-side simulation feature available in P&PM reports allows us to run some What-if simulation according to parameters. We have 2 parameters country and percentage. The purpose is to simulate a percentage per country. So, the user select a country in the 1st parameter, then he defined the percentage in the 2nd parameter and finally he run the simulation. Using this approach, he can simulate different percentages per country. No issue regarding the implementation, it works fine. But, at the end, we don't know which percentage has been applied to which country.

Is there a way to write the parameters values somewhere in the report when we execute the client-side simulation?

thanks for your help,

Romuald

[zhiyitang · Accepted solution]

Hi romuald.colletaz,

One possible option would be that you store the parameter value in a dimension (char) or measure (numeric value) of a query, then use either the chart Dimension Value or Numeric Point to display these values on report canvas.

Best regards,

Zhiyi Tang

[romuald_colletaz]

Hi Akshay,

Thank you for the proposition, sounds good approach.

Finally, I've chosen to add another query to display the values of my parameters. In my use case I have 100% per country by default. So, when the user execute a simulation with a percentage for a given country, I save the value into this new query and then I apply the values saved in this query to my data.

regards,

Romuald

[akki0785]

Sure Romuald. That's also another solution. Good luck.

Regards,

Akshay Georaikar

[akki0785]

Hi Romuald,

You can have one KF in your model. put a calculation for it with addition of parameter value. Now you can have your parameter value saved and can be displayed

Hope this helps.

Cheers

Akshay

[romuald_colletaz]

Hi,

thank you for your answer. The list of values will depend on the list of managed countries. So, it should be dynamic.

I can add a dummy query which displays a 100% percentage for each country. Then, I change the values in this query according to the country and percentage simulated.

Is there a way to display a report as a table instead of a chart (with a lot of countries, t will be tricky to have an understandable chart)?

best regards,

Romuald