Day: April 4, 2018

With the introduction of Mule 4, there are many new features available to use. One among them is “Try Scope.” If you have a Java background, you will be familiar with this term. In Java, a try block is used to enclose the code which has the possibility of being an exception, so that it can be handled without breaking the whole code.

Similarly, this feature is now enabled in Mule 4. Instead of creating a new flow to create specific error handling protocols for each component, we can put our component in the try block. A try scope wraps one or more event processors, then catches and handles any exceptions that might be thrown by any of these enclosed event processors. The behavior is as if you extracted those enclosed event components into a separate flow with its own error handling strategy, but inline, without having to actually define a new flow. https://goo.gl/gv9sYi #DataIntegration #ML

In 1711 release, SuccessFactors introduced the functionality of workflow email customization. Using this functionality, we can trigger mass email communication to employees for different purpose.

We will use custom MDF & Workflow email customization functionality to trigger mass email. For my demo purpose I have used two different scenarios.

* System unavailability due to Cut-over activity.
* System unavailability due to SF quarterly release.

Let’s See how to configure it:

Step 1: Create Document Generation Templates.

Sample Template for Cut-over:

Sample Template for Release:

Step 2: Create Workflow Group. Here add the recipients to whom you want to send communication email. In the below group I have added two employees.

Step 3: Create Workflows.

Sample Workflow for Cut-over:

Sample Workflow for Release:

Step 4: Create MDF, the driver of the email trigger. I have created very simple MDF. Based on your requirement you can add other fields in the MDF.

Step 5: Create Rule to trigger workflow for different scenarios.

Sample rule: 

Step 6: Assign the rule in the MDF Save Rules.

All set. Let’s trigger mass email communication.

Go to Manage Data and create/edit the custom MDF record.

1st I am triggering mass email for Cut-over Activity. Hence from the MDF record drop down I am selecting “Outage due to cut-over.” The drop-down was configured in the MDF ( Pick list).

Save the Data & it will trigger mass email.

Sample Email:

In the same way I have triggered email for system unavailability due to release.

Sample Emails:

So don’t wait. If client wants offer this functionality to them.

  http://bit.ly/2EiOCrk #SAP #SAPCloud #AI

The other week I presented this at SAP Insider BI HANA 2018.  I received several emails from attendees asking for the videos I showed, so I uploaded them to YouTube (without sound) so I will show below with some instruction:

Source: SAP/SAP Insider

You can consume native SAP Analytics Cloud models in SAP Analysis Office.

Below is a video comparing the results from SAP Analytics Cloud to SAP Analysis for Office

Comparing SAP Analytics Cloud Story and Consuming Cloud Native Model in Analysis Office

Source: SAP/SAP Insider

Access to support modes including  client profiling statistics, etc

In case of issues, you can record some statistic for SAP Support

Support Mode includes ABAP trace, NCO display MDX query (EPM)

Profiling Mode includes client profiling, EPM profiling

Advanced Mode includes custom choice of individual settings

SAP Analysis Office 2.5 Troubleshooting

Source: SAP/SAP Insider

You can change the context menu, remove/add ribbons

SAP Analysis Office: Customize User Interface

Source: SAP/SAP Insider

After defining conditional formatting, you change the scaling on a measure and it should apply same as before

SAP Analysis Office: Scaling Factors in Conditional Formatting

Source: SAP/SAP Insider

Before complete formatting gone

Now re-apply table design rules after a reset

After a data source reset, you can keep the table design rules

Leave default activateformularecognitiononexisting cells to on in configuration

SAP Analysis Office: Keep Table Design Rules after Data Source Reset

Source: SAP/SAP Insider

More information is available for recent list for data sources

SAP Analysis Office: Additional information in recent list for data sources

Source: SAP/SAP Insider

This is an OLD BEx authorization – hide the info area tree – restrict access to specific access for a specific role

Check BW prerequisites

SAP Analysis Office: Authorization check for InfoArea tree

Source: SAP/SAP Insider

In Table Design you can integrate empty rows/columns and user can integrate Excel formulas

“Autocomplete” is the same as “fill handling” – better explained by the video

SAP Analysis Office Auto Complete for Table Design Formulas Reference Outside the Crosstab

Source: SAP/SAP Insider

This feature too is better explained by the video

SAP Analysis Office: VLOOKUP references to member section

Source: SAP/SAP Insider

You can use full member selector instead of the simple to use search and range options

Source: SAP/SAP Insider

You can use full member selector instead of the simple to use search and range options

SAP Analysis Office: Filter Component Individual Selection Filter by Range

Source: SAP/SAP Insider

Before dates in Analysis Office were handled as strings, now treated as Excel format; helps with formulas – need it in the Excel format

SAP Analysis Office: Excel Native Rendering of Date and Time

If you are interested in Analysis Office please consider joining the May 7 ASUG Analysis Influence Council Relaunch http://bit.ly/2uGYhrS #SAP #SAPCloud #AI