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 Chriss Miller 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. bittmapp

    Job on Prod Server using Dev Server resources after migrating packages

    Gradly, thanks so much for your replies, I will re-script the job as you suggest and see if it changes the behavior. I initially scripted the job to a "New Query window" and changed all of the instances of DEVSERVER to PRODSERVER. I thought that would work. I will let you knwo how it goes...
  2. bittmapp

    Job on Prod Server using Dev Server resources after migrating packages

    Thanks for your response. I have checked all, I mean all of the connections in all of the packages and they all point to the PRODSERVER databases. Do you think I should install the SQL Management Studio on the PRODSERVER and create the job and schedule from there? thanks so much.
  3. bittmapp

    Job on Prod Server using Dev Server resources after migrating packages

    I created several packages on DEVSERVER and migrated files to PRODSERVER. I created a job on DEVSERVER and then modified the job script to create the same job on PRODSERVER. When I schedule the job on PRODSERVER it seems that there is some connection to the DEVSERVER that is using up its...
  4. bittmapp

    Updating a table with a running sum?

    Vongrunt, you've done it again! You have saved my hide on many occasions! Thank you so much. bitt
  5. bittmapp

    Updating a table with a running sum?

    Hi Vongrunt, To answer your question, SQL 2005. Thanks again for looking. bitt
  6. bittmapp

    Updating a table with a running sum?

    Vongrunt, Thanks for taking a look. Really appreciate it! Correct, Yes, for each product and one last thing. the daily table will have the product and par for every day until today. Even though the transaction table does not have. Like this. product Date par...
  7. bittmapp

    Updating a table with a running sum?

    i have the following two data tables transaction table: product Date parAmt -------------------------------------------- pen 01/01/2006 100 pen 01/04/2006 -100 pen 01/06/2006 250 daily table product...
  8. bittmapp

    Logging and Tracing package execution

    I have a few questions: 1. Is there a more detailed description of a package's execution other than in the debugger? A log file? 2. Is it possible to increase the tracing verbocity of the file? 3. When several packages have been scheduled using SQL Agent, is there a way to see the...
  9. bittmapp

    sp to populate a price table

    Thank you so much for your reply! Will this work if the pen has additional price dates? for instance: current table: product priceDt price -------------------------------------------- pen 01/01/2006 100 pen 01/06/2006 200 pen...
  10. bittmapp

    sp to populate a price table

    Yes, I do have a time dimension built with calendar table . bitt
  11. bittmapp

    sp to populate a price table

    i have a price table with product, priceDt, and price in it. the priceDt indicates the price of a product 'as of' that date. what i need to do is create a table with records for all of the products, for all of the dates from the products first priceDt up to today. in other words, the current...
  12. bittmapp

    Remove Drill to Child Metric

    Hi, In Web 7.5 how can I remove the drill to child metirc? any information would be appreciated. thx
  13. bittmapp

    Metric that qualifies on attribute??

    Can a metric built with a qualification on an attribute. I mean someting like this. if indicator = Y, then sum(amt) else (sum(amt)*.86) Thanks in advance. bitt
  14. bittmapp

    count days in a month

    Hello, I have been able to create a count metric that counts the number of days in a month, but when I put an attribute from other dimension than time, there is a cartesian join with the lookup table of the un-related attribute. What I want to do is show a Month, products, and sales with the...
  15. bittmapp

    Filters vs. PageBy

    Hello, Can someone tell me if this is true or false. Please help. When a report has a PageBy attribute and no filter associated with that attribute and it is executed the resultset will be stored in cache. And then when a user clicks the page by dropdown, the report then uses only the slice...
  16. bittmapp

    Bulk Metric createion?

    Thanks so much, Spod. Your ideas are great. Just what the Dr. ordered. You get a star from me, Thanks again, bitt
  17. bittmapp

    Bulk Metric createion?

    Hello, is there a way to configure or create metrics outside the MSTR Desktop interface, like XML or something? Have to create hundreds of metrics..... Thanks, bitt
  18. bittmapp

    MSTR 7.2 to 7.5

    Hello and Thx in advanced. I was wondering if someone could give a short list of some of the enhancements to MSTR between 7.2 and 7.5. I hear that optimization plays a big part in 7.5, is this true and how? Thank you so much. bitt
  19. bittmapp

    Help with Metric Dimensionality?

    I am trying to created two metrics to use on a report, I am having a problem with one. There are Stores and Departments, Stores have many departments (Parent>Child) here is my report Department Sales StoreSales ------------------------------------------------------ 10 100 800 20 100...
  20. bittmapp

    I Server on an XP Pro box

    Can an Intelligence Server be created on an XP Professional box? When I go to the Configuration Wizard, the option to create the 'I' server is Grayed Out....? TIA bitt

Part and Inventory Search

Back
Top