Question.1 What is the component of the enterprise framework that provides Core web intelligence display and interaction? Answer: The Web Intelligence Report Server provides core Web Intelligence display and interaction within the platform for end-user query and analysis. The Web Intelligence Report Server is accessed when the CMS requests the..
Question.1 What is a cell editor? Answer: Gives definition of specific cells in queries (intersection of two structures one characteristics structure and one key figure structure); using this you can override the default cell values. Question.2 What are the options for calculating result as summation? Answer: The sum of total..
Question.1 How can we overcome by loops? and also is it possible, one user can different universe? Answer: By using Alias and context Alias- loop contains one look up table Context-loop contains more than one lookup table. Question.2 How do we apply SQL query on selected variables? Answer: If you..
Question.1 What are the advantages of column-based tables? Answer: Advantages: Faster Data Access: Only affected columns have to be read during the selection process of a query. Any of the columns can serve as an index. Better Compression: Columnar data storage allows highly efficient compression because the majority of the..
Question.1 What is proposed from statistics for aggregates? Answer: You can ask the system to get the optimal characteristics for aggregation by using the BW statistics data (like query run time, etc). Question.2 Can you define aggregates on time dependent navigational attributes? Answer: Yes, as of version 3.x Question.3 What..
Question.1 What is $ as an authorization value? Answer: You use $ followed by a variable name (values populated in user exit for bex); this avoids having too many roles. Question.2 What is info object 0TCTAUTHH? Answer: This is used in hierarchy authorization Question.3 How would you debug security issues?..
Question.1 What is a filter? Answer: A filter, as the name suggests, is used to apply a condition to get specific or “filtered” data in the report. A filter can be applied either at the universe level or at the report level. Filter at the report, the level is nothing..
Question.1 What is the role of surrogate keys in the data warehouse and how will you generate them? Answer: A surrogate key is a simple Primary key which maps one to one with a Natural compound Primary key. The reason for using them is to alleviate the need for the..
Question.1 what are 16 fields in pricing procedure? Answer: 1.step 2.counter 3.condition type 4.description 5.from 6.to 7.manual 8.mandatory 9.statistical 10.print 11.subtotal 12.requirement 13. Alternative calculation type 14. Alternative condition base value 15 account key 16. Accrual Question.2 what is Condition type? Tell me the main groups? Answer: A condition type..
Question.1 Explain ‘Sales Document Blocking’? Answer: You may be required to block a specific sales document type from bather processing, when you want to block undesirable customaries. You can achieve this for specific customer or for a specific document type. You may also black it, in the customer master record,..