Running Check Reports for a BSO Essbase Cube
Before running a Check Report for an BSO Essbase cube, make sure that a fully qualified name is used to differentiate any duplicate members used within dimensions or across dimensions. To construct a fully qualified name from a duplicate member name, add the fully qualified name as a rule logic statement on the Rule Logic Add/Edit as Text screen (see Adding a Rule Logic Statement as Free Form Text). This requirement applies to Profitability and Cost Management, Financial Consolidation and Close, and Tax Reporting.
Note that a fully qualified member name comprises the duplicate member or alias name and all ancestors up to and including the dimension name. Each name must be enclosed in brackets ([ ]) and separated by a period (.). The syntax is as follows:
[DimensionMember].[Ancestors...].[DuplicateMember]
For example:
[Market].[East].[State].[New York]
[Market].[East].[City].[New York]
See Oracle® Essbase Database Administrator’s Guide.