I'm wondering if it's possible to create a field of variables. For instance, I would make a link table with one column/field as a Client Name (which would link to the fact table), and one column containing variable names for each client. The variable values would be set in the module by input boxes or slider objects.
I want to put the variable names in a field so that I can access them dynamically in a straight table and perform calculations with the values. For instance, if I called the field "ClientVariables," I would access each value by using an expression like:
Dimension = Client Name
Expression = sum(Revenue)*ClientVariables
I think I would run into trouble with dereferencing each variable. "ClientVariables" would only contain a string value with the name of each variable, but it would need to be dereferenced to access the value inside. Is this possible?
