tag:blogger.com,1999:blog-8884584404576003487.post244316753820753347..comments2020-10-22T05:28:35.284-04:00Comments on ORACLENERD: Random Thought: #19oraclenerdhttp://www.blogger.com/profile/12412013306950057961noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-8884584404576003487.post-82839290124780452902011-03-18T12:41:24.441-04:002011-03-18T12:41:24.441-04:00I agree with Chet on this one. Real number / fract...I agree with Chet on this one. Real number / fraction seems logical, no integers.Enrique Avilesnoreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-37149718933919399082011-03-18T11:16:43.122-04:002011-03-18T11:16:43.122-04:00@jeff
obiee can definitely do that. my point is t...@jeff<br /><br />obiee can definitely do that. my point is that it shouldn't be stored as something which it is not (a whole number).<br /><br />i certainly don't mind doing calculations using obiee (or any tool), just a pain that it's labeled PCT yet it really isn't.oraclenerdhttps://www.blogger.com/profile/12412013306950057961noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-80039685943054216682011-03-18T08:43:57.797-04:002011-03-18T08:43:57.797-04:00I would store it as the real number, e.g. 0.00002
...I would store it as the real number, e.g. 0.00002<br /><br />Or let the program compute the percentage itself from the raw data.<br /><br />Surely you can comment/document in OBIEE?hillbillyToadhttp://www.thatjeffsmith.comnoreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-11403545180789063212011-03-18T07:26:11.543-04:002011-03-18T07:26:11.543-04:00Definitely as fraction. It simplifies arithmetic o...Definitely as fraction. It simplifies arithmetic operations a lot.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-15589584870452496292011-03-17T21:49:52.182-04:002011-03-17T21:49:52.182-04:00@dan
i have no idea what you are talking about.@dan<br /><br />i have no idea what you are talking about.oraclenerdhttps://www.blogger.com/profile/12412013306950057961noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-88826374060647798572011-03-17T21:49:42.032-04:002011-03-17T21:49:42.032-04:00@dan
i have no idea what you are talking about.@dan<br /><br />i have no idea what you are talking about.oraclenerdhttps://www.blogger.com/profile/12412013306950057961noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-5356812522235072062011-03-17T21:38:29.439-04:002011-03-17T21:38:29.439-04:00@jeff
despite my bad math as noted by mr. norris....@jeff<br /><br />despite my bad math as noted by mr. norris...the column name even had PCT in it.<br /><br />Barnacles.oraclenerdhttps://www.blogger.com/profile/12412013306950057961noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-16358162964872974462011-03-17T21:36:32.839-04:002011-03-17T21:36:32.839-04:00A percentage means "x per hundred", so I...A percentage means "x per hundred", so I'd always expect a column identified as using percent units to be stored/represented as such: 40 means 40% or 0.4; 0.4 means 0.4% or 0.004.Jeff Kemphttp://jeffkemponoracle.comnoreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-132940072054524282011-03-17T21:30:46.606-04:002011-03-17T21:30:46.606-04:00i hate you right now
:pi hate you right now<br /><br />:poraclenerdhttps://www.blogger.com/profile/12412013306950057961noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-83954415500405493112011-03-17T21:05:02.152-04:002011-03-17T21:05:02.152-04:00Note 40% = 0.4 and 0.04 = 4%. Better keep your day...Note 40% = 0.4 and 0.04 = 4%. Better keep your day job because making change at McDonald's may not be a good option for you :)Dan Norrishttps://www.blogger.com/profile/09711669745371007306noreply@blogger.com