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

    Scheduling Cube Processing

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

    Set Datefirst question

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

    Dividing percentages evenly

    PaulBricker, thanks ! exactly what I was looking for.
  4. gaperry

    Assign role to owc pivottable

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

    Assign role to owc pivottable

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

    Dividing percentages evenly

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

    Assign role to owc pivottable

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

    Retrieve MDX query from Excel

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

    Biztalk training

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

    Viewing the SELECT statement in an OLAP Cube

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

    Pivottables and web access

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

    Check out a free OLAP DHTML browser

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

    Check out a free OLAP DHTML browser

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

    Biztalk training

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

    Help with an Insert and Where statement

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

    Help with an Insert and Where statement

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

    Connect to OLAP Server with HTTP Connection

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

    Biztalk training

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

    Biztalk training

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

    MDX select statement to show all cube data based on the user login ID

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

Part and Inventory Search

Back
Top