Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. stetou

    Security config

    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...
  2. stetou

    MDX Square root or Power

    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!
  3. stetou

    indexing tables...still slow

    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!
  4. stetou

    indexing tables...still slow

    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...
  5. stetou

    Adding leading spaces to text based on length

    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
  6. stetou

    indexing tables...still slow

    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!!
  7. stetou

    column name with MDX and openquery

    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...
  8. stetou

    Export to....another format than /&quot;?%$ EXCEL

    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...
  9. stetou

    avg function

    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...
  10. stetou

    avg function

    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...

Part and Inventory Search

Back
Top