Search results for query: *

Hi MicroStrategy gurus: Basically we developed two metrics, say metric A and metric B. For all product IDs, except product ID1,ID2,..,IDm, we'll use metric A, otherwise, use metric B. We're trying to create another metric C that is the combination of metric A and B, so that users don't need...

We have an MSTR document that comprises of multiple reports. What we would like to do is to setup a prompt such that we can decide as to which of the reports are included in the document. Basically what we want to do is dynamically change the contents of the document. Unfortunately it seems...

Hi there, We have individual users and groups subscribed to various services in NarrowCast. Many of these folks are both individual users and members of groups. Does anyone know how MicroStrategy counts NarrowCast licenses in this situation? Does "group@company.com" (which...

Namrac, We ran into the same problem, where the License Manager counts admin users as architects as well. Like OLAP Services, this license-within-a-license trick is designed to get you to pay more money. To get around it, uncheck all architect privileges from the system administrator group...

Thanks, entaroadun. Not sure what I'd do without folks like you... 26point2

Hi there, I'd like to create a report with a distinct count of users, sum of their pageviews by month, and a derived metric like this: Time Unique Users Page Views PageViews/User Oct 2003 1,000,000 5,000,000 5 Nov 2003 2,000,000 9,000,000 4.5 ...and...

Hello, Does anyone know if we can use NarrowCast to run SQL statements directly against a database, and then use NarrowCast for the scheduling, formatting and distribution? We have some report and file requirements that don't lend themselves easily to a dimension model. When I set up a new...

Hi there, I have a metric that counts orders in the customer fact table. I'd like to modify the count to exclude order id's that are in the suspended user fact table. I haven't been successful playing with count parameters, and I'm not sure about importing a list of 400K orders to be used as a...

MSTR gods: I have a conformed geography dimension with five levels in the hierarchy--- from country down to zip code. Some countries don't need all five levels--- they only need four. For records of such countries, the county and sub-county levels have the same data. When you drill down in...

Hi folks, We have a 7.2.1 web report that has six possible prompt answers-- one choice for each of the last rolling six months. Rather than have to manually run this report six times every morning (once for each prompt answer) to create the caches, I've created six duplicated schedules (again...

Hi there, We have a prompt that will let users select any dates that have passed our QA process (max(date_id) where load_flag=6). We'd like to have the default answer be the max of these dates. That way, users can just hit "finish" and execute their report for the latest data, or...

nlim and chael, Thank you for your help! It's good to know there are experts who cover this board. Though hacking into the database through an asp page is ugly, we did get it to work through an OLE DB, rather than an ODBC connection (the MicroStrategy Oracle driver is problematic, as chael...

Has anyone tried to put a data refresh timestamp on their MSTR web pages, so that users know when the last time the database was loaded? I'm trying to insert a database call into the genericheader.asp page and placing the max(date_id) on the web page. I've been able to insert this field into a...

We have created a stacked report (one grid report on top of another, with the second header removed) via a document and modification of XSL. This document displays properly in MSTR Web, but we would like to enable a download to Excel when users click on the report. For a standard grid report...

Aman, you need Object Manager. Several of the other posts reference this admin tool, which will allow you to selectively move objects. It must be purchased separately. Hope this helps! Dennis write2dyu@yahoo.com

Well, folks, I figured it out. Three simple steps. No need to make calls to the metadata database or anything complicated. Here's what to do: First, find the GenericHeader.asp file. Where it references the canned MicroStrategy logo, insert the following: If...

Hi User14, Yes, you are right. Would you have any example code that I could use to do this? Much appreciated, Dennis

Hi there, We have one department that would like to see their logo displayed on their login/welcome page for their various projects they own. This is easily done by inserting our logo into the GenericHeader.asp file, as described in TN5600-072-0551. However, another group of departments we...