We have done the same thing at our place. Here’s how we do it, in the time dimension click the edit button in property “default measure” in the option “Enter...

I had a simmilar issue and used a sql task to solve the problem.

here's the syntax if you want to adapt it and try.

INSERT INTO Ref_Rebate_Index

SELECT...

I don't know of any. Just out of interest what is it about Analysis Services Manager that is making you look for alternatives?

The underlying datatype and the AS datatype were both double.

I figured the same solution, it was just a reason why it was happening that was eluding me.

Cheers.

Howard.

try the previous link to se if it helps.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=93756#bm93832

this article may also help http://www.sqlservercentral.com/columnists/jsack/capturingtheerrordescriptioninastoredprocedure.asp

Is this the kind of thing your looking for -

iif(([Measures].[Avg Order Amt],[Customer].CurrentMember.Parent) 0, ([Measures].[Avg Order Amt], [Customer].CurrentMember) / ([Measures].[Avg Order Amt], [Customer].CurrentMember.Parent), NULL)

Try these -

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapunisys.asp

"Processing Interaction" (more to do with dims, but worth a look) http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part6/c2661.mspx

http://www.microsoft.com/sql/evaluation/bi/bianalysis.asp

http://www.only4gurus.com/v2/ShowCat.asp?Cat=OLAP%20/%20Data%20Mining%20/%20BI

Yes. Go into the design of the table you want to move, select the properties and change the table filegroup.

Is your SQL server service account in the windows Administrators group? by that I mean the log on account on the SQLSERVERAGENT service.

You should investigate 'Member Groups'. Alternativly you may need to generate custom levels eg. if you have 80,000 customers you may want to create an A-Z level.

Somethings to remember,...

Your fact table has a torn page, rendering it rather useless. Torn pages occur when there has been a problem reading or writing data to disk; a common cause may...

Try this -

http://www.sqldev.net/events.htm theres a power point show called "70 - Best Practices for High Performance Data Loading" "70GertDrapers_slides.zip"

It has some rather handy info and advice.

There are a lot of variables you will have to take into consideration when making a guestimate like this. Things like

-how much initial data do you have

-how long are...

Would this work for you ?

([Item].currentmember,[Measures].[Comp Location Qty])/([Item].currentmember.parent,[Measures].[Comp Location Qty])

Very much akin to discussion

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=93756#bm93832

however, this version is much more visually comprehensive.

This article that should help a lot of people as it appears to have been...