Skip to Content
0

Manual variable creation in crosstab in Design studio

Aug 22, 2017 at 06:03 AM

112

avatar image
Former Member

Hi Friends,

How to create manual variable in crosstab in Design studio. Whether It is possible not?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Mustafa Bensan Aug 22, 2017 at 08:38 AM
1

Rajesh,

A couple of points:

1) Please search before posting as this topic has been discussed before;

2) You can add a dynamic calculation to the Crosstab at run-time via the context menu;

3) If you can be more specific about your requirement for the "manual variable" we can try to assist further.

Regards,

Mustafa.

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Mustafa Bensan.

Thank for your reply.

I need your help. I need to Create below report in crosstab in Design studio.

Product, No.of.Sold,Cost columns are there in my database. Bucket column not there in database.

How to create bucket column using manual variable in crosstab in Design studio.

report.png (3.8 kB)
0

Hi Rajesh,

With standard Design Studio you cannot create such a column in a Crosstab. If the Bucket dimension is a genuine business requirement then it should be modelled in the database.

Alternatively you could apply the approach described in the following blog:

https://blogs.sap.com/2016/03/10/design-studio-16-data-blending-and-what-if-analysis-with-data-iterator-bring-your-own-data-source/

Regards,

Mustafa.

1
Former Member

Thank you .

0