I'm getting a major performace hit opening up many Adomdconnections in .net
c#.
I'm trying to share the connection, but it seems to close everytime I close
a reader.

Please i need your help, some days ago i installed a SQL 2005 AS and create
a cube.
By a policy of the compani the name of the server is servercube.domain.com.
But I need to access the cubes from the internet by a OWC, in my firewall i

Hi to all,
Someone know how i can change the server collation of MS SQL Server?

I have a dimension with the following attributes
Family
Group
Line

I have recently migrated from SSAS 2000 to SSAS 2005.
After migration, the performance of one of my queries has gone down
significantly in the migrated 2005 version as compared to the
performance of the same query in SSAS 2000. i also noticed that the

We have a need to use a web service as a data source for SSAS.
Basically we have data from remote systems available as a web service
and I would like to source this into SSAS.
The reason they have been published as a web service is to enable real

I've got a fact table (car rental episode) that has start and end date/
time stamp:
RentalId
StartTime

I have developed an Analysis Services cube that I would like to be able to
browse through a web front end.
Is it possible to this without buying any tools, using MDX, etc?
I use Reporting Services and add reports to the report manager. It would be

In my datetime dimension I have a simple date that is just: mm/dd/yyyy -
however because it's a Char - inside my cube I can't tell it filter on
=>'1/1/2006'.
If I change it back to a datetime - it will have min and sec and it appears

I had a calculated measure called "Return%".
For testing purposes, I created another measure called "Return_%" with
an underscore in between "Return" and "%". I deleted the original
"Return%" calculated measure and renamed the "Return_%" measure to

I'm new to MDX and am having trouble figuring out if it is possible to
create a query result of Literal Strings in MDX.
In SQL I can do:
SELECT 'Parameter 1' as field

some have an idea how to do this in MDX?
    Sales
Year     2007   
gen-07    10

I need help with a problem of day counting.
I have a fact table, where each fact has a start date and an end date
(a kind of 'activity' logging : activity type, start, end)
I need to compute the average number of days per fact, so I have to

Hi - I've been trying to create a result set like the following:
June 2004    $100
May 2004     $124
Apr 2004     $99

We have built a data cube with SQL Server Analysis Services and now we’re
looking for a way that our users can browse the data in the cube.
We have been using Excel 2007 during development and that works really well.
We can connect to the cube easily because it’s all on the same ...