Search results for query: *

Thanks for trying Jeff! :) markros, I couldn't get your join to work, it returns no data. I had been trying something similar before I came here for help. I was able to get snitin78's code to work, so I think I'm set. Thanks so much for all your help guys! You rock! :) Toni

Thank you both! I'll give those a try and see if I can get it to work.

SQL 2000 I have never done loops or variables in SQL, but I think I need to for my current problem. Any help on the syntax would be greatly appreciated! I need to populate a table with ranges of numbers. My table will have only 2 columns… “from” and “to” values, and should have no gaps...

thanks reisw, I will give that a try. Toni

Hi folks. I hope someone can help me with this. I’m trying to display two metrics filtered by two different date attributes on the same report with one single date displayed. I need to display dollars ordered and dollars invoiced by day. Dollars ordered is based off of “Order Date” and...

Just got the permissions changed on the repository database and it works now. Thanks.

Yes, we migrated all the databases. Right now it appears if may be a permissions issue on the migrated databases... that is what we are exploring at this moment any way. Any other suggestions would be appreciated though. Thanks!

We have moved our sql database (target data) to a new server. We made the necessary setup changes to the point where we can now run workflows sucessfully. However the sessions that contain persistent values are updating the persistent values on the old server. Can someone tell me what I need...

Thanks for all your help ArtieChoke. It turned out to be a problem in the batch file itself.

I'm not sure if this will help any, but we created another batch job that just copies a file from one directory to another. I substituted that bat file in my command task and it worked. So it's just the email task that fails, though I can run the exact command from the command line and it...

Yes, the batch file does run if run outside of Infa... it sends the email as it is supposed to. The workflow log shows... INFO : LM_36330 ... Command task instance [testemail]: Execution started. INFO : LM_36620 ... Command task instance [testemail]: running command [Command1], with command...

Thanks for the suggestions; no luck yet. Any other ideas? Toni

email.bat is my batch file that sends an email. I've tested that and it works fine. It's just when I call this batch file from Infa that doesn't work.

We are using INFA 6.1 and do not use exchange server. We would like to use email notifications of failures with a command task. We are using blat as the email program. In the command task we have tried "c:\blat\email.bat" and "\blat\email.bat" but neither of them sends an email. Looking at...

We are using Informatica version 6.1 and would like to use the built in email funtionality for notification of failures, etc. I see in the manual that if the server is Windows based (which ours is) that we need to use Outlook. However, we use Lotus Notes and I'm wondering if there is a way to...

Thanks!

I am new to SQL and need help with the following problem. I have a table that contains every Fiscal Period (format is year month) and the corresponding previous Fiscal Period. Here is an example of the data in the table (it really contains all years back to 1998 and out to 2008)… Existing...

I'm new to MSTR 7.5. I'm trying to learn Report Services and have been looking at the Operational Metrics document in the MicroStrategy Tutorial project. I can't figure out how they omit the column metric headings from the Revenue, Profit, Margin, ect... grid reports. When I bring those...

I am trying to display the report's directory path in a pdf header or footer. There is no icon to do this, but I wondered if there was another way to do it. I go into my report, go to Data / Export Options and choose pdf file. Click on Advanced Options and then the Header / Footer tab. There...

We are trying to set up report templates for our power users to use when creating a new report. We have created a report with various attributes and metrics. The metrics contain a date prompt and the report also contains a report prompt on company. We then copied this report to the...