Skip to Content
author's profile photo Former Member
0
Former Member

Delete a particular record while executing the BEx Query In Excel UI

Posted on Nov 22, 2011 at 06:19 AM 11 Views

Hi ,

While executing the BEx query in Excel UI, I want to delete selected record from Excel UI.

So must be reflected to InfoCube data as well.

Is there any way?

Regards,

Rohit

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 22, 2011 at 06:54 AM
    0

    Hi,

    Can you please elaborate on what basis you want to delete the record? You want to delete the record permanently in Cube also?

    Thanks

    Riyez

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo T Ravi Chandra
    T Ravi Chandra
    Posted on Nov 22, 2011 at 08:41 AM
    0

    Hi rohith,

    If u create a report based on a standard INFOCUBE , then u can't delete the particular record in EXCEL UI, but whereas if u have created the report based on REAL TIME INFOCUBE, then u can achieve ur desired result. To delete the selective record from EXCEL UI , u have to convert the infocube to the "PLAN MODE" then u can delete or insert the record in excel UI , and that data will be reflected to REAL TIME IC .

    Thanx & Regards,

    RaviChandra

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 22, 2011 at 08:55 AM
    0

    Hi.

    If you had use real time cube it was very simple with IP functionality, but I guess your cube is regular and not real time ...

    In this case you can use function RSDRD_SEL_DELETION for selective deletion of a data from the cube.

    Be carefull with selective deletion ...

    Regards.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.