Custom attributes can be included in the data warehouse via Studio. The attributes of the object also need to be selected manually for inclusion in the data warehouse. Simply check the box for ‘Include in the Data Warehouse.’ Custom objects can be included in the data warehouse via Studio. All monthly time slices should have the same From Date and Number of Periods.
#Pentaho data integration nvl update
If not, you can update the From Date and Periods in the time slice request. Verify these ranges work for your company. Time slices with the Data Warehouse flag checked determine the ranges for the facts in the data warehouse. –The entity selected does not restrict the investment data included in the data warehouse to that entity. –The entity chosen determines which fiscal periods are used when aggregating data. –The languages selected determine which localizations are included in the data warehouse (more languages means more disk). This depends on the size of the CA PPM database.Īdministration/General Settings/System Options: This database can be on the same physical server, a different instance on the same server, or on a different server. The CSA data warehouse properties allow you to configure the basic data warehouse credentials and settings. A flag has been added to Studio objects and attributes that control whether the data warehouse load job automatically adds custom objects and attributes. –The data warehouse is extendable without customization. Studio attributes are not available in Business Objects Universes without customization. –Since the data warehouse is separate from the CA PPM database, the database can be tuned differently for optimal performance. The data warehouse always uses the numeric key of the dynamic lookups. –In the CA PPM financial tables, codes are used instead of IDs. In the data warehouse, the finish/end dates always match CA PPM. Database functions in queries must be leveraged to determine the correct date. –In the CA PPM database, the finish/end dates do not always match those displayed in CA PPM. In the data warehouse, resource columns (manager_key, resource_key, etc.) are always the resource_key. –In the CA PPM database, manager points to the user ID and resource points to the resource ID, or code, which makes it inconsistent. –Columns are consistently named across tables. –Specific time slice requests are set up to populate the data warehouse. –Similar tables are grouped together by the table prefix and the names are very descriptive. –With the exception of configuration and meta tables, the data warehouse tables are ‘user friendly’ to report against. Facts are combined into summary and period tables. –The data warehouse carries keys and descriptive values in the dimension tables so fewer joins are required. Relational database makes queries very complex. –The data warehouse schema resides on another database server taking the stress off the transactional CA PPM database. Reports and portletsrun against transactional data. OThe Data Warehouse is modeled on a STAR schema, with Dimensions covering the major areas in CA PPM and their associated Facts. The data transformation and load runs as a CA PPM job. OPentaho Data Integrator is embedded within CA PPM. OOut of the box reports and domains for Investments, Resources, Financials and Timesheets. OLightweight, drag and drop business user reporting capability Jaspersoft Reports, Ad Hoc Views & Domains A Snowflake is a dimension table that can be indirectly linked to a fact table. A simple Star would have a fact table with a few direct links to dimension tables. Star Schema is a type of database design. Facts are the metrics on an object (Examples: Total Cost, Actual Hours, etc.). Dimensions are the descriptive fields on an object (Examples: Investment ID, Investment Name, Investment Manager, etc.). Predefined, yet configurable, time slices Separate schema optimized for business decision making and analytics Modeled on the STAR schema and includes the following master objects: Investment (All Types), Resource, Portfolio and TimesheetĬonsistent naming conventions, formats and encoding structures Review the presentation from this hands-on lab to learn the details of the new CA PPM data warehouse. Facilitating access to project and resource data is a key focus area for CA Project & Portfolio Management (CA PPM).
Having the right data at your fingertips is critical for making decisions in the new world of software-driven business.
0 kommentar(er)
