Search results for query: *

one way is to divide your metric by the threshold metric. eg. create a threshold metric M2 defined by something like case count<2 then 0, else 1 then divide your original metric by M2. When threshold is triggered, you should get a divide-by-zero which gives you a null.

teccum, if that's the case, I would recommend you take a look at the MicroStrategy office product. Apparently you can run regular MSTR reports right from inside excel without going through web. ie. something like an excel add-in.

I tried what you did in tutorial and got the right answer.... When all else fails, delete and try again, I suppose. Seems pretty odd to me tho.

check in version 8. Can access Excel via generic ODBC driver, and can place cross datasource calculations on documents.

refresh your browser cache...

this is more like a bug fix request. The graph axis should dynamically pick up the formatting of the metric being graphed...log it with tech support.

if claim_received and claim_paid are in the same fact table, then you can try the following: create attribute called days_to_payment, point to single table with 2 columns, define as claim_paid_column-claim_received_column. You might need to do some database specific applysimple to get the...

there's a strange bug in the attribute form window. You need to use the f(x) button in the expression editor to create the expression. find the case function under internal functions, for condition type in "isnull(column1)", then pick column1 for result1. Click finish. now in the...

do you mean if column1 is null, then column2, else column1 if yes, then you don't need to use applysimple, instead use Case("isnull(column1)", [column1], [column2])

in this particular case, you get only one value for the num_per; that's why you want to get rid of the cross join. I don't think you can do that in MSTR. Out of curiosity, why isn't the exped_id related to person_id. Seems like that would be logical...

hmm, I'm not too good with xsl. You might need to add TARGET="_blank" to the <a href> tag.

the hanging web sounds more like a bug, did you report to tech support? Some hanging issues are covered in the knowledge base site. For example see TN6800-073-0014 After drilling down on a prompted report, the browser page hangs when using the back button in MicroStrategy Web

One way would be to put your expression for time difference in minutes as a fact. Just as an example, say your expression is (INT(start_time) - int(end_time)) / 60, Then you should create a new fact called Time_difference_minutes, point to your fact table and type in your expression here...

how about using a metric instead of attribute. Create metric as max(date) and add to your applysimple.

the major reason why MSTR does not support it this way is that business days are different in every country due to holidays etc. So how shall we solve this problem? One way is to create a metric called "number of business days". Let's try this approach, it assumes you have a day attribute...

All, version 8 is out on the download site. And yes, they did fix this Report Services document personalization issue. Now you don't need to use personalized report execution.

is the location for the movie file relative or absolute? You might need to set an absolute path to make sure the browser is not looking for the movie in the MicroSTrategy directories.

check out technote TN4100-72X-0210 "How to create a report that returns a random sample of data in MicroStrategy."

what type of distribution would you want from these 100 million rows?

one way is to create a metric called "# holidays" and filter it to the specific dates. Then just do a compound metric.