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 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 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..