This content has been marked as final. Show 5 replies
When refreshing a Smart View spreadsheet, the following error occurs:
Error in Grid XML: Each Dimension must be used once and only once.
The worksheet contains an Adhoc Query and comments have been added to the grid.
One or more of your comments starts with a word that is also the name of a member in your application.
When you add text to a worksheet and refresh, SmartView examines the newly added text to see whether it was your intention to extend the grid. If a member is identified, but it belongs to a dimension that is inappropriate for the column or row it is in, the error will be generated.
Remove the duplicate dimension name that was added as free form text.
hope this helps..
thanks for your message, Do you have any idea about how to find this kind of issue easily ? If system can prompt which words that will be perfect.
I do checked all my accounts and dimensions ,there do not have the duplicate labels. acutally my ad hoc report do not have any commens and input cell. it is still prompt the message.:(
Any one can help ?
Try deleting the data in the adhoc sheet and performing a refresh thereafter.
thanks your message,But actually we want to refresh all columns with only one refresh click.
I am guess some bugs for the API HypMenuVRefresh, any technical can help?