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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by hudi

  1. hudi

    MDX: Showing two levels in a dimension

    Hey, it's better if you user function descendants. You can define which levels you want to show. Check out help and there is a good example! Bye, Andrej
  2. hudi

    Migrate OLAP cubes

    Hi, easiest way to do it is to use Meta Data Scripter. This is an add-in for Analysis services and it makes .vbs file from any OLAP object you select. That is, if you select a dimension, cube or whole OLAP database. Then you just run the VBS file and it will create you the object you have...
  3. hudi

    Connection problems SQL Server

    Hi, check if your account is in OLAP Administrators group! bye, Andrej
  4. hudi

    Need your recommendations - Cubes??

    Hi, If you have OLAP cubes prepared, then I suggest to you to review application called ProClarity. Till now this is the tool the best feedback from our users. Or try a new excel based application called BiXL - Business Intelligence for Excel. Bye, Andrej
  5. hudi

    performance tuning analysis services

    Hi, I assume that you have problems with the speed of your queries on your cubes. Analysis Services: On each cube you have option (right click) Usage Analysis. If you choose this, you can see how long it takes for each query to show the data to the user. See which queries are problematical...
  6. hudi

    Choosing an OLAP solution

    Hi, OLAP solutions I build are on MS SQL server 2000 and MS Analysis service 2000 and for clients ProClarity Desktop client! Price about MS SQL you probably know and about ProClarity find it out on their web site http://www.proclarity.com We have build many solutions on these tools and I...
  7. hudi

    Error processing cube

    Hi, As I assume, if you test the connection in the data link properties it is OK! If that's true, i think you should find your solution by instaling service pack 2 at least for Analysis services! Also recheck your privilegies on both servers! What kind of authorization do you have on the...
  8. hudi

    Client For Cube

    Hi, Very good reporting and browsing tool is ProClarity Desktop Client!! You can create reports, so that the users do not have look through data and search the things they want! The latest version is 4.0, but in march is coming out version 5.0! http://www.proclarity.com On the site you can...
  9. hudi

    MDX

    Hi! I have some problem creating a calculated member in Analysis manager! I have several dimensions (Products, Markets, MarketSize,...). Then I have mesures(SalesQ, P,...). Measure P tells me if the product is present in the specific market. e.g. if IDMarket 1001 has for IDProduct 123 value of...
  10. hudi

    How to execute an output of a select statement?

    Well I found that, but now I have another problem on which I didnt think before! My output is about 100 select statements which are pretty long. And I have to execute them by using UNION ALL clause! I mean, I need the union of all my select statements which I get from my output! So, there is...
  11. hudi

    How to execute an output of a select statement?

    Hi, For example i have a select statement that generates me a several new select statement and I would like to execute them! That means that I would like to execute the output, result of the select statement! Anyone? bye Andrej
  12. hudi

    OLAP Cube -Design storage process

    Hi, About your first problem! How big design storage were you making? I had the same problems! I solved it by creating very small amount of aggregations! That means your query's will be slower than before, but after running the most often used query's you have to do the optimization -...
  13. hudi

    RIDDLE

    yeah sorry!! I just wake up now and now I can clearly see that I made a mistake when just quickly overviewed your solution which is correct!! I was to sleepy yesterday to do something wright! OK, you get a chocholate!! :-Q
  14. hudi

    RIDDLE

    it doesn't return the nth highest value but it retuns nth minimal value!! there's no chocholate for you!! :-9 bye
  15. hudi

    RIDDLE

    Well guys you've tried, but only agar wrote the full anwser, which is incorrect in one little word!! agar: you wrote desc, where it should be asc!! We are queryinq for nth highest value! Sorry, no chocholate for anyone!! LOL
See more

Part and Inventory Search

Back
Top