Technology Blogs

The MRP 1 view is the first of 4 MRP views on the material master. The MRP 1 VIEW is a place holder for defining the Planning methods and lot sizing procedures of a give material at a plant/storage location level. MRP stands for “material requirements planning”, which aims to guarantee material availability. MRP is necessary to procure or produce quantities of material for internal purposes or external sales. The four MRP views contain many fields relevant to planning and production, but only a few are of importance to PRODUCT COSTING. The MRP 1 view consists of general data, MRP procedures, and lot size data (Figure 3.2). Figure 3.2: Material Master MRP 1 view MRP type The MRP Type Key determines whether and how the material is planned. You have the following options: PD – Relevant for Material Requirement Planning ND – No Planning in SAP VB – Manual reorder point planning (Consumption based planning) VM- Automatic reorder point planning (Consumption based planni...

Using subscriptions to deliver reports via e-mail The Subscriptions feature is considered to be one among the most important features in Tableau’s interactive data visualization product.  It is by far the easiest way to ensure that you review the most critical and valuable information on a regular basis. The information is shared via email once you have subscribed to a dashboard. In Tableau, you can easily subscribe to reports that you need on a recurring basis.  Subscribed dashboards/sheets will be delivered to your inbox in the form of a PNG image linked to jump directly to the interactive version of the dashboard. Busy managers sometimes like to have their reports delivered. Tableau supports this through subscriptions. The user will be notified via e-mail when the report is updated. These schedules are defined by a server administrator, allowing administrators to ensure that any additional server load is balanced appropriately. Subscription e-mails also contains lin...

Enhancing views with filters, sets, groups and hierarchies Sorting isn’t the only way to arrange data. Creating drill-down hierarchies are easy in Tableau. Perhaps your data include a dimension set with too many members for convenient viewing. Grouping dimensions within a particular field is also available. Interacting with your data may uncover measurement outliers that you would like to save and reuse in other visualizations. That capability is enabled via sets. Even group of sets can be created on-the-fly. Making hierarchies to provide drill-down capability: Hierarchies provide a way to start with a high-level overview of your data, and then drill down to lower levels of detail on demand. In below diagram you can see a two-level view of the data that includes product category and then sub-category. That presentation may include more detail than you prefer to see. A hierarchy that combines category and sub-category can address both needs. Below diagram uses a hierarchy to sho...