dimension attribute in text field

[former_member206621]

Dear all,

We would like to show some attributes of dimension Customer in our report - it is possible to show these attributes in a crosstab but we would like to show these attributes in a text field - how can we do this?

Kind regards,

Lieselot

[former_member206621 · Accepted solution]

As this is not possible (yet) in Design Studio I have created a universe in IDT based on a function in our ERP.  This function will fetch all data needed in our report.

[Former Member]

as of DS 1.6 its possible:

DS_1.getMembers("0CUSTOMER", 9).forEach(function(element, index) {

  element.getAttributeMember("0COUNTRY")

});

if you need specific member you can add an if to this loop

Amit

[reiner_hille-doering]

There is for quite some time script APIs available to get attribute members, e.g.

var members = DS_1.getMembers("0CUSTOMER");

members.forEach(function(member) {

   var attr = member.getAttributeMember("0COUNTRY");

   TEXT_1.setText(attr.text);

});

[former_member206621]

Anyone?

[Former Member]

Hi Lieselot,

1. We cannot use Display attribute directly in Design Studio unless we make it Navigational

2. To display it in the text box you will need to use this something like this TEXTBOX.setText() you can find more details in Help doc.

Also another option is to use Tile to display text(which is part of SAP custom components which you will have to install. Details provided on help.sap under SDK for Design Studio)

Hope this helps.

Rajan

[TammyPowlas]

Hi Lieselot - I am not following entirely.

Could you describe how you want to use the attributes in a text field?

Do you mean Customer Name with customer market?

[former_member206621]

Hi Tammy,

For example: we want to show the address of the customer in our report.  You can find all the elements of an address (city, region, street, ...) in the attributes of the customer.  You can make these attributes visible in a crosstab, but we would like to show them in a text field.

Kind regards,

Lieselot

[TammyPowlas]

Hi Lieselot - thank you for that detailed explanation

An early check - I don't think this is possible at the time - it is a good idea

Maybe the community will have some ideas?

[TammyPowlas]

One work-around (not a fan of this) is to make those display attributes into navigational attributes on the info object - I don't like that but it may work.  This is a BW development model change.

I hope others will contribute with ideas.

[former_member206621]

We are also not a fan of this solution - hoping someone will have another idea (because we are out of ideas)