Install Microsoft SQL Server 2000 DTS Designer Components on your SQL Server 2005 server.

Look for a .dts file to import. Unfortunately you cannot create new DTS packages in the designer.

Now...

http://technet.microsoft.com/en-us/library/cc966399.aspx

Create a DTS package with a Process OLAP database task. Schedule this package to run every hour.

In the dimension designer look for an property called HideMemberIf when you select your hierarchy. Now choose ParentName as the value. (A member is hidden when its name is identical...

Put the XMLA statement in a Job and execute this job from your proc with exec msdb..sp_start_job

Create a named calculation in your dsv

case Comp when 'yes' then 1 else 0 end

and create a regular measure on this named calculation with SUM as aggregate function.

Or a named calculation in the DSV...

Strick,

Business...

You should add a surrogate key to your dimension tables. And join your fact to this surrogate key.

Have you created a DTS package that is run from your job? Have you tried to run the DTS package with dtsrun and see if it performs or not?

Or you could connect to your OLAP databse over http. Check Accessing the Analysis Server Over HTTPS on MSDN if you are using AS2000 or Configuring HTTP Access to SQL...

Akshaya,

Akshaya (6/12/2008)

---

I want to retrieve data from a cube. What query can i use to perform search on a cube? I have been using Visual Studio 2005 to create the...

Mohammed,

runs these queries on the Adventure Works OLAP database and notice the difference...

with member [measures].[x] as 1

select [measures].members on columns

from Finance;

with member [measures].[x] as 1

select addCalculatedMembers([measures].members) on columns

from Finance;

stevefromOZ (2/9/2009)

---

[...]have...

Try adding AddCalculatedMembers to your...

Have you also tried other OLAP clients? CNS International has just released version 4.3 of their product Datawarehouse Exporer. A fully functional trial version can be downloaded from their site.