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!

  • Congratulations bkrike 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: *

  • Users: gmckernan
  • Content: Threads
  • Order by date
  1. gmckernan

    Selecting 2 dates when viewing time dimension - PLEASE HELP!!!

    Hi I have created a cube and Im viewing it through Excel. My Time dimension drills down Years>Months and works very well, however I CANNOT SELECT 2 months at once beside each other to show data for them. The drop down combo box only lets me select one date at a time...is there any way to...
  2. gmckernan

    where do I enter limiting SQL when creating a measure.

    I have one very simpole question. In creating a cube I am bringing out sales for all suppliers. However I just want it to bring out suppliers that are in location 2 I know the SQL will be "select suppliername from suppliers where location = 2" However I have no idea where to put this...
  3. gmckernan

    DTS scheduler not saving when to process details

    I am going in and scheduling a time for a DTS package to be executed. However I make the settings (For example process package every Monday at 6.00) When I go back into the scheduler..IT DOESNT SEEM TO SAVE THE SETTINGS AND IT JUST RETURNS TO THE DEFAULT !!!! Is this normal...is it accually...
  4. gmckernan

    Processing analysis services cube at specific time

    Hi Im at a loss I want to be able to use DTS to process a cube at a specific time every day, say 9am every night. I know there is some DTS control that lets me do this...does anyone know what it is or where it is and how it is used. Any help is greatly appreciated... Gavin
  5. gmckernan

    viewing a .cub file - what to use

    when I create a .cub file using analysis services and save it on the server, how do I view it in Excel...when I go to file/open I cant even find the file...can anyone shed some light ??
  6. gmckernan

    Problem viewing a simple dimension

    I am creating avery simple dimension, I basically cannot get any dimensions to browse. It goes all the way to the end of the wizard to create them then says "unable to browse the dimension 'New Dimension' The parameter is incorrect" Any ideas anyone ? its a very simple dimension, I...

Part and Inventory Search

Back
Top