There is an apocryphal story about a nuclear scientist at the Los Alamos proving grounds in the late 1940s. When informed that the Soviet Union had sent spies to infiltrate the complex and steal the secrets of the atomic bomb, he replied that the U.S. should give the Soviet Union all the data on those first atomic bomb tests. His reasoning was, of course, that the Soviets would take years to get through the data regardless what their spies told them and thus not actually build a bomb for many more years.
KPI Partners Blog
Tags: Data Warehousing, Case Study, Business Intelligence, Blog
KPI Partners eBook Launch: Understanding Oracle BI Components
Tags: Data Warehousing, OBIEE, Mobile BI, Business Intelligence, Abhinav Banerjee, News, Oracle BI, Book
Creating an Alias vs. Duplicating a Physical Table (SQL & OBIEE)
by Kurt Wolff
When you duplicate a table, you create a new physical table with a new name. If this table is involved in a query, the SQL FROM clause will list this table. If the table does not exist in the database, then an error will occur.
Creating an alias creates a copy of the metadata table object that will be referenced in SQL with a new alias name. The alias name in SQL, as it is for all tables, will be derived its metadata ID.
To see the table IDs in OBIEE metadata, use the Oracle BI Query Repository utility. Here are some physical tables (and aliases) in a repository that I’ve created. It’s the last five digits of the ID that will be used to create the table aliases in SQL.
Tags: Data Warehousing, Kurt Wolff, Blog
Video >> A Fun Look At The History Of Business Intelligence
What is Business Intelligence? Listen to a brief history of BI, where we've been, where we are now, and where we are going...