Against my better judgement I have been thrust into the duty of
creating Crystal reports for my company.  I have discovered rather
quickly that I also need to become familar with SQL (creating views
and stored procedures).

Hi Newsgroup.
I am a beginner in MDX and am writing an MDX script which returns the
employee, their expenses current and previous year, and their ranking which
represents their current expenditure, 1 has the highest expenditure.  The

I was wondering if it was possible to see metadata such as the server
version \ service pack level etc of the analysis server by querying the
engine.
for example when using the database engine I can just say "SELECT

On Windows server 2003, I have SQL Server 2005.  I have installed a SSAS
instance called "INST1".  I need to correct the instance name and set it as
"SSAS1".  Can this be done or do I need to un-install the instance and
re-install it?

I've been having trouble figuring out the context/cube space that I'm
dealing with when creating a calculated measure.
Let's say I have a calculated member.  When that calculated member is
evaluated in the context of a particular tuple. all members of all

Hello developers,
Please help, I cannot figure this out.
In OLAP 2005 (SSAS) this trivial query executes:
select [Measures].[Amount] on 0 from [Budget] where ([Account].&[All

Hello...
Someone can help me?
I need to filter my [Time] Dimesion and it have an attribute called [Year]
i want to do a thing like this:

I'm having trouble figuring out how to do a Count, Average, Min and Max
value for my data.
I have the following Fact tables:
FactEnrollment - This records each Enrollment in the system.  An Enrollment

I just heard from Robbie Meng, SQL Server moderator for Partner support that
there is no way to expose an OLAP cube in the browser. My question is whether
there is a 3rd party product that is able to do this. I would like to publish
cubes and let end-user manipulate them using an ...

For SQL Analysis server I have seen there options on each database to
backup that individual database.
Is there a method of regularly backing up SSAS databases like using
SQL Server Agent Jobs for SQL Server Databases?

How can I run SSAS 2008 with cellsetgrid ?? or it only could be used
con SSAS 2005?

I have a table with 3 columns as follows:
Category Group Code
A X AX1
A X AX2

I'm on Win2K, SQL2K & SP3. The AS crashed when creating database roles. I
could no longer start AS. It always shows the following error in the event
log:"Application popup: SqlDumper.exe - Entry Point Not Found : The procedure
entry point MiniDumpWriteDump could not be located in ...

I've got a simple cube with 1 measure group and 7 dimensions.
1 of these dimensions is a Fact dimension (same source table as the measure
group).
When I process the cube (incl the dimensions) the processing hangs as soon

I need help to write MDX query to get following output:
I have a dimension with 3 attributes Product Category, Product ID and
Purchase Date and I need to select Product Category and Product ID for
which Purchase Date is the latest one.