| Print Open PDF Version of Online Help

### Viewing SQL Code in the Advanced Tab in Analytics The Advanced tab in the analysis editor shows the SQL code that is submitted to the Oracle BI server when the analysis is executed. Viewing the SQL code can help you to troubleshoot possible issues in an analysis. The Advanced tab is available only if your user role has one of the following privileges: Manage Custom Reports Manage Personal Reports If your user role has the Cross-Subject Areas Analytics privilege, then you can also use the Advanced tab to enable the dimensionality variable in the SQL code for an analysis that combines two or more subject areas. The dimensionality variable enables the query to return the total value for all of the selected measures in the dimensions. For more information about combining multiple subject areas in an analysis, see Combining Multiple Subject Areas in a Single Analysis.

Published 5/23/2022 | Copyright © 2005, 2022, Oracle and/or its affiliates. Legal Notices.