Attributes - SAP Information Modeler

Attributes are individual non-measurable analytical elements. Attributes add context to data. These are qualitative descriptive data similiar to Characteristics of SAP BW. For example, MATERIAL_NAME. There are three types of Attributes in Information Modeling:

• Simple Attributes are individual non-measurable analytical elements that are derived from the data foundation. For example, MATERIAL_ID and MATERIAL_NAME are attributes of a MATERIAL subject area. 

• Calculated Attributes are derived from one or more existing attributes or constants. The attribute is based on static value or dynamic calculation. For example, extracting the year part from the customer registration date, assigning a constant value to an attribute which can be used for arithmetic calculations. 

• Private Attributes are used to model Analytic Views and cannot be used outside the view. Private attributes add more information to the data model. Private attributes of Fact tables are used to link to the subject area or dimensions i.e. Attribute Views. For example, we create an analytic view ANV_SALES to analyze the sales of materials, and select MATERIAL_ID as a private attribute from the database table SALES_ITEM. In this case, MATERIAL_ID could be used only for modeling data for ANV_SALES. We will learn about private attributes later when we will design Analytic Views.

SAP HANA Information Modeler

Information Models are multiple database views of transactional data stored in the physical tables of SAP HANA Database used for Analytical purposes. Analytical Data Modeling is only Possible For Column Tables i.e. Information Modeler only works with column storage tables.

For that reason Replication Server creates SAP HANA tables in column store by default. Data Services also creates target tables in column store as default for SAP HANA database. The SQL command to create column table: "CREATE COLUMN TABLE Table_Name..". Also the data storage type of a table can be modified from Row to Column storage with the SQL command "ALTER TABLE Table_Name COLUMN".

We can Choose to publish and consume SAP HANA tables data at four levels of modeling using SAP HANA Studio Information Modeler Perspective.They are Attribute View, Analytic View, Calculation View and Analytic Privilege. These content data models are basically the combination of Attributes and Measures.

SAP BPC 10 - Lista de Cursos Oficial

***BPC 410 Ver : 96 for BPC 10.0 -- http://goo.gl/wYrio
***BPC 420 Ver : 96 for BPC 10.0 -- http://goo.gl/nXryo
***BPC 430 Ver : 96 for BPC 10.0 -- http://goo.gl/rexpg
***BPC 440 Ver : 96 for BPC 10.0 -- http://goo.gl/9ztoh

Mobile BI on the NEW iPad

Check out this short demo of Mobile BI on the new iPad. The new iPad features like the Retina Display and extreme processing speed will take business insights to the next level.

    

Formaciones: soluciones sobre HANA y Movilidad

Dos de las soluciones que más están en boca de todos, presentan sus formaciones, SAP HANA y movilidad.

Los cursos sobre HANA ya están planificados, en formato Ramp-Up:

• TZH300 – SAP HANA Implementation & Modeling.- Del 29 al 30 de marzo 2012, Madrid.

• TZBWHA – SAP BW on SAP HANA 1.0.- El 2 de abril 2012, Madrid.

Así como la completa solución de cursos sobre Sybase, cuyas fechas se iran publicando a medida que se vayan planificando:

Curriculum Sybase ›

¿Cual de las dos formaciones te atrae mas?