tag:blogger.com,1999:blog-76892584371981926102011-04-21T18:17:21.344-04:00BI TrainingBusiness Intelligence Software Traininghttp://www.bi-training.comhttp://www.blogger.com/profile/10650187220409433693noreply@blogger.comBlogger51100tag:blogger.com,1999:blog-7689258437198192610.post-16509407724472220182008-08-19T11:45:00.001-04:002008-08-19T11:45:41.963-04:00Interactive Reporting: Is My_Billing_Date a data type of Date or is it of String? Is My_Billing_Date of data type Date or is it of type String? You can avoid the ambiguities encountered with date formats by creating a new date object instead of using a string. To create a date object, use: New Date(yr, mo, da) Where yr is the 4 digit year, mo is the month (zero based, so January is 0), and da is the day of the month. For your computed column, you could say: http://www.bi-training.comhttp://www.blogger.com/profile/10650187220409433693noreply@blogger.com0tag:blogger.com,1999:blog-7689258437198192610.post-33215231041349126982008-06-23T01:10:00.002-04:002008-06-25T15:38:51.213-04:00Allow non join queries OCE setting in Hyperion Interactice ReportingA setting in the setup of the open catalog extension that you may be afraid to use, in that it might create a cartesian product using non-join's.<?xml:namespace prefix = o />This feature is very useful if you want to join to a single row of a table but have no keys with which to do the join. Then the Cartesian product of 1 row with the rest of your results is exactly what you want. I have used http://www.bi-training.comhttp://www.blogger.com/profile/10650187220409433693noreply@blogger.com0tag:blogger.com,1999:blog-7689258437198192610.post-83973592371674529892008-02-12T14:30:00.000-05:002008-02-11T17:13:15.979-05:00How to understand joins in your database using Hyperion Interactive Reporting.{Posted from a BI-Training Hyperion instructor}As an instructor teaching Hyperion Explorer, I often will get a question about someone's database at work. Unfortunatly, I cant answer those questions. Thats called 'consulting'. And I do accept Paypal for those kind of questions. (Just dont tell my boss!)<?xml:namespace prefix = o />So, how does one approach an understanding of massive database http://www.bi-training.comhttp://www.blogger.com/profile/10650187220409433693noreply@blogger.com0tag:blogger.com,1999:blog-7689258437198192610.post-27898705731630483512008-02-11T16:34:00.000-05:002008-02-11T17:13:40.190-05:00A Traffic Light approach on Pivot sections in Hyperion Interactive Reporting{Posted from a BI-Training Hyperion instructor}<?xml:namespace prefix = o />Looking to crate a traffic light in a pivot?One approach is to use the spotlighter. But the problem here is that you cannot compare two fields against each other, say an Actual and Goal. The solution is the use of a computed item. Create a computed item in the pivot using an if condition.Say if (actual > goal) {'great'} http://www.bi-training.comhttp://www.blogger.com/profile/10650187220409433693noreply@blogger.com0tag:blogger.com,1999:blog-7689258437198192610.post-74306448061901383282008-02-08T13:00:00.000-05:002008-02-11T17:14:02.328-05:00Welcome to the BI Training blogWelcome to the first blog posting from http://www.bi-training.com/.We have been training and consulting in Business Intelligence since 1995. We have trained over 15,000 students all over the country but predominantly in the east coast of the US.We intend on providing tips and tricks on the technologies we work with including the business intelligence products from Oracle (Hyperion/Brio/Scribe), http://www.bi-training.comhttp://www.blogger.com/profile/10650187220409433693noreply@blogger.com0