Search results for query: *

With Oracle you can build a function (not a stored procedure) that can do the decryption. If you have to do it outside of Oracle, you can build your own analytical function inside MicroStrategy (check out the function plugin wizard; and brush up you C++ skills! ;-) ). 2 cents, FLB

Did you make sure that in the datatype of the metric you explicitely maked it as a URL? Worst case scenario, change the XSL to force it to be a URL! ;-) FLB.

I actually just got a call from a MSTR Rep (that's what triggered my research). And he said that MSTR Consulting is proposing a module that does FTP and sFTP. We had been waiting for the sFTP support for a while now (we got the FTP one a while back). Now I am waiting for a quote.... FLB.

Now, that makes more sense to me! :)

Another way would also to disable those users (using Command Manager) at specific times. Not sure how that would translate into the user experience. I would still go the ESM route! :)

execution idling the project will prevent _all_ users from generating queries that will hit the data warehouse while keeping it up and running (i.e. users can see objects, open history list messages,....). [please not that idle mode is different from unloading a project] Another idea: Another...

Don't delete _all_ the cache objects (you will make a lot of users unhappy), just clear the element cache. I concur that this could also be a security filter related "issue".

If you don't show us how you wrote the SQL for the logical view, I don't think there is much we can do to help....

From the model point of view, is B4 the parent of A4 or is A4 the parent of B4?

It's one of the preferences in Web at the project level if I am not mistaking (well.... actually I think the limit in on the size of the file, not the number of elements).

Is your column wide enough on the grid? Is the data type you are using for the column wide (big) enough to store such large number (if not look at the new BIGINT support in 8.0.x)

No need to use applysimple on that one, the case statement and a compound metric will do (the max(flag) metric is just going to need to have the right dimensionality)

You must have disabled the popup warning windows.... When you rename a project you _have_ to restart the I-Server for the change to take effect..... Now the main question is: why do you need to rename you projects in production?????

This is odd.... This is not what I am seeing in 8.0.0 nor in 8.0.1. Any customization in place?

reisw is right and you will not need OLAP Services! ;-)

You probably don't need to create a fact if the report mockup you put out is actually real (and then follow iolaper's solution with max(name@desc) instead of max(name)). If you have OLAP Services, you probably can do that in a derived metric too. 2 cents, FLB

I personally prefer not to stop I-Server if this is not necessary. Instead I: - set the project in execution idle (i.e. users can do whatever they want, but the request wait in queue and do not hit the DB) - set DB thread / priority differently early in the morning in case the ETL process is...

When you run this report and send it to your history list, what is the size of the cache generated?

Hi, I was checking with google what the max value for maxHeapSize would be and ran into this thread: thread42-788935 (supposed to have a link to it, not sure how this will show up though...). Anyway, the thread states that the max value is 768MB for Windows 2000. Now, I will not deny it (nor...

1. Are you using "Char" columns in your database or "varchars". If you are using "Chars" you might want to use the "trim" function (or strtrim?) to replace leading and trailer spaces 2. You can change the alias for the "metrics" header to "" (instead of matching the font color to the background...