Search results for query: *

Is there a way to ftp a file to a ftp server using Narrowcast Service.

Hi, I would like to get a report like this Item Cost AAA 10 BBB 25 CCC 100 which displays only the latest cost information for an item. The fact table has following values Item Date Cost AAA 08/02/05 20 AAA 08/04/05 10 BBB 08/01/05 50 BBB 08/02/05 25...

Hi, Can anyone tell me whats the time interval between each SQL Retry in Narrowcast Server Pre-SQL editor. Thanks

Hi, how to do exception reporting. If i have duplicate records in my table, i would like to show uniquely that these are duplicates. Order_Id,Order_Date,Order_value , Combination of this is duplicated in the table by whatsoever reason. How can i get the report to do exception saying that these...

Hi, I have a nested prompt , say Year==>Quarter. I pick up Year=2004 and being nested my Quarter shows values pertaining to that year. This prompt is optional. Since I want all the Quarter values belonging to Year=2004 i don't select any at this level. The SQL generated doesn't contain any...

Hi, I have services configured to Save To File. Services are running successfully but i don't see any file getting saved in the said location. Whats missing in my setup ? Any ideas.. Thanks

Hi, I need to run services based on information thats loaded in the warehouse. We have number of customers whose data comes and gets loaded at different time. Every customer has a service associated with it. As soon as "customerA" load is complete i would like to kick off the "serviceA". For...

Hi, How to setup an enviornment where we have WebI on unix and Publisher on Windows(i think we cannot have publisher on Unix). I am using BO Enterprise 6.1a suite. Any suggesstions on setting up the environment. Thanks

Hi, How can we asscoiate a datamart to a report. My report has information coming from data mart. So i need to run datamart first to refresh the data and then execute report. Thanks Sanjay

I am trying to generate a report which generates the following SQL in MicroStrategy resulting incorrect results. I am interested in creating a direct SQL which generates correct results .(as mentioned below at the end). How can i avoid having clause in SQL and i am looking for a where clause in...

Hi, Is there a way to retrieve Administrator's password for a metadata. We lost the password. We have a metadata for which Administrator's password is not known to us. Can MSTR tech support figure out if we provide the metadata. Does anyone has any suggestions. It would help us in getting this...

Hi, How can i display list of values or attribute elements along with a pseudo value like 'ALL Values' so that user has choice of picking up either a definite element or this pseudo value. Thanks

Hi, We have one Intelligence Server license which we are using it for Production. If we need to have a development Inteligence Server, can i use the same license on a different box and treat it as development IS. Does license manager allow this or should i purchase another license for...

Hi, Need clarification on how cache works in Intelligence server. I have reports executed inturn creating cache for this months(say January month) data. When i run the same reports next month(Feb month), does it going to retrieve me the latest months data as well ? or just the last months data...

Hi, Can anyone suggest a way to implement a project having two environments i.e,Development and Production. How to move objects from dev to prod environments. Note: We don't have Administrator's Object Manager license. Any method without using Object Manager would really help us in setting up...

Hi, I have few reports which use custom group(around 20 groupings based on a metric value say ranges) and go against 15GB fact table. The report comes out with an error saying report execution timed out. I tried increasing it to 60 min, but still of no use. These reports are run once in a month...

Hi, I need to calculate no. of days between 2 dates in MicroStrategy using ApplySimple and Datediff('dd',date1,date2). I am aware of using this directly when the two dates are attributes or metrics in MicroStrategy. But how to calculate and apply the standard ApplySimple along with datediff...

Hi, Report which is bursted out has to be sent to a FAX server. How to achieve this in BO. Fax Server here is RightFax. Any suggestions ? Thanks

Hi, I am aware of sending email through VBA as an attachment in whatever format. But now i need to send email with report data being email body instead of an attachment. Any ideas ? Thanks

Hi, Do anyone one know what complexity is involved in Webi Interface Customization. What are the files to be customized. I am using ASP. Appreciate help, examples and guidance. Thanks