Recap: ASUG Chicago Chapter Meeting (July, 2017)

July 20, 2017 – Chicago, IL: This past week, GyanSys attended and was one of the sponsors at the ASUG Chicago Summer Chapter Meeting. The event was conducted at The Northern Illinois University, in Naperville.

The Chapter meeting was well attended by around 125 SAP professionals and included organizations such as – Sloan, NEC, Amer Sports, Commscope, Sysmex, Bunn, Zimmer, Grainger etc. to name a few.

Steve Williams (Business Solutions Manager – PLM, Delta Faucet) and Sanjay Una (Sr. Solution Architect, GyanSys) presented a session on – “Simplified SAP PLM S/4 1610 Using Fiori 2.0 for NPD”. The session outlined –

  • Seamless Integration between Teamcenter & S/4HANA SAP PLM for MM & EBOM creation, Change Number & Engineering Record using Middleware T4S
  • Central repository maintained within the SAP system, setting realistic timing and systematic follow-up, and increase speed to market capability
  • Global standard view of the all NPD projects and the individual projects therein, better visibility into project spend & faster response to the need for corrective action


The session provided a great overview of how S/4HANA 1610 would help Delta Faucet overcome manual processes and disconnects in legacy systems for New Product Development. It was attended by over 35 attendees and helped drive insightful discussions.

Steve Williams (Business Solutions Manager – PLM, Delta Faucet Company) & Sanjay Una (Sr. Solution Architect, GyanSys) presenting the Simplified SAP PLM S/4 1610 Using Fiori 2.0 for NPD. (Click here to access presentation)

 GyanSys give-away: An Autographed Arrieta jersey! The lucky winner was an attendee from the Sloan Company.

Integrating Salesforce and Google Drive Using Files Connect

Companies are getting increasingly reliant on applications such as and Google Drive. The ability to share information between these applications enables streamlining business processes. All that is needed is minor customization within Salesforce, without the need for any API and complex code.

The introduction of Salesforce Files Connect, has made the process of exposing Google Drive files data to Salesforce users much simpler. Previously, this required accessing data via Google web services APIs. Files Connect provides connectors for Google Drive. Once setup and configured, external data sources can be created to allow employees access data from Google Drive in Salesforce.

What is Files Connect?

As the name implies, the most obvious use of Files Connect is the ability to access documents stored in Google Drive from within Salesforce. For example, a proposal document that resides in Google Drive can be attached to a lead that resides in Salesforce.

Files Connect can be setup in either Copy Mode or Reference Mode. Copy Mode actually stores a copy of the Google Drive document in Salesforce. If files are shared with a Chatter group, all group members can access the files, even if they lack access to the document in Google Drive. In Reference Mode, a copy of the file is not stored in Salesforce and there is simply a reference to the document in Google Drive. Any access to the file in Salesforce will require that the user have access to the file in Google Drive.

The Custom Properties of Google Drive can even be included in Search, SOQL, and SOSL Queries, so federated searches can query both Google Drive and Salesforce simultaneously from any device. Google Drive documents attached to social feeds, groups or records will be included in Salesforce search results.

Salesforce Files Connect InfographicFiles Connect Architecture Overview

Steps for Integrating Salesforce and Google Drive

The process starts with enabling Files connect for the Salesforce instance with a result that culminates accessing Google Drive in Salesforce. It is easy to establish and configure the connection.

Step 1: Enabling Salesforce Files Connect

Go to Build->Customize->Salesforce Files->Settings->Files Connect. Or if you are lazy like me, you can find Files Connect in the quick find bar. From there click on edit and enable Files Connect. In file Sharing setting select  ’Copy’  or  ‘Reference’ depending upon your business requirement as discussed above.

Files Connect settings

Step 2: User Access Permissions for Files Connect

The next step is to set up user permissions for Files Connect. If you use permission sets for managing user permissions, go to Permission Set->System Permissions->Edit, then Select “Files Connect Cloud”. Click Save.

Salesforce system permissions

Step 3: Creating an Auth Provider

Now we need to set up the auth provider.

Once you click save, you would be directed to an Auth Provider Detail screen. This screen will have necessary details like “Callback URL”. You would need it for the next steps.

Auth. Provider Detail

Step 4: Configuration in Google Drive

Now it’s time to configure Google Drive.

  • Search URL in Google.
  • Create “New Project”.
  • Enable API “Google Drive API”, “Google App Marketplace SDK” for newly created project.
  • Create a Product in “OAuth consent screen” before creating “client ID” in credential.
  • Create client ID in credential, select web application and put “Callback URL” obtained in step 3 in Authorized redirect URIs. Click ‘Create’ it will give ‘’Client Id” and “Client Secret”. Copy “Client Id” and “Client Secret”, you would need it for next steps.

Google Developer Console

Step 5: Reconfiguring Auth Provider

  • Put the ‘’Client Id” and “Client Secret” obtained in step 4 in “Consumer Key” and “Consumer Secret”.

Step 6: Creating External Data Source

  • The next step is to create an external data source in Salesforce.
  • Go to Setup->Build->Develop->External Data Source
  • Click on New External Data Source. You can use any name and label you like but it’s easier if you use similar names to authentication provider and other apps.
  • In Type Select Files Connect: Google Drive.
  • Identity Type is Per User. Authentication Protocol is OAuth 2.0
  • In Authentication Provider, click on lookup. Select the Authentication Provider that we just created in earlier steps.
  • Click Save.

New External Data Source

Now that we have created the external data source, we have to enable it in permission set.

Step 7: Configuring Permission Set

  • Go to Permission set->External Data Source->Edit
  • Select and add the newly created data source to the Enabled External Data Source section.
  • Click Save.

Google Drive permissions

After going through and customizing all of those, it’s time to test it. Select Files Tab->External Files->Google Drive. Now you can access data from Google Drive in Salesforce.

Salesforce Files Tab


Here are some limitations of Files Connect –

  • You cannot upload files directly from Salesforce to Google Drive using files connect. You can only access and download it.
  • Some limitation of Google Drive API.
    • Requests per day 1,000,000,000
    • Requests per 100 seconds per user 1,000
    • Requests per 100 seconds 10,000

Concluding Remarks

All things considered, this is a very easy and reliable integration method. This method can be used to connect other products like Google Apps, SharePoint App, OneDrive, etc.

Watch this space for my next post related to Salesforce Integration.

Find out how Tate & Lyle uses the platform to focus more on their customer instead of their disparate data systems.

For more information related to Salesforce Application Development, contact us at


Simple Goods Movement in SAP S/4 Using Fiori

SAP has been touting the simplification aspects of SAP S/4 specifically around the Fiori enabled transactions to perform tasks in the system. Anyone familiar with the SAP GUI transaction “MIGO” knows that it is sometimes difficult to navigate and not very visually pleasing to the user.

The Migo Function in Action

SAP Fiori has begun taking the MIGO functions and making them simple, visually pleasing and easy to use resulting in a better user experience for the end user.

Below is an example of a movement of product from unrestricted stock to blocked stock in a simple Fiori transaction.


SAP Fiori UI


The user in this example, is a warehouse clerk and has access to the Warehouse Processing tiles in the SAP Fiori application. The user selects the Transfer Sock In-Plant tile.


SAP Fiori Transfer Stock UI


The user is presented with the screen above showing the valid storage locations that the material is extended to within the plant. This is a nice feature as the user no longer has to jump to another SAP transaction to find this data.

Also the stock is showing in the top right corner of the screen. The user in this example, is moving 1 piece from the RAW location to blocked stock in the RAW location. By selecting the Up Arrow next to the quantity 999.00 showing in RAW unrestricted use stock and then selecting the Down Arrow on the blocked stock line for the RAW storage location the user will be shown the popup below where they can enter the quantity to transfer.


The user will select the post button and a material document will be created in SAP for the posting.



The material document number is shown to the user and then the screen below shows the updated stock position that is reflecting in the SAP S/4 system.



This simple example of a material movement shows how SAP Fiori is simplifying transactions in the SAP S/4 system and creating a better user experience for customers.

Over time we will explore some more features of the SAP S/4HANA 1610 system and also see more examples of the Fiori 2.0 features. SAP continues to develop Fiori applications and by considering an upgrade to S/4HANA, customers can leverage Fiori to simplify their business.

My future blog posts will cover details on how S/4 Fiori handles the most frequently used transactions in core ECC.

I am at SAPPHIRE 2017 in Orlando. If you are attending please stop by to watch our S/4 demos at Booth #1059.



Recap: ASUG Indiana Chapter Meeting (February, 2017)

February 17, 2017 – Carmel, IN: This past week, GyanSys hosted the Opening ASUG Indiana Chapter meeting of 2017. This was a daylong event filled with education, networking and information sessions around key SAP trends.

The event was conducted in GyanSys’ warehouse; which recently went through a complete transformation to a professional grade conference center, with capacity to host over a 100 attendees.

The Chapter meeting was well attended by around 60 SAP professionals across Indiana based organizations such as – Roche Diagnostics, Allison Transmission, Delta Faucet, Aunt Millie’s, Vertellus, Eli Lilly, Bridgestone Firestone, Goodyear, Purdue University to name a few. The key sponsors of the event in addition to us were – Protera Technologies, Clear Software, Monocle Group & Intellicorp.

The sessions focused on evolving trends within the SAP industry. Topics covered included –

  • Customer journey around S/4HANA implementation, migration to HANA and SAP BI 4.2
  • Presentations by SAP on Integrated Business Planning (IBP) – Strategy & roadmap
  • How to deploy SAP Production Applications in the cloud

For the viewing pleasure of those who missed out, following are some photos from the event, with a brief description and link to presentation. (Click here to learn more)


ASUG Indiana Chapter Meeting – Welcome Note

ASUG Chapter Meeting Sponsors

Nick Jackson (IT Director, Delta Faucet) & Sean Mawhorter (Supply Chain Practice Director, GyanSys) presenting the Delta Faucet SAP S/4HANA Transformation Journey. (Click here to access presentation)


Sign Up for More Updates

MRP on SAP S/4HANA: Insight to Action

Material Requirement Planning is a key process in production to maintain optimized level of inventory while producing the product at an expected timeline and cost. SAP has versatile Material Requirement Planning tool which has proved to be useful for years. Competitive markets, increasing inventory costs and improved computing capabilities calls for further improvements within the MRP tool.

These are few challenges with current MRP tool:

  • Long and resource intensive MRP runs imply a periodic and batch process.
  • New Demand and Supply changes make MRP plans immediately outdated.
  • No real time single view for material information and shortages.
  • Requirement to navigate to multiple ERP transactions to evaluate solution alternatives.


Improving Manufacturing and catapulting it to the next level will need achievement of the following goals:


SAP S/4HANA with its digital core is capable of executing data intensive MRP process at unprecedented speeds. MRP Live (MD01N) optimizes processes to reduce MRP run-time by 10 fold, thereby making MRP FastSimple and Cross Plant.


S/4HANA 1610 is not only about the speed of MRP execution but also about providing Smart solutions to manage material shortages and other requirements around MRP. The scope of this blog includes discussions around Fiori Apps available in S/4HANA 1610. Below is a snapshot of all MRP related Fiori apps available with 1610.


Material availability can be influenced by several factors like delayed material status, Sales Order fulfillment, change in customer order and several others. The MRP controller should be aware of real time material shortage situation.


Manage Material Shortages


With S/4HANA Fiori apps the MRP Controller will see all relevant information side by side allowing him to take a quick look and gather meaningful insight to take immediate action.

Below is snapshot of Material shortages for the MRP Planner.


This app highlights issues across thousands of material stock situation. MRP Planner has option to check stock requirement list from the same app.


Solution doesn’t only show the material shortage situation but also recommend solution with the option of simulating the possible solution and check viability.


Insight to action capability of the solution helps resolving the issues before it occurs.


Manage Change Requests – MRP


Change request can be raised when using app for managing material and uncovered requirement. App for new, requested and answered change request are available on the MRP Planner.


Proposed changes can be requested from vendor and status can be updated from Answered to Closed upon response of the vendor.

Email can be sent to the vendor and upon their response, changes to Purchase order or stock transfer order can be applied.


Manage Production Order


Production order can also be managed from MRP cockpit. Manage Production order app provides the list of your order with uncovered items.


Individual production order at app has Stock Requirement list, Component info, Milestone, Material overview and order detail. User can also navigate to fact sheets and back end transactions.

Monitoring Internal and External Requirements:


There are separate apps available for Internal and external requirements. The MRP controller can check the coverage of the component required for in-house Production Order, Process order, Maintenance order and network order. Solution recommendations are available for handling shortage situation similar to material Shortages app.


Manage external requirement app provides view of uncovered and delayed items required for sales order and STO. App recommends solutions to overcome the situation with preview capabilities.


MRP Material Issues: 


This app provides view of material(s) for which issues had occurred in MRP execution. Planner can get the information to analyze the issue with material for which problems occurred in the planning run.


MRP Scheduling and Key Figures:


Planner can schedule MRP from Fiori app and review the status of the MRP execution.


MRP Key Figures:


Exception handling based on real time data and early identification of issues with different materials improves material flow and reduces lead time of product development.

Transformed user experience for the material planner has great potential to boost Planner productivity. The simplified and insightful Fiori Application provides a delightful user experience to the Material Planners.

GyanSys Inc. Re-Certified SAP Partner Center of Expertise (PCoE)

Carmel, Indiana – GyanSys Inc. recently achieved another milestone in our pursuit of expanding our AMS service offering portfolio to our customers. GyanSys Inc. has received audit re-certification as SAP Partner Center of Expertise. The audit confirmed that the service and support organization at GyanSys supports its customers in accordance with SAP’s current technical and organizational standards.

Currently, GyanSys is supporting Aunt Millie’s Bakeries and Sigma Tau Pharma Source as their SAP PCoE partner to support Level 1 and Level 2 OSS issues. GyanSys is in the process of on-boarding several other customers under this program in 2017. SAP PCoE auditors carried out intensive scrutiny of our service offerings, tools, people & processes. The major areas which were audited include:

  • SAP® Business-All-In-One and Analytics
  • VAR (Value Added Reseller) Documents and interviews for quality of our PCoE service management process and support staff
  • SAP Solution Manager Data and SAP-internal systems for data validation and collection

“At GyanSys we are dedicating efforts to further streamline our processes and set specific KPI measurement standards to evaluate performance. Our focus is on increasing customer satisfaction by providing a sustained and scalable platform.”

Rajkishore Una, President/CEO, GyanSys Inc.

GyanSys Infotech (India) Has Become SAP-Certified Provider of Application Management Services (AMS)

Bangalore, India – SAP auditors carried out intensive scrutiny of GyanSys’ service offerings, tools, people & processes at Bangalore before certifying GyanSys Infotech as a provider of SAP Application Management Services (AMS).

The major areas that were audited include:

  • SAP product experience
  • The quality of our IT service management process (Service Design, Service Transition, Operations & Continual Improvement)
  • SAP Services (Business Transformation, Design Thinking, MaxAttention, HANA Services, Mobile Services, etc.)
  • Network topology and connectivity

“GyanSys is all set to embark on a certified model where different skill sets work together across multiple clients – this could include advisory, roll out & solution expertise, troubleshooting, and operations.”

Muralidhara Sarali, VP – Sales & Delivery (India), GyanSys Infotech (India)

“GyanSys is excited about this accomplishment. It is another milestone in our pursuit of expanding our support service offerings portfolio to our customers. Currently, there are only 11 AMS certified partners operating from India.”

Rajkishore Una, President/CEO, GyanSys Inc.

Should You Consider Upgrading to BW 7.5?

The latest numbers by SAP reveal that approximately of 14-15K customers are running their BW data warehouse  with a third party database such as Microsoft SQL Server, ORACLE, IMB DB2 etc. With the release of BW 7.5, we have the HANA DB underneath and lot of our customers are wondering how exactly they can leverage this and the impact on their current data warehouse.

If you are an existing BW customer (up to 7.3), you might have several questions. Below are some of the commonly asked questions.shutterstock_333225731-[Converted]

  • What are the benefits of the upgrade?
  • Is it relevant if there is a plan to upgrade ECC to Suite on HANA (SOH) or S/4?
  • Is there a role for SAP BW if S/4 Hana is the source system?
  • If a new Data warehouse is being implemented, should SAP BW 7.5 be considered?

BW takes care of SAP security and authorizations, complex hierarchies, non-cumulative data for stock and many other capabilities. In addition, there is a new modelling methodology for HANA called LSA++, which simplifies and accelerates the build and operations of an EDW.

Read on to find out the future of data warehousing at SAP and the role BW within this.

1. Simplified Data Models


  • New architectures should consider SAP BW and SAP HANA as modeling environment for implementations.
  • SAP BW 7.4 simplifies data modeling by consolidating InfoProviders (see diagram).
  • New InfoProvider adds more flexibility to architecture. For example, CompositeProvider with joins between InfoProviders, also supports temporal joins.
  • Eclipse-based modeling is available for new objects like CompositeProvider, Open ODS View, and (advanced) DataStore object.

2. Leverage the power of SAP BW and SAP HANA


  • Integration of External Data Structures with Open ODS Views.
  • Build lightweight models without the need to create InfoObjects by using field based modelling. This is useful in rapid prototyping or agile model creation.
  • Open ODS Views allows easy consumption of external data.

3. SAP HANA Smart Data Access for SAP BW

With Smart Data Access (SDA), smaller data volumes can be read directly in HANA modeling views or CompositeProviders without ever persisting it in SAP BW or native HANA. This functionality enables your SAP BW on HANA to become a federated data warehouse. Thus eliminating the need to persist all data directly in HANA


Smart Data Access:

  • Automatically handles Deltas
  • Enables federated data models to be combined with SAP BW data
  • Enables Big Data scenarios such as integration of HADOOP with enterprise data in SAP BW

4. Real-Time Replication with SAP LT Replication Server shutterstock_190080125-[Converted]

  • Replicate data in real time into SAP BW via the ODQ framework
  • SLT can be used in two modes: scheduled or real-time
  • Multiple subscribers can easily share the same delta information
  • ODQ allows data transfer into InfoProvider directly; PSA can be skipped

5. Efficient Data Management with Dynamic Tiering


  • SAP HANA Dynamic Tiering enables you to optimize the main memory resource management by using extended tables.  PSA and Advanced DataStore objects, can be set as extended tables. Warm data is moved from Main memory to the extended tables
  • This reduces the consumption of main memory as warm data is stored in disk based storage
  • Usage depends on the object purpose. For example, staging layer objects with rare reporting activities but still in focus for data operations are good candidates for warm data


In order to build an app, data-mart, data platform or database, Native HANA can be used on its own. To build an Enterprise Data Warehouse, the BW on HANA route is recommended.

Thus, with the release of BW 7.5 we have SAP BW as an application-driven approach, and the SQL-based approach just with SAP HANA, without any application like BW on top of it. The combination of SAP BW and SAP HANA enables us to simplify the data modeling processes, increase the agility of the Enterprise Data Warehouse (EDW) and reduce the complexity of the EDW landscape.

With the wide use of Big Data at organizations, it is clear that BW will play an important role in the overall HANA data warehouse, while integrating data from a variety of sources such as S/4, other ERPs, Hadoop, etc.

Power Up Text Analytics with Machine Translation

“Man’s inability to communicate is a result of his failure to listen effectively.” – Carl Rogers

What is Machine Translation (MT)?

Machine translation eliminates the need for a human translator to translate large volumes of words. For instance, when we receive a text in German “Aller Anfang ist schwer”, our first step is to use a Bing/Google translator app to get a comprehensible answer. This can be a time consuming endeavor that can be made significantly quicker (and more accurately) thanks to machine translation.

Does Machine Translation Help?

The applications for Machine translation are innumerable:

  • Customer / Employee feedback: Quickly translate feedback across geographical locations. This  improves understanding within customer service/HR teams and assists development of high quality products, improved customer service, thereby converting to customer loyalty.
  • Enhanced communication between and within organizatwons engaging in different spoken languages.
  • Content Localization: User guides, manuals, warranties, Websites, etc. (e.g. eBay)
  • Security: Government or Organizations can heighten security by translating communication that might be a threat.

Some companies currently using MT: Adobe, eBay, Facebook, Etsy, etc.

What is Text Analytics?

The Twitter platform best exemplifies Text Analytics, where they can analyze how certain keywords are being used by users over certain time or even in real time.



A screenshot of Trends Map using Twitter data

How Does Text Analytics (TA) Help?

Like Machine Translations, large organizations significantly benefit from Text Analytics. It works in conjunction with external social media or internal unstructured data, thereby providing opportunities to act in real time, such as generating buzz about an upcoming product launch.

In addition, all the engagements are measurable and provide enormous insights. The combination of Text, Sentiments, Location, etc. can provide extremely valuable insights into eco-systems comprising of 100s of products, 1000s of employees, millions of documents/correspondence and many millions of customers.

How Can the Power of Machine Translation & Text Analytics Be Combined to Create Opportunities? 

Here are some scenarios:
  1. When organizations receive large volumes of customer feedback in English, German and Spanish:
    1. “Its difficult to use this product”
    2. “Ich kämpfe um dieses Produkt zu verwenden”
    3. “Lucho utilizar este producto”
  2. When organizations have a bulk of contracts with global customers and vendors:
    1. “los derechos exclusivos a reproducir”
    2. “Strafe als Entschädigung bei Zahlungsverzug”
  3. For enabling organizations to listen to the voice of the employees across the globe to incorporate their suggestions for improvements
    1. “Änderung Griff-Design”
    2. “El cambio de cantidad de ingredientes mejorará el sabor”

With the combined power of Translation and Text Analytics, organizations can generate value from insight generated through customer’s feedback and employee engagement at a global level. This data can help drive the next level of innovation or promote incremental improvements to products or services.

What Do Your Next Steps Look Like?

  • Test run some of the Translators APIs/ Widgets. Start using Translator APIs from various providers. These can be used in the background during data storage or adding a widget. This allows users to decide when to translate.
  • There are ways to convert speech to text and subsequently use the resultant information in analytics. This is particularly helpful while collecting automated surveys.
  • Organizations use real-time translation to support customers worldwide from a single location, helping outsourced support, and saving cost.
  • Identify and shortlist vendors who can provide both Text Analytics and Machine Translation.

Sign Up for More Updates

Bridge Between Hadoop Data and Enterprise Data: SAP HANA Vora

“The goal is to turn data into information, and information into insight.” – Carly Fiorina

Data and fact driven approaches helps increase the overall accuracy of decision making. Having the necessary tools to process data swiftly allows decision making at the right time. Data volume is currently exploding beyond anyone’ expectations and here are some facts suggesting that –

  • DATA volume created in the past two years far exceeds the data created in the history of human race.
  • DATA is growing at the rate of 7 megabytes of new information created every second for every human being on the planet.
  • In a span of five years there will be over 50 billion smart connected devices in the world, all developed to collect, analyze and share data.

Considering the rate at which digital information is being generated from various sources (Mobile, Internet of things, social media), there is a strong need for innovative and effective ways to analyze data.  There is the added challenge of analyzing a combination of big data and enterprise data. In order to achieve the desired effectiveness, this Innovation will need not only the brightest minds with the process expertise but also the support of the right software solution.

Here are some use cases for bringing Enterprise data and Hadoop Data together –

  1. New Product Ideas:

The success of a new product can be ensured with the correct data, right at the time of idea selection. Information about economic factors, market indicators, competitors along with others factors help generate a pattern to indicate the right ideas for the market. Monitoring customer sentiments can increase the overall chances of success. A software solution presenting a platform to generate reports leveraging product ideas from the enterprise system along with indicators from Hadoop is need of the hour.

  1. Fraud Protection:

To prevent fraud before it occurs, make DATA your best friend. There are multiple sources such as firewalls, system authentication, bank transaction, payment, unstructured system data, log files, security systems that provide evidence of fraud. This is definitely a significant chunk of data. Bringing the enterprise and Hadoop data together for reporting can help create patterns to proactively trace and identify fraudulent activities.

There are many more use cases in addition to these pertinent to the world of High Tech, Manufacturing, Healthcare, Finance, and Security

Enter, HANA Vora

The selection of the right solutions for the aforementioned scenarios depends on the 3 V’s of data: VolumeVelocity and Variety. SAP aims at focusing on big data by providing insight with HANA Vora. This enables OLAP analysis of Hadoop data while giving developers the option of bringing right contextual information, by combining Business transaction data and Hadoop data.

Capabilities of HANA Vora include:

  • Use of in memory query engine to analyze big data stored in Hadoop.
  • Ability to combine Big data with Enterprise data to improve OLAP reporting with Hadoop data.
  • Simplification of big data ownership within a landscape by combining SAP HANA and Hadoop data.

In conclusion, SAP HANA Vora successfully bridges the gap between Enterprise and Hadoop data by bringing together highly distributed enterprise data framework.

Sign Up for More Updates