cancel
Showing results for 
Search instead for 
Did you mean: 

Virtuval Charecteristics

Former Member
0 Kudos

Hi experts,

Please can any one explain,

What r virtual characteristics? when we use them? and what r virtual keyfigures and when we use them?

Thanks in advance

Mallik

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

An exemple in order to calculate stock age

you can use a virtual key figure ZAGE because if the cube is not updated

since a long time for a material, the age of the stock is still changing

day after day .....

So stock age = current date - date of movment stock.

You can't store current date in the cube then for this kind of problem

virtual key figure can be usefull.

The age will be calculated when you will launch the query

Virtual key fugure/characteristics must be use when data volume is small

else response time can increase in a penalizing way

Best regards,

Christophe

Former Member
0 Kudos

Hi chris,

Thanks for u r responce. Now i got an idea on this.

Mallik

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

These characteristics/key figure called VIRTUAL are feeded when you launch your query not when you load data to the cube.

There are present in cube structure but stay empty.

Results are calculated(or feeded in case of characteristics) with abap coding in specific exit after query launch.

EXIT_SAPMRSRU_001 BW: Definition of Virtual Characteristic and Key Figure

SMOD transaction enhancement RSR00002 see documentation.

But don't forget that it must be use when the data volume is small else

the response time can became very very long ....

Christophe

Former Member
0 Kudos

Hi Christophe,

I am thankful to u r reply. But i didn't get u r point. Can u explain me clearly what r virtuval characters and key figures, when and where we use them with example please.

Thanks in advance

Mallik

Former Member
0 Kudos

Hi,

A Virtual Characterstic is a normal Characterstic,The Only difference is the data will be Updated at the time of Query Execution.Just Create a Characterstic add this Char to the Cube.You need to write some ABAP Code to Update this Char.

You will find the Doumentation and Example in SMOD for Virtual Characterstics and Keyfigures.

for Documentation and Example.

Goto Tcode SMOD -> Enter Enhancement as RSR00002 ,Select the Radio button Documentation -> Click on Display

and The Use of Virtual Char/KF is for eg.You have 2 Collumns C1 and C2,

You want a New Collumn C3 in which you have to fill with C2 when ever C1 is Blank.Suppose C1 is having Data for the first 10 Rows and C2 is Having 20 Rows.

Now C3 has to Update with first 10 Rows of C1 and the Next 10 rows from C2(10 to 20).

Hope it helps.

Thanks,

-Vijay

Former Member
0 Kudos

Hi Vijay,

I have one more doubt, u said that C1 and C2 r havind data with 10 and 20 rows respectively. the first 10 rows of C2 and C1 r they same? If they r same then why we want third one C3. If they r not same C3 should contain 30 rows(correct if i am wrong). Please could u explain me.

Thanks in advance

Mallik

former_member188975
Active Contributor
0 Kudos

Hi Mallik,

You can search the forums and find good info here. As an example, see the following threads to find out info about Virtual KF and chars:

Hope this helps...