Search results for query: *

We are creating a migration process for MicroStrategy environment and writing down pros and cons of using object manager or project merge. Have you had any undocumented issues with any of the tools (unexpected results or software bugs), any tool does the work quicker than the other or any...

Do you have access to any best practises documents on setting up MicroStrategy security you can share (security roles, groups, users, object level etc.) ?

Wonder if there is a possibility to leverage caching in the following scenario: In the model: Sales Person -> Branch -> Region -> Channel Report template has - Channel and metric (on the channel level) There is a prompt on Sales Person Let's say John B. and Tom P. both belong to channel ABC...

Anybody successfully run a report and then switch the page-by selection through the URL API ? I followed tech note TN5600-8X-1915 and not sure what to use for elemKey.

Is there any cleaner way than building table aliases in MSTR to implement multiple metrics, performing calculations by joining fact table to LU_Date table on different date fields ?

Need to create a URL link for report services drilling. Parent report has a custom group in a page-by so that one custom group element makes one page. When I click on the link, I’d like it to dynamically pass the current page custom group filter over to the child report. Can I do it without...

How do I convert integer number from 1 - 9 to a char '01' - '09' and in the same time integer 10 + to same char with two characters ?

Is there a function in DB2 to returns the first nonzero argument ? Column1 = 0 Column2 = 1.5 Function (column1, column2) = 1.5

Are any of these date functions supported in DB2 ? Monday of the week (INPUT: date) for example Monday of the week (2005/02/01) = 2005/01/31 1st of the month (INPUT: date) for example 1st of the month (2005/01/21) = 2005/01/01 1st of the year (INPUT: date) for example 1st of the year...

Any idea to modify existing metrics calculating days between two given dates: Facts are defined as: Date_n+1 - Date_n and metrics as sum(Date_n+1 - Date_n). These calculations should exclude company holidays. This is MicroStrategy 7.2.3 platform. The database platform is DB2 and the fact table...

I am getting an error with with CFX_Excel Tag when running a Coldfusion 4.5 application. Error Diagnostic Information Error in CFX_Excel Tag Can't start Excel The error occurred while processing an element with a general identifier of (CFX_EXCEL), occupying document position (29:1) to...

How can I configure MicroStrategy Web 7.5.1 so that by clicking LOGOUT, user would be logged out of the system and would be redirected to a different web site, instead of standard "Thank you for using MicroStrategy Web. You have been logged out" ?

How should I modify the code below that mrnumber parameter is passed to url path of the action page? When I hit submit, I want to see in the url: get_report.cfm?type=mr&mrnumber=xxxx <cfform action = "get_report.cfm?type=mr" method = "post"> <div align="left"> <font size="2">&nbsp...

Does the instalation process for Coldfusion Server 4.5 prompt the user to set the password for Coldfusion Administrator web access ? Or it is set after the server is installed ?

How can I check the version of my Coldfusion Server ? I need another way than logging to Coldfusion Administrator Web site. Does this information maybe sit somewhere in a text file in the folder where the Cfm Server is installed ? Thanks a lot,

How can I display two columns in a drop down, like: <CFQUERY name = "getpersoninfo" ... > select person_id, last_name, first_name from person </CFQUERY> <CFSELECT .. query = "getpersoninfo" value = "person_id" display = "last_name, first_name">

Anybody ever had an issue with an ApplyComparison function inside advance qualification. SQL generated by the report ignores this filter. This is MicroStrategy 7.1, issue both in 2 and 3 tier. To make things stranger, the code used to work. It stopped working after I made a modification to the...

Is it possible to change the mail server used by Coldfusion to send e-mails other than through Administration web page ? Also, how can I reset password for Coldfusion administration web page ? Thanks a lot,

Today is the last day to purchase MicroStrategy PEP program for 2,500 $ a year. It will cost 3,000 $ starting tomorrow. Details on http://www.microstrategy.com/Education/PEP.asp. The requirement is however two people to sign up (5,000 $) and I am looking for somebody to share the cost. Please...

I have an error with an application written in Coldfusion, which executes queries against the database and puts the results in Excel. I am getting the following error, no code changes have been happening recently. The program has been working fine. Any idea why this could be happening and how it...