I have a chart with Dimension grouping(Material, Customer, Plant etc) and there are expressions likes sum(OrderquantityinPieces), Sum(DeliveryQuantityinPieces), Sum(DeliveryQuantityinPieces/OrderquantityinPieces), Sum(OrderquantityinCarton),Sum(DeliveryQuantityinCarton),Sum(DeliveryQuantityinCarton/OrderquantityinCarton), Sum(OrderquantityinPallet),Sum(DeliveryQuantityinPallet),Sum(DeliveryQuantityinPallet/OrderquantityinPallet)
This looks BigTable and I want to make it Dynamic where I can select the Data based on pallet, Carton, Pieces.
I also dont want to make individual charts with Cartons, Pallets, Pieces.
Just Like I made Dimension as a cycleGroup to select the data, I want the expressions also to be dynamic and thereby reduce this bigtable to small 3 expressions like Sum(Orderquantity), Sum(DeliveryQuantity), Sum(DeliveryQuantity/Orderquantity)
correct me if I am wrong. For this solution to work after giving the value in the Inputbox, script must be reloaded to get the data. The users logging in through the accesspoint cannot do it. Hence it is not useful.
It should work fine. No reload needed. It's simply $() expansion at work. The $(vUoM) will be replaced with one of the literals Pallets, pieces or cartons. The expression will read as sum(OrderquantityinPallets) for example. No reload needed.
After implementing this, the application does work fine but after sometime whenever I am saving, it does not react and I have to close the application thru the Taskmanager and open again. It is performance wise not good.