Search results for query: *

I have a report with 2 metrics, A and B. Metric B has a metric qualification filter based on metric A. When the SQL is generated metric A is determined twice (two passes), once for display and once as a qualification for Metric B. Is there anyway that I can get Microstrategy to eliminate one of...

I have a report which allows the user to choose a month and then displays a single metric, by day, for that month. Unfortunately, if there is no data for a particular day, then this day does not appear on the report. How can I force all days for the month to appear?

Thanks nlim, I agree with you that BOBJ becomes difficult after a while, so much imbedded calculations that are difficult to correct (especially if you were not the one to have created the original report). I am working as a contractor for a company that has never had BOBJ. I have used it in...

Thanks for the response. The report accepts a prompt for a chosen month, then displays that month's calculation along with the previous eleven months and a percent change between the last two months. The dimensionality constraint of Microstrategy does not allow me to do this easily. (I could...

I have created a metric which is quite complex, it relies on 10 other base metrics. I need to produce several transformations of this metric but the transformations do not seem to work. I have been told that I need to create transformations for all of the base metrics in order to make the...