Search results for query: *

Hi, I just installed Apache 2.2 and I'm trying to configure the security rules, starting with a simple task...Deny from all and then I will Allow access for specific directories. In httpd.conf I have <Directory /> Options FollowSymLinks AllowOverride None Order deny,allow Deny...

Hello, How can we get the square root of a value with MDX? I saw that some programmer use this "^" But, it doesn't work for me... I thought it was an easy task...Maybe it is? Thanks!

Great!! I Queried the cube and got the SQL with profiler, saved the trace and ran the index wizard. With my table well indexed I got my results in 1.5 seconds instead of 9 minutes. My boss will be proud!! haha Thanks to all of ya!

Unfortunatly I don't have the query....!!! I'm using an OLAP-client software. It is a ROLAP cube and I didn't use Analysis services to build it. The queries are SQL, not MDX. That'S why I didn't posted my thread in the OLAP Forum. It's the first time I use the software with that many records...

if I understood well your column type should be CHAR instead of nvarchar. The leading space are automatically generated. "SQL Server char data is always stored in the data file as the full length of the defined column."see SET ANSI_PADDING

hi, My table contains 3 000 000 records. My queries are very slow. I've indexed my 6 foreign keys without selecting any option in the Manages indexes box. It doesn't improve performance at all. I have no clue what to check next to solve this problem. Any suggestions would be useful... Thanks!!

I've built a cube using analysis services. With Query analyser I use OPENQUERY to run an MDX statement. It doesn't always work... It seems that the length of the column name is too long depending on the members name. When it works it returns something like: [table name].[level 1].[level...

I'm using analysis services with Proclarity Analytics Platform 5.0 I would like to export the results of my queries into an SQL server table, an Access database or a text file...instead of Excel. Why?? Because I have a lot of records and unfortunatly Excel doesn't support that much records. Is...

Answer from Mark Landry.... The problem you face with any of the statistical functions in MDX like AVG(), MEDIAN(), etc. is that it's not a precalculated measure in the cube. These functions expect a set of tuples that each resolve to a measure and the statistical function operates over the...

Hi, I'm trying to calculate a standard deviation using the MDX function. It doesn't work, so I practice with avg function, it's suppose to be simpler.... Let's suppose I have 3 dimensions: time, contaminants and age. I want the average calculated while user select different members. The Measure...