The next step is to right click on Dimension → InfoObject Direct Input as shown in the following screenshot.Īdd InfoObject to dimension. Rename the dimension as per the InfoObject. To create a copy of an already existing InfoCube, you can enter an InfoCube as a template. Once all this is done, you can click on Create as shown in the following screenshot. You can select the type from – Standard or Real Time as per the InfoCube type. Go to Modeling tab → InfoProvider → Create InfoCube.Įnter the technical name of the InfoCube. In case there is an InfoObject that doesn’t exist, you can create and activate them. How to Create an InfoCube?Īll InfoObjects to be used in an InfoCube should be available in an active version. Your own InfoCube should begin with a letter between A to Z and that it should be 3 to 9 characters in length. In SAP BI, InfoCubes begins with a number which is usually 0 (zero). InfoCube stores the summarized / aggregated data for a long period of time. A reporting user can define or execute queries against an info cube. It is a self-enclosed data set encompassing one or more related business processes. In SAP BI, an InfoCube contains Extended Star Schema as shown above.Īn InfoCube consists of a fact table which is surrounded by 16 dimension tables and master data that is lying outside the cube. The fact table and dimension tables in an InfoCube are both Relational database tables. Granularity (degree of detail) of key figures in an InfoCube is defined by its characteristics.Ĭharacteristics that logically belong together are grouped together in a dimension. The key figures in an InfoCube are related to characteristics of its dimension. These dimensions and fact tables are linked to each other using identification numbers (dimension IDs). There are large fact tables that contains key figure for InfoCube and multiple smaller dimension tables that surround it.Īn InfoCube contains fact tables that further contain key figures and characteristics of an InfoCube that are stored in the dimensions. InfoCubes consist of different InfoObjects and are structured according to the star schema. These Real-time InfoCubes are used differently to standard InfoCubes. The real-time characteristic can be assigned to an InfoCube. It consists of a number of InfoObjects that are filled with data from staging. InfoCube StructureĪn InfoCube is used to store the data physically. They are available as InfoProviders for analysis and reporting purposes. You can add data from one or more InfoSource or InfoProviders to an InfoCube. A fact table in the star schema is joined with multiple dimension tables. An InfoCube consists of a set of relational tables which are logically joined to implement the star schema. This is the piece we will keep fixed, and will be used as our frame of reference.An InfoCube is defined as a multidimensional dataset which is used for analysis in a BEx query. This means the up-left-back cubie always remains in its home We'll see below how this affects our representation of the cube as a subgroup of $S_$. This means we have to be careful on how we fix an orientation of the cube in space. There are no fixed-centres on this cube, unlike the 3×3×3 cube where each centre cubie remains fixed under face-twists. There is really only one aspect of the pocket cube that once needs to be careful in dealing with. To solve this puzzle just apply the basic solution of Rubik's cube and ignore steps involving edge cubies. Since this cube is really just the 3×3×3 Rubik's cube with all the edge pieces removed then our notation, and analysis, of Rubik's cube can be applied to the Pocket cube.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |