Bex query with count of all Master Data records

[Former Member]

Hello experts.

Kindly help me with following.

Right now developing report for Plant Maintenance using DSO MTTR/MTBR (Mean Time to Repair/Mean Time Between Repair).

DSO contains information about equipment failures (transaction data) and also Equipment Master Data.

It is important to highlight  - transaction data contains only equipments which had problems (failures).

So to count failure rate I have to take number of failures/(number of total equipment  in this period) * 100 (equipment type wise).

But if I will operate Bex with transaction data it will be not right because it will show me only equipments which had problems (not total).

My question is - how to calculate total number of equipments in Bex (this number I have in Master data), but how to bring it to Stage in Bex?

Thank you and best regards.

[RafkeMagic · Accepted solution]

search on "slow moving items" scenario

[Rushikesh_Yeole]

HI,

Create two queries based on master data and other on DSO.

Create replacement path variable (Say Equipment)  from query based on DSO.

[Former Member]

Hello Rushikesh,

can you please describe more detailed - where to create variable and which options to chose.

First part I understood - how to create equipment count type wise, but second...

Thank you very much.