In Today’s session I will discuss about best practices ,tips and tricks. Let’s start one by one . 1. Proper way for report Creation : Create the report from BO launchpad Datasource not from Tcode RSRT  in SAB BW datasource/ Native hana CV. otherwise when you try to reschedule the report from CMC then it will through the error. Preferable  Method....

Microsoft Office is a commonly-used word processing suite among many companies today. if you’ve got SAP installed, you have much flexibility in combining both of these software suites into something seamless and integrated. However, configuring the systems to work together does take a bit of work. Here, we’ll run through the configuration that links Microsoft....

This blog post is on usage of two powerful Nodes namely Hierarchy function and Minus Node in HANA Calculation view. Both Nodes are available in SAP HANA 2.0 XSA and HANA cloud. Minus and Hierarchy function Node are available starting SAP HANA 2.0 SPS01 and SPS03 respectively for on premise and available in SAP HANA....

Here is the summary of what is covered in this article: Introduction and Inserting formula data source. How to define SAPGetData formulas in Analysis for office. Usage of SAPSelectMember formula in SAPGetData. Introduction and Inserting formula data source: Steps: Open Analysis for Office and login to the server (client system) Goto Insert Data Source and....

Most of the time in Analysis Office we use single query and multiple queries in multiple sheet. When two queries are used in same sheet of Analysis Office, one after another there may be a risk of overlapping of the crosstab if the data increases and we get a warning message in Analysis Office. Causing....

For quite some time now SAP Analysis for Microsoft Office, edition for SAP Analytics Cloud has been available to all SAP Analytics Cloud users for data driven spreadsheet analytics. And this is great because Analysis for Office is a great solution for this. However, the edition for SAP Analytics Cloud was missing one feature that....

Dear SAP Community, we have rolled out Analysis for Office 2.8 SP6 to a wider group of users. While doing that we gained some experience on the behavior and issues that occured while rolling out this new version. I have collected all issues and the resolution steps in order to help you in case you are....