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

Thanks to all of you ! Can anybody help me a step further now. I have a date record with date_ts, year_id, month_id, quarter_id, week_id. Month_id, quarter_id and week_id are unique keys that start with value 1 from Jan 1st 1900. Year_Id is 1900, 1901 .. 2006. Any way to create - week of year...

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

thanks a lot for suggestions

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" ?

no luck, any other way to pass this parameter, so that the link works OK ?

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,

Thanks a lot ! Is last_name + ", " + first_name as fullName a correct Oracle syntax ?

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