Search results for query: *

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

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

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

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

Hi, Does anyone know how to turn off the report status indicater for the Web interface? You know the circle that has the binary numbers moving around in it... TIA, bitt

Hi, I have a report that has a prompt for to pick month. The report has item as an attribute and sales as the metric. I would like to create a new metric that shows the accummulated sales for the item from the item's start date. The item's start date could be last month or could possibly...

Is there a way to have the default report template for an Empty Report formatted to Squares rather than Red and Black, at the project level, not the user level? thanks, bitt

How would one be able to name a target file with a value from the source data, and make it different each day? In other words, I have a source with a field (here is an example of the value in the field, '20041012') and I want to name the target file something like this...

I am trying to insert and / or update a target from a flat file that is set up like this. PK indicator value 1 revenue 100 1 cost 200 1 percentage 50 What I want the target to show is the following PK revenue cost...

Can a document object be sent to an email address using Narrowcaster? Thanks for your input. bitt

Hello, I have to create a fully prompted report that allows the user to do the following: List the (Top 10 departments in sales) or (show the departments in the Top 25% of sales) or (Bottom 10) or (Bottom 25%) for a chosen Store, for this week. Do I have to build separate metrics for Rank...

I have a fact table with prod_id upd_date price i want to create a metric that will return the price for the product for the latest upd_date. do i have to add a column to the table that indicates current price? any ideas would be appreciated. thanks, bitt