Restricted Key Figure showing up Blank!!

[Former Member]

Hello,

I am working on a report where i need to use RKF for certain requirement. The scenario is as below:

The data in the cube is as below:

Employee WageType Amount

1 XYZ 100

1 ABC 1800

2 XYZ 50

2 ABC 2500

The report looks like below:

Employee WageType Amount Balance

1 XYZ 100 -

2 XYZ 50 -

Here employee & wage type are chars whereas amount is standard KF from cube and balance is RKF.

Balance is restricted on KF amount for wagetype ABC.

Now the problem is as the report has the char WageType in the rows, corresponding Balance would be always blank but we want to show balance corresponding to the employee. The report should look like:

Employee WageType Amount Balance

1 XYZ 100 1800

2 XYZ 50 2500

Is there any logical solution for the above.

Regards,

Shashank

[mansi_dandavate · Accepted solution]

Hi Shashank,

You might have tried this.

Try using constant selection on the RKF which you have used..It might work.

[Former Member · Accepted solution]

Hi Mansi,

Sometimes we really do miss out on simple basic things and try to concentrate on alternative complex approaches. Thanks for reminding me the basic concept, I agree i missed on trying that one (skipped from mind).

It had to work and it did work.

Regards,

Shashank

[mansi_dandavate · Accepted solution]

Oh Cool! Yes it does happen sometimes...

But dont worry thats what SDN is for!!!!

Enjoy!!!

[Former Member]

Create a RKF key figure with wagetype = ABC.I hope it will work

Regards

Bibhu