Skip to Content

Custom Calculated Column in Design Studio based on another value

Hi Expert,

I have a requirement were we need to create a column in cross-tab like below.

The initial value for cross tab will come BEx. And we need to create a calculated field in design studio level.

In the below sample, column A and B will come from one query and column E and F will come from another query.

we need to calculate the column C.

Please provide your suggestion. We expecting to do this calculation in Design Studio level.

Thanks!

Regards,
Ramesh J

requirement.png (11.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Hi Ramesh,

    You have mentioned that "column A and B will come from one query and column E and F will come from another query." Are you aware that you cannot assign more than one query to a Crosstab?

    Regards,

    Mustafa.

  • Get RSS Feed

5 Answers

  • Feb 06 at 08:08 AM

    Hi you have an option to mark the two KF and then right click

    Or create the calculation in AAO and use the smart copy/paste function to move the DS from AAO to Design Studio

    But if you reset the datasource in Design Studio afterwards - the calculations will be removed

    /René

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 06 at 10:24 AM

    Hi - this can be done at runtime - have you tried that? See https://blogs.sap.com/2015/11/27/custom-measures-calculations-sap-design-studio-16/

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 08 at 05:38 AM

    Hi.

    Maybe you can use the merge datasource of discovery.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 08 at 02:03 AM

    Hi Rene,

    Will check.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 08 at 02:04 AM

    Hi Tammy,

    The once which shared could helps to calculate with the value in same Datasource. But here we need to pull a value from another datasource and need to do the caculation.

    Thanks!

    Regards,
    Ramesh J

    Add comment
    10|10000 characters needed characters exceeded