Title: Analysis for Office

Title

Analysis for Office

Package

Digitale SAP-Bibliothek

Platform

Your learning platform for SAP software

URL

https://et.training/dashboard/product/video/753 

Status

Current

Publication Type

Other

Medium

Video

Language

First Author

Tobias Meyer

First Editor

Empty

Publisher Name

Empty

Date First in Print

Empty

Date First Online

2021-01-01

Access Start Date

Empty

Access End Date

Empty

Volume Number

Empty

Edition Statement

Empty

Access Type

Empty

Note

Installation and ConfigurationInstallation and ChecksAuthorizationsShortcut PropertiesCustomize Analysis OfficeOptionsTechnical ConfigurationCustomize User InterfaceCompany and Embedded ProfileBasic FunctionalityThe Analysis Office AddinThe Ribbon menuYour first CrosstabOpen and Save a workbookDifferent context menusSorting your dataFilter your data by memberFilter your data within hierarchiesFilter your data directly on the CrosstabFilter your data via background filterFilter your data by measureUse BEx Conditions in Analysis OfficeRankingAccess mode for filteringPrompting and VariablesAllowed and forbidden areasSwap AxesChartsHow to use InfofieldsTotalsHow to display MembersNumber Format/Currency Conversion/Scaling Factor/Zeros and Negative ValuesCreating New CellsFormat CellsCrosstab ConfigurationStylesHow to use Conditional FormattingAdvanced FunctionsHierarchiesSAP Excel FormulasUse Standard CalculationsHow to use Dynamic CalculationsCreate Advanced CalculationsCreate RestrictionsWork with Query ViewsUse the Filter PanelCreating PowerPoint SlidesUse Excel Formulas in your CrosstabReport-Report-InterfacePrompt VariantsContains PatternConvert to formulaCreate a Web ApplicationLaunch the Query DesignerUse Smart Copy and PasteGroup your Crosstab and Link DimensionsBuild Hierarchies on the flyWork with the formula-optimized modeCreate a default workbookReporting with Analysis Office API and VBAOverviewInformationWorking

Last Changed External

Empty