Search results for query: *

The one bug I know is 'Report Service' documents that have freeform sql grids on them. They will not work in Object Manager. You will have to delete the project in production and copy the entire project over. This was in 8.0.2 HF1 I think. Otherwise I haven't found a reason to choose Object...

1) If Month and Date attributes are parent-child you should not need to define both on the report. If you use a hierarchy prompt I think you can achieve this result. Create a custom hierarchy called Pacific where the only attributes on it are PacificMonth and PacificDate. Now create a...

Make sure you have temp table space creation access in the database and if so, you have ENOUGH space to store it. Users in my client site have 200GB spaces and they spool out. Try to restrict the amount of data you want to display. Check your SQL for cross joins and make sure 'fail on...

You should be able to open the two project sources and source and destination projects and be able to drag the report from source to destination. (Microstrategy's uniqueness is its Object Oriented concepts that allows you to freely drag and drop objects.) The conflict window will open up with...

Paste the SQL here please. I think you have no relationship between your two attributes when they try to access your fact data together (data not available at that level). Make sure the fact table that these two attributes are meant to share, are checked on both attributes. Please send your...

1) go to SQL view of the report and check to see if you have any cross joins. 2) Try running the report during off peak hours to see if it still errors. 3) Take the SQL from the report and query your database directly to make sure it's the data retrival that is causing the issue. If the SQL...

APPLYSIMPLE("(TRUNC(sysdate)-#0", DATE) DATE is not Drop_Date but the form in the attribute that contains your date. It's been a while since I used ApplySimple, so if I am wrong someone please correct me. Thanks iolaper

We have the same problem and I have logged a case with Tech support for this, though they have not figured out a solution for it. Text boxes WILL BE reformatted when viewed in the web. The workaround is to try to use the grid header as much as possible. Our client wanted the web, excel and pdf...

If the report was cached and only cache was executed, you will not get any SQL generated.

1) Dont think so (It would be a 'NO' had I worked on those two versions). 2) Yes, but when you move the project and try to open it in the newer version it will throw up a dialog box asking you to 'Update' the metadata to match the IS MSTR version in the destination. In normal cases I would...

Yeah that's not exactly what I want. The one thing I found out is to change the code on MSTR web and change the XSL to point to a new window. I was trying to avoid that.

I thought this would be obvious but in Web 801, is there a way to tell MSTR to open up a new window to execute the report when you click on a report link? Right now when you click on the report it executes and returns data on the same page. I know there is an option to export reports into excel...

Hello All, I have been part of this group for almost an year now. I have found it very useful, invaluable and informative. I have recommended this forum to so many co-workers. A couple of quick suggestions: 1) When someone helps you out please do give them STAR. Not only is this a great...

Dataover load? Cache on server consumed all the memory? Has time limit for report execution exceeded?

Create a fact from Name. Use it as a Metric. The definition of your metric should be Max(Name).

Read TN5800-75x-0588 for help

You could either use an ApplySimple or use a Threshold. Thresholds do not require you to come up with any fantastic solutions, but are pretty powerful. The only catch though is that both your Indicator attribute and your Sum(Amt) metric should be on your grid

I just skimmed through your question, and hopefully I am giving you the right solution here: Go to your Condition Tab in metric, and click on Advanced. Uncheck 'Remove related report filter elements' This should do the trick!

Giving this assuming you have OLAP services, create a metric with Max(Date) and through it in your Report Objects window so that it is hidden. This should give you the results you need. If you dont have OLAP services you can still hide that one column by setting the width of the Max(Date)...

I think there is a way to append the userid at the end of the cache file so that even if both users run identical reports with identical filters it will still not share cache. But coming back to your question, if a user creates a cache of a report, and another person reruns the report or a...