Is it possible to put characteristics in structures?

[Former Member]

I want to display employee's performance, which is a characteristic, in a structure that i have created. However, BW seems to be complaining about that. Is there a way to get round that problem?

[Former Member]

ann,

welcome to the SDN!

i'm thinking of two approaches to the problem:

1- does this employee performance change over time? maybe you should just model this as a KF instead, and arbitrarily assign numbers for each letter equivalent. then, when you report, substitute the value with the respective character.

2- how about reporting in tabular view? that way you can intermesh characteristics and attributes and keyfigures.

hope we've helped - don't forget to give out points. 😃

ryan.

[Former Member]

Ryan

Your suggestion sounds possible... but how do I

arbitrarily assign numbers for each letter equivalent?and how do when you report substitute the value with the respective character?

Thanks

Ann

[Former Member]

ann,

well, the first part is easy - you know what values to expect right? make a simple value matrix for it, and make your coding in the update/transfer rules, like so:

A+ = 4.25

A = 4

A- = 3.75

...

D- = .75

the latter question should also be easy - create a variable via BEx Query Designer and make sure it is set to type 'Customer Exit'. then you should make your coding in that user exit (BW side) to provide the conversion you want.

ryan.

[former_member200327]

Ryan/Ann,

I don't see how second part of your approach would work: variables work as selection criteria only (unless it's a Formula Variable). You can't change query results using variables.

Unfortunately you have to use Virtual Characteristics/Key Figures User exit.

Regards,

Gersh

[Former Member]

Hi Ann,

you cannot put a characteristic directly in the structure. You can create a selection or formula in the structure. You must create a selection for each value that you want in the structure.

With this type of structure you could edit the value of each cell.

Regards

Manuel

[former_member200327]

Hi Ann,

Does employee performance has a numeric value? If it has, than you can define a Formula Variable based on Employee Performance, than Calculated Key Figure based on that variable and include that CKF in your structure.

Please let me know if you need more details on how to do this.

Regards,

Gersh

[Ashwin]

Hi!

i think in this case you can use a variable for employee perfiormance with the proceesing type replacementpath which give you the key value of the employeeperformance pobject. you can then use this variable in a calculated keyfigure and use this directly in your structure just as a key figure..

this wil definatly work... i dont have idea about whether using this workaroud will have a performance implications.

hope this helps.

with regards

ashwin

[Former Member]

Thanks I will give it a go now!!

[Ashwin]

Hi ann!

just inform if you are successfull.

with regards

ashwin

[Former Member]

No it's not...

The employee performance thing is a text, like A-, A+ etc...

and I am trying to pull it into my structure which reports that last 2 year's performance.

It only gives me X

Any advise?

[Former Member]

I tried to put a characteristic into the structure and the error that I got back is:

"use a key figure everywhere in the structure" and

"A key figure has to be uniquely specified in all cells"

Thanks

[Ashwin]

Hello!

you can use this doc https://websmp106.sap-ag.de/~sapdownload/011000358700001963972003E/HowToCalcWithAttr.pdf

for the above doing specified method

(Reward some points if if helps... )

with regards

ashwin

[Former Member]

Can i have both Key figs and characteristics in the same structure?

[Former Member]

Hi Ann,

Please see the link below to understand defining Key figure & Characteristics Strucuture,

http://help.sap.com/saphelp_nw04/helpdata/en/4d/e2bebb41da1d42917100471b364efa/content.htm

If this didn't solve, Let us know the error you are getting.

Thank you

Arun