Skip to main content

Posts

SAP Best Practices

Almost for all industris there are documented and configured proceses called Best Practices. And all of this Best Practices are free and online on the SAP Help portal. You can find here Best Practices for the following industries: industries: Apparel and Footwear Automotive Chemicals Consumer Products Consumer Durables & Home Appliances Dealer Business Management EC&O Fabricated Metals High Tech Home & Personal Care Industrial Machinery & Components Logistic Service Providers Maintenance, Repair & Overhaul Medical Devices Mining Retail Pharmaceuticals Primary Steel Professional Services Public Sector Utilities for SAP R/3 Water Utilities - for SAP IS-U Wholesale Distribution

Infocube Creation Step using SAP BI 7.0

SAP has come up with enhanced functionalities for business warehousing. The new functionalities are part of SAP Business Intelligence 7.0 (SAP BI 7.0). There are some differences in SAP BI 7.0 while creating objects. We will see how to create InfoCube and other related Objects in SAP BI 7.0. Infocube uses concept of star schema. Infocube is created using Characteristics and Key Figures. Characteristics are levels on which reporting has to be performed. For example, Product, Customer and Plant. Key Figures are measures used for characteristics. For example, sales quantity for a product, customer and location combination. In this section we will discuss InfoArea and InfoObject Catalog creation steps in SAP BI 7.0. 1) Logon to SAP and Execute transaction RSA1, shown below is the left hand side panel 2) Select the InfoProvider at right hand side panel and select 'Create InfoArea; 3) Enter name and description for InfoArea 4) Go to InfoObjects at left hand panel, select...

SAP BI interview questions and Answers

Interview Questions: 1. We have standard info objects given in sap why you created zinfo objects can u tell me the business scenario . 2. We have standard info cubes given in sap why you created zinfo cubes can u tell me the business scenario 3. In keyfigure what is meant by cumulative value, non cumulative value change and non cumulative value in and out flow. 4. when u creating infoobject it shows reference and template what is it 5. what is meant by compounding attribute tell me the scenario? 6. I have 3 cubes for that I created multiprovider and I created a report for that but I didn’t get data in that report what happen? 7. I have 10 cubes I created multiprovider I want only 1 cube data what u do? 8. what is meant by safety upper limit and safety lower limit in all the deltas tell me one by one for time stamp, calender day and numberic pointer? 9. I have 80 queries which query is taking so much time how can you solve it 10. In compression level all requests are becoming zero whi...