Search results for query: *

Flybridge, there is an "connections icon" available in DTS designer that will let you "Execute a Package". You just select the icon from the "connections" list (same area you select your "to and from" connections. The icon looks like a small yellow package / box with blue arrows. Once you drag...

I have a "view" where I am using DATEPART (week, [mydate])to show the current week and I need to make sure that the week shows up in the view based on the week starting on Monday instead of the standard US week which starts on Sunday. What is the best way to combine DATEFIRST with...

PaulBricker, thanks ! exactly what I was looking for.

plsh, Yes, you are correct on the Enterprise Edition question. I had forgotten about that since I started out with that edition of SQL server. If is more expensive but worth it. Microsoft will be adding "Reporting Services" to this edition in the next release of SQL Server. I am...

Hi plsh, Here is the link that discusses connecting to Analysis services via web. http://support.microsoft.com/default.aspx?scid=kb;en-us;324961&Product=sql2k I hope this helps. Worst case, we could always do this via phone if you are really in a jam and it would help to do this one section...

Hi all, I have a number that I need to divide accross a group of percentages. Example: $1000 - Need to spread this number accross the following percentages 60%,30% & 10% to find the correct $$$ value for each. Note that the total percentage will always be %100. There are several fields...

Hi plsh, I had a similar problem with this some time back. When connecting via OWC in your browser, does your connect string use an HTTP protocol for your DATA SOURCE NAME ? (i.e., "http://SERVER NAME") You should be able to use any valid Windows username in the connect string...

Hi pabloj, Could you tell me exactly where to look in Excel to find the above Pivot table object and it's MDX properties ? I am some what new to using this in Excel. Thanks.

timscronis, Sorry to tell you that I did not take the training. I have heard good things about this outfit but we opted not to do it this year because of the economy. Good luck. G

I have created several data cubes in MS Analysis services and am using MS Office Components to view them in a web browser on our website. I am TRYING to remember how to view the entire SELECT statement for a given data cube.(MDX Query) I want to be able to cut and paste the MDX query into...

datras, reference this article and webcast from Microsoft. http://support.microsoft.com/default.aspx?scid=kb;en-us;324961&Product=sql2k I have a similar setup as you described and now have a good solution for this..I can type more on this later if you need it but have to run for now...

ClarkJeff, I am using the standard MS Office embedded pivot table in my web pages. I also have this setup using security for our external users combined with MDX expressions and roles to limit who can see what. I have installed the free browser mentioned above and it is simple to use and from...

Hi, Not sure how or where you found this nice little OLAP browser but, THANKS ! I already have in place a web based OLAP system using Analysis services, OWC and Browser but this is a nice little utility for reporting needs. About time something like this was created and then given away for...

barefooter, Here is the website for the Biztalk training. http://www.altotraining.com/developer/courses/moc2379.asp I have not actually taken the training yet as we have pushed out some of our apps until later on in the year. The other item of interest is that this company does not get a lot...

swampBoogie, thanks for the reply. The tables I am using have very few fields. What I am trying to do is: In table B, I need to add a week number in the week field, (in this case week number 4) where it does not exist and at the same time, update the other fields that go with week 4 in table B...

I am trying to insert a row of data from one table where it does not exist in another table using the below statement. In this case, I want to insert the data from table A into table B where week 4 in table B does not exist. And at the same time I am setting the week in table B to be 4. I get...

Hi radekr, I have spent the better part of last year setting up our Web Components and data cubes for public access. It was sometimes painful and documentation was hard to come by but it has been succesful. A couple of questions for you below. Here is the Microsoft link that you referred to...

Thank you very much. I ended up finding a place in Minnesota that is Microsoft Gold certified.

Can anyone tell me where to find a good training class for Biztalk ? Or at least recommend a few good books ? I searched the Microsoft site and could not find too much in a way of training. Thanks, George

I am somewhat new to MDX. I have a webpage that displays a pivot table based on an Analysis server data cube. I am trying to create and MDX statement that would show ALL data in the cube for a given sales person based on the Microsoft login ID. Example: Show all data in a given cube for sales...