Recent content by andresvc

My recomendation is..... Insert other field in the table A and change the value of this field (like a flag) when you pass the information to the table B.

This is the script for this problem. For Sales in the last 30 days. ApplyComparison ("#0 < #1", [Date DataBase]@ID, ?[Date Prompt]) AND ApplyComparison ("#0+30 >= #1", [Date DataBase]@ID, ?[Date Prompt]) The rest of the filter is in the same form. Regards.

Hi everybody. In my report I want to present 3 metrics: 1) The sales in the last 30 days. 2) The sales between the last 31 and 60 days. 3) The sales between the last 61 and 90 days. The problem is that I base my study in a date prompt and then I compare this date prompt with the day of the...

What I need to do for configurate the SQL Mail????? Thanks for your help

I want to use this Case in DTS of SQL Server and I can´t. Regards.

Hi... I want to use the expression Case with SQL in the oracle database but I can´t to find the correct form to use it. Anybody can help me????? or if you know about a link with a very good documentation of that please tell me... Thanks for your help. Regards.

The problem was that I have 2 pages of prompts and I need to finish them in two ocassions. In the first page I observe the prompt SELECTION. I need to select the INVOICE DATE or NOTE DATE and then I click finish. In the second page I observe the prompts DATE1 and DATE2. I select the dates and...

- I have the facts 'INVOICE' and 'NOTE'. - I make a metric 'INVOICE DATE' that use the fact 'INVOICE'. This metric include conditions with prompts referring to dates 'DATE1' 'DATE2'. - I make a metric 'NOTE DATE' that use the fact 'NOTE'. This metric include conditions with prompts referring...

With the metrics in the version 7i we can use the thresholds but what happend with the attributes???? Thanks for your help..

I will call to tech support. Thanks nlim.

I think that the problem is: For example in the report 'A' you call with prompts the attribute Year and Month, the report 'B' calls with prompts the attribute Year for consequence you only have two prompts Year and Month. If you want three prompts you need to create another attribute for...

Hi. I have a problem with the color of the values of the subtotals. I have a metric 'A' that present information in currency format and I have the metric 'B' that present information in percent format but the color of the negatives of this metric is red. I want to see the value of the...

I will try this. Thanks.

I have the version 7.2.0 of Microstrategy and I can see this option but I try to use it and not runs. You can tell me why?

The problem is that the information change every day. For example a user runs a report at 7:00 P.M. and the information change at 8:00 P.M. and the system present wrong information at 9:00 P.M. Do you have another option for this??