on 2020 Mar 17 8:26 AM
Dear experts,
I am working on SAP 10.1 Netweaver standard model. We have an installation on BW on Hana 750 SP 010.
I have a dimension with many members (around 20000) and many properties (22). Two properties have a lenght of 1333 to store very long texts.
I need to clear some members from the dimension, but I cannot load the editor. The windows is trying to load the members but it cannot do it (it's still like in the picture below):
Do you know any other way to manage dimension members? Maybe some way to execute a deletion from the backend? I cannot use the clear option in the load package as there are trasnactional in the cube, so I am not allowed to clear members with data.
Thanks for your advices
Rgds
Francesco
Request clarification before answering.
First BW 750 SP10 is outdated. Upgrade to the latest and may be the Web interface issue will be solved.
Also I do not understand, what do you want to achieve!
It's not possible to delete members with transactional data. What do you mean by:
"I need to clear some members from the dimension"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I have some dimension members which have been deleted from ECC but loaded in BPC before the deletion. I need to delete them from BPC dimension as well, but if I cannot open the editor I don't know how to do it.
Thanks for your suggestion regarding the SP: the basis management is up to the client so I will suggest them to plan an upgrade.
Thanks
rgds
Francesco
Yes it's strange..this is public administration and this field can contain a concatenation of different texts. currently we have no members reaching 1333 but I cannot decrease the property lenght..and this lenght is allowed by BPC so it is supposed to work (BTW in dev system where we have only 4000 members I can open the dimension)
fgavarini
"I will mark the deleted members with a property in the loading phase, so I can exclude them from the reports" - strange idea (exclude from reports based on property...). Better to solve the root issue.
But the idea about the property is not bad for member deletion:
https://blogs.sap.com/2019/08/26/how-to-mass-delete-obsolete-members-in-bpc-dimension/
Note: I have already try to load the members with empty properties..but it's still the same.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.