You must perform the steps in this topic before you begin using your workbooks with Oracle Smart View for Office 11.1.2.5.200 and later.
If you are working with spreadsheets that were created and used with version 11.1.2.2.102 or earlier of Smart View, Oracle Essbase, and Oracle Hyperion Provider Services, you must complete the following steps in order to assure that row and column data aligns properly with their parent members:
Make a backup copy of your workbook.
In the Data tab of the Options dialog box, clear the Repeated Members option.
Refresh the workbook. You may refresh the entire workbook or refresh each sheet individually.
Go back to the Data tab of the Options dialog box, and select the Repeated Members option.
Perform the refresh operation again.
The workbook is ready for use with Smart View version 11.1.2.5.200 and later.