cubes over the Web?
A. Yes to both questions. In fact, a user could connect to a cube over the Web and still be in Excel. There are many solutions to delivering cubes and OLAP data over the Web. Among these, Microsoft ActiveX controls, Active Server Pages (ASP) scripting, and ActiveX Data Objects (ADO) Application Programming Interfaces (APIs) provide a variety of solutions for querying OLAP data over the Web. When user uses Microsoft Query and saves the OLAP query file before creating the cube, he/she can open the OLAP query (ie oqy files) in Excel which loads the cube in MS Excel using MS Excel Pivot Table report. When users publish the MS Excel Pivot Table using MS Excel, user can access the cube over web also. Q. What is the difference between a data mart and a data warehouse? A. Data marts are specialized databases designed to handle the reporting needs of a single department or single line-of-business application. A data warehouse is typically several data marts “rolled-up” into one giant database s
Related Questions
- Once my trial version expires, can I download it again and reuse Web Response Grabber Business Trial version?
- Are there any conditions of registration that will prevent web registration?
- Are there any conditions of registration that will prevent web registration?
- How can I manually configure the HTTP proxy of the web shield?
- How can I manually configure the HTTP proxy of the web shield?
- cubes over the Web?
