Question
What is olap in business intelligence?
Answers
Online Analytical Processing, a category of software tools that provides analysis of data stored in a database. OLAP tools enable users to analyze different dimensions of multidimensional data. For example, it provides time series and trend analysis views. The chief component of OLAP is the OLAP server, which sits between a client and a database management systems (DBMS). The OLAP server understands how data is organized in the database and has special functions analyzing the data.
A good OLAP interface has writes an efficient sql and reads an accurate data from db.To design and architect having good knowledge on DB understanding the report requirements.   Your Comment




  • Contributors: *,


Search
Can you Answer!!
  • Q Which are the main steps of a merge sorting algorithm?
  • Q Tell us the difference between merge and quick sort. Which one would you prefer and why?
  • Q Give me a specific example of a time when a co-worker or classmate criticized your work in front of others. How did you respond? How has that event shaped the way you communicate with others?
  • Q How to set up a default drawing directory?
  • Q How does normalization of huge pointer works?
  • Q Using pointer, changing A to B and B to A is Swapping the function using two address and one temperory variable. a,b are address, t is temporary variable. How function look like?
  • Q How exactly do I read/write simple types in non-human-readable ("binary") format?
  • Q How do you log changes and generate change documents in FI
  • Q What are the New Job Postings from the Company or Organization, Central Pollution Control Board ?
  • Q What is the difference in creating filters in designer and business objects?
  • Q Could you explain your workflow? what's your sprint length, ticketing?