Monthly Archives: June, 2005
OLAP and SQL Firewall Configuration
OLAP and SQL Firewalls For a client or middle-tier to access You will need to open the following firewall ports:SQL Server: 1433 OLAP Services: 2393, 2394, 2725 For more information, … Continue reading
Calculate Memory Used by Olap
Calculate Memory used by OLAPTo calculate memory, the formula is:DimSize = (M x (61 + 4L + Sa + Sk))) + 4P + Sn where M: Number of members in … Continue reading
Olap’s Lazy Aggregation Error
Lazy Aggregation ErrorIf you get an “Error during lazy aggregation of partition %PartName% in cube %CubeName%, this is typically caused by a lazy aggregation error. To resolve this, you can: … Continue reading
How to archive an OLAP database (not using msmdarch.exe)
How to archive an OLAP database (not using msmdarch.exe) To provide an unsupported method to archive an Olap database instead of using msmdarch.exe. You can backup the file folder containing the Olap … Continue reading
Renaming OLAP database (Unsupported)
Renaming OLAP database (Unsupported) Below are the unsupported steps to rename and OLAP database. Archive the OLAP database and SQL repository (assumes you migrated the OLAP repository to SQL). Stop … Continue reading
OLAP Distinct Count – how to make it faster
Distinct Count To get the full performance out of Analysis Services for distinct count, insure that a distinct count measure is in its own cube and you can perform custom … Continue reading
