Search results for query: *

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

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

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

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

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

I am creating a consolidation and putting Revenue in one of my elements. The expression is {Account = 4600}; however I need to multiply it by a negative one because revenue is stored in the database as a negative and needs to show positve on the report. I tried putting {Account = 4600} * -1...

Hi all, I am new to MicroStrategy and new to the group. I am creating an Income Statement report that has a percentage as one of the rows and need to know how (if) this can be done in a Custom Group. An example would be: Element 1: Sales = Filter on GL Account (Account # = 4000 – 4999)...