Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

For a little entertainment!! We all know how to find the highest value in a column (MAX(), SET ROWCOUNT 1 / ORDER BY, SELECT TOP 1) But the question is: how to find the nth highest value in a column??? Well?? B-)

Hi! About your problem! Why don't you create a procedure in your DTS as SqlExecute Task, which will generate you a time table! year-quarter-month-week-day And then you can use VBscript to name all the days and months...!! It's easier!! Then your problem can be solved in Analysis manager...

Hi, One another thing that Terry did not tell! In case that your login on SQL server is windows authentication then your command line looks like: dtsrun /S serverName /E /N packageName /E stands for trusted connection Andrej

Hi Sarah This will be very short! Look I work with MS OLAP on databases of MS Sql an DB2, but I suggest you Cognos solutions! Yes it's much more expensive but there is a reason for it! Your database for OLAP will be probably on ORACLE so try to find a product that is most optimized and...

The ways to log all processes on dimensions and cubes in Analysis service! Anyone??