Business Objects | Informatica | Oracle | SQL
Dimensional modeling is a data modeling technique in data warehouse design. Dimensional models use facts and dimensions to describe data for the business. Facts are typically numeric values that are additive (can be aggregated). Dimensions are descriptive elements used for grouping, labeling, and filtering facts. In the schema below: units_sold is a fact date, store, and product are dimensions all …
There are many prevailing definitions of business intelligence. Ultimately it is up to your organization to adopt the definition that makes sense to you. My favorite definition is provided by Forrester Research. Business Intelligence (BI) is a set of methodologies, processes, architectures, and technologies that transform raw data into meaningful and useful information used to enable more effective strategic, tactical, …
A question that I often receive is: “What should I do to learn how to develop ETL mappings using Informatica PowerCenter?” Here are the steps that I would take to learn how to do extract, transform, and load with Informatica PowerCenter. I assume that you already have knowledge of SQL. If you don’t know SQL or need to learn more …
If you use Business Objects Web Intelligence on a Mac, you are aware that it is very difficult to find a browser that is compatible. In fact, SAP will basically tell you that the Mac is not a supported environment. However, I have found a combination that will work for you. I have tested this on the following Mac environment: …
SAP Business Objects Web Intelligence has 3 different clients available: Web Java – Rich Internet Application Desktop – Desktop (Windows only) Each of the Business Objects Web Intelligence clients have unique features that are not available in the other clients. There isn’t a Business Objects Web Intelligence client that has all the features. Feature Web Java Desktop File > New …
