Search results for query: *

According to MicroStrategy, invalidated cache whose type is "Mataching" but NOT "HISTORY" should be deleted by MicroStrategy itself. However, we are seeing many Invlidated Cache with "Matching" as its type still loaded to I server all the time. And the Clean Up Invlidate Cache doesn't work...

This issue has been puzzling me for a long time, but I don't know if anyone of you have ever found a workaround on this. When you have the following on a report: Week, User, and metric-Sales. The layout of report is "User" at Row level, "Week" and "Sales (metric)" are on Column. Week is on top...

I have a report using Threshold to replace Metric value. The image shows up prefect on the web. But NC email only shows its URL instead of the image itself. The image is on the Web Server. Any help will be appreciated! Thanks, Phoenixier

I am new to Narrowcast and I have situation which I think should be doable, but just can not get it right. Any help will be appreciated. I have 4 MSTR reprots need to be put into one Excel file and email out through Narrowcast. The first 2 are Grid reprots and the second 2 are Graphical. The...

We all know that Consolidation requires calculations to be done in Analytical Engine. But how do you evaluate its impact on I-Server? we have a situation in which we wonder if we should use Custom Gruop instead of Consolidation to avoid the impact on I-Server. Have any of you run into this...

I am sure many of you guys have done this before. I am trying to expolore some options here. The request is that once a tablebase table is loaded, for example, one indicator column is set to 1, a MicroStrategy report needs to run. One way of doing it is to schedule a Command Manager Job...

Hi, Guys, I am running a large report. Seeing this Error: Expected execution Status 1, 2, received status 3. Have anyone seen this before? Thanks, Phoenixier

Is there a way to identify a list of Objects such as Metrics, that have no dependencies? Command manager Script maybe? We have about 450 metrics created by a developer who has left, but many of them have no dependencies. Any suggestions? Thanks, Phoenixier

I am running into a situation that I would appreciate any help you may give. Here it is: 1. There is one object prompt containing 8 attributes. 2. When select one out of 8 attributes to run the report, user do not want the attribute column name to be displayed because their names are very...

I am running into a situation that because the potential number of rows returned is too big, we want the users to drill to lower level. For example, our report will be at Region level, which has about 20,000 rows. And now if the user wants to dig down to city level, then can drill. However...

I have a field with values like "Summer 2005", I need to translate that into "Summer 2004", basically, to the same text + last year. I know that in Oracle, I can do LTRIM, RTRIM and CANCATENATE, etc., but I cann't figure it out in Teradata. Any help will be greatly appreciated. Thanks...

I am in the design phase of one project that requires currency conversions for multiple facts by using a currency exchange table. The difficulties I am having is that it feels like requires calculations across two fact tables. Here are the table structures: Fact_Table -------------------...

You may find this question strange but it really puzzles me now. Any help will be appreciated. Here is the question. In 7.2.2, with Teradata as backend, when we set all metrics to be inner join, sometimes the report uses "left outer joins" in the last SQL pass between intermedia...

For 7.2.2, on the web, how can I set the save report option to "Save the report with all prompting" as default? Thanks, Phoenixier

Greetings! Need help with customizing Object Prompt XSL! I am creating a new XSL for Object prompt based on existing Single Select Listbox. It needs to have the HIbrowsing function (Having the folder path displayed on top of the box) which just like the...