cancel
Showing results for 
Search instead for 
Did you mean: 

Not able to delete key figure

former_member196080
Participant
0 Kudos

Hi Experts,

I created one Kf, with some exception aggregation.

Then I used this kf in one of the cube, loaded data and done some testing.

Now ,I no longer need this Kf and want to delete the same.But while deleting system is not allowing me to delete this.Its data element is referencing somewhere else.

Error message I'm getting is "

Data Element /BIC/Ozxxxxx (Revised and Active vers.) was not deleted (check references)"

When I done where used of this Kf, the key figure data element is referencing some where else.

like  in /BIC/E table and some view /bic/v100254m etc.

Since I deleted the data in the cube already and there are no aggregates/BIA on this cube not sure why data element referencing to E table and V table(View).

Any help for deleting this Keyfigure?

Thanks

Accepted Solutions (0)

Answers (7)

Answers (7)

Former Member
0 Kudos

hi Rubane,

Is this infoobject a reference characteristic for another infoobject? Please check in RSD1 ..

Do share if this is the case/ not.

Thanks,

Sheen


    

former_member196080
Participant
0 Kudos

Hi,

Sheikh, its not referencing to any object.

Thanks

abdullahqureshi
Contributor
0 Kudos

Hi Rubane,

I think you to check that same key figure is using anywhere else in data targets(cube,dso). May be using by anybody else?

Regards,

Abdullah

former_member196080
Participant
0 Kudos

All,

Just want to clarify , already deleted this KF from cube and data is also deleted from this cube.

And I'm trying to delete KF itself, there I'm getting issue.

Thanks

former_member196080
Participant
0 Kudos

Also I deleted all the dim IDS of the cube as well.

Not sure how to delete SIDs of the cube?

former_member976
Active Contributor
0 Kudos

Hi,

Please share the screen shot which error your facing.

former_member196080
Participant
0 Kudos

Hello,

Pls find screenshot

former_member976
Active Contributor
0 Kudos

Hi,

first select the which one your deleting the KF

deleting the SID not easy if you aware of the deleting SID it is better for you.

select the object KF - double click on the KF -> select the where used list function -> now it open new screen -> expand the object -> then find the KF how many targets maintaion.

please look at the screen shot.

Thanks,

Phani.

former_member196080
Participant
0 Kudos

Hi,

Phani, where used list of kf shows nothing but where used list of data element shows e tables and views.

Thx

former_member202718
Active Contributor
0 Kudos

Hi Rubane,

Can you goto SE14 and then try deleting this Data from there (The tables from where you are getting error) and then the IO.

regards

SVU

former_member196080
Participant
0 Kudos

Hi SVU,

I'm afraid deleting those tables may cause any inconsistencies.

What do you think?

former_member202718
Active Contributor
0 Kudos

Hi Rubane,

Is it the table of the Infoobject related to KF or something else.

If its just IO then it can be deleted.

regards

SVU

Former Member
0 Kudos

If you want to delete keyfigure data from cube: first you have to delete data from cube including aggregates and index. after deleting data from cube use remodeling and delete keyfigure from cube; for this got to administration-->Remodling--> enter the remodeling rule and infoprovider give the discription like deleting keyfigure name (Ex: sales)--> click on operation list--> enter the keyfigure name and delete.

former_member976
Active Contributor
0 Kudos

Hi,

First delete the KF form the cube then delete it.

if you are deleting the KF it will ask the popup window it is exist some other targets.

Thanks,

Phani.

RamanKorrapati
Active Contributor
0 Kudos

Hi,

Before deleting a key fig, first you need to remove that key fig form cube design.

Use remodeling concept and try to delete key fig from info cube.

if it won't allow then you can try to delete cube data and later you can delete key fig from cube design thru change mode.

if your at dev system then only follow above suggestion.

Thanks

former_member183012
Active Contributor
0 Kudos

Hi,

have you selected DIMID and SID while deleting the data from cube if not do that and try.

Regards,

Ganesh Bothe