Recent content by johnem

Dear Listers, We're experiencing a memory issue in Analysis Services cube production. The error is reported as : Analysis Server Error: Memory error [The server computer is running low on memory. Close some applications, and then try again.] The cube is partitioned and uses a snowflake schema...

Guys, if I only had $1 for every re-install, i'd almost be wealthy !! John

Dear Listers, I have recently installed AS & SP3 from the SQL Server 2000 EE disk. Two issues I am unable to resolve : i) The default Foodmart db is not installed, ie. no Foodmart 2000 folder is created. ii) Unable to register the server in the AM pane resulting in 'Errors occured while...

JK, we're currently running MDAC 2.7 (default install with AS SP3) .... however does MDAC 2.8 guarantee a resolution? Regards, John

Dear Listers, On two occasions now we have installed (AS 2000 and SP3) on a server running (Windosw 2000 server and SP3) and have been unable to register the server within the Analysis Manager. The following message is displayed : Error: Provider cannot be found. It may not be properly...

Dear Listers, If SQL Server 2000 SE database & server components are installed on svr A (Database server with dual cpu) (per cpu mode), and SQL Server 2000 SE Analysis Services ONLY is installed on svr B (Application server with dual cpu), what are the licencing implications : Given that the...

Dear Listers, Initial investigations show that our OLAP cube will source 300 million database rows initially, and incrementally add 2 million rows per week. We're considering the use of partitions to reduce the time required to build the cube, but have no experience in design recommendations...

Dear Listers, User A logs onto PC1 and is able to select AS cube data on PC1 when using XL's Data Connection Wizard. (MS Office SP2 install). User A logs onto PC2 and is unable to select AS cube data on PC2 when using XL's Data Connection Wizard. (MS Office SP2 install). Can anyone assist me...

Dear listers, Despite AS & SP3 re-installs (x3), MDAC 2.7 SP1 install, I am unable to register the Analysis Server. I have confirmed that my login is a member of the OLAP Admins and granted Full Control on the MsOlapRepository$ share and run the MDAC Component Checker to confirm MDAC 2.7 SP1...

Dear Listers, Is there a means by which I can populate a variable using the following syntax ? exec [servername].master.dbo.xp_servicecontrol querystate,msdtc Note the following: If the source server was 'AA' and my statement was : insert #temp(columnname) --(on server BB - target server)...

Dear Listers, My understanding is that to create an Analysis Services database or cube and to be able to process a cube requires the user be an OLAP administrator on the local server. Once a user is a local OLAP administrator they have access to all cubes on the local server. I would like a...

Dear Listers, At the request of one of our developers, I was asked to monitor C:\ drive disk-space consumption during cube processing. At the commencement of the processing we had approx. 2.8GB available. The partition data files, ie. (dbname.agg.rigid.data), peaked to approx.100MB. DIsk space...

No issues, only mgt. is being cautious b4 we progess forward with a SP upgrade. Regards, john

Dear Listers, We, (members of OLAP Administrators), are unable to create/process cubes unless the BUILTIN\Administrators local group is configured as 'sa'. Surely this blows a hole in any security model. Can access, to perform the above, be controlled via NT? Any thoughts, work-around or...

Dear Listers, Are there any known issues regards AS functionality following installation of SP3? TIA John