Skip to Content

Marking a dimension as line item

Hi

FI Document number 0AC_DOC_NO does not have any master table or text table as it is just storing the number. Therefore no SIDS exists. Now when i insert this in a cube, will it be a good idea to mark the dimension as line item. Will it make any sense as the data load performance is affected when creating SID's. What will happen in this case. Will marking it as line item still save time on creating DIM ids.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Oct 29, 2015 at 10:45 AM

    Hi Tom,

    If you mark it as line item it will definitely save time both in loading as well as reporting.

    There won't be any dimension table created and as a result the DIM id's will no longer be a hindrance.

    Regards,

    Amit

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 29, 2015 at 10:27 AM

    Hi Tom,

    Will marking it as line item still save time on creating DIM ids.


    Certainly! as it wont create any DIM id's which increases both loading and report performance.


    if your cube had data already, you can always check the dimensions size from standard program SAP_INFOCUBE_DESIGNS before making it LID.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 29, 2015 at 10:30 AM

    Hi,

    Usually in a Cube Design, if only one characteristic assigned to a dimension only, we can make that dimension as a Line Item Dimension.

    Thanks and Regards,

    Mahesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 29, 2015 at 10:30 AM

    Hi,

    As this is only 0AC_DOC_NO ( document number) and no relation making it line item dimension make sense. Performance in both load and reporting point of view.

    Thanks.

    -J

    Add comment
    10|10000 characters needed characters exceeded