These are questions I faced. If you have any screen shots for any one of the question provide that one also.
1. We have standard info cubes given in sap why you created zinfo cubes can you tell me the business scenario?
2. In keyfigure what is meant by cumulative value, non cumulative value change and non cumulative value in and out flow?
4. when you creating infoobject it shows reference and template what is it?
5. what is it 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 you 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 which data is compressing tell me detail?
11. what is meant by flat aggregate? Explain in detail.
12. I have created process chain 1st day it taking 10 min after that 1st week it taking 1 hour after that next time it taking 1 day with a same loads what happen how can you reduce the time of loading?
13. how can you know the cube size? in detail show me you have screen shots
14. where can we find transport return codes?
15. I have a report it taking so much time how can I rectify?
16. what is offset? Without offset we create queries?
17. I told my process chains nearly 600 are there he asked me how can you monitor I told him I will see in rspcm and bwccms he asked is there any third party tools is there to see? Any tools are there to see tell me what it is?
18. how client access the reports?
19. I don’t have master data it will possible to load transaction data? it is possible is there any other steps to do that one?
20. what is structure in reporting?
21. which object based you created extended star schema?
22. what is line item dimension tell me brief
23. what is high cardinality tell me brief
24. process chain is running I have to stop the process for 1 hour after that re runn the process where it is stopped? In multiprovider can I use aggregations
25. what is direct schedule and what is meta chain?
26. which patch you used presently? How can I know which patch that one?
27. how can we increase data packet size?
28. hierarchies are not there in bi and why?
29. remodeling is applied only on info cube? why not dso/ods?
30. In jump queries we can jump any transactions just like rsa1, sm37 etc it is possible or not?
31. why ods activation fail? What types of fails are there? What are the steps to handle
32. I have a process chain is running the infopackage get error don’t process the error of that info package and then you can run the dependent variants is it possible?
Provide any performance and loading issues or support issues, reporting errors, Loading errors and process chain errors etc. Please explain in detail or create a screenshots for all the questions and explain in detail. If you have any screen shots or text data can u give me the link.
Get More Questions and Answers with Explanation related to SAP Business Warehousing at SAP BW Forum.