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
what are the concerns of OLTP and DSS systems?
how would u estimate the size of Lookup transform data and index cache?
Is apache nifi an etl tool?
what is pmrep command?
what is pmrep command?
How etl testing is different from database testing?
Explain about power designer data modeling software?
Explain the use lookup tables and Aggregate tables?
What is the difference between Data Warehousing and Data Mining?
What are materialized views & where do we use them?
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 do you understand by active and passive transformations?
What are three tier systems in etl?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
what do u do when DB time takes more?in sap bi