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

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

...select pa1.GLDEPTCD GLDEPTCD, pa1.ADWKID ADWKID, CASE WHEN a14.DEPTGRP_NO = '01' THEN NVL((pa1.WJXBFS1 * (1.0 / (CASE WHEN (NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0))=0 THEN NULL ELSE (NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) END))), 0) WHEN a14.DEPTGRP_NO = '09' THEN NVL((pa3.WJXBFS1 *...

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

...rows Pass5 - Duration: 0:00:01.07 insert into session.ZZT1Y03146CMD002 select a11.STORNBR Store, a11.ITMNBR ITMNBR, a11.WHSECD WHSECD, (2.0 * sum(a11.GROSSINVAMT)) WJXBFS1 from DWADMV.STORINVCITM a11 join DWADMV.STORINVC a12 on a11.BUSDY = a12.BUSDY and a11.INVCNBR =...

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

Hi FLB, Upgrading Works like a charm. Actually we need to upgrade even the Iserver, Web & NC along with the rest of the desk tops. The Iserver upgradation seemed pretty straight forward. But the only precaution we took was to have a backup of metadata. Once we got the backup, we upgraded the...

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 iolaper, Thank you for your suggestions. It seems like I was able to figue out the culprit here. And now my report seem to be working. Thank you very much. - Leo

Yup. Thats where you look for it and ask specifically for all the "Metrics" that are unused OR no dependencies. I tried it and it seem to be working. -Leo

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