Recent content by Leo1278

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

Mstrgrl, I ran into the situation once. The production project is renamed to some other project name. It happened to two of our projects. This happened when we migrated to 8.0 and it only happened that one time. All we did was to restart the server to see the problem disappear. -Leo

Hi All, Apparently, I was missing a SUM in my ApplyAgg. - Leo

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 Rambo.. Thank you for your response. Actually, I am working on DB2 but not teradata. You observation with the join seem reasonable to me. However, either full/left outer join dint give me any results. So, ultimately, I removed one metric that is off the "GROSSINVAMT" fact column to...

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 iolaper & Rambo I dont have any metric called '0'. All you do is: 1) Open a new metric (Metric Editor) 2) Type in.... ZeroToNull(0) OR a) Click on "f(x)" b) Double Click on "Null/Zero Functions" folder c) Choose "ZeroToNull" function and click next d) In the "Arg1" field...

Hi, iolaper I got it working on most occasions by manually typing "ZeroToNull(0)" on the metric definition. However, thresholds should also serve the purpose. - Leo

Hey iolaper, Thank you. I was looking for this function. I think I understood that and It seem to be working. -Leo

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

Hi, 1) Define a metric as : ZeroToNull(0) and save it as "Blank Metric" 2) Place it wherever you need a null column. Shouldnt that be good enough? - Leo

Hi FLB Sounds like a task that I have to perform in a week's time...Upgrade to Microstrategy 8.0 Whats the "Right Order" that you are talking about? Any other advices b4 upgradations? Thanks a lot. - Leo

Hi Teccum, I know that there is a round-about for the purpose that you mentioned in your post. Can I have another project created for your second source of data and use datamarts to bring the results from EXCEL into your original project? Hope that helps. - Leo

Hi reisw, Thank you for the info. I sure will have to do another upgrade to Microstrategy 8.0 in the near future. So, it is nice to know. - Leo