Browse by Tags

All Tags » olap   (RSS)
SQL Server OLAP - back to basics for Cube access from front-end application?
11 February 08 02:38 AM | SQL Master | 3 Comments   
One of the [SSP] forum user asked about what is OLAP, how the process flow occurrs when update happens to a fact table! It sounds like the basic question for Analysis Services user, OLAP - On-Line Analytical Processing for BI - Business Intelligence is Read More...
Backup and Restore of Analysis Services Database - gotchas
12 December 07 02:38 AM | SQL Master | 2 Comments   
Since the evolution of SQL Server 2000 version the backup and restore methods have been enhanced for better performance to provide a better option for the DBA, as usual the backup and restore operations are an integral part of the Analysis Services infrastructure. Read More...
OLAP Connectivity from Pivot Table in Excel - security permissions
25 September 07 02:14 AM | SQL Master | 4 Comments   
Security permissions in OLAP is similar to normal OLTP based environment. Say if you are using Pivot Table object in MS Office Excel to display the reports using OLAP objects like Cubes. To achieve this it should connect to an OLAP Server and database Read More...
BI Survey - world's largest independent survey about your experience
10 July 07 10:59 AM | SQL Master | 1 Comments   
If you would like to share your experience in managing Business Intelligence products and applications that are used in business/corporate/enterprise performance management, as a whole it is called OLAP. This survey is to help in identifying the trends Read More...
Filed under: , , , ,
OLAP Design best practices for Analysis Services
13 May 07 12:57 AM | SQL Master | 1 Comments   
We have got best practices articles on BPA , Security , IndexOptimization for SQL 2005 (non BI) and BP(suggested) for SSIS and I was searching for similar in OLAP - Business Intelligence on Analysis Services in SQL Server 2005. Here it is, a collection Read More...