Most RecentQuestion: Is there a way to load FX rates through a workflow? The system admin wants it to be part of their regular workflow. Is there a way to have a cross dimension lookup in a parser rule that is associated with a dimension in the Data Source? Question: How do you run a consolidation, or a force calculate, in a business rule? I’m copying data into another scenario and then want to calculate the member formulas in the account dimension. Question: Is it possible to refer in a custom translation rule to an account with flow for an FX rate?Question: How can I perform Cube View calculations against hidden columns?Question: How can I write consolidation rules to exclude parent currency adjustments? Additional detail on specific situation:What is the best approach to “subtract” members in a hierarchy, the following member filter is not returning the expected results. E#Tot_Mgmt.Remove(Houston)Question: What is best practice for business rules? Is it a better approach to attach them to the cube and run as part of the consolidation or is it better for them to run through a data management sequence?We have a cube view with 3 levels of expansion – Account, UD4 (Currency) and Entity. We would like to see the entities summed for each account, by currency.Question: Is it possible to automatically add a blank row between groups of members within reporting?
