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

Kirti, Its a real cool ETL tool

Hi refer to Tech Note in MSTR support site for more details on XP support for MSTR : TN5800-72X-0175

Sorry about the subject typo error , it is SQL Retries.

petperson, Could you pls let me know whats the time interval between each SQL retry in PreSQL editor in Narrowcast Server

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

Across network

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

nlim, this could be a good candidate for your WISH LIST. I see a great advantage with this feature(triggering datamart from a report to utilise the objects created by datamart in the report) in the tool. Thanks

entaroadun and nlim, you are correct. i have to run my datamart every time when i have to run my report. I agree as you said that it defeats the basic urpose of datamart. i am using this datamart as one of those multipass SQL and using the metrics generated in the report. I am looking for...

I have my datamart into the project and also have respective objects pointing to this datamart. My report uses these objects and also other objects in the project. I want to run the datamart before i run the report sothat datamart gets refreshed with latest data.

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

Thanks entaroadun, i am able to get the desired results.

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 bring psuedo value rather than making prompt optional.