Skip to Content
0

Custom Calculated Column in Design Studio based on another value

Feb 06 at 05:43 AM

119

avatar image

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)
10 |10000 characters needed characters left 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.

0
* Please Login or Register to Answer, Follow or Comment.

5 Answers

René Hvidberg Feb 06 at 08:08 AM
0

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é


picture.png (7.4 kB)
Share
10 |10000 characters needed characters left characters exceeded
Tammy Powlas
Feb 06 at 10:24 AM
0

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/

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 08 at 05:38 AM
0

Hi.

Maybe you can use the merge datasource of discovery.

Share
10 |10000 characters needed characters left characters exceeded
Ramesh Jothimani Feb 08 at 02:03 AM
0

Hi Rene,

Will check.

Share
10 |10000 characters needed characters left characters exceeded
Ramesh Jothimani Feb 08 at 02:04 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded