The Format Range doesnt work with the EXPAND ONLY option b/c the option ONLY cause an expansion on the axis, and does not retrieve data. Without the data, the formatting process is not applied to the query.
The GROUPEXPANSION option only applies to the use of GROUP and ENTITY dimension to build out a report for a legal consolidation process.This function only works in BPC for Microsoft.
Hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.