Sitemap

• Home
• Blog
• • Datasphere
  • Analysis for Office
  • SAP BW
  • • Administration
    • BEx
    • BIP
    • BWMT
    • HANA
    • ABAP
  • .Net
  • Excel
  • • VBA
  • Design Studio
• Shop
• • Analysis for Office Book
  • ABAP Tools
  • • Transport Dependency Check
    • Query Link Components
• Archive
• • 2024
  • • February
    • January
  • 2023
  • • May
    • March
  • 2022
  • • December
    • September
    • June
    • April
    • March
    • February
    • January
  • 2021
  • • September
    • April
    • March
    • February
    • January
  • 2020
  • • December
    • November
    • October
    • September
    • August
    • July
    • June
    • April
    • March
    • February
    • January
  • 2019
  • • December
    • November
    • October
    • August
    • July
    • June
    • May
    • April
    • March
    • February
    • January
  • 2018
  • • November
    • October
    • August
    • July
    • June
    • May
    • April
    • March
    • February
    • January
  • 2017
  • • December
    • November
    • October
    • September
    • August
    • July
    • June
    • May
    • April
    • March
    • February
    • January
  • 2016
  • • December
    • November
    • October
    • September
    • August
    • July
    • June
    • May
    • April
    • March
    • February
    • January
  • 2015
  • • December
    • November
    • October
    • September
    • June
    • May
    • April
    • March
    • January
  • 2014
  • • December
    • November
    • October
    • September
• About
• Contact

Blog

• 07/16/2024 - SAP Datasphere: Dynamic previous year in an Analytic Model
• 02/28/2024 - SAP Datasphere Hierarchies like in SAP BW
• 01/04/2024 - Review 2023 and outlook
• 05/31/2023 - Consume hierachies with nodes in SAP Datasphere
• 03/08/2023 - Data Warehouse Cloud Analytic Model is released
• 12/22/2022 - Data Warehouse Cloud Analytic Model
• 09/21/2022 - Custom Slide Shows in Microsoft PowerPoint
• 06/05/2022 - Analysis for Office 2.8 SP14 is available
• 04/19/2022 - Using SAP Data Warehouse Cloud bridge to convert SAP BW 7.4 objects
• 03/29/2022 - Create a parent-child hierarchy in SAP Data Warehouse Cloud
• 02/15/2022 - Another MTD/WTD/QTD/YTD calculation in SAP Data Warehouse Cloud
• 01/22/2022 - MTD/QTD/YTD Calculation in SAP Data Warehouse Cloud
• 01/06/2022 - Analyze Apple Health data with Python
• 09/13/2021 - Comparing of data flows through SAP landscape
• 04/16/2021 - Analysis for Office 2.8 SP8 is available
• 03/23/2021 - Data Warehouse Cloud: Restrict Data Access in Hierarchies
• 02/08/2021 - Authorizations with Data Access Control in SAP Data Warehouse Cloud
• 01/28/2021 - Create a time hierarchy in SAP Data Warehouse Cloud
• 01/19/2021 - BW/4HANA Query Link Components
• 12/08/2020 - BW/4HANA XXL InfoObjects
• 11/30/2020 - SAP Analysis for Office 2.8 SP6 is available
• 11/05/2020 - BW/4HANA 2.0 Composite Provider with InfoObject Join
• 10/16/2020 - Analysis Office 2.8 SP5 is available
• 10/08/2020 - BW/4HANA 2.0 Agile Open ODS View Modeling
• 10/03/2020 - BW/4HANA 2.0 Composite Provider Modeling
• 09/28/2020 - SAP HANA Calculation View Documentation
• 08/06/2020 - BW/4HANA: Customer Exit Variable with dynamic assignment
• 07/14/2020 - BW/4HANA 2.0 Customer Exit Variables with own enhancement spot
• 07/08/2020 - BW/4HANA 2.0 first impressions
• 07/02/2020 - Analysis Office Video Course is done
• 06/08/2020 - Analysis Office 2.8 SP3 is available
• 04/21/2020 - Analysis Office Video Course
• 04/20/2020 - Analysis Office: Time Dependent Hierarchies
• 04/03/2020 - What's new in Analysis Office 2.8 SP2
• 03/31/2020 - SAP Transport Dependency Check
• 03/30/2020 - Analysis Office 2.8 SP2 is available
• 03/18/2020 - Get Analysis Office - The Comprehensive Guide
• 02/18/2020 - Analysis Office Dimension Grouping
• 01/27/2020 - Analysis Office Show medium text in prompt filter
• 01/21/2020 - SAP Analysis for Office - The Comprehensive Guide 5th edition is available
• 12/03/2019 - What's new in Analysis Office 2.8
• 12/02/2019 - Analysis Office 2.8 is available
• 11/28/2019 - Analysis for Office Filter multiple hierarchy nodes
• 10/25/2019 - Decode an Analysis Office Workbook
• 10/24/2019 - Analysis Office - The Comprehensive Guide
• 10/02/2019 - Analysis Office 2.7 SP8 is available
• 08/27/2019 - Aleksandra
• 08/16/2019 - Analysis Office - The Comprehensive Guide Discount Code
• 08/15/2019 - What's new in Analysis Office 2.7 SP7
• 08/06/2019 - SAP BW F4 BAdI to restrict hierarchy nodes
• 07/09/2019 - Analysis Office Size Limit of result set exceeded with small query
• 06/06/2019 - Analysis Office 2.7 SP6 is available
• 05/08/2019 - SAP BW fix incorrect data in a DataStore-Object
• 04/08/2019 - SAP HANA Table Functions
• 03/25/2019 - Analysis Office 2.7 SP5 is available
• 03/04/2019 - Customer exit variable to hide hierachy node
• 02/07/2019 - Analysis Office 2.7 SP4 is available
• 01/13/2019 - Analysis Office - The Comprehensive Guide 4th edition
• 01/03/2019 - Analysis Office 2.7 SP3 is available
• 11/26/2018 - SAP Business Warehouse DTP Filter with ABAP Routine
• 11/22/2018 - Analysis Office 2.7 - Data Source for Defining Formulas Part 2
• 11/06/2018 - What's new in Analysis Office 2.7 SP2
• 10/25/2018 - Analysis Office 2.7 SP2 is available
• 08/07/2018 - Analysis Office 2.7 SP1 is available
• 07/31/2018 - Analysis Office Launching Workbooks from BIP with variables
• 07/23/2018 - SAP BW Reset request/task status
• 07/16/2018 - Analysis Office Data Source for Defining Formulas
• 06/18/2018 - SAP HANA Calculation View to build virtual keyfigure
• 06/14/2018 - What's new in Analysis Office 2.7
• 05/28/2018 - What's new in Analysis Office 2.6 SP3
• 05/18/2018 - Analysis Office 2.6 SP3 is available
• 05/08/2018 - SAP BW Assign navigation attribute to InfoObject
• 05/08/2018 - Book about BW Backend tips & tricks
• 05/03/2018 - BW Modeling Tools: Create a CompositeProvider
• 04/09/2018 - SAP Analysis Office Book is available
• 04/03/2018 - What's new in Analysis Office 2.6 SP2
• 03/23/2018 - Analysis Office 2.6 SP2 is available
• 03/19/2018 - Analysis Office Restrictions
• 02/07/2018 - What's new in Analysis Office 2.6 SP1
• 02/06/2018 - SAP BW Decode String during Import
• 02/02/2018 - Analysis Office 2.6 SP1 is available
• 01/12/2018 - SAP BW Create own reversal entry
• 12/27/2017 - Analysis Office Filter by Member Attribute
• 12/12/2017 - SAP BW: Keyfigure to Account Model
• 12/11/2017 - Analysis Office 2.6 is available
• 11/20/2017 - Analysis Office 2.5 SP2
• 11/20/2017 - What's new in Analysis Office 2.6
• 11/08/2017 - SAP BW Use Pattern in Variable with Customer Exit
• 10/17/2017 - Analysis Office 2.5 - Technical Configuration
• 10/04/2017 - Analysis Office 2.5 DataSource Information
• 09/26/2017 - Analysis Office 2.5 Scaling Factor
• 09/19/2017 - Analysis Office 2.5 is available
• 08/21/2017 - Analysis Office 2.5 & AMDP
• 07/21/2017 - Design Studio Mobile Application
• 06/21/2017 - BW/4HANA Export Transports
• 06/07/2017 - Analysis Office 2.4 SP3 is released
• 05/29/2017 - BW Modeling Tools create advanced DataStore-Object
• 05/16/2017 - Install your own SAP BW on a virtual machine
• 05/11/2017 - Analysis Office - The Comprehensive Guide 2nd edition
• 05/01/2017 - Analysis Office Video Course
• 04/18/2017 - SAP BW Performance optimization for mass data without SAP HANA
• 04/13/2017 - SAP BW Visio Shapes
• 04/05/2017 - SAP BW Copy Queries to a new MultiProvider
• 03/27/2017 - SAP BW Analysis Process Designer (APD)
• 03/20/2017 - SAP BW Check your data model
• 03/13/2017 - Analysis Office 2.4 SP2 is released
• 03/06/2017 - SAP BW find meta chain
• 02/27/2017 - SAP BW Change Object Directory Entries
• 02/20/2017 - Analysis Office Get Calendar Week for SAPSetFilter
• 02/13/2017 - Analysis Office Hide Customize User Interface
• 02/06/2017 - SAP Analysis for Office Insert Product Image
• 01/30/2017 - SAP Analysis for Office 2.4 Table Design features
• 01/24/2017 - SAP Analysis for Office 2.4 SP1 is available
• 01/23/2017 - SAP BW Transport of Copies
• 01/16/2017 - SAP BW Create SPO via BAdI - Part 3
• 01/09/2017 - SAP BW Create SPO via BAdI - Part 2
• 01/02/2017 - SAP BW Create SPO via BAdI - Part 1
• 12/27/2016 - BW Modeling Tools add a new project
• 12/19/2016 - SAP Analysis for Office 2.4 Workbook Protection and Styles
• 12/12/2016 - SAP Analysis for Office 2.4 File System Settings
• 12/06/2016 - Setup BW/4HANA on Amazon AWS
• 12/05/2016 - Open documents from BI platfrom with .Net
• 12/01/2016 - SAP Analysis for Office 2.4 Customize User Interface
• 11/29/2016 - What's new in SAP Analysis for Office 2.4
• 11/28/2016 - Analysis Office - The Comprehensive Guide
• 11/28/2016 - Access BI platform with a .Net Application
• 11/24/2016 - Install BI Platform and setup Windows AD authentication
• 11/21/2016 - How to build a RFC Server with NCo 3.0 Part 2
• 11/14/2016 - Design Studio Import & Export Application
• 11/10/2016 - BW Modeling Tools
• 11/07/2016 - SAP Design Studio Update Extension
• 11/06/2016 - Design Studio setting up Eclipse
• 10/18/2016 - Migrating Analysis Office workbooks from BW to BI Platform
• 10/10/2016 - SAP Analysis for Office SAPInsertLine
• 10/05/2016 - SAP Analysis for Office Excel formula video
• 10/04/2016 - SAP Analysis for Office Cancel long-running Queries
• 09/30/2016 - SAP Analysis for Office - The Comprehensive Guide
• 09/27/2016 - Using SAPGetVariable with VBA
• 09/20/2016 - Design Studio SDK installation
• 08/15/2016 - Design Studio Settings
• 08/10/2016 - Settings for the Analysis for Office Plug-in
• 07/25/2016 - Analysis for Office Infofields, formulas & Dashboard functions
• 07/19/2016 - Design Studio crashes during start
• 07/11/2016 - Analysis for Office Filter Data by Member
• 07/04/2016 - Analysis for Office Workbook vs. DataSource Variants
• 06/27/2016 - Analysis for Office Variable Operator Contains Pattern
• 06/21/2016 - Error while executing function module BICS_PROV_OPEN
• 06/13/2016 - Analysis for Office Table Design, API and Design Rules
• 06/07/2016 - BEx Query Designer: No Authorization for Query
• 06/03/2016 - Analysis for Office SAPOpenWorkbook
• 06/01/2016 - Design Studio 1.6 SP2
• 05/30/2016 - BEx Query Average vs. Excel Average
• 05/25/2016 - Analysis for Office 2.3 features
• 05/24/2016 - Analysis for Office 2.3 is available
• 05/17/2016 - Analysis for Office Save Query View
• 05/09/2016 - Analysis Office Data Analysis Advanced Calculations
• 05/02/2016 - Change Requests after release
• 04/15/2016 - Process Chain Change Process Type
• 04/05/2016 - Analysis for Office Logoff
• 04/04/2016 - Design Studio Install Extension on BI Platform
• 03/09/2016 - Design Studio Application Print
• 03/07/2016 - Design Studio Preferences
• 03/07/2016 - Analysis for Office 2.2 SP2 is available
• 03/04/2016 - How to build a RFC Server with NCo 3.0 Part 1
• 02/29/2016 - Sum many ranges with ALT=
• 01/26/2016 - .Net Error Interop type cannot be embedded
• 01/15/2016 - Support SAP Connector for Microsoft .Net (NCo)
• 01/06/2016 - Rename and delete an Analysis for Office Workbook
• 12/18/2015 - Video How to maintain Master Data in SAP 7.4 
• 12/08/2015 - Analysis for Office: How to work with Excel formulas
• 11/19/2015 - Analysis for Office: Best Practice Connection
• 11/12/2015 - Analysis for Office 2.1 Logoff via VBA
• 10/19/2015 - Analysis for Office Goto ala BEx Query
• 10/15/2015 - Analysis for Office Addin crashes
• 10/07/2015 - Enable Analysis for Office Addin
• 09/26/2015 - SAP Analysis for Office filter multiple items
• 09/22/2015 - SAP Analysis for Office DataSource Info Field
• 09/18/2015 - One further Excel Dashboard Example
• 09/17/2015 - Create simple Excel Dashboards
• 06/02/2015 - SAP BW find orphaned workbooks
• 05/26/2015 - Relocation of OLAP functions on SAP HANA
• 04/28/2015 - How to convert a text field into a date field with VBA
• 04/23/2015 - Analysis for Office Increase data cells
• 03/26/2015 - SAP BW hierarchy and attribute change run for all InfoObjects
• 03/10/2015 - SAP BW 7.4 Maintain characteristics 
• 03/04/2015 - SAP COPA keyfigure assignment
• 03/02/2015 - Define SAP COPA key figure schemes
• 01/14/2015 - Remove BW Query from user favorites
• 01/12/2015 - Explosion of structured items 2LIS_03_BF
• 01/09/2015 - Create own Excel formula
• 01/08/2015 - Delete VBA array content
• 01/02/2015 - Factors affecting the performance of the BEx Analyzer
• 12/30/2014 - SAP BW ABAP remove symbols
• 12/23/2014 - Infoset throws dump while checking or activating
• 12/22/2014 - Display SAP Minus keyfigures correct in Excel
• 12/17/2014 - Define default Workbook in Analysis Office
• 12/16/2014 - Overview SAP Business Objects tools
• 12/11/2014 - Change key figures of an used InfoProvider
• 12/09/2014 - Unlock InfoObjects in Business Warehouse
• 12/05/2014 - Connecting error in Analysis for Office
• 12/04/2014 - Unlock Business Warehouse database lock
• 12/03/2014 - SAP Analysis for Office function undo
• 12/01/2014 - Replicate SAP BW DataSource
• 11/25/2014 - SAP BW Query Read Mode
• 11/18/2014 - Open a BEx workbook via VBA
• 11/08/2014 - Load VBA code from a text file
• 10/23/2014 - Start a Process Chain by VBA
• 10/22/2014 - How to use a remote enabled function module in SAP BW with VBA
• 09/15/2014 - List of all SAP BW Users
• 09/12/2014 - SAP BW Authorization check
• 09/05/2014 - Activate all inactive transformations
• 09/05/2014 - How to check the InfoCube scheme
• 09/04/2014 - Connecting via VBA to a SAP system