Skip to Content

Bex query Issue

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.

uwfo8.png (6.6 kB)
1eabx.png (5.6 kB)
hzgb2.png (7.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Nov 15, 2017 at 06:33 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 27, 2017 at 05:52 AM

    Hi,

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

    Reagrds,

    Anand

    Add comment
    10|10000 characters needed characters exceeded