Treinamento

KPI Dashboard

Build a KPI Dashboard - Excel 2013 WebApps www.youtube.com/watch?v=odmZm9JF2aw

Excel Pivot Tables, Charts & Dashboards

Excel Pivot Tables, Charts & Dashboards - Excel 2016, 2013 & 2010   www.youtube.com/watch?v=v-0Z4qGS0xk

PIVOTcHART

Adding a trendline to a PivotChart   www.youtube.com/watch?v=8IlNtal6cFg  

All About Classical & Extended Star Schema

What is Schema ? In database management system (DBMS), the schema represents relational database. It defines the tables, the fields in each table and the relationship between fields and tables. In other words schema is a collection of database objects, including tables, views, indexes and...

Learn About Key & Characteristics Settings CFK, RFK & Formulas

Characteristics Settings - Display Name: By default, when a characteristic is added to the query, it displays the description specified in SAP BW. It is possible to replace this with customized text as follows. Click on Properties Select the General tab Enter Description Characteristics Settings -...

Installing BW Standard Content

BI Content: BI Content provides selected roles within a company with the information that they need to carry out their tasks. SAP NetWeaver Business Warehouse delivers pre-configured authorization objects under the collective term BI content. To understand this we take an example of a sales...

How To Load Master Data From ECC?

Step 1) Creating a Generic Data Source for Text InfoObject Right click on the BI Source System -> Customizing Extractors.   In next screen,  click on Maintain Generic DataSources. In next screen, Type a Technical name for the Text. Click Create Button. In next screen, Enter the...

What Is an Infocube? How To Create One?

What is Infocube? Infocube is data storage area in which we maintain data which we are extracting from source system physically.  An InfoCube can function as both a data target and an InfoProvider. From a reporting point of view, an Infocube can be described as a self-contained dataset. For...

What is InfoSet?

Infoset is a special kind of Infoprovider which does not store data physically. In other words, Infoset are InfoProviders that logically join data and provide this data for BI queries. Infoset collects data from the tables of InfoProviders used to build it.  Infoset describes data sources that...

Power Pivot

Como fazer um Power Pivot:www.youtube.com/watch?v=P6uTB0gQWgQ

1 | 2 | 3 >>