Skip to Content

A Complex Query Structure

Hello,

I want my BEx Query Structure like this.

Column First - A separate keyfigure

Column Second, Third, Fourth, Fifth - A same keyfigure related to following characteristics.

The second structure is not allowing me to add a keyfigure. Is there any possible way to solve. Please guide.

Thanks in advance

bex.png (142.7 kB)
excel.png (13.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    May 14 at 07:58 AM

    Within a query definition you can use either no structures or a maximum of two structures. Of these, only one can be a key figure structure.

    You can combine structures freely with other characteristics on the axes.

    Add comment
    10|10000 characters needed characters exceeded

  • May 14 at 06:27 AM

    Hi,

    did you try with restricted key figure?

    Regards,

    Anand

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 14 at 02:57 PM

    Hello;

    I think, for that structure, you don't need to have the "Structure" in Columns.

    Can you please remove it and run the query?

    Thanks & Regards;

    Ricardo

    Add comment
    10|10000 characters needed characters exceeded