Select Data Ð PivotTable and PivotChart Report… to access the PivotTable and PivotChart wizard.ģ. Open an empty Excel spreadsheet by selecting Start Ð All Programs Ð Microsoft Office Ð Microsoft Excel.Ģ. Importing the Cube into Microsoft Excelġ. Select File Ð Exit to close the SAS Management Console. Select File to close the OrionStar Propertiesġ1. Select the PUBLIC group, then click on the check box to grant this group Read permission.ġ0. Select the Authorization tab in the OrionStar Properties window.ĩ. Right-click the OrionStar cube and select Properties from the pop-up menu.Ĩ. Expand Authorization Manager in the Navigation Tree.ħ.
#Olap cube excel password#
Login using the BIArchitecture metadata profile and the username and password provided by the instructor.Ģ.
These permissions are granted using sas management console.ġ.Select Start Ð All Programs Ð SAS Ð SAS Management Console to invoke the SAS Management Console. Permissions must be added manually for the desired group of users to be able to display the cube data. While the metadata about the cube is available to all users by default, the data in the cube itself is not.
#Olap cube excel how to#
This section shows how to use Microsoft Excel to view a sas olap cube.
#Olap cube excel windows#
Overview of SAS Business Intelligence Windows Client Tools.SAS Business Intelligence Platform Overview - SAS BI.SAS OLAP Cube Studio Interface - SAS BI.An Overview of SAS Stored Processes - SAS BI.Working with OLAP Cubes in SAS Enterprise Guide.Creating a Stored Process from a SAS ETL Studio Job - SAS BI.New Features of SAS Enterprise Guide 3 - SAS BI.Exploring SAS Enterprise Guide - SAS BI.Using the SAS Stored Process Manager - SAS BI.Overview of the SAS Add-In for Microsoft Office - SAS BI.Using the SAS Add-In for Microsoft Office - SAS BI.Overview of the SAS Information Map Studio - SAS BI.Using SAS Information Map Studio - SAS BI.Overview of SAS Web Report Studio - SAS BI.Overview of the SAS Information Delivery Portal - SAS BI.Using the SAS Information Delivery Portal - SAS BI.Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback. ObjNewSheet.Cells(intRow, 1).Value = objPF.Caption
This example creates a list of all the PivotTable field names used in the first PivotChart report. Return valueįor Online Analytical Processing (OLAP) data sources, there are no hidden fields, and the object or collection that's returned reflects what's currently visible. SyntaxĮxpression An expression that returns a CubeField object. This collection contains all PivotTable fields, including those that aren't currently visible on-screen.