cancel
Showing results for 
Search instead for 
Did you mean: 

How to display PropertyuFF1Au300CPARENTHu300D on BPC for Excel

Former Member
0 Kudos

Hi.

Can the dimension property:PARENTH

Is it possible to show the dimension property:PARENTH on BPC for Excel ?

I try to use 「EvPRO」.but it didn't work.

Are there special function for property:PARENTH ?

Takuo

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

As far as I know it is not possible to show the PARENTH1 property in BPC for excel.

Workarround is to make an additional property and copy the values from parenth1 into this property. Then the values from the new property can be retrieved using the EVPRO function.

Regards Tim Vierhout

Edited by: Tim Vierhout on Jul 16, 2008 12:45 PM

Former Member
0 Kudos

Alwin , Tim

Thanks for replay!

Certainly, the way you show can solve this problem.

But when the parent member is changed , the property I create has old value.

I don't want to change value . Are there dynamically ways.

Takuo

Former Member
0 Kudos

You could try an excel formula in the extra column, but I believe that after processing the formula is removed (never tried this myself).

And a method might be to arrange things directly in SQL using triggers or custom ssis packages. But to be honest, is this really worth it, how many changes do you make in a parenth structure. A simple manual for the administrator here might be enough.

My advice is always, KISS (keep it simple and stupid)

Alwin

Former Member
0 Kudos

You cannot retrieve the parenthx property using the evpro formula. there is also no other formula that can do this.

But, you can create an extra property (Xparenth1) where you copy in the contents of the parenthx columns and than use evpro to retrieve the value for this new/extra property.

Hope this helps,

Alwin