Skip to content
NextLytics
Megamenü_2023_Über-uns

Shaping Business Intelligence

Whether clever add-on products for SAP BI, development of meaningful dashboards or implementation of AI-based applications - we shape the future of Business Intelligence together with you. 

Megamenü_2023_Über-uns_1

About us

As a partner with deep process know-how, knowledge of the latest SAP technologies as well as high social competence and many years of project experience, we shape the future of Business Intelligence in your company too.

Megamenü_2023_Methodik

Our Methodology

The mixture of classic waterfall model and agile methodology guarantees our projects a high level of efficiency and satisfaction on both sides. Learn more about our project approach.

Products
Megamenü_2023_NextTables

NextTables

Edit data in SAP BW out of the box: NextTables makes editing tables easier, faster and more intuitive, whether you use SAP BW on HANA, SAP S/4HANA or SAP BW 4/HANA.

Megamenü_2023_Connector

NextLytics Connectors

The increasing automation of processes requires the connectivity of IT systems. NextLytics Connectors allow you to connect your SAP ecosystem with various open-source technologies.

IT-Services
Megamenü_2023_Data-Science

Data Science & Engineering

Ready for the future? As a strong partner, we will support you in the design, implementation and optimization of your AI application.

Megamenü_2023_Planning

SAP Planning

We design new planning applications using SAP BPC Embedded, IP or SAC Planning which create added value for your company.

Megamenü_2023_Dashboarding

Dashboarding

We help you with our expertise to create meaningful dashboards based on Tableau, Power BI, SAP Analytics Cloud or SAP Lumira. 

Megamenü_2023_Data-Warehouse-1

SAP Data Warehouse

Are you planning a migration to SAP HANA? We show you the challenges and which advantages a migration provides.

Business Analytics
Megamenü_2023_Procurement

Procurement Analytics

Transparent and valid figures are important, especially in companies with a decentralized structure. SAP Procurement Analytics allows you to evaluate SAP ERP data in SAP BI.

Megamenü_2023_Reporting

SAP HR Reporting & Analytics

With our standard model for reporting from SAP HCM with SAP BW, you accelerate business activities and make data from various systems available centrally and validly.

Megamenü_2023_Dataquality

Data Quality Management

In times of Big Data and IoT, maintaining high data quality is of the utmost importance. With our Data Quality Management (DQM) solution, you always keep the overview.

Career
Megamenü_2023_Karriere-2b

Working at NextLytics

If you would like to work with pleasure and don't want to miss out on your professional and personal development, we are the right choice for you!

Megamenü_2023_Karriere-1

Senior

Time for a change? Take your next professional step and work with us to shape innovation and growth in an exciting business environment!

Megamenü_2023_Karriere-5

Junior

Enough of grey theory - time to get to know the colourful reality! Start your working life with us and enjoy your work with interesting projects.

Megamenü_2023_Karriere-4-1

Students

You don't just want to study theory, but also want to experience it in practice? Check out theory and practice with us and experience where the differences are made.

Megamenü_2023_Karriere-3

Jobs

You can find all open vacancies here. Look around and submit your application - we look forward to it! If there is no matching position, please send us your unsolicited application.

Blog
NextLytics Newsletter Teaser
Sign up now for our monthly newsletter!
Sign up for newsletter
 

Master Data Planning with SAP BW/4HANA and Possible Alternative

Master data maintenance is one of the most common requirements in planning projects. Users should be able to independently adjust master data for their planning, without the help of the IT department. Various approaches exist to implement this requirement - via an ABAP class or the Business Planning and Consolidation (BPC) Cockpit. With BW/4HANA, there is a new possibility. I will introduce you to this option in the following article.

As of BW/4HANA 1.0 SP 08, it is possible to use InfoObjects as InfoProviders for data planning. This way you can use an aggregation level and input-ready query to change master data or even create new combinations. In the following, I will explain how it works using a small example. In our example, we want to maintain attributes chart of accounts, country and currency for a company code.

Preparation

To do this, we first need to adjust the InfoObject settings. Under Properties, please activate the settings Usable as InfoProvider and Planning Mode.

InfoObject in Planning Mode

Then, as with the InfoCube or ADSO, you have to switch the InfoObject from staging to planning. To do this, please select the Manage Attributes menu item in Eclipse.

Manage attributes

By default, the setting is set to Staging. Please switch it to Planning.

Manage InfoObject

Data target switched to interactive planning

The setting can also be set as default value. When loading the master data, it can be switched to Staging via a process chain.


Master data maintenance in SAP - Five tools in comparison

Master data maintenance NextTables


Aggregation Level and Query

In the next step we build an aggregation level. Here, the InfoObject serves as the InfoProvider.

Create a new aggregation level

The attributes of the InfoObject are automatically generated as key figures. These are added to the aggregation level.

Maintain aggregation level

Based on this aggregation level, we create a plan query.

Create a new query

The company code is then added in the rows and attributes in columns. Set the attributes modelled as key figures to Input-Ready in the Planning tab.

Input ready query

Now the query can be used to maintain the master data.

Maintain master data via query

You can also enter new master data. To do this, set the RSADMIN parameter for Analysis for Office to BICS_NEW_MASTER_DATA = X. You can learn how to do it in the article "How to maintain RSADMIN parameters". This way, you can also enter new company codes that did not previously exist and assign attributes.

Create new master data

New master data can be created via transaction RSRT even without the RSADMIN setting. However, this user interface is only partly user-friendly.

RSRT Query Monitor

Master Data Planning with SAP BW/4HANA - Our conclusion

With BW/4HANA, SAP has introduced another way to maintain master data. Using the standard planning functionality, users can adjust the master data.

However, the solution involves many modelling steps. For example, in addition to adjusting the InfoObject, an aggregation level and query must also be created. Both have to be adapted for new attributes, which complicates the maintenance of the solution. There are also implications for the daily loading processes. The InfoObject must be constantly switched between planning and staging.

The many steps and cumbersome maintenance call for a simpler alternative. With NextTables, NextLytics AG introduces a revolutionary approach to SAP master data maintenance for InfoObjects. You can maintain master data directly and also implement small ad-hoc planning solutions. This is an add-on to SAP, so no server is required.

Simple master data maintenance with NextTables

So, if you are looking for a way for business users to

  • edit several InfoObjects using one user environment
  • lock individual InfoObjects attributes for maintenance or automatically update them with values
  • have special authorization requirements
  • upload master data
  • want to maintain other data, in addition to master data, such as ADSOs or transparent tables

then NextTables can be an alternative for you.

Would you like to learn more about NextTables? We present NextTables in detail on our product page.

Learn all about smart data maintenance with NextTables

,

avatar

Sebastian

Sebastian Uhlig has been consulting companies in various industries on SAP BI solutions at national and international level since 2001 and covers the range from requirements analysis to the implementation of complex solutions. He has experience in leading project teams and is the architect of the product NextTables. He enjoys mountain biking and watching American football games.

Got a question about this blog?
Ask Sebastian

Blog - NextLytics AG 

Welcome to our blog. In this section we regularly report on news and background information on topics such as SAP Business Intelligence (BI), SAP Dashboarding with Lumira Designer or SAP Analytics Cloud, Machine Learning with SAP BW, Data Science and Planning with SAP Business Planning and Consolidation (BPC), SAP Integrated Planning (IP) and SAC Planning and much more.

Subscribe to our newsletter

Related Posts

Recent Posts