Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
An example of what I am trying to do is allow the user to move a slider which would impact cost or revenue and the output would be changes in margin %. The dimension is Product Group. Right now, all of the product groups (about 10 of them) are impacted from the one variable.
Does anyone know how (and if) I would be able to allow a slider (variable) to impact a specific product group instead of the entire dimension. For example, a 5% increase in cost and a 4% increase on product group B would change the total gross margin % by X%; as opposed a 5% increase in cost and a 4% increase in price across the board. I want to minimize the need for the user to have to make selections from list boxes and export the data to do additional calculations. I'm not very experienced with scripting or data models, but have been designing mostly from the user interface properties.
You can do this using variables. I have attached a similar example (with the change affecting the price of a single product) just to show you what I mean, but you could easily use margin instead.
You can do this using variables. I have attached a similar example (with the change affecting the price of a single product) just to show you what I mean, but you could easily use margin instead.
Thanks so much! So this isn't set analysis is it? It's a little different. Is the "%SelectProduct" a field from a table? is it a variable, or is it something else?
The example you provided is very helpfull, I'm going to try this.
Nope, no set analysis. To create the %SelectProduct field I created an island table in the script and added a Hide Prefix statement so that it won't show up in the Current Selections box (not necessary, just for aesthetic reasons).
Then the input box (slider for you) uses the variable vMargin to adjust the price in the expression. Let me know if you have any questions.