on 07-21-2014 8:41 PM
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 "
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
have you selected DIMID and SID while deleting the data from cube if not do that and try.
Regards,
Ganesh Bothe
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.