In the modern digital world customers with information at fingertips, making informed decisions to buy or lease a car.

Manufacturers can now connect with customers directly, transform the traditional selling practices by offering customized incentive programs. Using advanced analytics manufacturers can get deeper insights into customer sentiments and influencing factors for closing a deal with the customer

With this dynamically changing ownership models and competitive incentives landscapes, manufactures and dealers need more tools to manage incentive programs and budgets to dynamically modify programs by gaining insights into customer’s preferences to win deals.

Incentive Planning and Trade Promotion management process consists of activities aimed at successful automobile sales which can benefit from improved budgetary controls. Sales promotions and program activity, dealer incentives, promotional campaigns, and many other programs are accurately planned, budgeted, executed and audited for efficacy using our flexible and easy to customize Incentives / Trade Program Management solution.
 

Our flexible solution offers:

• Planning Budgets – total allocation of dollars
• Reconciliation – detailed breakout of budgets
• Programs – Add and manage initiatives
• Reports and Publications – chargebacks from distributors and vendors against the program 

Plan and Analyze Promotion Budgets:

 

Create templates and established budget plans templates. Plan Budget Allocations, Analyze program effectiveness, measure progress and ensure accurate execution which can be tracked by:

Model / VIN / Product

Regions / Zones / Market

Dealer / Zip/ Distributor

Program / Affiliations / Fleet
 

Planning & Management Workflows:
 
Create or Change programs, conduct what-if financial analysis, measure and review budget impacts. Review and track changes and manage approvals.:

Planning Workflow

Financial Workflow

Program Changes

Audit Trail and Compliance

Incentives Planning and Management through a set of standard and ad hoc business processes with workflow and analytics

Connect all process steps (activities) and decision events, such as program planning, new incentive model analysis, approval 

Trigger process approvals, notifications and communication workflows where the execution of one task results in automatic initiation of other processes
 

Seamless Data and System Integration

Add new data sets, integrate budgets from existing ERP system, connect other CRM systems, including external financial

Establish two-way integration with data feeds.

Keep your existing Financial tools for budgets and integrate with new incentive management solution automatically.

Add new programs and import from existing CRM systems and managed metadata.

Track & Manage Spending

Manage incentive payments to dealers and partners. Track and manage program expenditures, reconcile financial and maintain accurate reporting across,

Leverage the TEK Incentives & Promotion Management tool to gain full visibility and maximum control on your budgets and effective incentive programs.

Create Targeted Incentive Programs with Advanced Analytics, AI and Machine Learning

Create customized and targeted incentive plans by gaining insights into customer preferences, social trends, tailored promotional programs:

With access to open data, social media and APIs take a  giant  step from conventional incentive planning by deploying

• Prescriptive analytics driven approach
• AI in measuring customer trends and sentiments
• Digital Incentive Campaigns

 Thank you,
Bharat Sunkari.

DataFlow Object

Right-click on Data Flow Object

When creating the Dataflow object a transport request opens up.

Afterwards add a new or existing Datasource by drag and drop to the Details:

Double click on the entered Datasource leads to the following properties:

Select a Source System and if you want a copy from an existing or a proposal from an ODP connection

By clicking on the „NEXT“ button the Dataflow is shown – now it is possible to add any other object to the dataflow.

In this example an ADSO was added and filled with three InfoObjects

Now you created a persistent ADSO.

Activate the newly created ADSO. Create a connection between the newly created ADSO and the previously created Datasource

Now you’ll see a transformation and DTP creation is possible based on the connection.

Right-click on the transformation symbol and select “Create Transformation … “

Now you are able to create a transformation – Target and Source are filled automatically:

Here you are able to define all settings for the transformation as well as connect to the fields from the previous ADSO

In addition, if infoObjects are available in the source – they are automatically connected. Don’t forget to activate!

Same for the creation of the DTP. All DTP properties can be selected. You can see/select/change all the properties already known in BW.

Same process for the composite provider – drag and drop the composite provider, assign a name and create a connection to the ADSO.

It is also possible to add a comment for the specific selections within the dataflow. Click the one you want to comment on – go to the properties section and add documentation.

Conclusion

As you could experience, the Dataflow object is an easy way to model your intended dataflow. You can see all the different stages on one side in one place and do not have to click yourselves through your modelled dataflow, which can be difficult and time-consuming with two different tools either the Eclipse modelling tool and the SAP GUI.

Although it is a simple way to create a complete dataflow it does not replace process chains for loading data as it is moreover a graphical view of your model. For loading the data into your model you also need to create a process chain.

Finally I’ve put together some hints which will make your work easier:

• Create Persistent Objects of ADSO, InfoSources, HCPR directly out of DataFlow Maintenance Screen
• You can use Templates eg. Datasource or Infosource as templates and more.
• When you have a SourceObject like an Infosource and a Target object like an ADSO, first create the connection in between before persisting the ADSO, then all fields/InfoObjects of the source are automatically taken into account for the DataModel of the Target.
• Execution of DTP’s is possible
• if you want to use DTP Monitor you have to execute the DTP in the DTP Maintenance Screen, from here the InPlace GUI is being called.

Tek-Analytics scheduling engine brings scheduling capabilities to SAC stories and models. You can use Scheduling engine to burst the reports in PDF, Excel formats and the destinations can be email client, File system or SFTP.

 It is a lightweight on-premise installation with easy to maintain GUI interface. Administrators can choose the Models, Stories to be busted with Recurrence schedule.  Stories can be published to third-party vendors by email or SFTP. 

Formats supported – PDF, Excel, CSV

Destinations – Email Client, File System, SFTP

Out of passion with CDS modelling, this is one interesting thing I did for a customer to create a planning enabled CDS view

First, create Custom CDS / Custom Analytical query using Fiori App.

Launch ABAP eclipse and add the ATP local package to eclipse. In this case, the package is TEST_YY_KEY_USER_LOCAL_APP package.

Copy the entire code from the CDS view generated by App

Create a new CDS view and paste the code, Change the names in the code as required

Declare Planning annotations .

This will save a lot of time in defining the query/CDS view from scratch.

The CDS view will be available as any other CDS view in BI tools. But since the origin for the new CDS view is ADT, you cannot develop new Analytical queries on this using the app.

Method 1 – High-level Pictorial representation – Direct Method recommended

Method 2 – High-Level Pictorial representation – Wrapper Method

Step 1

Step 2 –

 

Method 3 – Flowgraph

The First two method is to complete SQL way where we create an input table, result table and call SQL wrapper or procedure directly. We have many SAP documents with SQL samples for this. Below I am showing Flowgraph method for running ABC Analysis algorithm.

Input and Result tables are already created as per Algorithm requirements.

                          
 – Karthik Addula

Consuming HANA Data sources from Power BI Desktop 
 

Step 1 – Launch Power BI Desktop

Step 2 – Click Get Data

Step 3 – Select databases > SAP HANA database

Step 4 –  Enter the server details and select connection type

Import = Imports the data ( you can also schedule this)

Direct = Executes data on demand whenever a user refreshes the data ( Real-time)

Step 5 – Select type of credentials  and click connect

To use Kerberos Windows AD SSO – Select use my current credentials

To use HANA database user id and password – select database and type user id password

Step 6 –  Upon successful connection, all the Calcviews will be displayed as per authorization

Step 7 – Select the calc view and click load

All the data will be now available for visualizations.

In SAP Analytics Cloud, you can add a time calculation to your chart without using the calculation editor. This allows you to create quick comparisons with your data such as Previous Year, Period over Period, Year to Date, and so on.

There are two ways to filter your visualizations using time filters:

• Adding a time calculation
• Creating a single value filter

There’s a time and place to use each, and in this post, we’ll show you some examples of how each of these time filters work.

1) Adding a time calculation

If your data includes different levels of granularity (i.e. year, quarter, month) then you can add a Time Calculation to compare your data over these periods.

First, we need to create a chart and add our measure. For this example, we’ll select Gross Margin. We also need to add Date as our time dimension.


 

Next, we’ll select ‘Add Time Calculation’ and choose ‘Previous Year’ from the list.

When we do this, nothing happens to our chart. It still shows our Gross Margin for All. We receive the following notification both in the chart and in the builder panel: “The Date dimension must be drilled to Year or lower level for Gross Margin – PY to appear.”

need to drill down to a lower level of granularity so that our chart can compare this years’ data with the previous year.

Once we drill down using the drill down icon within the chart, we can see our data compared with previous years. If we choose, we can continue to drill down to lower levels of granularity.

We can select any two measures in our chart, and a variance breakdown appears showing us the difference between the two data points.

Adding a variance

Another way to compare data from previous periods is to add a variance to your chart.

Following the previous example, we can remove the Time Calculation we added, then select our chart, and choose the ‘Add Variance’ option.

We can leave our Measures to ‘All Measures in Use (Dynamic)’, and for the dimension, we can select ‘Time’.

When we do that, we’re given all the different time variations such as Current Period, Previous Period, Previous Year, and so on. Select “Previous Year” for the Date dimension and click on Ok.

Now, our chart displays the variance based on the time period we selected.

 

Depending on your preference, there are different display options you can choose for your variance chart.

We can further drill down into any of our ranges to see a lower level of granularity and the variance will be calculated accordingly.

2) Creating a single value filter

As mentioned previously, there’s another way you can filter your visualization using time filters. First, we looked at adding a time calculation and a variance. The other way is to create a single value filter.

This option is useful for when you’re using a numeric chart, which doesn’t allow you to add a time dimension. Let’s look at an example.

We’ll start by creating a numeric point chart and selecting Gross Margin as our measure. However, this chart is displaying our total Gross Margin for all time periods, which is not what we want. Rather we want to filter the chart by time, specifically 2015.

We can also add a variance so that we can see how 2015’s Gross Margin compares to the 2014’s.

To do this, we start by selecting our visualization and then adding a Time (Member) filter.

This allows us to select the exact date for which we want to filter. In this example, we want to filter our visualization by 2015.

 

When we select OK, the time filter is enabled and our visualization restricts the measure by the time we selected.


 

Next, we can follow the same workflow described in the previous example and add a variance at the year granularity, which will show us how this year’s Gross Margin compares with the previous year.


 

We’ve shown you two ways to filter your data by time, as well as how to add a variance to compare two values.