cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Is there a way to import member formulas in BPC?

Boyan_P
Participant
0 Likes
898

Hello,
I have a situation on which I have to delete and reload all data in BPC cube, because of wrong Master Data.
So I have to delete all Transactionaldata, after that to delete Master Data and then to reload Master and Transactional data.
That`s OK, but as I know I`ll lose all Member Formulas that I have defined for dimensions....

So my question is whether there is a way to Import Member Formulas in BPC?

My BPC is 10.01, also I think that i`ll be able to generate those formulas in Excel.
I`m talking for about 1K Member Formulas.

Any help is appreciated ...

Regards,
Boyan.

Accepted Solutions (0)

Answers (3)

Answers (3)

Boyan_P
Participant
0 Likes

Hi Nick,

No. I haven't find anything on how to deal with such a issue.
The problem is not solved.
Anyway while I looking for some info about this problem I came across several topics that discuss that it is a good idea to avoid using too many Member Formulas. Too many member formulas can led to performance troubles.

Regards,
Boyan.

former_member186338
Active Contributor
0 Likes

"Too many member formulas can led to performance troubles" - not correct 🙂

To many formulas on the same report - correct!

Former Member
0 Likes

Hi Boyan,

Have you managed to find something to help you? I may be in a similar position (slightly fewer Member Formulas). Very similar infrastructure (BPC 10.1 on HANA BW 7.50 SP05)

(For the tag, start typing "BusinessObjects Planning and Consolidation ..."

Regards

Nick

Boyan_P
Participant
0 Likes

Sorry for the incorrect tag. I searched for BPC tags and the only that i found was for MS starter kit.
On the topic:

I`m running on version SAP BO BPC 10.1 over NW 7.5

Business Warehouse is:

SAP_BW 7500002 / SP Level 002 / Support Package APK-75002INSAPBWSAP

DB is HANA if that does matter.