Search results for query: *

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

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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