cancel
Showing results for 
Search instead for 
Did you mean: 

SAP BPC 10.1 NW - Cannot load dimension members in administration

fgavarini
Explorer
0 Kudos
437

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

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member186338
Active Contributor
0 Kudos

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"

fgavarini
Explorer
0 Kudos

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

former_member186338
Active Contributor
0 Kudos

fgavarini

The question is: do you have transactional data on the mentioned members? Even zero's?

P.S. Check in RSA1

fgavarini
Explorer
0 Kudos

No I have no transactional data on those members..already checked in RSA1

former_member186338
Active Contributor
0 Kudos
fgavarini

Then looks like SP upgrade is the only solution. Hope you have already clean dim cache etc...

By the way, what is the idea to have 1333 char properties? Looks strange...

fgavarini
Explorer
0 Kudos

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
Explorer
0 Kudos

Yes I have already cleaned dim cache, optimized the cube but nothing happened

former_member186338
Active Contributor
0 Kudos

fgavarini

It's a strange idea to store long texts in dimension properties... Why not to have the mentioned texts on the specific reports?

fgavarini
Explorer
0 Kudos

what do you mean on the specific reports? anyway the system is live but I didn't see any other option (we have many members that may change descriptions in the source system so it would be a mess managing the descriptions within the reports/input forms)

former_member186338
Active Contributor
0 Kudos
fgavarini

1333 char description??? Is it a joke?

fgavarini
Explorer
0 Kudos

I found a workaround: I will mark the deleted members with a property in the loading phase, so I can exclude them from the reports. thanks

former_member186338
Active Contributor
0 Kudos

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/

fgavarini
Explorer
0 Kudos

Note: I have already try to load the members with empty properties..but it's still the same.

Thanks