I am aware a set analysis is not the best idea, I was wandering if a peek function for expressions were existing. Basically, I want to return a value from the rates table depending on multiple criteria coming from a selection in my qvw and from fact table (but I can't allocate the FXRates table to a fact table line as I have to let the user to select which type of rate he wants to use.
Don't hesitate to ask me if I am not clear enough. It seems clear in my head but maybe not here.
My recommendation would be to solve the problem in the load script and to store the relevant Rate within the fact table. The extra memory used for it, will be well justified by the savings in the run-time calculations
I would have done that if I had not to let the possibility to the end-user to choose himself which Type (AOP/Forecast/Actual) conversion rate we would like to apply. Furthermore I need to add a variance analysis based both on value and FX Rates.
In this case, I'd load all three types (AOP/Forecast/Actual) as three fields in the Fact and use the corresponding value in the expression, based on the user selection.You can faciliate it in a number of ways - through the use of conditional expressions or using variables that hold the corresponding expression formulas.