Recent content by sunnyphoenixier

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...

Thanks for the reply. I have not tried the dimensionality because there potentially can be many metris on report and dimensionality can be complicated by then. However I have opened an issue with MicroStrategy. I will post any progress on this. Thank you again! phoenixier

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

All- I ended up using Dinzana's approach. It works prefectly. The only problem with this approach is the scalability since everytime, I have to draw the graphs again in Excel. Regarding the bitmaps approach, once the graph imported, it becomes static, I don't know how to automate the...

Right. That should work I think, but I have to try it out. I was just trying to find a easy way out here. :) It just doesn't make lots of sense to me for MSTR not be able to sending report in Graph Mode through Excel. Thanks for the feedbacks! Phoenixier

Thanks for the quick reply. It definitely helps. My original intent was to include a MicroStrategy Graphical report instead of using Excel's graph tool. Is that possible? 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...

It is hard, or impossible from my experience, to get this SQL from MSTR. Why don't you query the database directly? BTW, this SQL doesn't answer the question you are asking. You probably want Select SUM(1) from B where PK not in (Select distinct PK from A); Phoenixier

iolaper, Thanks for the feedback. I don't have a definite answer on this. Our understanding is Consolidation impacts the memory of IS much more than Custom Group, probably not much more in this case since there are only 3 values for the attribute, while Custom Group takes much more resources...

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...

petperson, That's a wonderful reply. Thanks! Your NC approach sounds especially creative. It may be an apporach that we can adopt in our case. However, I am curious about what impacts on the NC server it may impose that having a schedule runs every 5 minutes. I guess we can test it out...

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...

Never mind. It timed out. Thanks, Phoenixier

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