what are the facilities provided by OLAP to analytical users?
Answer Posted / maruthi
1.)MULTI-DIMENSIONAL ANALYSIS
2>)AD-HOC QURIES
3.)REDUCED REDUNDANCY
4.)AGGREGATED DATA
5.)SECURITY
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
What is abap? What are idocs?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
Explain me ETL project architecture in Detail?
Explain what is etl process? How many steps etl contains explain with example?
what are the session parameters? How do u set them?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
what is pmrep command?
what are the concerns of OLTP and DSS systems?
What is etl tool in hadoop?
how do u set partition points in the mapping?
How many types of transformations supported by sorted input?
list and discuss two approaches for updation of target table in Informatica and how they are different.
tell me few points when u become TL