Bex query Issue

[former_member183519]

Hello All,

Now i have data like below in bex output:

Instead of multiple rows i want data into a single row for last 3 chars in screenshot..

Could anyone pls tell any possibility for this

Thanks.

[former_member183519 · Accepted solution]

Hi All,

Issue solved..

cant do anything at bex level, i have changed the logic at cube level(end routine).

Added 3 new IO(type-KF), and then doing aggregation on last value.

Thanks.

[Anand71]

Hi,

if you are using multi provider try to use constant selection in Bex query in restricted key figure level.

Reagrds,

Anand