Suppose I have application that shows order information. Initially the application was built to show information regarding when the order was placed. After the application was placed in production for a few weeks the customer decides they would also like to see the same information regarding orders but this time they want to replace “Order Date” with “Delivery Date”. To increase scalability, I would like to modify the existing app to have a Dynamic Dimension for date. I was thinking maybe a radio button for “Order Date” / “Delivery Date”. Then create an “if statement” that will set a variable to the relevant value. I would then use the generic/dynamic date variable based on the button value in my set analysis instead of the current hard coded “Order Date” (filtering on the variable field might be clunky). I suspect there might be better ways to handle this situation so I thought I would get a few other opinions before I started building. Any examples, ideas or constructive criticisms would be greatly appreciated.
