Skip to Content
avatar image
Former Member

want to know info cube have No Update aggregation type

Hi Experts,

I would like to know whether info cube have No Update aggregation type?

i should bring all the records from the data source to info cube without summarize or without overwrite.

i would like to know if in case i compressed the cube definetly all request will be a single request but here i don't want to merge(summarize) the records please give me the solution.

Warm Regards

Karthik Manoharan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • avatar image
    Former Member
    Dec 19, 2016 at 07:37 AM

    Why not to go fo DSO instead of Cube? There you can give option as overwrite instead of aggregation for KF.

    Br

    sd

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 19, 2016 at 09:21 AM

    Hi Sumeet Thanks for your reply yes i can use DSO but i don't want to overwrite the records what i want is i should keep the same records which is available on Data Source.

    Can I go With Write Optimized DSO?

    but experts say's that's not the write way.

    Pleas help me on this

    Regards

    Karthik.M

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 20, 2016 at 08:16 AM

    Hi experts

    can anyone reply on the above.

    regards

    Karthik.M

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 20, 2016 at 08:30 AM

    Go to KF's included in cubes and select No Aggregation in Aggregation tab...

    https://help.sap.com/saphelp_erp60_sp/helpdata/en/80/1a64d3e07211d2acb80000e829fbfe/content.htm

    Hope this helps...

    JP

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 20, 2016 at 08:35 AM

    yes please go ahead with write optimized DSO and give option in setting as 'Do not check uniqueness of data' to avoid over written of records

    br
    sd

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 20, 2016 at 12:12 PM

    Hi All,

    Thanks for your replies i will check and come back to you if in case i have any doubts

    Regards

    Karthik.M

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 07, 2017 at 10:17 AM

    Hi Experts,

    i have characteristics object and it has blank value and i maintained master data record with blank for the particular object when i put display as text in bex query designer level a can get blank value in Report but when i am trying to publish the same to WAD again am getting the same '#' symbol i want to replace the same to blank.

    i don't want to change this to all reports i want this only for particular report.

    Please help me on this really appreciate once you give any solution.

    Thanks

    Karthik.M

    Add comment
    10|10000 characters needed characters exceeded