Design studio over UNX Key and text

[shlomi_weiss2]

Hi All

I'm working on a model over a UNX with D.S 1.2 SP1 patch1

I have a strange question

Some of the components like Dimension filter, list view and others work with Key and text like BW does

I want to display text and filter by the key, but in UNX they are in 2 fields and not one like in BW.

It doesn't make sense that SAP didn't think about it

Any ideas???

Shlomi

[XaviPolo]

You can define keys in universe.

Select your dimension and add key in "Keys" tab,

After this, DS will show you Text and Key in Filters, etc.

[shlomi_weiss2]

Thanks Polo

It is exactly what I was looking for but unfortunatelly it doesn't work

I still see onmy text in dimension filter on Design studio

Any idea why?

Even in the initial view when I try to display members as, I see only key

Other options are grayed out.

Shlomi

[XaviPolo]

I have same problem with DS 1.3

Seems that keys are not read.

Be aware that if you define a prompt over a dimension with keys defined, universe expects to recive the key...

[shlomi_weiss2]

Hi

I tried your suggestion to transfer key values to a text field with key defined but it didn't seem to work even on the IDT level:

Field definition:

Key definition:

The data contains 2 companies,

I've built a simple query in IDT to show them:

After adding to the query a prompt on DB Name field and trying to give a value of 1 or 2

I get an empty result set

What did I do wrong?

Shlomi

[IngoH]

Hi,

you are adding the Name to the filter and enter "1" which is the code to the values. The value needs to match your dimension

You are using a Universe, so those kind of elements such as key and text and medium text and long text need to be defined in the Universe.

In case your underlying source is BW - there is no need for a Universe at all.

regards

Ingo Hilgefort, SAP

[shlomi_weiss2]

Hi Ingo,

Thanks for your response

I'm using a UNX Universe as you can see from my screen shots and I have defined a key on the universe dimension level, but I cannot find any way to see key and text on Design studio.

I thought as Xavier Polo suggested that if I have a dimension key defined in my Universe, I will be able to transfer keys to it, and that is what I tried to do in my screen shots with a success.

Is there any way to see UNX dimension key and text in Design studio?

Shlomi

[Former Member]

In IDT make dimension with attr. In attr put text value

Try to additem method to your component. For example:

var rd = DataSource.getMembers(" your dimension", 100);

  rd.forEach(function(element, index) {

       Combobox.addItem (element.internalKey,   element.getAttributeMember("dimension attr").text);

  });

[Former Member]

Hi Shlomi,

The workaround to this could be to include both fields in your query, or include the field containing the key merely as a filter while designing the query. This is the general structure of a Universe (to the best of my knowledge), and little change can be made here.

Thanks and Regards,

Eshwar Prasanna

[shlomi_weiss2]

Hi Eshwar

I fail to understand your workaround suggestion

I can have only one field as a dimension in the dimension filter of the Universe

I want the user to select the text and I want the key to be transferred as a prompt to the Universe

Shlomi