starschema dimension table

[Former Member]

for which reason the sap system give 3 dim table by it selp(unit,time and datapackage is given by system itselp)

i dont understand is this 3 dimension are required every time or what is its reason?

[ravi_chandra3 · Accepted solution]

Hi

Data Package : Whenever u load the data into the infocube those data will get loaded as per the request , those request information will be stored in that dimension.

Unit package : For keyfigure u have units like (sec, kg etc.). This package will hold this information.

Time Package : THe information about the 0FISCPER,0CALMONTH will hold this dimension.

For detail information plz refer the above post.

Hope u got it,

Regards,

RaviChandra

[raghu_ram]

Hi,

Out of the sixteen dimensions which we have max in an InfoCube, three are SAP defined as you said.

It's based upon the Multidimension modelling. These three are Standard dimensions defined by SAP, remaining thirteen are for Custome use.

You need to use these three dimensions as a mandatory.

- Time dimension: 0CALDAY, 0CALMONTH etc.

- Unit / currency dimension: The respective dimension table is generated if the key figures selected in the InfoCube are of type

u2018amountu2019 or u2018quantityu2019.

- Packet dimension: With every load into an InfoCube there is a unique packet-ID assigned. This allows you to purge

erroneous loads without recreating the whole InfoCube again. The packet dimension can increase

overheads during querying and can therefore be eliminated using the compress feature of the

InfoCube after proven correctness of the loads up to a certain packet-ID.

Hope it clears

Regards,

Raghu

[Former Member]

Hi,

When you create an InfoCube, the dimensions data package, time and unit are already defined by default. The data package dimension contains technical characteristics. Time characteristics and units are automatically assigned to the corresponding dimensions.

A Basis Cube usually has four dimension tables.

Units dimension table

Data package dimension table

Time dimension Table

Other Dimensions

Time Characteristics

Time characteristics form the time reference frame for many data analyses and evaluations. They are delivered with Business Content. Defining our own characteristics is not possible.

Units

Unit InfoObjects can be specified alongside the key figures. They enable key figure values to be partnered with their corresponding units in evaluations.

Examples:

Currency unit ( 0CURRENCY)

Value unit ( 0UNIT)

Technical Characteristics

These characteristics have an organizatorial function within SAP BI.

Examples:

Request ID (0REQUID)

Change ID (0CHNGID)

Hope this will be helpful,

Thanks,

Vinod