davebettinger.wordpress.com
Who Needs a Quick Date Dimension? | ORA-Dave
https://davebettinger.wordpress.com/2009/03/26/who-needs-a-quick-date-dimension
Tips, strategies, and thoughts on Oracle development. March 26, 2009. Who Needs a Quick Date Dimension? Here’s a quick and easy way to generate a date dimension. Posted in Data Warehousing. Laquo; Chart of Accounts Dimension for Finance Data Mart. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out. You are commenting using your Twitter account. ( Log Out.
davebettinger.wordpress.com
July | 2008 | ORA-Dave
https://davebettinger.wordpress.com/2008/07
Tips, strategies, and thoughts on Oracle development. Archive for July, 2008. Creating Dimension Tables from EBS GL Chart of Accounts. On July 18, 2008. Getting OBIEE Dashboard Prompt Values Into BI Publisher. On July 18, 2008. On July 2, 2008. On July 2, 2008. Dan Norris’ Blog. Greg Partenach’s Blog. Piocon Technologies, Inc. Create a free website or blog at WordPress.com. Follow “ORA-Dave”. Get every new post delivered to your Inbox. Build a website with WordPress.com.
davebettinger.wordpress.com
Chart of Accounts Dimension for Finance Data Mart | ORA-Dave
https://davebettinger.wordpress.com/2008/10/23/chart-of-accounts-dimension-for-finance-data-mart
Tips, strategies, and thoughts on Oracle development. October 23, 2008. Chart of Accounts Dimension for Finance Data Mart. Account Type (Revenue, Expense, Asset, Equity, Liability). This technical brief will focus on how to design and build the Chart of Accounts dimension(s). SELECT application column name, segment name FROM fnd id flex segments fs, fnd id flexs f WHERE fs.id flex code = f.id flex code AND f.application table name = 'GL CODE COMBINATIONS';. If the design calls for separate dimension tabl...
davebettinger.wordpress.com
About Me | ORA-Dave
https://davebettinger.wordpress.com/about-me
Tips, strategies, and thoughts on Oracle development. My name is Dave Bettinger and I live in Lisle, IL, a Western suburb of Chicago. I work for Piocon Techologies, Inc as a consultant. I have worked with Oracle technologies for about 4 years and plan to do so for many more to come. In addition to Oracle database techologies I have a strong interest in Object Oriented software development, specifically Java. Leave a Reply Cancel reply. Enter your comment here. Address never made public).
davebettinger.wordpress.com
October | 2008 | ORA-Dave
https://davebettinger.wordpress.com/2008/10
Tips, strategies, and thoughts on Oracle development. Archive for October, 2008. Chart of Accounts Dimension for Finance Data Mart. On October 23, 2008. BI Publisher Template Relief with Oracle’s Model Clause. On October 23, 2008. Dan Norris’ Blog. Greg Partenach’s Blog. Piocon Technologies, Inc. Blog at WordPress.com. Follow “ORA-Dave”. Get every new post delivered to your Inbox. Build a website with WordPress.com.
davebettinger.wordpress.com
Creating Dimension Tables from EBS GL Chart of Accounts | ORA-Dave
https://davebettinger.wordpress.com/2008/07/18/creating-dimension-tables-from-ebs-gl-chart-of-accounts
Tips, strategies, and thoughts on Oracle development. July 18, 2008. Creating Dimension Tables from EBS GL Chart of Accounts. When creating a GL data mart one of the most important components is the Chart of Accounts (COA). Here is one way to create dimension tables for each level in the COA hierarchy. Create a view called GL COA V, replacing the flex value set name values for your specific COA:. Laquo; Getting OBIEE Dashboard Prompt Values Into BI Publisher. Leave a Reply Cancel reply.
davebettinger.wordpress.com
Getting OBIEE Dashboard Prompt Values Into BI Publisher | ORA-Dave
https://davebettinger.wordpress.com/2008/07/18/getting-obiee-dashboard-prompt-values-into-bi-publisher
Tips, strategies, and thoughts on Oracle development. July 18, 2008. Getting OBIEE Dashboard Prompt Values Into BI Publisher. Update: The scenario described below involved an attempt to pass parameters from a Dashboard to a BI Pub report using OBIEE running in a stand-alone OC4J. Attempting to accomplish the same goal using OBIEE running in OAS was much easier. It worked as the documentation describes and required no work-around. I will post screen shots soon…. 8230;Screenshots, finally:. John, if i unde...
davebettinger.wordpress.com
First Post | ORA-Dave
https://davebettinger.wordpress.com/2008/07/02/first-post
Tips, strategies, and thoughts on Oracle development. July 2, 2008. Well, after months of telling myself that I should start a blog, I’ve finally done it. I’m working on a pretty interesting project for a client right now and I’ve got a few experiences to share. I expect to post a few entries related to OWB, OBIEE, and BI Publisher in the coming days. Stay tuned…. Nice Anything you can post on the interesting project(s) you’re still on will be valuable! On August 18, 2008. Leave a Reply Cancel reply.
davebettinger.wordpress.com
About This Blog | ORA-Dave
https://davebettinger.wordpress.com/about
Tips, strategies, and thoughts on Oracle development. Welcome to my blog! The purpose of this site is to document my experiences as a consultant building systems with Oracle software. It will specifically focus on whatever tools and technologies I’m using at the time, primarily OWB, OBIEE, BI Publisher, JDeveloper, and PL/SQL. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). Notify me of new comments via email.