evdre, FormatRange doest work with ExpandOnly
Why FormatRange doest work with ExpandOnly?
And How use GroupExpansion (option in evdre)?
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.