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 Maintenance in SAP BW and alternatives

Master data maintenance in SAP BW can be a tedious process that requires a lot of coordination effort for business users and the involvement of IT. In this post, I show you how the master data maintenance generally works and which alternatives there are.

Master data contains all important information about a particular characteristic. It describes the characteristic in more details, using supplementary properties. In the case of a product, it may include attributes such as size, color, net weight and product hierarchy. In addition, descriptions in multiple languages can be added. Consequent and consistent maintenance of the master data considerably reduces the processing effort, as all important details are available at a glance.


Master data can be maintained either via SAP GUI or, as of SAP BW 7.5 and BW / 4HANA, via BW Modeling Tools. 
If you use the SAP GUI, call transaction RSD1 (Configure Characteristics ) and select the required InfoObject, for example 0PRODUCT. Then please click on Display.

Edit InfoObjects Start

You will see the overview of the characteristic's properties. Please click on Maintain in the top bar or press the F6 key.

Display Characteristic 0PRODUCT_ Details

In case you use BW Modeling Tools, please open the respective characteristic. In the tab General, below Properties area, you can click on the hyperlinked Master Data entry.

eclipse workspace

A web interface for master data maintenance will open. Please press the button New to start a wizard, which will guide you step by step through the creation of a new master data entry.

new entry

In the first step, you must specify a key for new product and associated object family. It is always advisable to use alphanumeric keys instead of the description. For example, supposing you maintain personnel data and enter the new employee as Schmidt, instead of assigning a personnel number 1337. If this employee now changes the name to Müller or Schmidt-Müller, you will have a problem. If you do it right from the scratch, you can just change the description that belongs to the 1337 personnel number.

keys


Master data maintenance - Five tools in comparison

Master data maintenance NextTables



Descriptions are also in the focus of the next step of master data maintenance. After you have entered the key, you can enter a description in different languages. If the texts were defined as language-dependent during the modeling of the InfoObject, enter the language key. Then you can enter the description. Depending on how the InfoObject is modeled, it can be short (20 characters), medium (40 characters), long (60 characters) or very long (1333 characters).

texts

Afterwards, please click on Finish, to finalize the master data maintenance.

If you do not want to use the wizard, you can use the Add line button. You can add one or more lines and enter keys and attributes in the table.

add lines

Please save your changes using the Save button and switch to the Texts tab to maintain the descriptions.

add text

You can change the attributes of several characteristic values, for example products, at once. To do this, press the CTRL key to highlight the desired entries (or use SHIFT to select the first and last entry, all entries in between will be selected automatically) and select Change selected records. The same thing works for texts, but usually it does not make sense to change multiple texts at once.

change selected records

This way you can modify the product family for multiple products at once.

change object family

Despite this nice feature, master data maintenance in SAP BW is rather cumbersome. If business department wants to add a new product, it has to go through several steps. The text is maintained separately from attributes and only one InfoObject can be edited at a time. For many business users, SAP GUI is a horror and also BW Modeling Tools is meant for more advanced users. The jump into a web interface represents rather a break in the UI, than a feature.

With Business Planning and Consolidation, SAP introduces a more user-friendly variant of master data maintenance. Users can create new master data or change existing master data via a user-friendly interface, without having to go into backend modeling. Use the path AdministrationModelingDimensions to get to the overview of the dimensions or characteristics that are encapsulated in your environment.

Bpc dimensions

Please select a characteristic, for example product line ZIAMPRLN. Using the Add button you can create a new entry in master data. In contrast to classic BW, you can also enter the description directly. You can also maintain attributes such as planner or team. By the way, you can do this also with existing entries.

bpc new entry

After you have maintained the master data, press the Save and Process button in the upper left corner to save the changes. Subsequently, the new master data is available and can be used, for example in planning.

BPC undoubtedly represents an improvement to the classic BW approach. The user interface looks much prettier and menu navigation should appeal to less technical users. However, it is still necessary to edit each dimension individually. In addition, it is not possible to upload master data from a file. From the system administrator's point of view, important functionalities such as validation or blocking of individual fields are missing.

With NextTables, NextLytics AG introduces a revolutionary approach to SAP Master Data Maintenance. If you are looking for an opportunity for business users to:

  • modify several InfoObjects at once using a user-friendly interface
  • lock specific attributes of the InfoObject or automatically update them with values
  • if you have special requirements for authorizations
  • if you are looking for an upload option in the InfoObject master data

then NextTables can be a valuable alternative for you.

Would you like to learn more about NextTables? Here we show you NextTables in detail and demonstrate all possible applications in our feature gallery:

Neuer Call-to-Action

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