Does anyone have any good tips or tricks on how to make up an Analysis
Services database on a nightly basis? Both the data and metadata.

Thanks!

From Books Online (archiving databases-Analysis Services, with msmdarch
command):

Syntax

["command-path]msmdarch["] /a Server "OLAPDataPath" "DatabaseName"
"BackupFileName" ["LogFileName" ["TempDirectory"]]

command-path

The path containing the msmdarch.exe file. By default, this path is:
C:\Program Files\Microsoft Analysis Services\Bin

Server
The server computer name that contains the database you want to archive.

OLAPDataPath
The path of the Data directory that contains the files for the database you
want to archive. By default, this path is:

C:\Program Files\Microsoft Analysis Services\Data

DatabaseName
The name of the database you want to archive.

BackupFileName
The path, file name, and .cab extension of the archive file.

LogFileName
The path, file name, and .log extension of the archive log. If you specify
an archive log that already exists, the new archive log is appended to it. If
you specify an invalid path or file name, the archive log is written to the
DBArchive.log file, which by default is C:\Program Files\Microsoft Analysis
Services\Bin\DBArchive.log.

TempDirectory
The specified path of the temporary directory used for processing space.
This option must be specified if LogFileName is specified.

Example
The following command archives the sample FoodMart 2000 database included in
Analysis Services.

"\Program Files\Microsoft Analysis Services\Bin\msmdarch" /a myserver
"\Program Files\Microsoft Analysis Services\Data\" "FoodMart 2000"
"\My archives\server myserver\FoodMart 2000.cab"



"Jesse O" wrote:

There's a native RANK function in MDX

Rank(«Tuple», «Set»[, «Calc Expression»])


Here's an example, say you wanted to rank cities based upon Store Sales for
all time:


WITH
SET [Top Store Sales] as 'Order([customers].[city].members,[Measures].[Store
Sales],BDESC)'
member [measures].[store sales rank] as 'Rank(
[customers].CurrentMember,[Top Store Sales])'

select [customers].[city].members on rows,
{ [measures].[store sales rank] } on columns
from sales

"Jesse O" wrote:

Sorry, the below was a respons to a ranking question, for some reason it
posted here. My apologies.

"SQL McOLAP" wrote:

Hi,
Did u tried to run the script given in BOL about AS backup in Query Analyser
Pls go though it because it gives the error as

'msmdarch' is not recognized as an internal or external command,
operable program or batch file.
NULL

From dos mode it works fine
pls tell me why does this error comes

--
waiting for solution
from
Sufian


"SQL McOLAP" wrote:

All,

Hopefully, backing up will be easier in '05, but until then --

1) Make sure that the path to MSMDARCH is in your environment path on your
server
2) Run this borrowed script (SQLServerCentral.com Script Library)

declare @Command varchar(550)
declare @ASServer varchar(25)
declare @ASPath varchar(100)
declare @BkpPath varchar(100)
declare @DatabaseName varchar(45)

set @ASServer = 's0adcepmbxx'
set @ASPath = 'E:\Microsoft Analysis Services\Data\'
set @BkpPath = 'E:\Olap Backup\'
set @DatabaseName = 'IVR'

set @Command = ('msmdarch /A ' + rtrim(@ASServer) +
' "' + @ASPath + '" "' + @DatabaseName +
'" "' + @BkpPath + @DatabaseName + '.cab"' +
' "' + @BkpPath + @DatabaseName + '.log"')
print @Command
EXEC master..xp_cmdshell @Command


"Mohd Sufian" wrote: