Search results for query: *

Hi all, This is a situation that I have never come across. I have a report in the following format... -------------------------------------- First Name | Last Name | Email | -------------------------------------- Now, I have to send email to all the users in the above list. The above list...

Hi All, I have a problem with my CASE statement. I am checking if any of you have encountered the error... Basically, What I am trying to do is.... IF GLDEPTCD = '01' THEN Metric1 ELSIF GLDEPTCD = '09' THEN Metric9. Please ASSUME that the SQL recognises all the temporary tables that starts...

Hello everybody, I have a compound attribute to get me "Item# & Warehouse Code" of an item. It was all working fine, when on one not-so-fine day, Someone/me messed up with the compound attribute (May have deleted/added a child or parent to this compund attribute). Now, the SQL looks like...

Hi All, I have this interesting situation where I do not get values displayed on my report. I get something like... ----------------------------------------------------------- Item#(WhseCD) Cost Purchases Sales 1 ABC 0 10.89 0 2...

Hi All, I have this interesting scenario: I have two columns (DeptID & ProdID) in my table and If I build an attribute for each of those columns and try to display it on the report, I get the following: __________________________________________________________ DEPTID PRODUCTID 0300...

i All, Can someone please tell me what are all the steps that I need to take care of to MIGRATE MSTR 7.5.1 to MSTR 7.5.3 We have a handful of desktop users. This is what I believe I should do: 1) With Administrator priviliges, use LICENSE MANAGER to upgrade the Key from MSTR7.5.1 to...

Hi All, I have this error while trying to execute a report: "Fact does not exist at a level that can suppport the requested for analysis" I am sure most of you have come across this. From my knowledge, there may be two reasons for this... 1) If the fatc is not defined at the intended level...

Hi all, I have a report that is to be displayed only in "Graph mode" on MSTR web. Although, on the desktop, I checked the Graph options so that I can see only graph on web, I am seeing Grid-Graph mode by default. Is there any other dafault setting that can change the display on web? The end...

Hi all, In one of his posts, Cuseman, mentioned a you need for an XSL style sheet to display only metrics by hiding the attributes in the report. I am fairly new to "Document Objects" and here is the situation I am in. I have two reports as shown below: Report#1: CUSTOMER Metric #1...

Hi all, This is my sample report requirement: DateTime1(DT1) DateTime2(DT2) Diff=DT2-DT1 (hr:min) 1/10/2004 9:00AM 1/10/2004 10:45AM 1:45 1/31/2004 10:30AM 2/2/2004 11:55AM 25:55 2/28/2003 11:30AM 3/1/2003 11:30AM 24:00 The DT1 & DT2 are two attributes of the type...

Hey all I know that Microstrategy does not support RECURSIVE HIERARCHIES. But can someone guide me (a URL)to a place where I can have more conceptual details on "Recursive Hierarchy". Also, How do we overcome Recursive Hierarchy using MSTR? Any kind of explanation/URL is highly appreciated...

Hi What are the various "Data Analysis" methods possible before we start developing a Microstrategy Report (from scratch) ? DB: Teradata. Thanks